学步园

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>

<%
 
  String server = "localhost";    //服务器地址
  String dbname = "tang";   //数据库名
  String user = "root";   //数据库用户名
  String pass = "admin";   //数据库密码

  String port = "3306";   //端口号

  String url = "jdbc:mysql://"+server+":"+port+"/"+dbname+"?user="+user+"&password="+pass+"&useUnicode=true&characterEncoding=gb2312";      //连接地址(jdbc:mysql://localhost:3306/tang?user=root&password=admin&useUnicode=true&characterEncoding=gb2312 )
 
  out.print(url);

  String driver = "org.gjt.mm.mysql.Driver";   //mysql驱动
  String sql = null;

  Connection conn = null;
  PreparedStatement psm = null;
  ResultSet rs = null;

  Class.forName(driver);    //加载驱动
  conn = DriverManager.getConnection(url);   //连接数据库
  
  sql = "select * from test";

  psm = conn.prepareStatement(sql);  //执行sql
  rs = psm.executeQuery();    //取得结果集

  while(rs.next())
  {
  %>
    <br /><%=rs.getString(2)%><br />
  <%
  }

  rs.close();
  psm.close();
  conn.close();
%>