?? frame1.java~179~
字號:
"WHERE name = '" +
jTextField2.getText() + "'";
jTextArea1.append( "\n發(fā)送的命令: " +
connect.nativeSQL( query )
+ "\n" );
ResultSet rs = statement.executeQuery( query );
displaydetail( rs );
jTextArea1.append( "\n查詢成功\n" );
statement.close();
}
else
jTextArea1.setText(
"請輸入要刪除的房客姓名" );
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
jTextArea1.append( sqlex.toString() );
}
//flag
try {
Statement statement = connect.createStatement();
if ( !jTextField2.getText().equals( "" ) ) {
String query="";
if(morethanone==false)
query = "DELETE FROM hotel2 WHERE name LIKE" +
"'"+jTextField2.getText()+"'";
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"+"'"+jTextField2.getText() + "'";
}
jTextArea1.append("\n發(fā)送的命令:"+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()) morethanone=morerows=true;
}
else
jTextArea1.append( "\n沒找到記錄\n" );
if(morerows)
{ rs.beforeFirst();
message(" 您要刪除的人的姓名不止一個，請在信息欄中查看，并填入他的房號，謝謝！");
String p="name"+"\t\t"+"sex"+"\t\t"+"age"+"\t\t"+"idnumber"+"\t\t\t\t"+"room"
+"\t\t"+"money"+"\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( 2 )+"\t\t"+rs.getString( 3 )
+"\t\t"+ rs.getString( 4 )+"\t\t\t"+rs.getString( 5 )+"\t\t"+money+"\n";
}
jTextArea1.setText(p);
}
}
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("這是小弟近期一作品，請各位大俠指教！誰要是看著好就用吧，也沒什么商業(yè)價值！我的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發(fā)送的命令: " +
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.getFetchSize()!=0)
{
for(int j=0;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;
}
//數(shù)字范圍在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位的數(shù)字，請重新輸入！");
jTextField5.setText("");
return false;
}
}
else
{
message("身份證號必須為18位的數(shù)字,請重新輸入!");
jTextField5.setText("");
return false;
}
}
boolean idnum(String t)
{
try{
Integer.parseInt(t);
}catch(Exception e){
return false;
}
//數(shù)字范圍在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("本程序為酒店客房管理系統(tǒng)，采用微軟的Access數(shù)據(jù)庫實現(xiàn)。因此，請用戶在使用前先安裝微軟的office，以便程序使用其中的Access。在用戶安裝完office后，請新建一個Access表數(shù)據(jù)庫，字段名分別為“ name,sex,age,idnumber,room ,in_date”，并且全為字符型。在完成以上操作后，請用戶在要運行程序的計算機上安裝odbc數(shù)據(jù)源（方法我就不細說了，好多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);
}
}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -