sqlcode.properties~231~

用户的注册 用户的登陆 发布用户的相关信息 浏览网站介绍的其他酒店的信息 通过本系统查询被预定的房间 查询客户的反馈意见

#--加载数据库驱动--#
driver=sun.jdbc.odbc.JdbcOdbcDriver
#--数据库连接--#
url=jdbc:odbc:hotel

#--个人用户表--#
#-- 插入数据--#
sql.userInfo.insert=insert into tb_userInfo values('?','?','?','?','?','?','?',?,'?','?','?',default,default)
#-- 更新数据--#
sql.userInfo.update=update tb_userInfo set userInfo_password='?',userInfo_name='?',userInfo_question='?',userInfo_answer='?',userInfo_imageId='?',userInfo_sex='?',userInfo_age=?,userInfo_tel='?',userInfo_email='?',userInfo_address='?' where userInfo_userId='?'
#--是否冻结个人用户--#
sql.userInfo.statusupdate=update tb_userInfo set userInfo_status='?' where userInfo_userId='?'
#-- 删除个人用户--#
sql.userInfo.delete=delete from tb_userInfo where userInfo_userId='?'
#-- 查询个人用户--#
sql.userInfo.select=select * from tb_userInfo
#-- 统计注册多少个人用户--#
sql.userInfo.count=select count(*) as number from tb_userInfo
#--判断用户--#
sql.userInfo.check=select * from tb_userInfo where userInfo_userId='?' and userInfo_password='?'
#--根据id查询用户--#
sql.userInfo.idselect=select * from tb_userInfo where userInfo_userId='?'

#-- 意见反馈表--#
#-- 插入数据--#
sql.advice.insert=insert into tb_advice (advice_oid,advice_content,advice_time,advice_hotel,advice_contentment) values(?,'?','?','?','?')
#-- 删除数据--#
sql.advice.delete=delete from tb_advice where advice_id=？
#-- 查询数据--#
sql.advice.select=select tb_advice.advice_id,tb_advice.advice_oid,tb_advice.advice_content,tb_advice.advice_time,tb_advice.advice_hotel,tb_advice.advice_contentment,tb_orderform.orderform_uid,tb_orderform.orderform_user from  tb_advice inner join tb_orderform  on tb_advice.advice_oid=tb_orderform.orderform_id  where advice_hotel=?
#-- 统计反馈意见有多少条记录--#
sql.advice.count=select count(*) as number  from  tb_advice inner join tb_orderform  on tb_advice.advice_oid=tb_orderform.orderform_id where advice_hotel=?
#-- 根据id查询数据--#
sql.advice.idselect=select tb_advice.advice_id,tb_advice.advice_oid,tb_advice.advice_content,tb_advice.advice_time,tb_advice.advice_hotel,tb_advice.advice_contentment,tb_orderform.orderform_uid,tb_orderform.orderform_user from  tb_advice inner join tb_orderform  on tb_advice.advice_oid=tb_orderform.orderform_id  where advice_id=?

#-- 系统管理员--#

#-- 系统管理员表--#
#--核查管理员帐户和密码--#
sql.admin.select=select * from tb_admin where admin_id='?' and admin_password='?'
#--更新管理员密码--#
sql.admin.update=update tb_admin set admin_password='?' where admin_id='?'

#--管理员发布公告表--#
#--插入数据--#
sql.notice.insert=insert into tb_notice values('?','?',default)
#--删除数据--#
sql.notice.delete=delete from tb_notice where notice_id=?
#--更新数据--#
sql.notice.update=update tb_notice set notice_title='?',notice_content='?',notice_time='?'where notice_id=?
#--查询数据--#
sql.notice.select=select * from tb_notice
#--统计所有的公告--#
sql.notice.count=select count(*) as number from tb_notice
#--根据id查询数据--#
sql.notice.selectNotice=select * from tb_notice where notice_id=?

#--友情连接表--#
#--插入数据--#
sql.link.insert=insert into tb_link values('?','?',default)
#--更新数据--#
sql.link.update=update tb_link set link_content='?',link_addr='?'where link_id=?
#--删除数据--#
sql.link.delete=delete from tb_link where link_id=?
#--查询数据--#
sql.link.select=select * from tb_link
#--统计友情连接有多少记录--#
sql.link.count=select count(*) as number from tb_link

#--企业用户--#
#--企业用户表--#
#--插入数据--#
sql.enterprise.insert=insert into tb_enterprise values('?','?','?','?','?','?','?','?','?','?','?',default,default,'?','?','?',default,?)
#--更新数据--#
sql.enterprise.update=update tb_enterprise set enterprise_password='?',enterprise_address='?',enterprise_province='?',enterprise_city='?',enterprise_postalcode='?',enterprise_corporation='?',enterprise_tel='?',enterprise_fax='?',enterprise_linkman='?',enterprise_linkmanTel='?',enterprise_img1='?',enterprise_img2='?',enterprise_img3='?',enterprise_level=? where enterprise_id=?
#--删除数据--#
sql.enterprise.delete=delete from tb_enterprise where enterprise_id=?
#--统计所有酒店--#
sql.enterprise.count=select count(*) as t from tb_enterprise
#--查询--#
sql.enterprise.select=select * from tb_enterprise
#--更新信誉度--#
sql.enterprise.crdupdate=update tb_enterprise set enterprise_credit=enterprise_credit+1 where enterprise_id=?
#--是否冻结企业--#
sql.enterprise.statusjupdate=update tb_enterprise set enterprise_status='?' where enterprise_id=?
#--判断企业用户--#
sql.enterprise.check=select * from tb_enterprise where enterprise_name='?' and enterprise_password='?'
#--判断企业用户--#
sql.enterprise.nameselect=select * from tb_enterprise where enterprise_name='?'
#--根据id查询酒店--#
sql.enterprise.idSelect=select * from tb_enterprise

#--企业招聘表--#
#--插入数据--#
sql.hr.insert=insert into tb_hr values(?,'?',?,'?','?','?','?','?','?','?','?','?')
#--删除数据--#
sql.hr.delete=delete from tb_hr where hr_id =?
#--查询数据--#
sql.hr.select=select hr_id,hr_eid,enterprise_name,hr_content,hr_howMany,hr_schoolAge,hr_linkman,hr_tel,hr_address,hr_workPlace,hr_demand,hr_linkmanEmail,hr_beginTime,hr_endTime from tb_enterprise inner join tb_hr  on tb_enterprise.enterprise_id=tb_hr.hr_eid where 1=1
#--统计招聘记录--#
sql.hr.count=select count(*) as number from tb_enterprise inner join tb_hr  on tb_enterprise.enterprise_id=tb_hr.hr_eid where 1=1
#--根据发布时期查询--#
sql.hr.dateselect=select * from tb_hr where hr_begintime='?'
#--根据招聘编号查询--#
sql.hr.hotelselect=select * from tb_hr where hr_id=?
#--统计根据id招聘记录--#
sql.hr.idcount=select count(*)  as number from tb_hr where hr_eid=?
#--根据企业查询--#
sql.hr.eidhotelselect=select * from tb_hr where hr_eid=?
#--更新招聘--#
sql.hr.update= update tb_hr set hr_content='?',hr_howMany=?,hr_schoolAge='?',hr_linkman='?',hr_tel='?',hr_address='?',hr_workPlace='?',hr_demand='?',hr_linkmanEmail='?',hr_beginTime='?',hr_endTime='?' where hr_id =? and hr_eid =?

#--企业公告表--#
#--插入数据--#
sql.hotelNotice.insert=insert into tb_hotelNotice values(?,'?','?','?')
#--删除数据--#
sql.hotelNotice.delete=delete from tb_hotelNotice where hotelNotice_id=?
#--更新数据--#
sql.hotelNotice.update=update tb_hotelNotice set hotelNotice_title='?',hotelNotice_content='?' where hotelNotice_eid=?
#--查询数据--#
sql.hotelNotice.select=select * from tb_hotelNotice
#--统计公告记录--#
sql.hotelNotice.count=select count(*) as number from tb_hotelNotice
#--根据企业编号查询公告--#
sql.hotelNotice.hotelselect=select * from tb_hotelNotice where hotelNotice_eid=？
#--根据日期查询企业公告--#
sql.hotelNotice.timeselect=select * from tb_hotelNotice where hotelNotice_time='?'

#--企业回复表--#
#--插入数据--#
sql.reply.insert=insert into tb_reply  values(?,?,'?',default)
#--删除数据--#
sql.reply.delete=delete from tb_reply where reply_id=?
#--根据反馈编号查询数据--#
sql.reply.select=select * from tb_reply where reply_aid=?
#--根据企业编号查询回复--#
sql.reply.eidselect=select * from tb_reply where reply_eid=?

#--订单表--#
#--插入数据--#
sql.orderForm.insert=insert into tb_orderForm values('?',?,'?','?','?','?','?','?','?','?','?')
#--删除数据--#
sql.orderForm.delete=delete from tb_orderForm where orderForm_id=?
#--企业查询订单--#
sql.orderForm.hotelselect=select * from tb_orderForm where orderForm_id=?
#--查询订单--#
sql.orderForm.userselect=select orderform_id,orderform_rid,orderform_eid,enterprise_name,orderform_uid,orderform_user,orderform_type,orderform_usertel,orderform_sex,orderform_price,orderform_ordertime,orderform_checkintime,orderform_checkouttime  from tb_orderform  inner join tb_enterprise  on tb_enterprise.enterprise_id=tb_orderform.orderform_eid where 1=1
#--统计查询订单--#
sql.orderForm.count=select count(*) as number  from tb_orderform  inner join tb_enterprise  on tb_enterprise.enterprise_id=tb_orderform.orderform_eid where 1=1


#--房间类型表--#
#--插入数据--#
sql.room.insert=insert into tb_room values(?,'?',?)
#--更新数据--#
sql.room.update=update tb_room set room_price=? where room_eid=? and room_type='?'
#--删除数据--#
sql.room.delete=delete from tb_room where room_eid=? and room_type='?'
#--查询数据--#
sql.room.select=select * from tb_room where room_eid =?

#--房间表--#
#--插入数据--#
sql.house.insert=insert into tb_house values('?','?',?,'?','?')
#--删除数据--#
sql.house.delete=delete from tb_house where house_number=? and house_eid=?
#--根据酒店和房间类型查询数据--#
sql.house.select=select * from tb_house where house_eid =? and house_type='?'
#--根据酒店和房间类型查询数据--#
sql.house.typeselect=select * from tb_house where house_eid=? and house_type='?' and house_status='?'
#--根据酒店和房间类型更新住房状态--#
sql.house.updatestatus=update tb_house set house_status='?' where house_number =? and house_eid=?
#--根据酒店和房间类型统计记录--#
sql.house.count=select count(*) as number from tb_house where house_eid =? and house_type='?'