public static void main(String[] args) {
// 物件1 - 使用空建構子
Personal p1 = new Personal();
// 物件2 - 使用傳入姓別當參數的建構子
Personal p2 = new Personal("Bill");
// 物件3 - 使用傳入姓名、性別、年齡、身份證字號當參數的建構子
Personal p3 = new Personal("Cindy", false, 20, "12345678");
// 物件1 因為內容是空的，使用 setName() 設定姓名
System.out.println("p1: Personal(): ");
p1.setName("Allan");
// 再用 getName() 將姓名資料讀出
System.out.println("name=" + p1.getName());
System.out.println();
// 物件2 只傳入姓名，因此直接使用 getName() 將姓名資料讀出
System.out.println("p2: Personal(\"Bill\"): ");
System.out.println("name=" + p2.getName());
System.out.println();
// 物件3 在實體化時便已有姓名、性別、年齡、身份證字號的資料
System.out.println("p3: Personal(\"Cindy\", false, 20, \"12345678\"): ");
System.out.println("name=" + p3.getName()); // 使用 getName() 將姓名資料讀出
String sex = (p3.getGender()) ? "M" : "F"; // 使用 getGender() 將性別資料讀出
System.out.println("gender=" + sex); // 搭配三元運算子，true 輸出男性、false 輸出女性
System.out.println("age=" + p3.getAge()); // 使用 getAge() 將年齡資料讀出
System.out.println("id=" + p3.getId()); // 使用 getId() 將身份證字號資料讀出
System.out.println();
}
public Personal persona(int id) {
String query = "SELECT * FROM `" + nameTable() + "` WHERE " + nameField()[0] + "=?;";
personal = new Personal();
try {
Connection con = Conexion.createConnection();
PreparedStatement preparedStatement = con.prepareStatement(query);
preparedStatement.setString(1, id + "");
ResultSet p = preparedStatement.executeQuery();
if (p.next()) {
personal.id = p.getInt(nameField()[0]);
personal.nombre = p.getString(nameField()[1]);
personal.correo = p.getString(nameField()[2]);
personal.seguroSocial = p.getString(nameField()[3]);
personal.telefono = p.getLong(nameField()[4]);
personal.direccion = p.getString(nameField()[5]);
personal.lugarnaciemiento = p.getString(nameField()[6]);
DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
personal.fechanacimeinto = formatter.parse(p.getString(nameField()[7]));
personal.puesto_id = p.getInt(nameField()[8]);
personal.activo = p.getInt(nameField()[9]);
}
} catch (SQLException ex) {
System.out.println(ex.getMessage());
} catch (Exception e) {
}
return personal;
}
// validaciones here
public boolean validate(Personal personal) {
this.personal = personal;
boolean value = true;
if (personal.fechanacimeinto == null) {
error += "Fecha no puede ser nula \n";
value = false;
}
if (personal.nombre == null) {
error += "Nombre invalido \n";
value = false;
} else {
if (personal.nombre.trim().isEmpty()
| personal.nombre.length() > 100
| personal.nombre.length() < 5) {
error += "Nombre invalido \n";
value = false;
}
}
if (personal.correo == null) {
error += "Correo invalido \n";
value = false;
} else {
if (!validateEmail(personal.correo)) {
error += "Correo invalido \n";
value = false;
}
}
if (personal.direccion == null) personal.direccion = "";
if (personal.lugarnaciemiento == null) personal.lugarnaciemiento = "";
return value;
}
public Personal insertar(Personal personal) {
if (personal != null) {
if (validate(personal)) {
personal.id = insertar();
return personal;
}
}
return null;
}
public Personal Update(Personal personal) {
if (personal != null) {
if (validate(personal)) {
personal.id = Update();
return personal;
}
}
return null;
}
public static void main(String[] args) {
Personal p1 = new Personal();
Personal p2 = new Personal();
Personal p3 = new Personal();
System.out.println("p1: Personal():");
p1.printData();
System.out.println("p2: Personal(\"Bill\"):");
p2.setData("Bill");
p2.printData();
System.out.println("p3: Personal(\"Cinkdy\", false, 20, \"12345678\"):");
p3.setData("Cinkdy", false, 20, "12345678");
p3.printData();
}
public static void main(String[] args) {
ApplicationContext applicationContext = new ClassPathXmlApplicationContext("Spring-Config.xml");
Personal personal = applicationContext.getBean(Personal.class);
System.out.println(personal.getName());
System.out.println(personal.getMail());
}
public static List<Personal> listaPersonal() {
String query = "SELECT * FROM " + nameTable();
List<Personal> personas = new ArrayList<Personal>();
try {
Connection con = Conexion.createConnection();
PreparedStatement preparedStatement = con.prepareStatement(query);
ResultSet p = preparedStatement.executeQuery();
while (p.next()) {
Personal personal = new Personal();
personal.id = p.getInt(nameField()[0]);
personal.nombre = p.getString(nameField()[1]);
personal.correo = p.getString(nameField()[2]);
personal.seguroSocial = p.getString(nameField()[3]);
personal.telefono = p.getLong(nameField()[4]);
personal.direccion = p.getString(nameField()[5]);
personal.lugarnaciemiento = p.getString(nameField()[6]);
DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
System.out.println(p.getString(nameField()[7]));
personal.fechanacimeinto = formatter.parse(p.getString(nameField()[7]));
personal.puesto_id = p.getInt(nameField()[8]);
personal.activo = p.getInt(nameField()[9]);
personas.add(personal);
}
} catch (SQLException ex) {
System.out.println(ex.getMessage());
} catch (Exception e) {
}
return personas;
}
