jsp酒店管理系统+sqlserver2005

package com.dao.impl; import java.util.ArrayList; import java.util.List; import java.util.Map; import javax.servlet.jsp.jstl.sql.Result; import com.command.ConnectionManager; import com.command.SQLCommandBean; import com.dao.HotelDao; import com.entity.RoomPartInfo_View; import com.entity.RoomTypeInfo; public class HotelDaoImpl implements HotelDao { /* * 显示所有类型的房间列表 * @see com.dao.HotelDao#getAllRoom() */ public List getAllRoom() { List list=new ArrayList(); String sql="select * from roomTypeInfo"; SQLCommandBean command=new SQLCommandBean(); try { command.setConn(ConnectionManager.getConn()); command.setSql(sql); Result result=command.executeQuery(); int rows=result.getRowCount(); for (int i = 0; i < rows; i++) { Map map=result.getRows()[i]; RoomTypeInfo rt=new RoomTypeInfo(); rt.setRoomTypeID((String)map.get("roomTypeID")); rt.setRoomTypeName((String)map.get("roomTypeName")); rt.setRoomAmount(Integer.parseInt(map.get("roomAmount").toString())); rt.setPrice(Double.parseDouble(map.get("price").toString())); rt.setRoomLeave(Integer.parseInt(map.get("roomLeave").toString())); list.add(rt); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } return list; } /* *管理员登陆 * @see com.dao.HotelDao#login(java.lang.String, java.lang.String) */ public boolean login(String username, String password) { boolean n=false; String sql="select userpassword from userInfo where username=?"; SQLCommandBean command=new SQLCommandBean(); try { command.setConn(ConnectionManager.getConn()); command.setSql(sql); List list=new ArrayList(); list.add(username); command.setValues(list); Result result=command.executeQuery(); if (result.getRowCount()>0&&username!=null && result.getRows()[0].get("userpassword").equals(password)) { n=true; } } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return n; } /* * 根据房间类型显示该类型所有房间详细状态 * @see com.dao.HotelDao#getRoomPartByID(java.lang.String) */ public List getRoomPartByID(String roomTypeID) { List list=new ArrayList(); String sql="select roomPartID,roomState from roomPartInfo_View where roomTypeID=?"; SQLCommandBean command=new SQLCommandBean(); try { command.setConn(ConnectionManager.getConn()); command.setSql(sql); List values=new ArrayList(); values.add(roomTypeID); command.setValues(values); Result result=command.executeQuery(); int rows=result.getRowCount(); for (int i = 0; i < rows; i++) { Map map=result.getRows()[i]; RoomPartInfo_View rp=new RoomPartInfo_View(); rp.setRoomPartID((String)map.get("roomPartID")); rp.setRoomState((String)map.get("roomState")); list.add(rp); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } return list; } /* * 修改房间状态 * @see com.dao.HotelDao#UpdateRoomStateByID(java.lang.String) */ public boolean UpdateRoomStateByID(String roomPartID,String roomStateID,int date) { // TODO 自动生成方法存根 boolean m=false; String sql="update roomPartInfo set roomStateID=?,date=? where roomPartID=?"; SQLCommandBean command=new SQLCommandBean(); try { command.setConn(ConnectionManager.getConn()); command.setSql(sql); List values=new ArrayList(); values.add(roomStateID); values.add(date); values.add(roomPartID); command.setValues(values); int n=command.executeUpdate(); if (n>0) { m=true; } } catch (Exception e) { // TODO: handle exception System.out.println("输入天数有误！"); } return m; } /* * 修改房间剩余（非 Javadoc） * @see com.dao.HotelDao#UpdateRoomLeaveByID(java.lang.String, int) */ public boolean UpdateRoomLeaveByID(String roomTypeID, int count) { // TODO 自动生成方法存根 boolean m=false; String sql="update roomTypeInfo set roomLeave=roomLeave-? where roomTypeID=?"; SQLCommandBean command=new SQLCommandBean(); try { command.setConn(ConnectionManager.getConn()); command.setSql(sql); List values=new ArrayList(); values.add(count); values.add(roomTypeID); command.setValues(values); int n=command.executeUpdate(); if (n>0) { m=true; } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } return m; } /* * 显示某一状态的所有房间列表（非 Javadoc） * @see com.dao.HotelDao#getAllRoomByStateid(java.lang.String) */ public List getAllRoomByState() { // TODO 自动生成方法存根 List list=new ArrayList(); String sql="select * from roomPartInfo_View"; SQLCommandBean command=new SQLCommandBean(); try { command.setConn(ConnectionManager.getConn()); command.setSql(sql); Result result=command.executeQuery(); int rows=result.getRowCount(); for (int i = 0; i < rows; i++) { Map map=result.getRows()[i]; RoomPartInfo_View rp=new RoomPartInfo_View(); rp.setRoomPartID((String)map.get("roomPartID")); rp.setRoomState((String)map.get("roomState")); rp.setRoomTypeID((String)map.get("roomTypeID")); list.add(rp); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } return list; } /* * 根据房间号查找房间状态（非 Javadoc） * @see com.dao.HotelDao#getStateidByRoomid(java.lang.String) */ public String getStateidByRoomid(String roomid) { // TODO 自动生成方法存根 String sql="select roomStateID from roomPartInfo where roomPartID=?"; SQLCommandBean command=new SQLCommandBean(); String stateid="1"; try{ command.setConn(ConnectionManager.getConn()); command.setSql(sql); List list=new ArrayList(); list.add(roomid); command.setValues(list); Result result=command.executeQuery(); if (result.getRowCount()>0) { stateid=(String)result.getRows()[0].get("roomStateID"); } } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return stateid; } /* * 根据房间号查找入住天数（非 Javadoc） * @see com.dao.HotelDao#getDateByRoomid(java.lang.String) */ public int getDateByRoomid(String roomid) { // TODO 自动生成方法存根 String sql="select date from roomPartInfo where roomPartID=?"; SQLCommandBean command=new SQLCommandBean(); int date=0; try{ command.setConn(ConnectionManager.getConn()); command.setSql(sql); List list=new ArrayList(); list.add(roomid); command.setValues(list); Result result=command.executeQuery(); date=Integer.parseInt(result.getRows()[0].get("date").toString()); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return date; } /* * 根据房间类型查找房间价格（非 Javadoc） * @see com.dao.HotelDao#getPriceByRoomTypeid(java.lang.String) */ public double getPriceByRoomTypeid(String roomTypeid) { // TODO 自动生成方法存根 String sql="select price from roomTypeInfo where roomTypeID=?"; SQLCommandBean command=new SQLCommandBean(); double price=0; try{ command.setConn(ConnectionManager.getConn()); command.setSql(sql); List list=new ArrayList(); list.add(roomTypeid); command.setValues(list); Result result=command.executeQuery(); price=Double.parseDouble(result.getRows()[0].get("price").toString()); } catch (Exception e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return price; } /* * 根据房间号查找房间类型（非 Javadoc） * @see com.dao.HotelDao#getRoomTypeidByRoomPartid(java.lang.String) */ public String getRoomTypeidByRoomPartid(String roomPartid) { // TODO 自动生成方法存根 String sql="select roomTypeid from roomPartInfo where roomPartID=?"; SQLCommandBean command=new SQLCommandBean();