package com.sxxy.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.sxxy.dao.CustomerDAO;
import com.sxxy.po.CustomerInfo;
import com.sxxy.util.DBCon;
public class CustomerDAOImpl implements CustomerDAO {
public boolean add(CustomerInfo customerInfo) {
// 添加
Connection con = null;
PreparedStatement pre = null;
try {
String sql = "insert into customer_info (condition_id,source_id,user_id, "
+ "type_id,customer_name,customer_sex,customer_mobile,customer_qq, "
+ "customer_address,customer_email,customer_remark,customer_job,"
+ "customer_blog,customer_tel,customer_msn,birth_day,customer_addtime, "
+ "customer_addman,customer_changtime,change_man,customer_company) "
+ " values(?,?,null,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
// 获取连接
con = DBCon.getConnection();
// 创建实例
pre = con.prepareStatement(sql);
pre.setInt(1, customerInfo.getConditionId());
pre.setInt(2, customerInfo.getSourceId());
//pre.setInt(3, customerInfo.getUserId());
pre.setInt(3, customerInfo.getTypeId());
pre.setString(4, customerInfo.getCustomerName());
pre.setString(5, customerInfo.getCustomerSex());
pre.setString(6, customerInfo.getCustomerMobile());
pre.setString(7, customerInfo.getCustomerQq());
pre.setString(8, customerInfo.getCustomerAddress());
pre.setString(9, customerInfo.getCustomerEmail());
pre.setString(10, customerInfo.getCustomerRemark());
pre.setString(11, customerInfo.getCustomerJob());
pre.setString(12, customerInfo.getCustomerBlog());
pre.setString(13, customerInfo.getCustomerTel());
pre.setString(14, customerInfo.getCustomerMsn());
pre.setString(15, customerInfo.getCustomerBirthday());
pre.setString(16, customerInfo.getCustomerAddTime());
pre.setString(17, customerInfo.getCustomerAddMan());
pre.setString(18, customerInfo.getCustomerChangeTime());
pre.setString(19, customerInfo.getCustomerChangeMan());
pre.setString(20, customerInfo.getCustomerCompany());
// 执行s q l:增加，修改，删除都是用executeUpdate
int i = pre.executeUpdate();
if (i > 0) {
return true;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
// 关闭
DBCon.closeCon(con);
DBCon.closePre(pre);
} catch (Exception e) {
e.printStackTrace();
}
}
return false;
}
public boolean delete(int customerId) {
// 删除
Connection con = null;
PreparedStatement pre = null;
try {
String sql = "update customer_info set is_used = '0' where customer_id =?";
// 获取连接
con = DBCon.getConnection();
// 创建实例
pre = con.prepareStatement(sql);
pre.setInt(1, customerId);
// 执行s q l:增加，修改，删除都是用executeUpdate
int i = pre.executeUpdate();
if (i > 0) {
return true;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBCon.closeCon(con);
DBCon.closePre(pre);
}
return false;
}
public CustomerInfo getAllList(int customerId) {
// 查询一条记录
Connection con = null;
PreparedStatement pre = null;
ResultSet res = null;
try {
//多表查询
String sql = "select a.* ,b.condition_name, c.source_name,d.type_name ,e.user_name from customer_info a,customer_condition b, customer_source c,customer_type d,user_info e "
+" where a.condition_id=b.condition_id and a.source_id=c.source_id and a.type_id =d.type_id and a.user_id = e.user_id and a.is_used=1 and customer_id =? ";
//获取连接
con= DBCon.getConnection();
//创建实例
pre=con.prepareStatement(sql);
pre.setInt(1, customerId);
res = pre.executeQuery();
if (res.next()) {
CustomerInfo customerInfo = new CustomerInfo();
customerInfo.setCustomerId(res.getInt("customer_id"));
customerInfo.setCustomerName(res.getString("customer_name"));
customerInfo.setConditionId(res.getInt("condition_id"));
customerInfo.setCustomerCondition(res.getString("condition_name"));
customerInfo.setSourceId(res.getInt("source_id"));
customerInfo.setCustomerSource(res.getString("source_name"));
customerInfo.setTypeId(res.getInt("type_id"));
customerInfo.setCustomerType(res.getString("type_name"));
customerInfo.setUserId(res.getInt("user_id"));
customerInfo.setCustomerForUser(res.getString("user_name"));
customerInfo.setCustomerSex(res.getString("customer_sex"));
customerInfo.setCustomerMobile(res.getString("customer_mobile"));
customerInfo.setCustomerQq(res.getString("customer_qq"));
customerInfo.setCustomerAddress(res.getString("customer_address"));
customerInfo.setCustomerEmail(res.getString("customer_email"));
customerInfo.setCustomerRemark(res.getString("customer_remark"));
customerInfo.setCustomerJob(res.getString("customer_job"));
customerInfo.setCustomerBlog(res.getString("customer_blog"));
customerInfo.setCustomerTel(res.getString("customer_tel"));
customerInfo.setCustomerMsn(res.getString("customer_msn"));
customerInfo.setCustomerBirthday(res.getString("birth_day"));
customerInfo.setCustomerAddTime(res.getString("customer_addtime"));
customerInfo.setCustomerAddMan(res.getString("customer_addman"));
customerInfo.setCustomerChangeTime(res.getString("customer_changtime"));
customerInfo.setCustomerChangeMan(res.getString("change_man"));
customerInfo.setCustomerCompany(res.getString("customer_company"));
customerInfo.setIsUsed(res.getString("is_used"));
return customerInfo;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBCon.closeRes(res);
DBCon.closePre(pre);
DBCon.closeCon(con);
}
return null;
}
public List<CustomerInfo> getNoAdmeasure( ) {
// 查询未分配的记录
Connection con = null;
PreparedStatement pre = null;
ResultSet res = null;
try {
//多表查询
String sql = "select a.* ,b.condition_name, c.source_name,d.type_name from customer_info a,customer_condition b, customer_source c,customer_type d where a.condition_id=b.condition_id and a.source_id=c.source_id and a.type_id =d.type_id and a.is_used=1 and a.user_id is null ";
//获取连接
con= DBCon.getConnection();
//创建实例
pre=con.prepareStatement(sql);
res = pre.executeQuery();
List< CustomerInfo> list = new ArrayList<CustomerInfo>();
while (res.next()) {
CustomerInfo customerInfo = new CustomerInfo();
customerInfo.setCustomerId(res.getInt("customer_id"));
customerInfo.setCustomerName(res.getString("customer_name"));
customerInfo.setConditionId(res.getInt("condition_id"));
customerInfo.setCustomerCondition(res.getString("condition_name"));
customerInfo.setSourceId(res.getInt("source_id"));
customerInfo.setCustomerSource(res.getString("source_name"));
customerInfo.setTypeId(res.getInt("type_id"));
customerInfo.setCustomerType(res.getString("type_name"));
customerInfo.setUserId(res.getInt("user_id"));
customerInfo.setCustomerSex(res.getString("customer_sex"));
customerInfo.setCustomerMobile(res.getString("customer_mobile"));
customerInfo.setCustomerQq(res.getString("customer_qq"));
customerInfo.setCustomerAddress(res.getString("customer_address"));
customerInfo.setCustomerEmail(res.getString("customer_email"));
customerInfo.setCustomerRemark(res.getString("customer_remark"));
customerInfo.setCustomerJob(res.getString("customer_job"));
customerInfo.setCustomerBlog(res.getString("customer_blog"));
customerInfo.setCustomerTel(res.getString("customer_tel"));
customerInfo.setCustomerMsn(res.getString("customer_msn"));
customerI
JAVA,CRM客户关系管理系统 （531个子文件） 
all-wcprops 4KB all-wcprops 2KB all-wcprops 1KB all-wcprops 997B all-wcprops 989B CustomerDAOImpl.class 13KB ReportFormsDAOImpl.class 9KB UserDAOImpl.class 9KB EmailDAOImpl.class 7KB WorkDAOImpl.class 7KB HouseDAOImpl.class 6KB LinkManDAOImpl.class 6KB CustomerInfo.class 6KB CustomerCareDAOImpl.class 6KB CustomerUpdateServlet.class 5KB UserInfo.class 5KB CustomerAddServlet.class 5KB NoticeDaoImpl.class 5KB UserUpdateServlet.class 5KB DepartmentDAOImpl.class 5KB LinkRecordDAOImpl.class 5KB RoleDAOImpl.class 5KB CustomerConditionDAOImpl.class 5KB UserAddServlet.class 5KB LoginDAOImpl.class 5KB CustomerSourceDAOImpl.class 4KB CustomerTypeDAOImpl.class 4KB HouseTypeDaoImpl.class 4KB EmailAddServlet.class 4KB HouseUpdateServlet.class 4KB LInkManUpdateServlet.class 4KB EmailUpdateSevlet.class 4KB CustomerUpdateAllNoAdmeasureServlet.class 4KB CustomerServiceImpl.class 3KB CustomerCareUpdateServlet.class 3KB HouseAddServlet.class 3KB LinkRecordAddServlet.class 3KB UserServiceImpl.class 3KB OtherInfo.class 3KB CustomerUpdateAllNoAdmeasureServlet1.class 3KB LinkManAddServlet.class 3KB CustomerCareAddServlet.class 3KB ReportFormsConditionQueryServlet.class 3KB ReportFormsSourceQueryServlet.class 3KB CustomerUpdateNoAdmeasureServlet.class 3KB ReportFormsTypeQueryServlet.class 3KB NoticeAddServlet.class 3KB ReportFormsQueryServlet.class 3KB EmailQueryManServlet.class 3KB LinkRecordDeleteServlet.class 3KB HouseDeleteServlet.class 3KB CustomerConditionDeleteServlet.class 3KB CustomerSourceDeleteServlet.class 3KB WorkQueryServlet.class 3KB LinkManDeleteServlet.class 3KB CustomerTypeDeleteServlet.class 3KB HouseTypeDeleteServlet.class 3KB CustomerDeleteServlet.class 3KB EmailDeleteNoSendServlet.class 3KB CustomerQueryMoreServlet.class 3KB NoticeDeleteServlet.class 3KB LoginCheckServlet.class 3KB EmailDeleteServlet.class 3KB EmailAddNoSendServlet.class 3KB FetionSendServlet1.class 3KB UserQueryMoreServlet.class 2KB LinkManInfo.class 2KB DepartmentAddServlet.class 2KB CustomerQueryServlet.class 2KB RoleAddServlet.class 2KB CustomerCareServiceImpl.class 2KB CustomerCareInfo.class 2KB LinkRecordInfo.class 2KB EmailInfo.class 2KB HouseQueryServlet.class 2KB CustomerConditionAddServlet.class 2KB DepartmentQueryServlet.class 2KB Fetion.class 2KB RoleQueryServlet.class 2KB LinkManServiceImpl.class 2KB CustomerCareQueryServlet.class 2KB CustomerSourceAddServlet.class 2KB HouseServiceImpl.class 2KB CustomerTypeAddServlet.class 2KB HouseInfo.class 2KB HouseTypeAddServlet.class 2KB EmailQueryNoSendServlet.class 2KB FetionSendServlet.class 2KB EmailQueryServlet.class 2KB DepartmentServiceImpl.class 2KB CustomerConditionQueryServlet.class 2KB LinkRecordQueryServlet.class 2KB CustomerSourceQueryServlet.class 2KB LinkManQueryServlet.class 2KB CustomerTypeQueryServlet.class 2KB NoticeQueryServlet.class 2KB RoleServiceImpl.class 2KB UserQueryServlet.class 2KB HouseTypeQueryServlet.class 2KB NoticeInfo.class 2KB共 531 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
a3210741
- 粉丝: 1
- 资源: 5
最新资源
- IBM FileNet Content Manager智能内容服务介绍V3.8
- C++程序设计-参考答案
- STM32超声波测距模块HC-SR04用定时器输入捕获实现测距
- 管理系统开发指南：功能要求、技术栈及安全控制
- 小学生信息管理系统，仅供参考
- IBM决策管理平台ODM介绍
- 汽车租赁管理系统，仅供参考
- 改进多任务transformer模型，以提高输血分类预测和注射种类容量回归预测的精度-医疗AI领域的多任务Transformer模型改进与应用：提高输血分类与注射容量预测的准确性
- 基于霍夫变换的人数检测软件
- IBM Process Mining流程挖掘
- 宿舍管理系统项目源代码全套技术资料.zip
- 最新仿720云全景制作源码-krpano仿720云全景网站源码 新增微信支付+打赏+场景红包
- 02326操作系统历年真题及答案2004-2023及课件PPT
- 音频采样与转换软件界面
- 租房网站项目源代码全套技术资料.zip
- java毕设项目之ssm班主任助理系统的设计与实现+jsp(完整前后端+说明文档+mysql+lw).zip
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
