package com.kewen.dao.Manage.impl;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.kewen.dao.BaseDao;
import com.kewen.dao.Manage.IManageDao;
import com.kewen.vo.Customer.Customer;
import com.kewen.vo.Manage.Manager;
import com.kewen.vo.Room.Room;
import com.kewen.vo.RoomType.RoomType;
/**
* 管理员类Dao
* @author 郭浩
* 最后修改日期：2018.5.9
* 版本 1.2
*/
public class ManageDaoImpl extends BaseDao implements IManageDao {
public Manager ManageLogin(String s_manage_count, String s_manage_pwd) {
// TODO Auto-generated method stub
Manager manage = null;
String sql="select s_manage_count,s_manage_name,s_manage_pwd,i_manage_role from manage where s_manage_count=? and s_manage_pwd=?";
Object[] params = {s_manage_count,s_manage_pwd};
res = super.commandQuery(sql, params);
try {
while(res.next()){
manage=new Manager();
manage.setS_manage_count(res.getString("s_manage_count"));
manage.setS_manage_pwd(res.getString("s_manage_pwd"));
manage.setS_manage_name(res.getString("s_manage_name"));
manage.setI_manage_role(res.getInt("i_manage_role"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return manage;
}
public Manager searchManage(String s_manage_name) {
// TODO Auto-generated method stub
Manager manage = null;
String sql="SELECT * FROM manage where s_manage_name=?";
Object[] params={s_manage_name};
res = super.commandQuery(sql, params);
try {
while(res.next()){
manage=new Manager();
manage.setI_Manage_id(res.getInt("i_Manage_id"));
manage.setS_manage_count(res.getString("s_manage_count"));
manage.setS_manage_name(res.getString("s_manage_name"));
manage.setS_manage_pwd(res.getString("s_manage_pwd"));
manage.setS_manage_sex(res.getString("s_manage_sex"));
manage.setI_manage_age(res.getInt("i_manage_age"));
manage.setS_manage_phone(res.getString("s_manage_phone"));
manage.setS_manage_email(res.getString("s_manage_email"));
manage.setS_manage_address(res.getString("s_manage_address"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return manage;
}
public List<Manager> searchJinliList() {
// TODO Auto-generated method stub
List<Manager> searchJinliList = new ArrayList<Manager>();
Manager manage = null;
String sql="SELECT * FROM manage where i_Manage_role='1'";
Object[] params=null;
res = super.commandQuery(sql, params);
try {
while(res.next()){
manage=new Manager();
manage.setI_Manage_id(res.getInt("i_Manage_id"));
manage.setS_manage_count(res.getString("s_manage_count"));
manage.setS_manage_name(res.getString("s_manage_name"));
manage.setS_manage_sex(res.getString("s_manage_sex"));
manage.setI_manage_age(res.getInt("i_manage_age"));
manage.setS_manage_phone(res.getString("s_manage_phone"));
manage.setS_manage_email(res.getString("s_manage_email"));
manage.setS_manage_address(res.getString("s_manage_address"));
searchJinliList.add(manage);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return searchJinliList;
}
public List<Customer> searchMCustomerList() {
// TODO Auto-generated method stub
List<Customer> searchMCustomerList =new ArrayList<Customer>();
Customer customer =null;
String sql="select * from customer";
Object[] params=null;
res = super.commandQuery(sql, params);
try {
while(res.next()){
customer =new Customer();
customer.setI_customer_id(res.getInt("i_customer_id"));
customer.setS_customer_count(res.getString("s_customer_count"));
customer.setS_customer_name(res.getString("s_customer_name"));
customer.setS_customer_sex(res.getString("s_customer_sex"));
customer.setI_customer_age(res.getInt("i_customer_age"));
customer.setS_customer_phone(res.getString("s_customer_phone"));
customer.setS_customer_email(res.getString("s_customer_email"));
customer.setS_customer_address(res.getString("s_customer_address"));
customer.setS_customer_room(res.getString("s_customer_room"));
customer.setI_customer_points(res.getInt("i_customer_points"));
customer.setD_customer_lastdate(res.getDate("d_customer_lastdate"));
customer.setD_customer_receverdate(res.getDate("d_customer_receverdate"));
customer.setS_customer_note(res.getString("s_customer_note"));
searchMCustomerList.add(customer);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return searchMCustomerList;
}
public List<Customer> searchMCustListByName(String s_customer_name) {
// TODO Auto-generated method stub
List<Customer> searchMCustLByName = new ArrayList<Customer>();
Customer customer = null;
String sql="select * from customer where s_customer_name = ?";
Object[] params = {s_customer_name};
res = super.commandQuery(sql, params);
try {
while(res.next()){
customer =new Customer();
customer.setI_customer_id(res.getInt("i_customer_id"));
customer.setS_customer_count(res.getString("s_customer_count"));
customer.setS_customer_name(res.getString("s_customer_name"));
customer.setS_customer_sex(res.getString("s_customer_sex"));
customer.setI_customer_age(res.getInt("i_customer_age"));
customer.setS_customer_phone(res.getString("s_customer_phone"));
customer.setS_customer_email(res.getString("s_customer_email"));
customer.setS_customer_address(res.getString("s_customer_address"));
customer.setS_customer_room(res.getString("s_customer_room"));
customer.setI_customer_points(res.getInt("i_customer_points"));
customer.setD_customer_lastdate(res.getDate("d_customer_lastdate"));
customer.setD_customer_receverdate(res.getDate("d_customer_receverdate"));
customer.setS_customer_note(res.getString("s_customer_note"));
searchMCustLByName.add(customer);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return searchMCustLByName;
}
public Customer searchMCustByCount(String s_customer_count) {
// TODO Auto-generated method stub
Customer customer = null;
String sql="select * from customer where s_customer_count = ?";
Object[] params ={s_customer_count};
res=super.commandQuery(sql, params);
try {
while(res.next()){
customer = new Customer();
customer.setI_customer_id(res.getInt("i_customer_id"));
customer.setS_customer_count(res.getString("s_customer_count"));
customer.setS_customer_name(res.getString("s_customer_name"));
customer.setS_customer_sex(res.getString("s_customer_sex"));
customer.setI_customer_age(res.getInt("i_customer_age"));
customer.setS_customer_phone(res.getString("s_customer_phone"));
customer.setS_customer_email(res.getString("s_customer_email"));
customer.setS_customer_address(res.getString("s_customer_address"));
customer.setS_customer_room(res.getString("s_customer_room"));
customer.setI_customer_points(res.getInt("i_customer_points"));
customer.setD_customer_lastdate(res.getDate("d_customer_lastdate"));
customer.setD_customer_receverdate(res.getDate("d_customer_receverdate"));
customer.setS_customer_note(res.getString("s_customer_note"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return customer;
}
public List<Manager> searchMJListByName(String s_manage_name) {
// TODO Auto-generated method stub
List<Manager> searchMJlByNameList = new ArrayList<Manager>();
Manager manage =null;
String sql="select * from manage where s_manage_name=?";
Object[] params={s_manage_name};
res=super.commandQuery(sql, params);
try {
whil
基于java-web酒店管理系统（前、后台）
4星 · 超过85%的资源 需积分: 49 55 浏览量
2018-07-17
14:44:59
上传
评论 16
收藏 4.89MB ZIP 举报 
基于java-web酒店管理系统（前、后台） （185个子文件） 
ManageDaoImpl.class 17KB ManageBizImpl.class 6KB CustomerDaoImpl.class 5KB Customer.class 4KB BaseDao.class 3KB Manager.class 3KB CustomerUpdateChoose.class 2KB JLUpdateInfoChooseServlet.class 2KB ManageDeleteRoomTypeServlet.class 2KB ManageDeleteCustomerServlet.class 2KB JLDeleteCustomerInfoServlet.class 2KB ManageDeleteJingLiServlet.class 2KB ManageDeleteRoomServlet.class 2KB JLSearchOwnInfoServlet.class 2KB ManageSearchRoomTypeInfoServlet.class 2KB CustomerSearchRoomServlet.class 2KB JLSearchRoomTypeInfoServlet.class 2KB ManageSearchRoomInfoServlet.class 2KB ManageSearchCustInfoServlet.class 2KB ManageLoginServlet.class 2KB ManageSearchJLInfoServlet.class 2KB JLSearchRoomInfoServlet.class 2KB JLSearchCustInfoServlet.class 2KB ManageSearchOwnInformation.class 2KB CustomerLoginServlet.class 2KB CustomerSearchOwnInfo.class 2KB IManageDao.class 2KB IManageBiz.class 2KB Room.class 2KB ExitServlet.class 2KB MExitServlet.class 2KB RoomType.class 2KB CustomerBizImpl.class 2KB ManageSearchRoomInfoByTypeServlet.class 2KB ManageSearchCustInfoByNameServlet.class 2KB ManageSearchJLInfoByCountServlet.class 2KB ManageSearchJLInfoByNameServlet.class 2KB ManageInsertCustomerInfoServlet.class 2KB JLSearchRoomInfoByTypeServlet.class 2KB JSearchCustInfoByNameServlet.class 2KB ManageUpdateRoomInfoServlet.class 2KB ManageSearchCustInfoByCount.class 2KB ManageInsertRoomTypeServlet.class 2KB ManageUpdateOwnInfoServlet.class 2KB ManageInsertJLInfoServlet.class 2KB CustomerSigninServlet.class 2KB JLUpdateJOwnInfoServlet.class 2KB ManageInsertRoomServlet.class 2KB ManageUpdateChoose.class 2KB ICustomerDao.class 515B ICustomerBiz.class 515B .classpath 529B org.eclipse.wst.common.component 474B org.eclipse.wst.jsdt.ui.superType.container 49B
ojdbc14.jar 1.47MB mysql-connector-java-5.1.6-bin.jar 687KB commons-collections-3.2.1.jar 562KB commons-httpclient-3.1.jar 298KB commons-lang-2.3.jar 240KB commons-beanutils-1.7.0.jar 184KB commons-io-2.4.jar 181KB json-lib-2.2.3-jdk15.jar 145KB ezmorph-1.0.3.jar 76KB commons-logging-1.1.1.jar 59KB commons-fileupload-1.2.2.jar 58KB ManageDaoImpl.java 25KB ManageBizImpl.java 6KB CustomerDaoImpl.java 5KB IManageDao.java 4KB IManageBiz.java 4KB Customer.java 4KB ManageInsertCustomerInfoServlet.java 3KB Manager.java 3KB CustomerSigninServlet.java 3KB JLUpdateInfoChooseServlet.java 2KB BaseDao.java 2KB CustomerUpdateChoose.java 2KB ManageLoginServlet.java 2KB CustomerLoginServlet.java 2KB ManageUpdateOwnInfoServlet.java 2KB ManageInsertJLInfoServlet.java 2KB JLUpdateJOwnInfoServlet.java 2KB JLDeleteCustomerInfoServlet.java 2KB ManageDeleteCustomerServlet.java 2KB ManageDeleteJingLiServlet.java 2KB ManageDeleteRoomTypeServlet.java 2KB ManageUpdateRoomInfoServlet.java 2KB ManageDeleteRoomServlet.java 2KB ManageUpdateChoose.java 2KB Room.java 2KB ManageSearchCustInfoServlet.java 2KB RoomType.java 2KB ManageInsertRoomTypeServlet.java 2KB ManageInsertRoomServlet.java 2KB ManageSearchJLInfoServlet.java 2KB JLSearchOwnInfoServlet.java 1KB JLSearchCustInfoServlet.java 1KB JLSearchRoomTypeInfoServlet.java 1KB ManageSearchRoomTypeInfoServlet.java 1KB CustomerSearchRoomServlet.java 1KB共 185 条
- 1
- 2
资源评论
W_fat2018-07-18没有数据库吗？
qq_289054852019-04-13没有数据库吗？能给表吗？？
GHHCNGC
- 粉丝: 84
- 资源: 8
最新资源
- 微信小程序源码 车源宝 二手车交易平台 源码下载
- 微信小程序源码 实现 城市切换 demo 根据城市首字母排序城市 选择城市 源码下载
- VMware7.0虚拟机硬盘无法编辑，无法连接到Profile-Driven Storage Service
- arm64内核的mongo镜像
- 基于stm32f103c单片机+MPU6050+0.96英寸OLED显示屏双柄遥控器硬件（原理图+PCB）工程文件.zip
- 整理的关于少儿编程的学习路径，以及如何在小升初，初升高和大学充分的利用起来编程经验的优势
- nhit完整源码+论文学习
- 足球比赛结果统计表2006-2011年大约28W场比赛
- 基于PHP+mysql的社区交流系统（源代码）
- yolov5,SSD 可能使用到的一些代码
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
