jsp 表格 mysql数据库_java web 程序---jsp连接mysql数据库的实例基础+表格显示

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("

");

%>