kefangcaozuo.java

基于jsp+javabean+tomcat+eclipse+SQLServer2000的酒店信息服务系统（原创）具有客房信息发布

/*
 * Created on 2004-10-15
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package OperateBean;
import DataBean.*;
import java.util.*;
import DB.DBBean;
import java.sql.*;
/**
 * @author iwy
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class Kefangcaozuo
{
	public int isok0(Kefangshuju shuju)
	{//判断要修改的客房里面是否有人在住,如果没有则返回0
		int i=0;
		DBBean db=new DBBean();//建立连接数据库的对象
		ResultSet r1;//建立结果集
		String query1;//select count(Xingming) from Kerenxx where Kefangh=660;
			query1="select Ruzhu from Kefangxx where Kefangh="+
			"\'"+shuju.getkefangh()+"\'"+";";
			r1=db.executeQuery(query1);
			try
			{
				if(r1.next())
				{
					i=r1.getInt("Ruzhu");
				}
			}
			catch(SQLException sl)
			{}
		return i;
	}
	public int isok1(Kefangshuju shuju)
		{//判断要修改的客房是否存在,0存在，1不存在
			int i=0;
			DBBean db=new DBBean();//建立连接数据库的对象
			ResultSet r1;//建立结果集
			String query1;//select count(Xingming) from Kerenxx where Kefangh=660;
				query1="select count(Kefangh) Geshu from Kefangxx where Kefangh="+
				"\'"+shuju.getkefangh()+"\'"+";";
				r1=db.executeQuery(query1);
				try
				{
					if(r1.next())
					{
						i=r1.getInt("Geshu");
					}
				}
				catch(SQLException sl)
				{}
			return i;
		}
	public int iscaninsert_kf(Kefangshuju shuju)
			{//判断要发布的客房是否已经被发布，是返回0，否返回1
				int i=0;
				DBBean db=new DBBean();//建立连接数据库的对象
				ResultSet r1;//建立结果集
				String query1;//select count(Xingming) from Kerenxx where Kefangh=660;
					query1="select count(Kefangh) Geshu from Kefangxx where Kefangh="+
					"\'"+shuju.getkefangh()+"\'"+";";
					r1=db.executeQuery(query1);
					try
					{
						if(r1.next())
						{
							//i=Integer.parseInt(r1.getString("Geshu"));
							i=r1.getInt("Geshu");
						}
					}
					catch(SQLException sl)
					{}
				return i;
			}
	public String insert0(Kefangshuju kefangshuju)
		{//向客房信息里面插入信息
			Vector v1=new Vector();//声明一个向量
			DBBean db=new DBBean();//建立连接数据库的对象
			ResultSet r1;//建立结果集
			String query1;
		
			{
				
				query1="insert into Kefangxx(Kefangh," +
					"Leixing,Jibenj,Ruzhu) values ("+
				+kefangshuju.getkefangh() +
				",\'"+kefangshuju.getleixing()+"\'"+
				","+kefangshuju.getjibenj()+
				",\'空房\'"+
				");";
				//query1="insert into luxianfb(mingcheng) values("+
				//query1="update luxianfb set mingcheng="+"\'"+shiyanshuju.getmingcheng()+"\'"+" where mingcheng=\'hd\';";
				//	"\'"+shiyanshuju.getmingcheng()+"\'"+");";
				r1=db.executeQuery(query1);
			}
			//r1.close();
			return query1;
			//r1.close();
			//catch(SQLException sl)
			//{}
		}
	public String insert1(Kerenshuju shuju)
		{//向客人信息里面插入信息
			Vector v1=new Vector();//声明一个向量
			DBBean db=new DBBean();//建立连接数据库的对象
			ResultSet r1;//建立结果集
			String query1;
	
			{
				query1="insert into Kerenxx(Kefangh,Xingming,Xingbie," +
					"Dianhuahm,Xinyongkkh,Ruzhurq,Lidianrq,Biaozhunjg,Shijijg," +
					"Yujiaoyj,Beizhu) values ("+
				+shuju.getkefangh() +
				",\'"+shuju.getxingming()+"\'"+
				",\'"+shuju.getxingbie()+"\'"+
				",\'"+shuju.getdianhuahm()+"\'"+
				",\'"+shuju.getxinyongkkh()+"\'"+
				","+shuju.getruzhurq()+
				","+shuju.getlidianrq()+
				","+shuju.getbiaozhunjg()+
				","+shuju.getshijijg()+
				","+shuju.getyujiaoyj()+
				",\'"+shuju.getbeizhu()+"\'"+
				");";
				r1=db.executeQuery(query1);
			}
				//r1.close();
			return query1;
		}
	public Vector select0()
		{
			Vector v1=new Vector();//声明一个向量
			DBBean db=new DBBean();//建立连接数据库的对象
			ResultSet r1;//建立结果集
			String query1;
			Kefangshuju sj=new Kefangshuju();
			try
			{
				query1="select Kefangh,Leixing,Jibenj,Ruzhu from Kefangxx;";
				r1=db.executeQuery(query1);
				while(r1.next())
				{
					sj.setkefangh(Integer.parseInt(r1.getString("Kefangh")));
					sj.setleixing(r1.getString("Leixing"));
					sj.setjibenj(Integer.parseInt(r1.getString("Jibenj")));
					sj.setruzhu(r1.getString("Ruzhu"));
					v1.add(sj);
					sj=new Kefangshuju();//注意每次插入之后都要对shiyansj清空
				}
			}
			catch(SQLException sl)
			{}
			return v1;
		}
	public Vector select1()
		{
			Vector v1=new Vector();//声明一个向量
			DBBean db=new DBBean();//建立连接数据库的对象
			ResultSet r1;//建立结果集
			String query1;
			Zongheshuju sj=new Zongheshuju();
			try
			{
				query1="select Kefangh,Leixing,Jibenj,Ruzhu,Xingming,Xingbie," +
					"Dianhuahm,Xinyongkkh,Ruzhurq,Lidianrq,Biaozhunjg,Shijijg," +
					"Yujiaoyj,Beizhu from Zonghe;";
				r1=db.executeQuery(query1);
				while(r1.next())
				{
					sj.setkefangh(Integer.parseInt(r1.getString("Kefangh")));
					sj.setleixing(r1.getString("Leixing"));
					sj.setjibenj(Integer.parseInt(r1.getString("Jibenj")));
					sj.setruzhu(r1.getString("Ruzhu"));
					sj.setxingming(r1.getString("Xingming"));
					sj.setxingbie(r1.getString("Xingbie"));
					sj.setdianhuahm(r1.getString("Dianhuahm"));
					sj.setxinyongkkh(r1.getString("Xinyongkkh"));
					//sj.setruzhurq(Integer.parseInt(r1.getString("Ruzhurq")));
					sj.setruzhurq(r1.getString("Ruzhurq"));
					sj.setlidianrq(r1.getString("Lidianrq"));
					sj.setbiaozhunjg(Integer.parseInt(r1.getString("Biaozhunjg")));
					sj.setshijijg(Integer.parseInt(r1.getString("Shijijg")));
					sj.setyujiaoyj(Integer.parseInt(r1.getString("Yujiaoyj")));
					sj.setbeizhu(r1.getString("Beizhu"));
					v1.add(sj);
					sj=new Zongheshuju();//注意每次插入之后都要对shiyansj清空
				}
			}
			catch(SQLException sl)
			{}
			return v1;
		}
		
	public Vector select2(String kefangh)
			{//综合数据的查询
				Vector v1=new Vector();//声明一个向量
				DBBean db=new DBBean();//建立连接数据库的对象
				ResultSet r1;//建立结果集
				String query1="";
				Zongheshuju sj=new Zongheshuju();
				try
				{
					query1="select Kefangh,Leixing,Jibenj,Ruzhu,Xingming,Xingbie," +
						"Dianhuahm,Xinyongkkh,Ruzhurq,Lidianrq,Biaozhunjg,Shijijg," +
						"Yujiaoyj,Beizhu from Zonghe where Kefangh="+kefangh+";";
					r1=db.executeQuery(query1);
					while(r1.next())
					{
						sj.setkefangh(Integer.parseInt(r1.getString("Kefangh")));
						sj.setleixing(r1.getString("Leixing"));
						sj.setjibenj(Integer.parseInt(r1.getString("Jibenj")));
						sj.setruzhu(r1.getString("Ruzhu"));
						sj.setxingming(r1.getString("Xingming"));
						sj.setxingbie(r1.getString("Xingbie"));
						sj.setdianhuahm(r1.getString("Dianhuahm"));
						sj.setxinyongkkh(r1.getString("Xinyongkkh"));
						//sj.setruzhurq(Integer.parseInt(r1.getString("Ruzhurq")));
						sj.setruzhurq(r1.getString("Ruzhurq"));
						sj.setlidianrq(r1.getString("Lidianrq"));
						sj.setbiaozhunjg(Integer.parseInt(r1.getString("Biaozhunjg")));
						sj.setshijijg(Integer.parseInt(r1.getString("Shijijg")));
						sj.setyujiaoyj(Integer.parseInt(r1.getString("Yujiaoyj")));
						sj.setbeizhu(r1.getString("Beizhu"));
						v1.add(sj);
						sj=new Zongheshuju();//注意每次插入之后都要对shiyansj清空
					}
				}
				catch(SQLException sl)
				{}
				return v1;
			}
	public int  select3()
			{//用于计算空客房的房间个数
				int i=0;
				Vector v1=new Vector();//声明一个向量
				DBBean db=new DBBean();//建立连接数据库的对象
				ResultSet r1;//建立结果集
				String query1;
				Kefangshuju sj=new Kefangshuju();
					query1="select count(*) Geshu from Kefangxx where Ruzhu='空房';";
					r1=db.executeQuery(query1);
			try
				{
					if(r1.next())
					{
						i=r1.getInt("Geshu");
					}
				}
			catch(SQLException sl)
			{}
		return i;
			}
	public int select4()
		{//用于计算被预订客房的房间个数
			int i=0;
			Vector v1=new Vector();//声明一个向量
			DBBean db=new DBBean();//建立连接数据库的对象
			ResultSet r1;//建立结果集
			String query1;
			Kefangshuju sj=new Kefangshuju();
				query1="select count(*) Geshu from Kefangxx where Ruzhu='预订';";
				r1=db.executeQuery(query1);
		try
			{
				if(r1.next())
				{
					i=r1.getInt("Geshu");
				}
			}
		catch(SQLException sl)
		{}
	return i;
		}
	public Vector select5(String kefangh)
				{//综合数据的查询
					Vector v1=new Vector();//声明一个向量
					DBBean db=new DBBean();//建立连接数据库的对象
					ResultSet r1;//建立结果集
					String query1="";
					Zongheshuju sj=new Zongheshuju();
					try
					{
						query1="select Kefangh,Leixing,Jibenj,Ruzhu,Xingming,Xingbie," +
							"Dianhuahm,Xinyongkkh,Ruzhurq,Lidianrq,Biaozhunjg,Shijijg," +
							"Yujiaoyj,Beizhu from Zonghe where Kefangh="+kefangh+";";
						r1=db.executeQuery(query1);
						if(r1.next())
						{
							sj.setkefangh(Integer.parseInt(r1.getString("Kefangh")));
							sj.setleixing(r1.getString("Leixing"));
							sj.setjibenj(Integer.parseInt(r1.getString("Jibenj")));
							sj.setruzhu(r1.getString("Ruzhu"));
							sj.setxingming(r1.getString("Xingming"));
							sj.setxingbie(r1.getString("Xingbie"));
							sj.setdianhuahm(r1.getString("Dianhuahm"));
							sj.setxinyongkkh(r1.getString("Xinyongkkh"));
							//sj.setruzhurq(Integer.parseInt(r1.getString("Ruzhurq")));
							sj.setruzhurq(r1.getString("Ruzhurq"));
							sj.setlidianrq(r1.getString("Lidianrq"));
							sj.setbiaozhunjg(Integer.parseInt(r1.getString("Biaozhunjg")));
							sj.setshijijg(Integer.parseInt(r1.getString("Shijijg")));
							sj.setyujiaoyj(Integer.parseInt(r1.getString("Yujiaoyj")));
							sj.setbeizhu(r1.getString("Beizhu"));
							v1.add(sj);
							sj=new Zongheshuju();//注意每次插入之后都要对shiyansj清空
						}
					}
					catch(SQLException sl)
					{}
					return v1;
				}
	public Vector select6(String kefangh,String ruzhurq)
					{//综合数据的查询(结算用)
						Vector v1=new Vector();//声明一个向量
						DBBean db=new DBBean();//建立连接数据库的对象
						ResultSet r1;//建立结果集
						String query1="";
						Zongheshuju sj=new Zongheshuju();
						try
						{
							query1="select Kefangh,Leixing,Jibenj,Ruzhu,Xingming,Xingbie," +
								"Dianhuahm,Xinyongkkh,Ruzhurq,Lidianrq,Biaozhunjg,Shijijg," +
								"Yujiaoyj,Beizhu from Zonghe where Kefangh="+kefangh+" and Ruzhurq=\'"+ruzhurq+"\';";
							r1=db.executeQuery(query1);
							if(r1.next())
							{
								sj.setkefangh(Integer.parseInt(r1.getString("Kefangh")));
								sj.setleixing(r1.getString("Leixing"));
								sj.setjibenj(Integer.parseInt(r1.getString("Jibenj")));
								sj.setruzhu(r1.getString("Ruzhu"));
								sj.setxingming(r1.getString("Xingming"));
								sj.setxingbie(r1.getString("Xingbie"));
								sj.setdianhuahm(r1.getString("Dianhuahm"));
								sj.setxinyongkkh(r1.getString("Xinyongkkh"));
								//sj.setruzhurq(Integer.parseInt(r1.getString("Ruzhurq")));
								sj.setruzhurq(r1.getString("Ruzhurq"));
								sj.setlidianrq(r1.getString("Lidianrq"));
								sj.setbiaozhunjg(Integer.parseInt(r1.getString("Biaozhunjg")));
								sj.setshijijg(Integer.parseInt(r1.getString("Shijijg")));
								sj.setyujiaoyj(Integer.parseInt(r1.getString("Yujiaoyj")));
								sj.setbeizhu(r1.getString("Beizhu"));
								v1.add(sj);
								sj=new Zongheshuju();//注意每次插入之后都要对shiyansj清空
							}
						}
						catch(SQLException sl)
						{}
						return v1;
						//return query1;
					}
	public String update0(Kefangshuju shuju)
		{//向修改客房的信息
			Vector v1=new Vector();//声明一个向量
			DBBean db=new DBBean();//建立连接数据库的对象
			ResultSet r1;//建立结果集
			String query1;
			//try
			{//update Kefangxx set Kefangh=00000,Leixing='dds',Jibenj=0000,Ruzhu=0 where Kefangh=0;
				query1="update Kefangxx set Kefangh="+
				"\'"+shuju.getkefangh()+"\'"+
				",Leixing=\'"+shuju.getleixing()+"\'"+
				",Jibenj="+shuju.getjibenj()+
				",Ruzhu="+0+""+
				" where Kefangh="+shuju.getkefangh()+";";
				r1=db.executeQuery(query1);
			}
			return query1;
		}	
		public  String zhuangtai(int i)
		{
			String s="空房";
			if(i==1)
			s="预定";
			if(i==-1)
			s="入住";
			return s;
		}
	public String  update1(String shuju)
			{//向修改客房的信息
				Vector v1=new Vector();//声明一个向量
				DBBean db=new DBBean();//建立连接数据库的对象
				ResultSet r1;//建立结果集
				String query1;
				//try
				{//update Kefangxx set Kefangh=00000,Leixing='dds',Jibenj=0000,Ruzhu=0 where Kefangh=0;
					query1="update Kefangxx set Ruzhu=\'入住\' where Kefangh="+shuju+";";
					r1=db.executeQuery(query1);
				}
				return query1;
			}	
	public String update2(Kerenshuju shuju,String kfh)
		{//修改客人信息
			Vector v1=new Vector();//声明一个向量
			DBBean db=new DBBean();//建立连接数据库的对象
			ResultSet r1;//建立结果集
			String query1;

				query1="update Kerenxx set Kefangh="+shuju.getkefangh() +
				",Xingming="+"\'"+shuju.getxingming()+"\'"+
				",Xingbie="+"\'"+shuju.getxingbie()+"\'"+
				",Dianhuahm="+"\'"+shuju.getdianhuahm()+"\'"+
				",Xinyongkkh="+"\'"+shuju.getxinyongkkh()+"\'"+
				",Ruzhurq="+shuju.getruzhurq()+
				",Lidianrq="+shuju.getlidianrq()+
				",Biaozhunjg="+shuju.getbiaozhunjg()+
				",Shijijg="+shuju.getshijijg()+
				",Yujiaoyj="+shuju.getyujiaoyj()+
				",Beizhu="+"\'"+shuju.getbeizhu()+"\' where Kefangh="+kfh+";";
				r1=db.executeQuery(query1);
				//r1.close();
			return query1;
		}
	public String delete0(String kfh,String rzrq)
			{//删除客人信息
				Vector v1=new Vector();//声明一个向量
				DBBean db=new DBBean();//建立连接数据库的对象
				ResultSet r1;//建立结果集
				String query1;

					query1="delete  Kerenxx where Ruzhurq=\'"+rzrq+
					"\' and Kefangh="+kfh+";";
					r1=db.executeQuery(query1);
					//r1.close();
				return query1;
			}
	
		



}