JSP连接mysql数据库
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=123");
Statement stm=conn.createStatement();
//stm.executeUpdate("insert into shop values ('男','林俊杰','323')");
ResultSet rs=stm.executeQuery("select * from shop");
out.print("
out.print("
性别:姓名:密码:");
while(rs.next()){
out.print("
");
out.print("
"+rs.getString("sex")+"");
out.print("
"+rs.getString("name")+"");
out.print("
"+rs.getString("pass")+"");
out.print("
");
}
out.print("
");
%>