String end = date + " 23:59:59";
String sqlCode = "select a.c_name 宾客,a.c_tel 联系电话,b.r_type 预定房间类型,a.r_no 预定房间编号,a.pa_time 预抵时间,a.keep_time 保留时间,a.eng_time 预定时间,a.remark 备注 "+
"from engage as a,roomtype as b where a.r_type_id = b.id and a.delmark = 0 and b.delmark = 0 and engagemark = 2 and a.pa_time between '"+start+"' and '"+end+"'";
sunsql.initDTM(dtm,sqlCode);
}
}
图20 客房预定信息核心代码
6.1.6客户管理
客户管理功能包过会员基本信息维护(会员信息增加,修改和删除),来宾信息一览表,通过会员或者是会员编号可以查询到会员的基本信息,也可以刷新会员信息。对于来宾信息一览表同样也可以通过来宾或者是编号查询到来宾的基本信息。客户管理的程序流程如图21所示:
图21 客户管理的程序流程图
图22 增加会员信息图
添加会员的主要的代码如图23所示:
public void actionPerformed(ActionEvent ae) {
Object o = ae.getSource();
if(o==bt1) {//=====================================保存
long pk = sunsql.getPrimaryKey();//得到主键
String m_id,m_name,sex,zj_no,m_tel,address;
m_id = tf1.getText();
m_name = tf2.getText();
sex = cb1.getSelectedItem()+"";
zj_no = tf3.getText();
m_tel = tf4.getText();
address = tf5.getText();
if(m_id.equals("")||m_name.equals("")||zj_no.equals("")||m_tel.equals("")||address.equals("")) {
//若添加项有空值
JOptionPane.showMessageDialog(null,"会员信息有空值,请重新输入!");
return;
}else {
try {
ResultSet rs = sunsql.executeQuery("select m_id from member where m_id = '"+m_id+"' and delmark = 0");
if(rs.next()) {
JOptionPane.showMessageDialog(null,"该会员编号已存在,请重新输入!");
tf1.requestFocus();
tf1.setText("");
}else if(!suntools.isNum(tf4.getText())) {//判断电话是否由数字组成
JOptionPane.showMessageDialog(null,"联系电话必须由数字组成,请重新输入!");
tf4.setText("");
}else {//将添加的信息插入会员表
String sqlCode = "insert into member (pk,m_id,m_name,sex,zj_no,m_tel,address)" +
"values ("+pk+",'"+m_id+"','"+m_name+"','"+sex+"','"+zj_no+"','"+m_tel+"','"+address+"')";