@Override public void saveEmployee(Employee db) { String name = db.getName(); String gender = db.getGender(); String dateOfBirth = db.getDateOfBirth(); String dateOfJoining = db.getDateOfJoining(); String passportNo = db.getPassportNum(); String passportExpiryDate = db.getPassportExpiryDate(); String visaNum = db.getVisaNum(); String visaExpiryDate = db.getVisaExpiryDate(); String localContactNum = db.getLocalContactNum(); String internationalContactNum = db.getInternationalContactNum(); String createdBy = db.getCreatedBy(); String createdOn = db.getCreatedOn(); String updatedBy = db.getLastUpdatedBy(); String updatedOn = db.getLastUpdatedOn(); String healthCardExpiryDate = db.getHealthCardExpiryDate(); String healthCardExpirydate2 = db.getHealthCardExpiryDate2(); String bankName = db.getBankName(); String branchName = db.getBranchName(); String accountNum = db.getAccountNum(); double basicSalary = db.getBasicSalary(); String addressLine1 = db.getAddressLine1(); String addressLine2 = db.getAddressLine2(); String addressLine3 = db.getAddressLine3(); String username = db.getUsername(); String iquery = "insert into employee_master(emp_name,gender,date_of_birth,date_of_joining,passport_no," + "passport_expiry_date,visa_no,visa_expiry_date,local_contact_no,international_contact_no," + "creation_by,creation_date,last_updated_by,last_updated_on,health_card_expiry,health_card_expiry2,bank_name," + "bank_branch_name,bank_account_no,basic_salary,address_line1,address_line2,address_line3,loginid) " + "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; jdbcTemplate.update( iquery, new Object[] { name, gender, dateOfBirth, dateOfJoining, passportNo, passportExpiryDate, visaNum, visaExpiryDate, localContactNum, internationalContactNum, createdBy, createdOn, updatedBy, updatedOn, healthCardExpiryDate, healthCardExpirydate2, bankName, branchName, accountNum, basicSalary, addressLine1, addressLine2, addressLine3, username }); String password = db.getPassword(); String role = db.getRole(); System.out.println(role); iquery = "insert into employees(username, password, authority) values(?,?,?)"; jdbcTemplate.update(iquery, new Object[] {username, password, role}); }
@Override public void updateEmployee(Employee db) { String name = db.getName(); String gender = db.getGender(); String dateOfBirth = db.getDateOfBirth(); String dateOfJoining = db.getDateOfJoining(); String passportNo = db.getPassportNum(); String passportExpiryDate = db.getPassportExpiryDate(); String visaNum = db.getVisaNum(); String visaExpiryDate = db.getVisaExpiryDate(); String localContactNum = db.getLocalContactNum(); String internationalContactNum = db.getInternationalContactNum(); String createdBy = db.getCreatedBy(); String createdOn = db.getCreatedOn(); String updatedBy = db.getLastUpdatedBy(); String updatedOn = db.getLastUpdatedOn(); String healthCardExpiryDate = db.getHealthCardExpiryDate(); String healthCardExpiryDate2 = db.getHealthCardExpiryDate2(); String bankName = db.getBankName(); String branchName = db.getBranchName(); String accountNum = db.getAccountNum(); double basicSalary = db.getBasicSalary(); String addressLine1 = db.getAddressLine1(); String addressLine2 = db.getAddressLine2(); String addressLine3 = db.getAddressLine3(); String username = db.getUsername(); String editQuery = "update employee_master set emp_name=?,gender=?,date_of_birth=?,date_of_joining=?,passport_no=?," + "passport_expiry_date=?,visa_no=?,visa_expiry_date=?,local_contact_no=?,international_contact_no=?," + "creation_by=?,creation_date=?,last_updated_by=?,last_updated_on=?,health_card_expiry=?," + "health_card_expiry2=?,bank_name=?,bank_branch_name=?,bank_account_no=?,basic_salary=?,address_line1=?," + "address_line2=?,address_line3=? where loginid=? "; jdbcTemplate.update( editQuery, new Object[] { name, gender, dateOfBirth, dateOfJoining, passportNo, passportExpiryDate, visaNum, visaExpiryDate, localContactNum, internationalContactNum, createdBy, createdOn, updatedBy, updatedOn, healthCardExpiryDate, healthCardExpiryDate2, bankName, branchName, accountNum, basicSalary, addressLine1, addressLine2, addressLine3, username }); }