package com.hygj.dao.wangshujun;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.apache.log4j.Logger;
import com.hygj.bean.lz.LoginBean;
import com.hygj.bean.wangshujun.KhBean;
import com.hygj.bean.wangshujun.PageBean;
import com.hygj.db.DbUtil;
public class KhglDAO {
/**
* 功能描述:查询所有客户的信息
* @author 王书君
* @return List 返回List
* School:华育国际0113班四组
* Date:2009/3/21
*/
static Logger logger = Logger.getLogger("IN");
static Logger logger1 = Logger.getLogger("ERR");
public List selectInfo()
{
List list = new ArrayList();
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
logger.info("用户查询所有客户信息");
try {
conn = DbUtil.getConn();
String sql = "select * from khgl where kh_use = '1'";
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
while(rs.next())
{
KhBean kb = new KhBean();
kb.setKh_ids(rs.getString("kh_ids"));
kb.setKh_name(rs.getString("kh_name"));
kb.setKh_bumen(rs.getString("kh_bumen"));
kb.setKh_person(rs.getString("kh_person"));
kb.setKh_you(rs.getString("kh_you"));
kb.setKh_guo(rs.getString("kh_guo"));
kb.setKh_sheng(rs.getString("kh_sheng"));
kb.setKh_city(rs.getString("kh_city"));
kb.setKh_time(rs.getString("kh_time"));
kb.setKh_xiatime(rs.getString("kh_xiatime"));
kb.setKh_endtime(rs.getString("kh_endtime"));
kb.setKh_di(rs.getString("kh_di"));
kb.setKh_zhu(rs.getString("kh_zhu"));
kb.setKh_dengji(rs.getString("kh_dengji"));
kb.setKh_zhuang(rs.getString("kh_zhuang"));
kb.setKh_lei(rs.getString("kh_lei"));
kb.setKh_lai(rs.getString("kh_lai"));
kb.setKh_hangye(rs.getString("kh_hangye"));
kb.setKh_xinyu(rs.getString("kh_xinyu"));
kb.setKh_bei(rs.getString("kh_bei"));
kb.setKh_fenlei(rs.getString("kh_fenlei"));
list.add(kb);
}
} catch (Exception e) {
e.printStackTrace();
}finally
{
try {
rs.close();
pstm.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
logger1.error(e);
}
}
return list;
}
/**
* 功能描述:查询所有客户的信息2(页面)
* @author 王书君
* @return List 返回List
* School:华育国际0113班四组
* Date:2009/4/4
*/
public List selectInfo2(PageBean page)
{
List list = new ArrayList();
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
conn = DbUtil.getConn();
String sql = "select top "+page.getPagecount()+" * from khgl where kh_id not in(select top "+page.getPage() * page.getPagecount()+" kh_id from khgl) and kh_use = '1'";
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
while(rs.next())
{
KhBean kb = new KhBean();
kb.setKh_id(rs.getInt("kh_id"));
kb.setKh_ids(rs.getString("kh_ids"));
kb.setKh_name(rs.getString("kh_name"));
kb.setKh_bumen(rs.getString("kh_bumen"));
kb.setKh_person(rs.getString("kh_person"));
kb.setKh_you(rs.getString("kh_you"));
kb.setKh_guo(rs.getString("kh_guo"));
kb.setKh_sheng(rs.getString("kh_sheng"));
kb.setKh_city(rs.getString("kh_city"));
kb.setKh_time(rs.getString("kh_time"));
kb.setKh_xiatime(rs.getString("kh_xiatime"));
kb.setKh_endtime(rs.getString("kh_endtime"));
kb.setKh_di(rs.getString("kh_di"));
kb.setKh_zhu(rs.getString("kh_zhu"));
kb.setKh_dengji(rs.getString("kh_dengji"));
kb.setKh_zhuang(rs.getString("kh_zhuang"));
kb.setKh_lei(rs.getString("kh_lei"));
kb.setKh_lai(rs.getString("kh_lai"));
kb.setKh_hangye(rs.getString("kh_hangye"));
kb.setKh_xinyu(rs.getString("kh_xinyu"));
kb.setKh_bei(rs.getString("kh_bei"));
kb.setKh_fenlei(rs.getString("kh_fenlei"));
list.add(kb);
}
} catch (Exception e) {
e.printStackTrace();
}finally
{
try {
rs.close();
pstm.close();
conn.close();
} catch (SQLException e) {
logger1.fatal(e);
e.printStackTrace();
}
}
return list;
}
/**
* 功能描述:按姓名查询客户信息
* @author 王书君
* @param name 客户的姓名
* @return List 返回List
* School:华育国际0113班四组
* Date:2009/3/21
*/
public List selectInfo2(PageBean page,String name)
{
List list = new ArrayList();
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
conn = DbUtil.getConn();
String sql = "select top "+page.getPagecount()+" * from khgl where kh_id not in(select top "+page.getPage() * page.getPagecount()+" kh_id from khgl) and kh_use = '1' and kh_name = ?";
pstm = conn.prepareStatement(sql);
pstm.setString(1, name);
rs = pstm.executeQuery();
logger.info("用户按姓名查询了一条客户信息,姓名为:"+name);
while(rs.next())
{
KhBean kb = new KhBean();
kb.setKh_ids(rs.getString("kh_id"));
kb.setKh_ids(rs.getString("kh_ids"));
kb.setKh_name(rs.getString("kh_name"));
kb.setKh_bumen(rs.getString("kh_bumen"));
kb.setKh_person(rs.getString("kh_person"));
kb.setKh_you(rs.getString("kh_you"));
kb.setKh_guo(rs.getString("kh_guo"));
kb.setKh_sheng(rs.getString("kh_sheng"));
kb.setKh_city(rs.getString("kh_city"));
kb.setKh_time(rs.getString("kh_time"));
kb.setKh_xiatime(rs.getString("kh_xiatime"));
kb.setKh_endtime(rs.getString("kh_endtime"));
kb.setKh_di(rs.getString("kh_di"));
kb.setKh_zhu(rs.getString("kh_zhu"));
kb.setKh_dengji(rs.getString("kh_dengji"));
kb.setKh_zhuang(rs.getString("kh_zhuang"));
kb.setKh_lei(rs.getString("kh_lei"));
kb.setKh_lai(rs.getString("kh_lai"));
kb.setKh_hangye(rs.getString("kh_hangye"));
kb.setKh_xinyu(rs.getString("kh_xinyu"));
kb.setKh_bei(rs.getString("kh_bei"));
kb.setKh_fenlei(rs.getString("kh_fenlei"));
list.add(kb);
}
} catch (Exception e) {
e.printStackTrace();
}finally
{
try {
rs.close();
pstm.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
/**
* 功能描述:按登记日期查询客户信息
* @author 王书君
* @param time 日期
* @return List 返回List
* School:华育国际0113班四组
* Date:2009/3/29
*/
public List selectInfo3(PageBean page,String time1,String time2)
{
List list = new ArrayList();
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
conn = DbUtil.getConn();
//String sql = "select * from khgl where kh_time between ? and ? and kh_use = ?";
String sql = "select top "+page.getPagecount()+" * from khgl where kh_id not in(select top "+page.getPage() * page.getPagecount()+" kh_id from khgl) and kh_use = '1' and kh_time between ? and ?";
pstm = conn.prepareStatement(sql);
pstm.setString(1, time1);
pstm.setString(2, time2);
rs = pstm.executeQuery();
logger.info("用户按时间段查询了一条客户信息,开始时间为:"+time1+"结束时间为:"+time2);
while(rs.next())
{
KhBean kb = new KhBean();
kb.setKh_ids(rs.getString("kh_ids"));
kb.setKh_name(rs.getString("kh_name"));
kb.setKh_bumen(rs.getString("kh_bumen"));
kb.setKh_person(rs.getString("kh_person"));
kb.setKh_you(rs.getString("kh_you"));
kb.setKh_guo(rs.getString("kh_guo"));
kb.setKh_sheng(rs.getString("kh_sheng"));
kb.
JAVA源代码客户资源管理(CRM)附数据库
5星 · 超过95%的资源 需积分: 31 13 浏览量
2010-01-30
12:15:59
上传
评论 4
收藏 3.25MB RAR 举报 
JAVA源代码客户资源管理(CRM)附数据库 （878个子文件） 
CheckNumServlet.java.bak 2KB CheckNumServlet.java.bak 2KB KhglDAO.class 12KB RYGLDAO.class 9KB SelectBumenDAO.class 8KB HeTongDao.class 7KB HuiFangDao.class 7KB KeHuDAO.class 7KB KhBean.class 5KB QuanxianDAO.class 4KB SelectLog.class 4KB UpdataInfoServlet.class 4KB LinkManBean.class 4KB renyuanadddoServlet.class 3KB GetKehuServlet.class 3KB QXBean.class 3KB UpdataKhServlet.class 3KB quanxianxiugaidoservlet.class 3KB GetinfoServlet.class 3KB LxrAmandServlet.class 3KB InsertServlet.class 3KB HdNewList.class 3KB UpdataInfoDAO.class 3KB HdMandServlet.class 3KB GerenziliaoXiugaiServlet.class 3KB DelInfoDAO.class 3KB CheckNumServlet.class 3KB SelectBmServlet.class 3KB CheckLoginDAO.class 3KB InsertInfoDAO.class 3KB NewList.class 3KB SelectKehuPopServlet.class 3KB HeTongBean.class 3KB HeTongTJServlet.class 3KB GetBumenServlet.class 3KB bianjidoServlet.class 3KB HeTongBJServlet.class 3KB NewDao.class 3KB MandDao.class 3KB UploadServlet.class 3KB CheckLoginServlet.class 3KB SelectBmAllServlet.class 3KB SelectKuhuinfoServlet.class 2KB LoginServlet.class 2KB DelBmDAO.class 2KB TreeBean.class 2KB InsertBumenDAO.class 2KB HdMandDao.class 2KB ListServlet.class 2KB UpdataBmDAO.class 2KB UpdataBumenServlet.class 2KB CheckNumberServlet.class 2KB HdNewDao.class 2KB HdBean.class 2KB HdInsertServlet.class 2KB TianJiaHFServlet.class 2KB HuiFangServlet.class 2KB HTfyDao.class 2KB HeTongServlet.class 2KB SelectTypeServlet.class 2KB ParDao.class 2KB SelectflServlet.class 2KB SelectYuanGongDAO.class 2KB quanxianguanlinamelistServlet.class 2KB HuiFangBJservlet.class 2KB HdListServlet.class 2KB renyuanguanliServlet.class 2KB SelectTreeDAO.class 2KB quanxianxiugaiServlet.class 2KB HdParDao.class 2KB RYGLBean.class 2KB UpdataBm2Servlet.class 2KB HdMandParServlet.class 2KB SystemServlet.class 2KB LxrParServlet.class 2KB DeleteLog.class 2KB UpdateKehuServlet.class 2KB SelectKehuKartServlet.class 2KB SelectIdServlet.class 2KB renyuanbianjiServlet.class 2KB UpdataBmServlet.class 2KB CheckNumber2Servlet.class 2KB BianJiHTServlet.class 2KB ChakanKehuServlet.class 2KB AmandKeHuServlet.class 2KB ParServlet.class 2KB checkuseridServlet.class 2KB delrenyuanServlet.class 2KB InsertTypeServlet.class 2KB InsertFenServlet.class 2KB BianJiHFServlet.class 2KB pageBean.class 2KB DeleteKehuServlet.class 2KB TiaozhuanServlet.class 2KB HdDeleteServlet.class 2KB quanxianchakanServlet.class 2KB DeleteServlet.class 2KB DeleteLoginServlet.class 2KB DeleteSysServlet.class 2KB CheckFilter.class 2KB共 878 条
- 1
- 2
- 3
- 4
- 5
- 6
- 9
- 1
- 2
前往页