@Override public List<Employee> getAllEmployees() throws SQLException { // TODO Auto-generated method stub List<Employee> empList = new ArrayList<Employee>(); String sql = "Select * from employees;"; DbConnection db = new DbConnection(); Connection con = db.getConnection(); PreparedStatement ps = con.prepareStatement(sql); ResultSet r = ps.executeQuery(); if (r != null) { while (r.next()) { Employee e = new Employee(); e.setId(r.getInt("id")); e.setFull_name(r.getString("full_name")); e.setGender(r.getString("gender")); e.setPhone(r.getString("phone")); e.setAddress(r.getString("address")); e.setUser_id(r.getInt("dept_id")); empList.add(e); } r.close(); ps.close(); con.close(); } return empList; }
@Override public Employee selectEmployee(Integer id) throws SQLException { // TODO Auto-generated method stub String sql = "Select * from employees where (id = ? );"; DbConnection db = new DbConnection(); // Database db = new Database(); // db.setDefaultParameters(); // db.setConnection(true); Connection con = null; if (db == null) { System.out.println("Null database"); System.exit(1); } con = db.getConnection(); if (con == null) { System.out.println("Null connection"); System.exit(2); } PreparedStatement ps = null; ps = con.prepareStatement(sql); ps.setInt(1, id); ResultSet r = ps.executeQuery(); Employee e = new Employee(); if (r != null) { if (r.next()) { e.setId(r.getInt("id")); e.setFull_name(r.getString("full_name")); e.setGender(r.getString("gender")); e.setPhone(r.getString("phone")); e.setAddress(r.getString("address")); e.setUser_id(r.getInt("dept_id")); } r.close(); ps.close(); con.close(); } return e; // return null; }