tadmindao.java

招标网站

package com.jblack.dao;

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

import com.jblack.model.Tadmin;
import com.jblack.model.Tcompany;
import com.jblack.tool.DBConnection;

public class TadminDAO {
	private DBConnection dbConn = new DBConnection();

	public List<Tadmin> query(String sql) {
		List<Tadmin> list = new ArrayList<Tadmin>();
		ResultSet rs = dbConn.executeQuery(sql);
		if (rs != null) {
			try {
				while (rs.next()) {
					Tadmin model = new Tadmin();
					model.setTadname(rs.getString("TAd_name"));
					model.setTadpassword(rs.getString("TAd_password"));
					list.add(model);
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		dbConn.close();
		return list;
	}

	public List<Tadmin> preQuery(String preSQL, Object[] args) {
		List<Tadmin> list = new ArrayList<Tadmin>();
		ResultSet rs = dbConn.executePreQuery(preSQL, args);
		if (rs != null) {
			try {
				while (rs.next()) {
					Tadmin model = new Tadmin();
					model.setTadname(rs.getString("TAd_name"));
					model.setTadpassword(rs.getString("TAd_password"));
					list.add(model);
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		dbConn.close();
		return list;
	}
	public List<Tcompany> cpreQuery(String preSQL, Object[] args) {
		List<Tcompany> list = new ArrayList<Tcompany>();
		ResultSet rs = dbConn.executePreQuery(preSQL, args);
		if (rs != null) {
			try {
				while (rs.next()) {
					Tcompany model = new Tcompany();
					model.setTcid(rs.getInt("TC_id"));
					model.setTcusername(rs.getString("TC_username"));
					model.setTcpassword(rs.getString("TC_password"));
					list.add(model);
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		dbConn.close();
		return list;
	}
}