private User getUser(ResultSet rs) { User us = null; try { int usId = rs.getInt("EmpId"); String role = rs.getString("Role"); String pass = rs.getString("Password"); us = new User(usId, pass, role); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return us; }
@Override public int delete(int key) { String sql = "DELETE FROM EmployeeLoginDetails WHERE empId = ?"; int rowDeleted = 0; try { PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setInt(1, key); rowDeleted = pstmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return rowDeleted; }
@Override public int add(User t) { String sql = "INSERT INTO EmployeeLoginDetails VALUES (?,?,?)"; int rowAdded = 0; try { PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setInt(1, t.getEmpId()); pstmt.setString(2, t.getPassword()); pstmt.setString(3, t.getRole()); rowAdded = pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } return rowAdded; }
public int update(User u) { String sql = "UPDATE EmployeeLoginDetails SET password = ? , role = ? WHERE EmpId = ?"; int rowUpdated = 0; try { PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setString(1, u.getPassword()); pstmt.setString(2, u.getRole()); pstmt.setInt(2, u.getEmpId()); rowUpdated = pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } return rowUpdated; }
@Override public List<User> findAll() { String sql = "SELECT * FROM EmployeeLoginDetails"; ArrayList<User> list = new ArrayList<User>(); try { PreparedStatement pstmt = con.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { User us = getUser(rs); list.add(us); } } catch (SQLException e) { e.printStackTrace(); } return list; }
@Override public User find(int key) { User us = null; String sql = "SELECT * FROM EmployeeLoginDetails WHERE EmpId = ?"; try { PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setInt(1, key); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { us = getUser(rs); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return us; }