@Override
public void updateEmployee(Employee employee) throws SQLException {
// TODO Auto-generated method stub
try {
String sql =
"UPDATE `employees` set full_name=?, gender=?, phone=?,"
+ "address=?, dept_id=? where (id = ? );";
System.out.println(sql);
DbConnection db = new DbConnection();
Connection con = db.getConnection();
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1, employee.getFull_name());
System.out.println("full_name= " + employee.getFull_name());
ps.setString(2, employee.getGender());
System.out.println("gender= " + employee.getGender());
ps.setString(3, employee.getPhone());
System.out.println("phone= " + employee.getPhone());
ps.setString(4, employee.getAddress());
System.out.println("address= " + employee.getAddress());
ps.setInt(5, employee.getDept_id());
System.out.println("dept_id= " + employee.getDept_id());
ps.setInt(6, employee.getId());
System.out.println("id= " + employee.getId());
// System.out.println(employee.getDept_id());
ps.executeUpdate();
// ps.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
@Override
public List<Employee> meetFilter(List<Employee> persons) {
List<Employee> malePersons = new ArrayList<Employee>();
for (Employee person : persons) {
if (person.getGender().equalsIgnoreCase("MALE")) {
malePersons.add(person);
}
}
return malePersons;
}
@Override
public void insertEmployee(Employee employee) throws SQLException {
// TODO Auto-generated method stub
DbConnection db = new DbConnection();
Connection con = db.getConnection();
con.setAutoCommit(false);
try {
String sql =
"insert into employees (full_name, gender,phone,address, dept_id ) values (?,?,?,?,?);";
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1, employee.getFull_name());
ps.setString(2, employee.getGender());
ps.setString(3, employee.getPhone());
ps.setString(4, employee.getAddress());
ps.setInt(5, employee.getDept_id());
ps.executeUpdate();
ps.close();
String sql3 = "select max(id)as id from employees";
PreparedStatement ps1 = con.prepareStatement(sql3);
ResultSet r = ps1.executeQuery();
Integer emp_id = 0;
if (r != null) {
while (r.next()) {
emp_id = r.getInt("id");
}
}
r.close();
ps1.close();
String sql2 = "insert into address (id, emp_id, address) values (?,?,?);";
PreparedStatement ps2 = con.prepareStatement(sql2);
ps2.setInt(1, employee.getId());
ps2.setInt(2, emp_id);
ps2.setString(3, employee.getAddress());
ps2.executeUpdate();
ps2.close();
con.commit();
con.close();
System.out.println("committed successfully");
} catch (Exception e) {
System.out.println("rolling back");
con.rollback();
con.close();
e.printStackTrace();
}
}
