public boolean empreg_insert(EmployeeRegForm ef) throws SQLException {
PreparedStatement ps1 = null, ps2 = null;
DBConn db = new DBConn();
String ps_name = null;
con = db.getConnection();
boolean flag = false;
try {
ps1 = con.prepareStatement("insert into employee_reg values(?,?,?,?,?,?,?,?,?)");
ps1.setInt(1, ef.getPs_id());
ps1.setString(2, ef.getDept_name());
ps1.setString(3, ef.getEmp_id());
ps1.setString(4, ef.getEmp_firstname());
ps1.setString(5, ef.getEmp_lastname());
ps1.setString(6, ef.getSex());
ps1.setString(7, ef.getJoin_date());
ps1.setString(8, ef.getDesignation());
ps1.setString(9, ef.getLoginid());
System.out.println("I am executed chai");
int i = ps1.executeUpdate();
if (i > 0) {
flag = true;
con.commit();
}
} catch (Exception e) {
e.printStackTrace();
} finally {
releaseResources(con, ps1);
}
return flag;
}
