通常我们有一个类与一个表相对应的字段.然后,每当我们在一个结果集中有一个(全)行,我们创建一个这个类的实例.
例:
考虑一个像这样创建的表:
CREATE TABLE customer (First_Name char(50),Last_Name char(50),Address char(50),City char(50),Country char(25),Birth_Date date);
一个模型类将是这样的:
public class Customer {
private String firstName;
private String lastName;
private String address;
private String city;
private String country;
private Date date;
public String getFirstName() {
return firstName;
}
// getters for all fields
public void setFirstName(String firstName) {
this.firstName = firstName;
}
// setters for all fields
public String toString() {
return String.format("[%s,%s,%s]",firstName,lastName,address,city,country,date);
}
}
现在,如果您读取数据并拥有一个ResultSet,您将创建一个新的客户对象并设置字段:
List customers = new ArrayList();
ResultSet rs = stmt.executeQuery("SELECT * from CUSTOMER;");
while (rs.next()) {
Customer customer = new Customer();
customer.setFirstName(rs.get("First_Name"));
// ... and so on
customers.add(customer);
}