peopledao.java

无论是web程序还是应用程序

package com.dao;

import java.util.*;
import com.domain.PeopleForm;
import java.sql.ResultSet;
import java.sql.*;

public class PeopleDao {
    private JDBConnection connection = null;
    public PeopleDao() {
        connection = new JDBConnection();
    }

    public List selectPeople() {
        List list = new ArrayList();
        PeopleForm form = null;
        String sql = "select * from tb_pagination";
        ResultSet rs = connection.executeQuery(sql);
        try {
            while (rs.next()) {
                form = new PeopleForm();
                form.setId(Integer.valueOf(rs.getString(1)));
                form.setName(rs.getString(2));
                form.setSex(rs.getString(3));
                form.setAge(Integer.valueOf(rs.getString(4)));
                form.setProfession(rs.getString(5));
                list.add(form);
            }
        } catch (SQLException ex) {
        }
        connection.closeConnection();
        return list;
    }
}