Akses Database melalui Castor - Bag 1

Motivasi
Castor membebaskan developer untuk menulis SQL melalui JDBC dalam mengakses database.

Persiapan
Persiapkan direktori kerja, dalam contoh ini /home/lab/myjava
Dapatkan Castor library Di sini dipakai : castor-0.9.5.2.jar

Deskripsi
Sebuah Java Bean EmployeeBean akan disimpan/dibaca dari table EMPLOYEE_TBL di database. mapping.xml digunakan untuk memetakan antara property dari EmployeeBean dan column di EMPLOYEE_TBL. database.xml digunakan sebagai database configuration.

Langkah
1. Tulis EmployeeBean.java
2. Tulis database.xml
3. Tulis mapping.xml
4. Tulis EmployeeApp.java
5. Set CLASSPATH
6. Compile
7. Launch

EmployeeBean
Simpan di sub directory employee di bawah /home/lab/myjava

employee/EmployeeBean.java
package employee;
import java.util.Date;
public class EmployeeBean
{
/* DATA */
private String id;
private String name;
private String department;
private String jobTitle;
private Date hireDate;
private boolean permanentEmployee;
private double salary;
public void setId(String id)
{
this.id = id;
}
public String getId()
{
return this.id;
}
public void setName(String name)
{
this.name = name;
}
public String getName()
{
return this.name;
}
public void setDepartment(String department)
{
this.department = department;
}
public String getDepartment()
{
return this.department;
}
public void setJobTitle(String jobTitle)
{
this.jobTitle = jobTitle;
}
public String getJobTitle()
{
return this.jobTitle;
}
public void setHireDate(Date hireDate)
{
this.hireDate = hireDate;
}
public Date getHireDate()
{
return this.hireDate;
}
public void setPermanentEmployee(boolean permanentEmployee )
{
this.permanentEmployee = permanentEmployee;
}
public boolean getPermanentEmployee()
{
return this.permanentEmployee;
}
public void setSalary(double salary)
{
this.salary = salary;
}
public double getSalary()
{
return this.salary;
}
}