@Override
public List<Employee> readEmployees(String infile) {
List<Employee> emps = new ArrayList<>();
Employee emp;
try (InputStream is = new FileInputStream(infile);
JsonReader reader = Json.createReader(is)) {
JsonObject obj = reader.readObject();
JsonArray empArr = obj.getJsonArray("Employees");
for (JsonObject empObj : empArr.getValuesAs(JsonObject.class)) {
emp = new Employee();
emp.setId(empObj.getInt("ID", -1));
emp.setFirstName(empObj.getString("FirstName", null));
emp.setLastName(empObj.getString("LastName", null));
emp.setDepartmentNumber(empObj.getInt("DepartmentNumber", -1));
emp.setLocationId(empObj.getInt("LocationID", -1));
if (emp.getId() > 0 && emp.getFirstName() != null && emp.getLastName() != null)
emps.add(emp);
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (JsonParsingException jpe) {
System.err.println("Json file is malformed.");
System.err.println(jpe.getMessage());
System.err.println(jpe.getStackTrace());
}
return emps;
}
@FXML
private void buttonListenerEdit(ActionEvent event) {
Employee emp = new Employee();
try {
emp.setId(Integer.parseInt(tfInfoId.getText()));
emp.setName(tfInfoName.getText());
emp.setPosition(tfInfoPos.getText());
emp.setStreet(tfInfoStreet.getText());
StringTokenizer tokens = new StringTokenizer(tfInfoCSZ.getText(), ","); // REQ#2
String cityState = tokens.nextToken().toString();
String zip = tokens.nextToken();
emp.setCity(cityState.substring(0, cityState.length() - 3));
emp.setState(cityState.substring(cityState.length() - 2));
emp.setZip(zip);
emp.setPayRate(Double.parseDouble(tfInfoPayRate.getText()));
Environment.updateEmployee(emp);
lblEditConfirm.setText("Employee Updated");
} catch (MinimumWageException e) { // REQ#11 REQ#12
lblWageError.setVisible(true);
} catch (Exception e) {
lblEditConfirm.setText("Error Could Not Update Employee");
}
if (rbHourly.isSelected()) {
initialize();
populateHourlyEmployee();
} else if (rbSalary.isSelected()) {
initialize();
populateSalaryEmployee();
}
}
@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;
}
protected Object getControlObject() {
Employee anEmployee = new Employee();
anEmployee.setId(123);
// anEmployee.setFirstName(null);
anEmployee.setLastName("Doe");
return anEmployee;
}
private void populateEmployee(EmployeeForm employeeForm, Employee employee) {
employee.setId(employeeForm.getId());
employee.setName(employeeForm.getName());
employee.setSurname(employeeForm.getSurname());
employee.setDateOfBirth(employeeForm.getDateOfBirth());
employee.setPhoneNumber(employeeForm.getPhoneNumber());
employee.setPosition(employeeForm.getPosition());
employee.setSalary(employeeForm.getSalary());
}
public Employee build() {
Employee employee = new Employee();
employee.setId(employeeId);
employee.setFirstName(firstName);
employee.setLastName(lastName);
employee.setIncome(income);
employee.setEmail(emailAddress);
return employee;
}
@RequestMapping(value = "/{id:.+}", method = RequestMethod.PUT)
@ApiOperation(value = "Updates the Employee instance associated with the given id.")
public Employee editEmployee(@PathVariable("id") Integer id, @RequestBody Employee instance)
throws EntityNotFoundException {
LOGGER.debug("Editing Employee with id: {}", instance.getId());
instance.setId(id);
instance = employeeService.update(instance);
LOGGER.debug("Employee details with id: {}", instance);
return instance;
}
/**
* Create the employee but don't commit the change to the database, instead keep it in the
* extended persistence context.
*
* @param name
* @param address
* @param id
*/
@Override
@TransactionAttribute(TransactionAttributeType.NOT_SUPPORTED)
public void createEmployee(String name, String address, int id) {
Employee emp = new Employee();
emp.setId(id);
emp.setAddress(address);
emp.setName(name);
em.persist(emp);
}
/** Create employee in provided EntityManager */
public void createEmployee(EntityManager em, String name, String address, int id) {
Employee emp = new Employee();
emp.setId(id);
emp.setAddress(address);
emp.setName(name);
try {
em.persist(emp);
em.flush();
} catch (Exception e) {
throw new RuntimeException("transactional failure while persisting employee entity", e);
}
}
@When("^I create json string from object and write to file$")
public void i_create_json_string_from_object_and_write_to_file() throws Throwable {
Employee employee = new Employee();
employee.setId(1);
employee.setFirstName("Pradeep");
employee.setLastName("Kumar");
employee.setRoles(Arrays.asList("ADMIN", "MANAGER"));
Gson gson = new GsonBuilder().setPrettyPrinting().create();
FileOutputStream fout = new FileOutputStream("output.json");
fout.write(gson.toJson(employee).getBytes());
fout.flush();
fout.close();
}
public List<Employee> parse(String fileData) {
InputStream is = new ByteArrayInputStream(fileData.getBytes(StandardCharsets.UTF_8));
try {
XmlPullParserFactory factory = XmlPullParserFactory.newInstance();
factory.setNamespaceAware(true);
XmlPullParser parser = factory.newPullParser();
parser.setInput(is, null);
int eventType = parser.getEventType();
while (eventType != XmlPullParser.END_DOCUMENT) {
String tagname = parser.getName();
switch (eventType) {
case XmlPullParser.START_TAG:
if (tagname.equalsIgnoreCase("employee")) {
// create a new instance of employee
employee = new Employee();
}
break;
case XmlPullParser.TEXT:
text = parser.getText();
break;
case XmlPullParser.END_TAG:
if (tagname.equalsIgnoreCase("employee")) {
// add employee object to list
employees.add(employee);
} else if (tagname.equalsIgnoreCase("id")) {
employee.setId(Integer.parseInt(text));
} else if (tagname.equalsIgnoreCase("name")) {
employee.setName(text);
} else if (tagname.equalsIgnoreCase("salary")) {
employee.setSalary(Float.parseFloat(text));
}
break;
default:
break;
}
eventType = parser.next();
}
} catch (XmlPullParserException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return employees;
}
public List<Employee> parse(InputStream is) {
try {
XmlPullParserFactory factory = XmlPullParserFactory.newInstance();
factory.setNamespaceAware(true);
XmlPullParser parser = factory.newPullParser();
parser.setInput(is, null);
int eventType = parser.getEventType();
while (eventType != XmlPullParser.END_DOCUMENT) {
String tagname = parser.getName();
switch (eventType) {
case XmlPullParser.START_TAG:
if (tagname.equalsIgnoreCase("mytag")) {
// create a new instance of employee
employee = new Employee();
}
break;
case XmlPullParser.TEXT:
text = parser.getText();
break;
case XmlPullParser.END_TAG:
if (tagname.equalsIgnoreCase("mytag")) {
// add employee object to list
employees.add(employee);
} else if (tagname.equalsIgnoreCase("mysubtag1")) {
employee.setId(Integer.parseInt(text));
} else if (tagname.equalsIgnoreCase("mysubtag2")) {
employee.setName(text);
} else if (tagname.equalsIgnoreCase("mysubtag3")) {
employee.setSalary(text);
}
break;
default:
break;
}
eventType = parser.next();
}
} catch (XmlPullParserException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return employees;
}
public void test() {
int size = getCacheIdentityMap().getMaxSize() * factor;
for (int i = 0; i < size; i++) {
BigDecimal id = new java.math.BigDecimal(i);
Employee employee = new Employee();
Vector pk = new Vector(1);
employee.setId(id);
employee.setFirstName("Joe");
employee.setLastName("Blow");
pk.add(id);
getPrimaryKeys().add(pk);
getCacheIdentityMap().put(primaryKeys, employee, null, 0);
}
}
public Object getControlObject() {
Employee controlEmployee = new Employee();
controlEmployee.setId(CONTROL_EMPLOYEE_ID);
controlEmployee.setFirstName(CONTROL_EMPLOYEE_FIRST_NAME);
Setting textSetting = new Setting(null, "text()");
DatabaseMapping firstNameMapping =
EMPLOYEE_PROJECT.getDescriptor(Employee.class).getMappingForAttributeName("firstName");
textSetting.setMapping(firstNameMapping);
textSetting.setObject(controlEmployee);
textSetting.setValue(CONTROL_EMPLOYEE_FIRST_NAME, false);
Setting fnSetting = new Setting("urn:example", "first-name");
fnSetting.addChild(textSetting);
Setting piSetting = new Setting(null, "personal-info");
piSetting.addChild(fnSetting);
controlEmployee.getSettings().add(piSetting);
return controlEmployee;
}
// 회원정보수정
@RequestMapping(value = "/information.modify", method = RequestMethod.POST)
public String Information_modify(HttpServletRequest request)
throws UnsupportedEncodingException, SQLException {
request.setCharacterEncoding("utf-8");
Employee employee = new Employee();
employee.setEmp_no(1);
employee.setDept_name("dept");
employee.setId("id");
employee.setEmp_name("amugae");
employee.setInhabit1(123456);
employee.setInhabit2(1234567);
employee.setPassword("1234");
employee.setAddress("Yongin");
employee.setJob_group("PM");
employee.setHigh_car("highschool");
employee.setCareer("3");
employee.setTechnique("no");
employee.setClass_posi("sawon");
request.getSession().setAttribute("employee", employee);
return "Information_modify";
}
@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;
}
protected Object getControlObject() {
Employee employee = new Employee();
employee.setId(CONTROL_ID);
employee.setName(CONTROL_NAME);
return employee;
}
