banjidao.java

accp s1毕业项目 考试管理系统

package com.exam.db.dao;

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

import com.exam.db.bean.BanJi;
import com.yutang.dboption.DBOption;
import com.yutang.dboption.IPreparedStatementSetter;

public class BanJiDao {
	BanJi banJi = new BanJi();
	List<BanJi> list = new ArrayList<BanJi>();
	DBOption<BanJi> db = new DBOption<BanJi>();	

	public List<BanJi> selectBanJiByGrade(final String grade) {
		db.setCon(MyConnection.getConnection(BanJiDao.class));
		String sql = "select * from BanJi where Grade = ? order by BanJiDate desc";
		list = db.queryAll(sql, banJi, new IPreparedStatementSetter() {
			public PreparedStatement setValues(PreparedStatement pst)
					throws SQLException {
				pst.setString(1, grade);
				return pst;
			}
		});
		db.closeCon();
		return list;
	}

	public List<BanJi> selectBanJiAll() {
		db.setCon(MyConnection.getConnection(BanJiDao.class));
		String sql = "select * from BanJi order by BanJiDate desc";
		list = db.queryAll(sql, banJi);
		db.closeCon();
		return list;
	}

	public BanJi selectBanJiByID(final String banJiID) {
		db.setCon(MyConnection.getConnection(BanJiDao.class));
		String sql = "select * from BanJi where BanJiID = ?";
		banJi = db.queryOne(sql, banJi, new IPreparedStatementSetter() {
			public PreparedStatement setValues(PreparedStatement pst)
					throws SQLException {
				pst.setString(1, banJiID);
				return pst;
			}
		});
		db.closeCon();
		return banJi;
	}

	// 保存班级
	public int insertBanJi(final BanJi banJi) {
		db.setCon(MyConnection.getConnection(BanJiDao.class));
		int result = 0;
		String sql = "insert into BanJi values (?,?,?,?)";
		result = db.save(sql, new IPreparedStatementSetter() {
			public PreparedStatement setValues(PreparedStatement pst)
					throws SQLException {
				pst.setString(1, banJi.getBanJiID());
				pst.setString(2, banJi.getBanJiDate());
				pst.setString(3, banJi.getTeaID());
				pst.setString(4, banJi.getGrade());
				return pst;
			}
		});
		db.closeCon();
		return result;
	}

}