bargainclientinfodaoimpl.java

一个oa系统

package com.oa.crm.db;

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

import org.hibernate.HibernateException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class BargainClientInfoDAOImpl extends HibernateDaoSupport implements
		BargainClientInfoDAO {

	public void addBargainClientInfo(BargainClientInfo bargainClientInfo) {
		// TODO 自动生成方法存根
		try { 
			getHibernateTemplate().save(bargainClientInfo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public int countNoExamineBargainClientInfo() {
		// TODO 自动生成方法存根
		int count = 0;
		String examineState = "未审核";
		 List list = null;
			try {  
				list = getHibernateTemplate().find("select count(*) from BargainClientInfo where examine_state=?",examineState);
				count = Integer.parseInt(list.get(0).toString());	
			} catch (HibernateException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		return count;
	}

	public void deleteBargainClientInfo(BargainClientInfo bargainClientInfo) {
		// TODO 自动生成方法存根
		try { 
			getHibernateTemplate().delete(bargainClientInfo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public ArrayList<BargainClientInfo> findAllBargainClientInfo() {
		// TODO 自动生成方法存根
		ArrayList<BargainClientInfo> list = new ArrayList<BargainClientInfo>();
		try { 
			list = (ArrayList<BargainClientInfo>) getHibernateTemplate().find("from BargainClientInfo order by examine_state desc");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	public ArrayList<BargainClientInfo> findAllNoExamineBargainClientInfo(
			String examineState) {
		// TODO 自动生成方法存根
		ArrayList<BargainClientInfo> list = new ArrayList<BargainClientInfo>();
		try {
			list = (ArrayList<BargainClientInfo>) getHibernateTemplate().find("from BargainClientInfo where examine_state=?", examineState);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	public ArrayList<BargainClientInfo> findBargainClientInfoByEmpId(
			String empId) {
		// TODO 自动生成方法存根
		ArrayList<BargainClientInfo> list = new ArrayList<BargainClientInfo>();
		try {
			list = (ArrayList<BargainClientInfo>) getHibernateTemplate().find("from BargainClientInfo where emp_id=?", empId);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	public void updateBargainClientInfo(BargainClientInfo bargainClientInfo) {
		// TODO 自动生成方法存根
		try {
			bargainClientInfo.setExamineState("已审核");
			getHibernateTemplate().update(bargainClientInfo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public BargainClientInfo findOneBargainClientInfoByPactId(String pactId) {
		// TODO 自动生成方法存根

		ArrayList<BargainClientInfo> list = (ArrayList<BargainClientInfo>) getHibernateTemplate().find("from BargainClientInfo where pact_id = ?", pactId);
		return list.get(0);
	}

	public ArrayList<BargainClientInfo> findMenberBargainClientInfo(int start) {
		// TODO 自动生成方法存根
		return null;
	}

	public ArrayList<BargainClientInfo> findMenberBargainClientInfoByEmpId(
			int start, String empId) {
		// TODO 自动生成方法存根
		ArrayList<BargainClientInfo> bargainClientInfoList = new ArrayList<BargainClientInfo>();
		String str = "select *from bargain_client_info where bargain_man ='" + empId + "' limit " + start + ",5";
		Connection conn = getHibernateTemplate().getSessionFactory().openSession().connection();
		PreparedStatement pstmt = null;
		ResultSet rst = null;
		try {
			pstmt = conn.prepareStatement(str);
			rst = pstmt.executeQuery();
			while (rst.next()) {
				BargainClientInfo bargainClientInfo = new BargainClientInfo();
				bargainClientInfo.setBargainMan(rst.getString("bargain_man"));
				bargainClientInfo.setBargainMoney(rst.getString("bargain_money"));
				bargainClientInfo.setClientId(rst.getString("client_id"));
				bargainClientInfo.setClientName(rst.getString("client_name"));
				bargainClientInfo.setExamineState(rst.getString("examine_state"));
				bargainClientInfo.setPactId(rst.getString("pact_id"));
				bargainClientInfo.setPactTime(rst.getString("pact_time"));
				bargainClientInfoList.add(bargainClientInfo);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch
			e.printStackTrace();
		}finally{
			try {
				if (rst != null) {
					rst.close();
				}
				if (pstmt != null) {
					pstmt.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (Exception e) {
				// TODO: handle exception
			}			
		}
	
		return bargainClientInfoList;
	}

	public int getRecordBargainClientByEmpId(String empId) {
		// TODO 自动生成方法存根
		String sql = "select count(*) from BargainClientInfo where bargain_man =?";
		int count = 0;
		count = Integer.parseInt(getHibernateTemplate().find(sql, empId).get(0).toString());
		return count;
	}

	public ArrayList<BargainClientInfo> findAllMenberBargainClientInfo(int start) {
		// TODO 自动生成方法存根
		ArrayList<BargainClientInfo> bargainClientInfoList = new ArrayList<BargainClientInfo>();
		String str = "select *from bargain_client_info order by examine_state desc limit " + start + ",5";
		Connection conn = getHibernateTemplate().getSessionFactory().openSession().connection();
		PreparedStatement pstmt = null;
		ResultSet rst = null;
		try {
			pstmt = conn.prepareStatement(str);
			rst = pstmt.executeQuery();
			while (rst.next()) {
				BargainClientInfo bargainClientInfo = new BargainClientInfo();
				bargainClientInfo.setBargainMan(rst.getString("bargain_man"));
				bargainClientInfo.setBargainMoney(rst.getString("bargain_money"));
				bargainClientInfo.setClientId(rst.getString("client_id"));
				bargainClientInfo.setClientName(rst.getString("client_name"));
				bargainClientInfo.setExamineState(rst.getString("examine_state"));
				bargainClientInfo.setPactId(rst.getString("pact_id"));
				bargainClientInfo.setPactTime(rst.getString("pact_time"));
				bargainClientInfoList.add(bargainClientInfo);
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch
			e.printStackTrace();
		}finally{
			try {
				if (rst != null) {
					rst.close();
				}
				if (pstmt != null) {
					pstmt.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (Exception e) {
				// TODO: handle exception
			}			
		}
		
		return bargainClientInfoList;
	}

	public int getRecordAllBargainClient() {
		// TODO 自动生成方法存根
		int count = 0;
		try { 
			String sql = "select count(*) from BargainClientInfo";
			count = Integer.parseInt(getHibernateTemplate().find(sql).get(0).toString());
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return count;
	}

}