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

28
                //设置参数
29
                pstmt.setString(1,"hello world");
30
                pstmt.setInt(2,1);
31
                
32
                //执行语句
33
                pstmt.executeUpdate();
34
                
35
            }catch(SQLException e){
36
                out.println("添加用户信息失败");
37
            }
38
            
39
            try{
40
                if(pstmt != null){
41
                    pstmt.close();
42
                    conn = null;
43
                }
44
                if(conn != null){
45
                    conn.close();
46
                    conn = null;
47
                }
48
            }catch(Exception e){
49
            
50
                out.println("数据库关闭失败");
51
            }
52
        %>
53
    </body>
54
</html>
删除数据
 
01
<%@page language="java" contentType="text/html;charset=gb2312"%>