테스트 기반으로 JDBC 통해 DB CRUD #3

JDBC UPDATE

    @Test
    public void updateUserName() throws Exception {
        String userId = UserTest.TEST_USER.getUserId();
        String updatedName = "updatedName";
        userDao.updateUserName(userId, updatedName);
        User updatedUser = new User(userId, updatedName);
        User realUpdateUser = userDao.findByUserId(userId);
        assertEquals(realUpdateUser, updatedUser);
    }​

 

    public void updateUserName(String userId, String name) throws SQLException {
        String query = "UPDATE user set name = ? WHERE user_id = ?";
        PreparedStatement pstmt = getConnection().prepareStatement(query);
        pstmt.setString(1, name);
        pstmt.setString(2, userId);
        pstmt.executeUpdate();
    }

 

JDBC DELETE

    @Test
    public void deleteUser() throws Exception{
        String userId = UserTest.TEST_USER.getUserId();
        userDao.deleteUser(userId);
        assertNull(userDao.findByUserId(userId));
    }

 

    public void deleteUser(String userId) throws SQLException {
        String query = "DELETE FROM user WHERE user_id = ?";
        PreparedStatement pstmt = getConnection().prepareStatement(query);
        pstmt.setString(1, userId);
        pstmt.executeUpdate();
    }