@Override
public MemberVO login(LoginVO loginVO) {
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String query = " SELECT USER_ID, USER_NAME, USER_PASSWORD "
+ " FROM USERS WHERE USER_ID = ? AND USER_PASSWORD = ? ";
try {
conn = dataSource.getConnection();
stmt = conn.prepareStatement(query);
stmt.setString(1, loginVO.getId());
stmt.setString(2, loginVO.getPassword());
rs = stmt.executeQuery();
MemberVO memberVO = null;
if(rs.next()) {
memberVO = new MemberVO();
memberVO.setId(rs.getString(1));
memberVO.setUserName(rs.getString(2));
memberVO.setPassword(rs.getString(3));
}
return memberVO;
}
catch(SQLException sqle) {
throw new RuntimeException(sqle.getMessage(), sqle);
}
finally {
DBCloseUtil.close(conn, stmt, rs);
}
}