projectbeansdb.java

来自「BUG跟踪系统是用来对开发软件时发现的bug进行跟踪。里面包括用户管理模块」· Java 代码 · 共 42 行

package su.bts1.imp;

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

import org.apache.struts.util.LabelValueBean;

import su.bts1.bean.ProjectBean;
import su.bts1.dao.DbOperator;

public class ProjectBeansDB {

	private DbOperator db = null;

	private final static String SELECT_PROJECTALL = "select * from project";

	public List projBeans(Connection conn) throws SQLException {
		List<ProjectBean> list = new ArrayList<ProjectBean>();
		db = new DbOperatorImp(conn);
		ResultSet rs = db.select(SELECT_PROJECTALL);

		ProjectBean project = null;

		for (int i = 0; rs.next(); i++) {
			project = new ProjectBean();

			project.setI(i);
			project.setProj_text(rs.getString("proj_text"));
			project.setProjName(rs.getString("proj_name"));
			project.setStartTime(rs.getString("proj_start"));
			project.setEndTime(rs.getString("proj_end"));

			list.add(project);
		}
		return list;
	}

}