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"));
customerInfo.set
没有合适的资源?快使用搜索试试~ 我知道了~
客户管理系统javaweb,没有使用框架
共478个文件
class:137个
java:137个
gif:66个
需积分: 10 14 下载量 199 浏览量
2017-12-19
18:01:37
上传
评论 2
收藏 1.66MB RAR 举报
温馨提示
servlet+jsp+css+js+javaBean 简单的项目,。。。。。。。。。。。。。。。。。。。
资源推荐
资源详情
资源评论
收起资源包目录
客户管理系统javaweb,没有使用框架 (478个子文件)
all-wcprops 4KB
all-wcprops 2KB
all-wcprops 1KB
all-wcprops 997B
all-wcprops 989B
CustomerDAOImpl.class 14KB
ReportFormsDAOImpl.class 10KB
UserDAOImpl.class 9KB
WorkDAOImpl.class 7KB
HouseDAOImpl.class 7KB
LinkManDAOImpl.class 6KB
CustomerCareDAOImpl.class 6KB
CustomerInfo.class 6KB
CustomerUpdateServlet.class 6KB
CustomerAddServlet.class 6KB
NoticeDaoImpl.class 5KB
UserInfo.class 5KB
UserUpdateServlet.class 5KB
DepartmentDAOImpl.class 5KB
CustomerConditionDAOImpl.class 5KB
LinkRecordDAOImpl.class 5KB
RoleDAOImpl.class 5KB
UserAddServlet.class 5KB
CustomerSourceDAOImpl.class 5KB
CustomerTypeDAOImpl.class 5KB
HouseTypeDaoImpl.class 5KB
LoginDAOImpl.class 4KB
HouseUpdateServlet.class 4KB
LInkManUpdateServlet.class 4KB
CustomerUpdateAllNoAdmeasureServlet.class 4KB
CustomerServiceImpl.class 3KB
CustomerCareUpdateServlet.class 3KB
HouseAddServlet.class 3KB
LinkRecordAddServlet.class 3KB
LinkManAddServlet.class 3KB
CustomerUpdateAllNoAdmeasureServlet1.class 3KB
UserServiceImpl.class 3KB
OtherInfo.class 3KB
CustomerCareAddServlet.class 3KB
NoticeAddServlet.class 3KB
CustomerUpdateNoAdmeasureServlet.class 3KB
WorkQueryServlet.class 3KB
ReportFormsConditionQueryServlet.class 3KB
ReportFormsSourceQueryServlet.class 3KB
ReportFormsTypeQueryServlet.class 3KB
LinkRecordDeleteServlet.class 3KB
ReportFormsQueryServlet.class 3KB
HouseDeleteServlet.class 3KB
CustomerConditionDeleteServlet.class 3KB
LinkManDeleteServlet.class 3KB
CustomerSourceDeleteServlet.class 3KB
CustomerTypeDeleteServlet.class 3KB
HouseTypeDeleteServlet.class 3KB
CustomerDeleteServlet.class 3KB
NoticeDeleteServlet.class 3KB
CustomerQueryServlet.class 3KB
DepartmentAddServlet.class 3KB
CustomerQueryMoreServlet.class 3KB
RoleAddServlet.class 2KB
UserQueryMoreServlet.class 2KB
LinkManInfo.class 2KB
HouseQueryServlet.class 2KB
LoginCheckServlet.class 2KB
CustomerCareServiceImpl.class 2KB
CustomerConditionAddServlet.class 2KB
CustomerCareInfo.class 2KB
LinkRecordInfo.class 2KB
DepartmentQueryServlet.class 2KB
CustomerSourceAddServlet.class 2KB
CustomerTypeAddServlet.class 2KB
RoleQueryServlet.class 2KB
HouseTypeAddServlet.class 2KB
CustomerCareQueryServlet.class 2KB
HouseServiceImpl.class 2KB
HouseInfo.class 2KB
DepartmentServiceImpl.class 2KB
LinkManServiceImpl.class 2KB
LinkRecordQueryServlet.class 2KB
CustomerConditionQueryServlet.class 2KB
CustomerSourceQueryServlet.class 2KB
LinkManQueryServlet.class 2KB
CustomerTypeQueryServlet.class 2KB
NoticeQueryServlet.class 2KB
RoleServiceImpl.class 2KB
UserQueryServlet.class 2KB
NoticeInfo.class 2KB
HouseTypeQueryServlet.class 2KB
CustomerCareDeleteServlet.class 2KB
DepartmentDeleteServlet.class 2KB
RoleUpdateServlet.class 2KB
UserDeleteServlet.class 2KB
RoleDeleteServlet.class 2KB
CustomerQueryNoAdmeasureServlet.class 2KB
DBCon.class 2KB
ReportFormsServiceImpl.class 1KB
LinkRecordServiceImpl.class 1KB
CustomerConditionServiceImpl.class 1KB
CustomerConditionInfo.class 1KB
CustomerSourceServiceImpl.class 1KB
DepartmentInfo.class 1KB
共 478 条
- 1
- 2
- 3
- 4
- 5
资源评论
谢邪谐
- 粉丝: 13
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功