<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import="java.sql.*" %> <% try { Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/yggl"; //数据库名 String username = "root"; //数据库用户名 String password = "xbw042620"; //数据库用户密码 Connection conn = DriverManager.getConnection(url, username, password); //连接状态 if(conn != null){ out.print("数据库连接成功！"); out.print("
"); // Statement stmt = null; // ResultSet rs = null; // String sql = "SELECT num,name FROM player;"; //查询语句 // stmt = conn.createStatement(); // rs = stmt.executeQuery(sql); String sql1 = "select * from player where num=?"; PreparedStatement ps3=conn.prepareStatement(sql1); ps3.setObject(1, request.getParameter("param1")); // ps3.executeUpdate(); ResultSet rs = ps3.executeQuery(); out.print("查询结果："); out.print("
"); out.println("number"+" "+"name "); out.print("
"); if (rs.next()) { out.println(rs.getInt("num")+" "+rs.getString("name")); //将查询结果输出 out.print("
"); } }else{ out.print("连接失败！"); } }catch (Exception e) { //e.printStackTrace(); out.print("数据库连接异常！"); } %>