住宿管理.java

该源码为酒店等使用的源码

              s5 = "'" + defaultModel.getValueAt(row, column+1) + "'";
              s6 = "'" + defaultModel.getValueAt(row, column+2) + "'";
	   }
	   if(column == 4){
		      s1 = "'" + defaultModel.getValueAt(row, column-4) + "'"; 
	          s2 = "'" + defaultModel.getValueAt(row, column-3) + "'";
	          s3 = "'" + defaultModel.getValueAt(row, column-2) + "'";
	          s4 = "'" + defaultModel.getValueAt(row, column-1) + "'";
	          s5 = "'" + defaultModel.getValueAt(row, column) + "'";
	          s6 = "'" + defaultModel.getValueAt(row, column+1) + "'";
     }
	  if(column == 5){
	          s1 = "'" + defaultModel.getValueAt(row, column-5) + "'"; 
	          s2 = "'" + defaultModel.getValueAt(row, column-4) + "'";
	          s3 = "'" + defaultModel.getValueAt(row, column-3) + "'";
              s4 = "'" + defaultModel.getValueAt(row, column-2) + "'";
              s5 = "'" + defaultModel.getValueAt(row, column-1) + "'";
              s6 = "'" + defaultModel.getValueAt(row, column) + "'";
 }
	  System.out.println(s2);
    }
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new 住宿管理().setVisible(true);
            }
        });
    }
    public void 删除() { 
   	 try { 
	     con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
	     stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
   	 int row=jTable1.getSelectedRow();//.getSelectedRow(); 
   	 stm.executeUpdate("DELETE FROM 住宿 Where o_id='"+a[row][0]+"'"); 
   	 JOptionPane.showMessageDialog(null,"数据已成功删除");
   	 defaultModel.removeRow(row);
   	 jTable1.updateUI();
   	 //this.显示();
   	 } 
   	 catch (SQLException ex) {
   		 JOptionPane.showMessageDialog(null,ex);
   	 }
   	 } 
    
    public void 显示(){
   	 try { 
	        int i = 0;
	    	con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
	    	stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
	    	rs = stm.executeQuery("select o_id,s_name,d_name,o_data,m_name,o_year from 住宿 O,客户 S,会员 D,客房 M where O.m_id=M.m_id and O.s_id=S.s_id and S.d_id=D.d_id;");
	    	while(rs.next()){
	    		o_id = rs.getInt(1);
	    		s_name = rs.getString(2);
	    		d_name = rs.getString(3);
	    		date = rs.getString(4);
	    		m_name = rs.getString(5);
	    		o_year = rs.getString(6);
	    	a[i][0] = String.valueOf(o_id);
	    	a[i][1] = s_name;
	    	a[i][2] = d_name;
	    	a[i][3] = date;
	    	a[i][4] = m_name;
	    	a[i][5] = o_year;
	    	i++;
	    	}
	    	pack();
	    	defaultModel.setDataVector(a,colname);
	    	stm.close();
	    	con.close();
	    	jTable1.updateUI(); 
   	 }
   	 catch (SQLException ex) {
   		 JOptionPane.showMessageDialog(null,ex);
   	 }
	    }
   
  public void 添加1() throws java.sql.SQLException{
       con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
   	stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
   	//rs = stm.executeQuery("SELECT * FROM department");
   	//int n = jTable1.getRowCount();
  	    //jTextField1.setText(String.valueOf(+2));
  	    String //s1 = "'" + jTextField1.getText().trim() + "'",
	           //s2 = "'" + jTextField2.getText().trim() + "'",
	           s3 = "'" + jTextField3.getText().trim() + "'",
	           s4 = "'" + jTextField4.getText().trim() + "'",
	           s5 = "'" + jTextField5.getText().trim() + "'";
   	    rSet1= stm.executeQuery("select s_id from 客户 where s_name='"+jTextField1.getText()+"';");
	    rSet1.next();
	    int temp1= rSet1.getInt(1);
	    rSet2= stm.executeQuery("select m_id from 客房 where m_name='"+jTextField2.getText()+"';");
	    rSet2.next();
	    int temp2= rSet2.getInt(1);
  	    String temp = "insert into 住宿(o_id,m_id,s_id,o_data,o_year) values("+s3+","+temp2+","+temp1+","+s4+","+s5+")";
  	    //System.out.println("Connection Successful!");   
  	    stm.executeUpdate(temp);
  	    stm.close();
  	    con.close();
  	    JOptionPane.showMessageDialog(this,"输入成功！");
  	    jTextField5.setText("");
  	  	jTextField4.setText("");
  	    jTextField3.setText("");
  	    jTextField2.setText("");
  	    jTextField1.setText("");
  	    jTable1.removeAll();
  	    this.显示();
  	    jTable1.updateUI(); 
  }
  
  public void 添加2() throws java.sql.SQLException{
	   int row = jTable1.getSelectedRow();
	   int column = jTable1.getSelectedColumn();
	   String s1 = null,s2 = null,s3 = null,s4 = null,s5 = null,s6 = null;
       con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
  	   stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
 	   if(column == 0){
 		      s1 = "'" + defaultModel.getValueAt(row, column) + "'"; 
	          s2 = "'" + defaultModel.getValueAt(row, column+1) + "'";
              s3 = "'" + defaultModel.getValueAt(row, column+2) + "'";
              s4 = "'" + defaultModel.getValueAt(row, column+3) + "'";
              s5 = "'" + defaultModel.getValueAt(row, column+4) + "'";
              s6 = "'" + defaultModel.getValueAt(row, column+5) + "'";
 	   }
 	   if(column == 1){
 		      s1 = "'" + defaultModel.getValueAt(row, column-1) + "'"; 
	          s2 = "'" + defaultModel.getValueAt(row, column) + "'";
	          s3 = "'" + defaultModel.getValueAt(row, column+1) + "'";
	          s4 = "'" + defaultModel.getValueAt(row, column+2) + "'";
              s5 = "'" + defaultModel.getValueAt(row, column+3) + "'";
              s6 = "'" + defaultModel.getValueAt(row, column+4) + "'";
 	   }
 	   if(column == 2){
		      s1 = "'" + defaultModel.getValueAt(row, column-2) + "'"; 
		      s2 = "'" + defaultModel.getValueAt(row, column-1) + "'";
		      s3 = "'" + defaultModel.getValueAt(row, column) + "'";
              s4 = "'" + defaultModel.getValueAt(row, column+1) + "'";
              s5 = "'" + defaultModel.getValueAt(row, column+2) + "'";
              s6 = "'" + defaultModel.getValueAt(row, column+3) + "'";
	   }
 	   if(column == 3){
 		   	  s1 = "'" + defaultModel.getValueAt(row, column-3) + "'"; 
	          s2 = "'" + defaultModel.getValueAt(row, column-2) + "'";
	          s3 = "'" + defaultModel.getValueAt(row, column-1) + "'";
              s4 = "'" + defaultModel.getValueAt(row, column) + "'";
              s5 = "'" + defaultModel.getValueAt(row, column+1) + "'";
              s6 = "'" + defaultModel.getValueAt(row, column+2) + "'";
 	   }
 	   if(column == 4){
 		      s1 = "'" + defaultModel.getValueAt(row, column-4) + "'"; 
	          s2 = "'" + defaultModel.getValueAt(row, column-3) + "'";
	          s3 = "'" + defaultModel.getValueAt(row, column-2) + "'";
	          s4 = "'" + defaultModel.getValueAt(row, column-1) + "'";
	          s5 = "'" + defaultModel.getValueAt(row, column) + "'";
	          s6 = "'" + defaultModel.getValueAt(row, column+1) + "'";
       }
 	   if(column == 5){
	          s1 = "'" + defaultModel.getValueAt(row, column-5) + "'"; 
	          s2 = "'" + defaultModel.getValueAt(row, column-4) + "'";
	          s3 = "'" + defaultModel.getValueAt(row, column-3) + "'";
              s4 = "'" + defaultModel.getValueAt(row, column-2) + "'";
              s5 = "'" + defaultModel.getValueAt(row, column-1) + "'";
              s6 = "'" + defaultModel.getValueAt(row, column) + "'";
 	  	}
 	    rSet1= stm.executeQuery("select s_id from 客户 where s_name="+s2+";");
	    rSet1.next();
	    int temp1= rSet1.getInt(1);
	    rSet2= stm.executeQuery("select m_id from 客房 where m_name="+s5+";");
	    rSet2.next();
	    int temp2= rSet2.getInt(1);
	    String temp = "insert into 住宿(o_id,m_id,s_id,o_data,o_year) values("+s1+","+temp2+","+temp1+","+s4+","+s6+")";
	    //System.out.println("Connection Successful!");   
	   stm.executeUpdate(temp);
	   stm.close();
	   con.close();
	   JOptionPane.showMessageDialog(this,"输入成功！");
	   jTable1.removeAll();
	   this.显示();
	   jTable1.updateUI();
 }
  public void 更新() throws java.sql.SQLException{
	   int row = jTable1.getSelectedRow();
	   int column = jTable1.getSelectedColumn();
	   String s1 = null,s2 = null,s3 = null,s4 = null,s5 = null,s6 = null;
	   con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
  	   stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
  	   if(column == 0){
	      s1 = "'" + defaultModel.getValueAt(row, column) + "'"; 
	      s2 = "'" + defaultModel.getValueAt(row, column+1) + "'";
	      s3 = "'" + defaultModel.getValueAt(row, column+2) + "'";
          s4 = "'" + defaultModel.getValueAt(row, column+3) + "'";
          s5 = "'" + defaultModel.getValueAt(row, column+4) + "'";
          s6 = "'" + defaultModel.getValueAt(row, column+5) + "'";
  	 	}
  	   if(column == 1){
	      s1 = "'" + defaultModel.getValueAt(row, column-1) + "'"; 
	      s2 = "'" + defaultModel.getValueAt(row, column) + "'";
	      s3 = "'" + defaultModel.getValueAt(row, column+1) + "'";
	      s4 = "'" + defaultModel.getValueAt(row, column+2) + "'";
	      s5 = "'" + defaultModel.getValueAt(row, column+3) + "'";
	      s6 = "'" + defaultModel.getValueAt(row, column+4) + "'";
  	   }
  	   if(column == 2){
	      s1 = "'" + defaultModel.getValueAt(row, column-2) + "'"; 
	      s2 = "'" + defaultModel.getValueAt(row, column-1) + "'";
	      s3 = "'" + defaultModel.getValueAt(row, column) + "'";
	      s4 = "'" + defaultModel.getValueAt(row, column+1) + "'";
	      s5 = "'" + defaultModel.getValueAt(row, column+2) + "'";
	      s6 = "'" + defaultModel.getValueAt(row, column+3) + "'";
  	   }
  	   if(column == 3){
	   	  s1 = "'" + defaultModel.getValueAt(row, column-3) + "'"; 
          s2 = "'" + defaultModel.getValueAt(row, column-2) + "'";
          s3 = "'" + defaultModel.getValueAt(row, column-1) + "'";
          s4 = "'" + defaultModel.getValueAt(row, column) + "'";
          s5 = "'" + defaultModel.getValueAt(row, column+1) + "'";
          s6 = "'" + defaultModel.getValueAt(row, column+2) + "'";
  	   }
  	   if(column == 4){
	      s1 = "'" + defaultModel.getValueAt(row, column-4) + "'"; 
          s2 = "'" + defaultModel.getValueAt(row, column-3) + "'";
          s3 = "'" + defaultModel.getValueAt(row, column-2) + "'";
          s4 = "'" + defaultModel.getValueAt(row, column-1) + "'";
          s5 = "'" + defaultModel.getValueAt(row, column) + "'";
          s6 = "'" + defaultModel.getValueAt(row, column+1) + "'";
  	   }
  	   if(column == 5){
          s1 = "'" + defaultModel.getValueAt(row, column-5) + "'"; 
          s2 = "'" + defaultModel.getValueAt(row, column-4) + "'";
          s3 = "'" + defaultModel.getValueAt(row, column-3) + "'";
          s4 = "'" + defaultModel.getValueAt(row, column-2) + "'";
          s5 = "'" + defaultModel.getValueAt(row, column-1) + "'";
          s6 = "'" + defaultModel.getValueAt(row, column) + "'";
  	   }
  	   	rSet1= stm.executeQuery("select s_id from 客户 where s_name="+s2+";");
  	   	rSet1.next();
  	   	int temp1= rSet1.getInt(1);
  	   	rSet2= stm.executeQuery("select m_id from 客房 where m_name="+s5+";");
  	   	rSet2.next();
  	   	int temp2= rSet2.getInt(1);
  	   	String temp = "insert into 住宿(o_id,m_id,s_id,o_data,o_year) values("+s1+","+temp2+","+temp1+","+s4+","+s6+")";
 	    //System.out.println("Connection Successful!");   
  	   	stm.executeUpdate(temp);
 	   	stm.close();
 	   	con.close();
 	   	JOptionPane.showMessageDialog(this,"编辑成功！");
 	   	jTable1.removeAll();
 	   	this.显示();
 	   	jTable1.updateUI(); 
  }
    // 变量声明 - 不进行修改
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    private javax.swing.JTextField jTextField5;
    private javax.swing.table.DefaultTableModel defaultModel;
    private java.sql.Connection con;
    private java.sql.Statement stm;
    private java.sql.ResultSet rs,rSet1,rSet2;
    Object colname[]= {"预订号", "客户姓名", "会员级别", "预订日期", "房间类型", "住宿天数"};
    int o_id;
    String s_name,date,m_name,o_year,d_name;
    Object a[][]= new Object[24][6];
    // 变量声明结束
    
}