jdbc

Use DTO's to represent data from single table row. Checkout the DAO pattern.

Here is a basic example to retrieve a List of User DTO's:

User DDL (MySQL based)CREATE TABLE User (

ID BIGINT AUTO_GENERATED PRIMARY KEY,

Name VARCHAR (20),

Age INTEGER

);

User DTOpublic class User {

private Long id;

private String name;

private Integer age;

// + getters + setters

}

UserDAO example to retrieve a list of userspublic List<User> getUsers() {

// First prepare the Connection and PreparedStatement yourself here. See JDBC tutorial.

ResultSet resultSet = preparedStatement.executeQuery();

List<User> users = new ArrayList<User>();

while (resultSet.next()) {

User user = new User();

user.setId(new Long(resultSet.getLong("ID")));

user.setName(resultSet.getString("Name"));

user.setAge(new Integer(resultSet.getString("Age")));

users.add(user);

}

return users;

}

BalusCa at 2007-7-12 15:29:43 >