daosalchancedao.java

J2EE客户关系管理系统!!!!!!!!!!!!!!!!!!!!

package com.accp.DAO;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.accp.VO.VOSalChanceVO;
import com.accp.DB.DBConnection;


public class DAOSalChanceDAO {
	public List<VOSalChanceVO> findBy(String str){
		List ls = new ArrayList();
		Connection con = DBConnection.getConnection();
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "select * from sal_chance where 1=1 and chc_cust_name like '%"+str+"%' and chc_status<=2";
		try {
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next()){
				VOSalChanceVO salchancevo = new VOSalChanceVO();
				salchancevo.setChcId(rs.getInt(1));
				salchancevo.setChcSource(rs.getString(2));
				salchancevo.setChcCustName(rs.getString(3));
				salchancevo.setChcTitle(rs.getString(4));
				salchancevo.setChcRate(rs.getInt(5));
				salchancevo.setChcLinkman(rs.getString(6));
				salchancevo.setChcTel(rs.getString(7));
				salchancevo.setChcDesc(rs.getString(8));
				salchancevo.setChcCreateId(rs.getInt(9));
				salchancevo.setChcCreateBy(rs.getString(10));
				salchancevo.setChcCreateDate(rs.getDate(11));
				salchancevo.setChcDueId(rs.getInt(12));
				salchancevo.setChcDueTo(rs.getString(13));
				salchancevo.setChcDueDate(rs.getDate(14));
				salchancevo.setChcStatus(rs.getString(15));
				ls.add(salchancevo);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DBConnection.ConnectionClose(con);
		}
		return ls;
	}
	
	public List<VOSalChanceVO> findBy2(String str){
		List ls = new ArrayList();
		Connection con = DBConnection.getConnection();
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "select * from sal_chance where 1=1  and chc_status>=2 and chc_cust_name like '%"+str+"%'";
		try {
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next()){
				VOSalChanceVO salchancevo = new VOSalChanceVO();
				salchancevo.setChcId(rs.getInt(1));
				salchancevo.setChcSource(rs.getString(2));
				salchancevo.setChcCustName(rs.getString(3));
				salchancevo.setChcTitle(rs.getString(4));
				salchancevo.setChcRate(rs.getInt(5));
				salchancevo.setChcLinkman(rs.getString(6));
				salchancevo.setChcTel(rs.getString(7));
				salchancevo.setChcDesc(rs.getString(8));
				salchancevo.setChcCreateId(rs.getInt(9));
				salchancevo.setChcCreateBy(rs.getString(10));
				salchancevo.setChcCreateDate(rs.getDate(11));
				salchancevo.setChcDueId(rs.getInt(12));
				salchancevo.setChcDueTo(rs.getString(13));
				salchancevo.setChcDueDate(rs.getDate(14));
				salchancevo.setChcStatus(rs.getString(15));
				ls.add(salchancevo);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			DBConnection.ConnectionClose(con);
		}
		return ls;
	}
}