tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jim Cheesman <jch...@msl.es>
Subject Re: Tomcat and Access Database
Date Mon, 30 Apr 2001 15:06:28 GMT
So what's the problem? What exception?


(And to those who are still going on about China, please stop. This is a 
TOMCAT list, not alt.politics.china...)


At 04:53 PM 4/30/2001, you wrote:

>Hello,
>I am Using Access Database to connect with JDBC in Java and my program 
>looks like this...
>
>public class ...{
>..............
>................
>...............
>
>try{
>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>con=DriverManager.getConnection("jdbc:odbc:shree");
>}catch(Exception e){
>e.printStackTrace();
>System.exit(1);
>}
>
>try{
>
>         stmt=con.createStatement();
>         ResultSet rs=stmt.executeQuery(query);
>         ResultSetMetaData rsmd=rs.getMetaData();
>         System.out.println("");


If this is a servlet (in fact whatever it is) it doesn't match the 
following line...

>         out.println("<font color=gray>");
>out.println("<u><b>"+"The Developers with " +level+ " Skill level in 
>"+softwarename + " is/are :"+"</b></u>");
>out.println("</font>");
>out.println("<hr border=2 color=midnightblue>");
>         out.println("\n");
>         out.println("<br>");
>         int no_column=rsmd.getColumnCount();
>         for(int i=1;i<=no_column;i++){
>                 if(i>1) out.print(",");
>                 String columnnames=rsmd.getColumnName(i);
>                 out.print("<B>"+columnnames+"\t\t"+"</b>");
>                 }
>                 out.println("<br>");
>
>                 while(rs.next()) {
>                 for(int i=1;i<=no_column;i++){
>                 if(i>1) out.print(",");
>                 String columnValue=rs.getString(i);
>                 out.print(columnValue+"\t\t");
>                 }
>                 out.println("<br>");
>                 }
>                 stmt.close();
>                 con.close();
>                 }catch(java.sql.SQLException e){
>System.out.println(e.toString());
>}
>out.close();
>}
>}
>
>
>
>
>Please help me to connect this program to Tomcat and work from tomcat server.
>It's very urgent...
>
>Thank You.


--

                           *   Jim Cheesman   *
             Trabajo: 
jchees@msl.es - (34)(91) 724 9200 x 2360
               Personal: 
mogrim@arrakis.es (34) 606 770 244
            Prepositions are not words 
to end sentences with.



Mime
View raw message