jsp---预处理语句对象PreparedStatement(7)

09
        <%
10
            String url = "jdbc:mysql://localhost:3306/javaweb";//连接数据库的url地址
11
            String user = "root";//登录数据库的用户名
12
            String password = "zhangda890126;;";//登录数据库的用户名的密码
13
            Connection conn = null;//链接对象
14
            PreparedStatement pstmt = null;//语句对象
15
            ResultSet rs = null;//结果集对象
16
            try{
17
                Class.forName("com.mysql.jdbc.Driver");//加载JDBC驱动程序
18
                conn = DriverManager.getConnection(url,user,password);//链接数据库
19
            }catch(ClassNotFoundException e){
20
                out.println("找不到驱动类");//抛出异常时，提示信息
21
            }catch(SQLException e){
22
                out.println("链接MySQL数据库失败");//处理SQLException异常
23
            }
24
            try{
25
                String queryAll = "SELECT * FROM user LIMIT ?,?;";//添加一条用户信息
26
                pstmt = conn.prepareStatement(queryAll);//创建预处理语句对象PreparedStatement
27
                
28
                //设置参数
29
                pstmt.setInt(1,2);
30
                pstmt.setInt(2,5);
31
                
32
                //执行语句