()
| 101 | } |
| 102 | |
| 103 | private void deleteAll() throws Exception { |
| 104 | Connection conn = ds.getConnection(); |
| 105 | |
| 106 | String sql = "delete from user_info "; |
| 107 | |
| 108 | PreparedStatement pstmt = conn.prepareStatement(sql); // SQL Injection공격, 성능향상 |
| 109 | pstmt.executeUpdate(); // insert, delete, update |
| 110 | } |
| 111 | |
| 112 | // 사용자 정보를 user_info테이블에 저장하는 메서드 |
| 113 | public int insertUser(User user) throws Exception { |
no outgoing calls
no test coverage detected