bugbeansdb.java

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

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 su.bts1.bean.BugBean;
import su.bts1.dao.DbOperator;

public class BugBeansDB {

	private  DbOperator db = null;

	private final static String SELECT_BUGALL = "select * from bug";

	public  List bugBeans(String projName, Connection conn)
			throws SQLException {
		//if(db == null)
		db = new DbOperatorImp(conn);

		ResultSet rs = db.select(SELECT_BUGALL + " where bug_projName_FK ='"
				+ projName.trim() + "'");

		BugBean bug = null;
		List<BugBean> list = new ArrayList<BugBean>();

		for (int i = 1; rs.next(); i++) {
			bug = new BugBean();

			bug.setBugName(rs.getString("bug_name"));
			bug.setI(i);
			bug.setEndDate(validateEndTime(bug.getBugName(), rs
					.getString("bug_endtime")));
			bug.setStartDate(rs.getString("bug_starttime"));
			bug.setText(rs.getString("bug_text"));
			bug.setBug_programer(rs.getString("bug_programer"));
			list.add(bug);
		}

		return list;
	}

	/**
	 * 未结束时内容填充为可选按钮
	 *
	 * @param bugName
	 * @param bug_endtime
	 * @return
	 */
	private synchronized String validateEndTime(String bugName,
			String bug_endtime) {
		if (bug_endtime == null) {
			return "<form name=\"form2\" method=\"post\" action=\"state.do\">"
					+ " <select name=\""
					+ bugName
					+ "\">"
					+ " <option value=\"1\">open</option>"
					+ "<option value=\"2\">closed</option>"
					+ "<option value=\"3\">reOpen</option>"
					+ "</select>"
					+ "&nbsp;<input type=\"button\" name=\"button1\" value=\"提交\" onClick=\"submit1()\">"
					+ "</form>";
		}
		return bug_endtime;
	}
	/*
	 * public String formatTime(String datetime) { SimpleDateFormat format = new
	 * SimpleDateFormat("yyyy-MM-dd"); return format.format(datetime); }
	 */

}