📄 frame1.java~186~
字号:
{
boolean notblank=false;
if(!jTextField6.getText().equals(" "))
notblank=true;
if(notblank)
query = "DELETE FROM hotel2 WHERE name LIKE" + "'" + jTextField2.getText() + "'"+"AND room LIKE"+"'"+jTextField6.getText() + "'";
}
jTextArea1.append("\n发送的命令:"+connect.nativeSQL(query)+"\n");
int result = statement.executeUpdate( query );
if ( result == 1 )
jTextArea1.append( "\n删除成功\n" );
else {
jTextArea1.append( "\n删除失败,请查看输入的房号是否正确。\n" );
jTextField2.setText( "" );
jComboBox1.setSelectedIndex(-1);
jTextField4.setText( "" );
jTextField5.setText( "" );
jTextField6.setText( "" );
}
}
else
jTextArea1.append( "\n请您输入名子" );
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}*/
}
void displaydetail( ResultSet rs )
{
try {
Calendar cal=Calendar.getInstance( );
String c=cal.get(Calendar.YEAR)+"-"+(cal.get(Calendar.MONTH)+1)+"-"+cal.get(Calendar.DATE);
boolean morerows=false;
//y
if (rs.next() ) {
jTextField2.setText( rs.getString(1) );
jComboBox1.setSelectedItem( rs.getString( 2 ) );
jTextField4.setText( rs.getString( 3 ) );
jTextField5.setText( rs.getString( 4 ) );
jTextField6.setText( rs.getString( 5 ) );
String temp=rs.getString(6);
Countdays count =new Countdays(temp,c);
jTextField1.setText(" "+price_eachday*count.getdays());
if(rs.next()) morerows=true;
if(!morerows)
{
String command = "DELETE FROM hotel2 WHERE name LIKE" +
"'" + jTextField2.getText() + "'";
delete(command);
}
}
else
jTextArea1.append( "\n没找到记录\n" );
if(morerows)
{
rs.beforeFirst();
//message(" 您要删除的人的姓名不止一个，请在信息栏中查看，并填入他的房号，谢谢！");
String p="name"+"\t\t"+"room"+"\n";
while(rs.next())
{
String temp=rs.getString(6);
Countdays count =new Countdays(temp,c);
String money=" "+price_eachday*count.getdays();
p=p+rs.getString( 1 )+"\t\t"+ rs.getString( 5 )+"\n";
}
jTextArea1.setText(p);
boolean judgeinput=false;
String roomnum="";
String command="";
//while(judge_roomnum(roomnum))
roomnum=JOptionPane.showInputDialog(" 您要删除的人的姓名不止一个，请在信息栏中查看，并在当前行填入他的具体房号，谢谢！");
while(!judge_roomnum(roomnum))
{
roomnum=JOptionPane.showInputDialog("您输入的房号不合法，房号只能为1到100的数字，请您重新输入，谢谢！");
}
command= "DELETE FROM hotel2 WHERE name LIKE" + "'" + jTextField2.getText() + "'"+"AND room LIKE"+"'"+roomnum + "'";
delete(command);
}
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
void delete(String m)
{
try {
Statement statement = connect.createStatement();
//if ( !jTextField2.getText().equals( "" ) ) {
String query="";
// if(morethanone==false)
query = m;
/*if(morethanone==true)
{
boolean notblank=false;
if(!jTextField6.getText().equals(" "))
notblank=true;
if(notblank)
query = "DELETE FROM hotel2 WHERE name LIKE" + "'" + jTextField2.getText() + "'"+"AND room LIKE"+"'"+jTextField6.getText() + "'";
}*/
jTextArea1.append("\n发送的命令:"+connect.nativeSQL(query)+"\n");
int result = statement.executeUpdate( query );
if ( result == 1 )
jTextArea1.append( "\n删除成功\n" );
else {
jTextArea1.append( "\n删除失败,请查看输入的房号是否正确。\n" );
jTextField2.setText( "" );
jComboBox1.setSelectedIndex(-1);
jTextField4.setText( "" );
jTextField5.setText( "" );
jTextField6.setText( "" );
}
// }
// else
// jTextArea1.append( "\n请您输入名子" );
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
void jMenuItem1_actionPerformed(ActionEvent e) {
JTextArea t=new JTextArea(10,15);
t.setLineWrap(true);
t.setEditable(false);
JScrollPane p=new JScrollPane(t);
t.setText("这是小弟近期一作品，请各位大侠指教！谁要是看着好就用吧，也没什么商业价值！我的QQ是：2410052。欢迎大家给我留言赐教，谢谢！");
JOptionPane.showMessageDialog(null,p,"谢谢使用，请多提意见！",JOptionPane.INFORMATION_MESSAGE);
}
void jButton4_actionPerformed(ActionEvent e) {
try {
Statement statement =connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String query = "SELECT * FROM hotel2 ";
jTextArea1.append( "\n发送的命令: " +
connect.nativeSQL( query )
+ "\n" );
ResultSet rs = statement.executeQuery( query );
findemptyroom( rs );
jTextArea1.append( "\n查询成功\n" );
statement.close();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
void findemptyroom(ResultSet r)
{
int m=0;
String emptyroom=" ";
try {
if(r.next())
{
//r.beforeFirst();
for(int j=1;j<=100;j++)
{
r.first();
int full=0;
do
{
if(r.getString( 5 ).equals(Integer.toString(j)))
{
full=1;
break;
}
}
while(r.next());
if(full==1) continue;
else
{
emptyroom = emptyroom + " " + j;
if(++m%5==0) emptyroom=emptyroom+"\n";
}
}
}
else
{
jTextArea1.setText("");
jTextArea1.setText("1～100号房间全是空的，您随便选吧！");
}
jTextArea1.setText(emptyroom);
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
}
/**该方法是年龄范围的合法性检验*/
boolean judge_age(String input)
{
int age;
try{
age = Integer.parseInt(input);
}catch(Exception e){
return false;
}
//数字范围在18至60的返回值是true
if((age >= 1) && (age <=100))
return true;
else
return false;
}
boolean judge_roomnum(String input)
{
int age;
try{
age = Integer.parseInt(input);
}catch(Exception e){
return false;
}
if((age >= 1) && (age <=100))
return true;
else
return false;
}
boolean namelegal()
{
if(!jTextField2.getText().equals("")&&jTextField2.getText().length()<=50)
return true;
else
{
message("必须输入姓名，且长度不能超过50");
return false;
}
}
boolean legal()
{
if( judge_age(jTextField4.getText())&&judge_roomnum(jTextField6.getText()))
return true;
else{
message("房号和年龄必须在1到100之间，请重新输入！");
jTextField4.setText("");
jTextField6.setText("");
return false;
}
}
boolean judge_idnum()
{
if(jTextField5.getText().length()==18)
{
String front1=jTextField5.getText().substring(0,4);
String front2=jTextField5.getText().substring(4,8);
String front3=jTextField5.getText().substring(8,12);
String front4=jTextField5.getText().substring(12,16);
String back=jTextField5.getText().substring(16,jTextField5.getText().length());
if(idnum(front1)&&idnum(front2)&&idnum(front3)&&idnum(front4)&&idnum(back))
return true;
else
{
message("身份证号必须为18位的数字，请重新输入！");
jTextField5.setText("");
return false;
}
}
else
{
message("身份证号必须为18位的数字,请重新输入!");
jTextField5.setText("");
return false;
}
}
boolean idnum(String t)
{
try{
Integer.parseInt(t);
}catch(Exception e){
return false;
}
//数字范围在18至60的返回值是true
return true;
}
boolean judge_sex()
{
if(!jComboBox1.getSelectedItem().equals(""))
return true;
else
{
message("请选择性别");
return false;
}
}
void message(String t)
{
JOptionPane.showMessageDialog(null,t);
}
void jMenuItem2_actionPerformed(ActionEvent e) {
JTextArea t=new JTextArea(10,15);
t.setLineWrap(true);
t.setEditable(false);
JScrollPane p=new JScrollPane(t);
t.setText("本程序为酒店客房管理系统，采用微软的Access数据库实现。因此，请用户在使用前先安装微软的office，以便程序使用其中的Access。在用户安装完office后，请新建一个Access表数据库，字段名分别为“ name,sex,age,idnumber,room ,in_date”，并且全为字符型。在完成以上操作后，请用户在要运行程序的计算机上安装odbc数据源（方法我就不细说了，好多java的书上有讲）。然后，用户就可以运行程序了！");
JOptionPane.showMessageDialog(null,p,"谢谢使用，请多提意见！",JOptionPane.INFORMATION_MESSAGE);
}
public static void main(String args[])
{
Frame1 app=new Frame1();
app.addWindowListener(
new WindowAdapter(){
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
}
);
}
}
class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class Frame1_jButton3_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton3_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class Frame1_jButton5_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton5_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton5_actionPerformed(e);
}
}
class Frame1_jButton2_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton2_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class Frame1_jMenuItem1_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jMenuItem1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jMenuItem1_actionPerformed(e);
}
}
class Frame1_jButton4_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jButton4_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}
class Frame1_jMenuItem2_actionAdapter implements java.awt.event.ActionListener {
Frame1 adaptee;
Frame1_jMenuItem2_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jMenuItem2_actionPerformed(e);
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -