listbean.java

利用struts开发的一个分页源码示例,可以直接导入到myeclipse下.

package com.yourcompany.bean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.yourcompany.util.DBConnection;
import com.yourcompany.vo.User;

public class ListBean {
	@SuppressWarnings("unchecked")
	public List findAll() {
		List list = new ArrayList();
		ResultSet rs = null;
		final String SQL = "select username,password,email from user";
		try {
			rs = DBConnection.getResultSet(SQL);
			while (rs.next()) {
				User user = new User();
				user.setUserName(rs.getString(1));
				user.setPassword(rs.getString(2));
				user.setEmail(rs.getString(3));
				list.add(user);

			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			if (rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return list;
	}

}