2001010304G01/out/artifacts/TestServlet02_war_exploded/sele.jsp

<%@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("<br />");
//            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("<br />");
            out.println("number"+"  "+"name ");
            out.print("<br />");
            if (rs.next()) {
                out.println(rs.getInt("num")+" "+rs.getString("name")); //将查询结果输出
                out.print("<br />");
            }
        }else{
            out.print("连接失败！");
        }
    }catch (Exception e) {
        //e.printStackTrace();
        out.print("数据库连接异常！");
    }
%>