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);
}
%>
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);
}
%>