tbidingdao.java

招标网站

package com.jblack.dao;

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

import com.jblack.model.Tbiding;
import com.jblack.tool.DBConnection;

public class TbidingDAO {
	private DBConnection conn = new DBConnection();
	SimpleDateFormat date = new SimpleDateFormat("yyyy-MM-dd");
	
	public int save(Tbiding tb) {
		String sql = "insert into tbidding (TC_id,TP_id,TB_bidDate,TB_ammount,TB_stattus)  values ("
					+ tb.getTcid()
					+ ", "
					+ tb.getTpid()
					+ ", date('"
					+ date.format(tb.getTbbidDate())
					+ "'), '"
					+ tb.getTbammount()
					+ "', '"
					+ tb.getTbstatus() + "')";

		int num = conn.insertAndGetPKKey(sql);
		conn.close();
		return num;
	
	}
	
	public List<Tbiding> querybid(int tpid) {
		List<Tbiding> list = new ArrayList<Tbiding>();
		ResultSet rs = conn.executeQuery("select * from Tbidding where TP_id = "+tpid);
		try {
			while (rs.next()) {
				list.add(new Tbiding(rs.getInt("TB_id"), rs.getInt("TC_id"),
									rs.getInt("TP_id"), rs.getDate("TB_bidDate"),
									rs.getInt("TB_ammount"),rs.getInt("TB_stattus")));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			conn.close();
		}
		return list;
	}
}