jdbc+jsp+servlet插入数据

插入/增加数据

1. 在web.xml中配置url-pattern
2. 在jsp页面中配置超链接使页面联系servlet
3. 在servlet中添加方法
   一般通过uri区分,注意post和get方法

if (request.getRequestURI().contains("login")) {
   	...
       }
else if (request.getRequestURI().contains("saveUser")){
   	...
       }

4. 在dao层添加接口并实现接口

@Override
    public void saveUser(Users user) {
        Connection conn=null;
        PreparedStatement pstmt=null;
        try {
            String url = "jdbc:oracle:thin:@ip:1521:orcl";
            Class.forName("oracle.jdbc.OracleDriver");
            conn = DriverManager.getConnection(url, "username", "password");
            conn.setAutoCommit(false);

            String sql = "INSERT INTO USERS VALUES(?,?,?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, user.getUserId());
            pstmt.setString(2, user.getUsername());
            pstmt.setString(3, user.getUsername());
            pstmt.executeUpdate();

            sql = "INSERT INTO USER_ROLE VALUES(?,?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, user.getUserId());
            pstmt.setString(2, user.getRole().getRoleId());
            pstmt.executeUpdate();

            conn.commit();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
            try {
                conn.rollback();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }finally {
            try {
                pstmt.close();
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }

        }
    }

5. 在servlet调用dao层方法，最终页面跳转