jdbc连接mysql数据库一般的写法

Connection con;
    Statement sql;
    ResultSet rs;
    try{
      Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动程序；
    }
    catch(ClassNotFoundException e){
     out.print("类找不到！");
    }
    try{
     con=DriverManager.getConnection("jdbc:mysql://localhost:3306/数据库名","用户名","密码");
     sql=con.createStatement();
     rs=sql.executeQuery("select * from usertable");
     out.print("<table Border class=datalist>");
     out.print("<tr><td colspan=8 align=center>用户数据</td>");
     out.print("<tr>");
       out.print("<td width=100>用户id </td>");
         out.print("<td width=50 >用户名 </td>");
           out.print("<td width=60>用户姓名 </td>");
             out.print("<td width=40 >年龄 </td>");
               out.print("<td width=40 >性别</td>");
                 out.print("<td width=60 >联系地址</td>");
                   out.print("<td width=100 >联系电话 </td>");
                     out.print("<td width=75>添加时间 </td>");
     out.print("</tr>");
     while(rs.next())
     {out.print("<tr>");
          out.print("<td >"+rs.getLong(1)+"</td>");
          out.print("<td >"+rs.getString(2)+"</td>");
          out.print("<td >"+rs.getString(3)+"</td>");
          out.print("<td >"+rs.getInt("age")+"</td>");
          out.print("<td >"+rs.getString("sex")+"</td>");
          out.print("<td >"+rs.getString("address")+"</td>");
          out.print("<td >"+rs.getString("tel")+"</td>");
          out.print("<td >"+rs.getString("settime")+"</td>");
     out.print("</tr>");
     }
     out.print("</table>");
      }
       catch (Exception e1){
       out.print("SQL异常！"+e1);
       
       } 
     %>

评论

1 楼 Javakeith 2010-09-16  

jdbc连接mysql数据库一般的写法

写法确实很一般，希望lz能给出 不一般的写法！