@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(); } }
public void testValidateSimpleType() throws Exception { boolean caughtException = false; File file = new File(ClassLoader.getSystemResource(CONTROL_XML_FILE_NAME).getFile()); Employee employee = (Employee) unmarshaller.unmarshal(file); try { validator.validate(employee.getPhone()); } catch (ValidationException xmlpe) { caughtException = true; } assertFalse("Phone object did not validate.", caughtException); }
@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(); } }