<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="gb2312"%>       
     
      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("
");   		out.print("
");   		out.print("
");   		out.print("
");   	}   	out.print("
      
       
        
性别：
        
姓名:
        
密码：
       
       
        
"+rs.getString("sex")+"
        
"+rs.getString("name")+"
        
"+rs.getString("pass")+"
       
      
     
");    %>