jsp使用jdbc连接my sql数据库测试代码

<%
    try {
      Class.forName("org.gjt.mm.mysql.Driver");     //加载MYSQL JDBC驱动程序  
      out.println("Success loading Mysql Driver!");
    }
    catch (Exception e) {
      out.print("Error loading Mysql Driver!");
      e.printStackTrace();
    }

 //  try {
  Class.forName("org.gjt.mm.mysql.Driver");
      java.sql.Connection connect = java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mysql","root","123456");
//连接URL为   jdbc:mysql//服务器地址/数据库名
//后面的2个参数分别是登陆用户名和密码
     out.println("Success connect Mysql server!");
     java.sql.Statement stmt = connect.createStatement();
     java.sql.ResultSet rs = stmt.executeQuery("select * from db");
   while (rs.next()) {
      out.println(rs.getString("Db"));
     }
 //  }
//   catch (Exception e) {
    //  out.print("get data error!");
 //    e.printStackTrace();
 //  }
%>