客房管理.java

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

        pack();
        
    }// </editor-fold>

    private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
    	this.删除();
    }

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
    	try{添加2();}
        catch(java.sql.SQLException e){
       	 	System.out.println(e);
       }
    }

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
    	try{更新();}
        catch(java.sql.SQLException e){
       	 	System.out.println(e);
        }
    }

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
    	this.dispose();
    	主操作 ma =new 主操作();
		ma.setVisible(true);
    }

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    	try{添加1();}
        catch(java.sql.SQLException e){
       	 System.out.println(e);
       }
    }
    
    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 m_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 * FROM 客房");
	    	while(rs.next()){
	    		m_id = rs.getInt(1);
	    		m_name = rs.getString(2);
	    		m_p = rs.getInt(3);
	    	a[i][0] = String.valueOf(m_id);
	    	a[i][1] = m_name;
	    	a[i][2] = String.valueOf(m_p);
	    	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() + "'";
  	    String temp = "insert into 客房(m_id,m_name,m_price) values("+s3+","+s2+","+s1+")";
  	    //System.out.println("Connection Successful!");   
  	    stm.executeUpdate(temp);
  	    stm.close();
  	    con.close();
  	    JOptionPane.showMessageDialog(this,"输入成功！");
  	    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;
	   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) + "'";
 	   }
 	   if(column == 1){
 		      s1 = "'" + defaultModel.getValueAt(row, column-1) + "'"; 
	          s2 = "'" + defaultModel.getValueAt(row, column) + "'";
	          s3 = "'" + defaultModel.getValueAt(row, column+1) + "'";
 	   }
 	   if(column == 2){
		      s1 = "'" + defaultModel.getValueAt(row, column-2) + "'"; 
		      s2 = "'" + defaultModel.getValueAt(row, column-1) + "'";
		      s3 = "'" + defaultModel.getValueAt(row, column) + "'";
	   }
      String temp = "insert into 客房(m_id,m_name,m_price) values("+s3+","+s2+","+s1+")";
 	    //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 s2 = null,s3 = null,s1 = 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) + "'";
  	   }
  	   if(column == 1){
	      s1 = "'" + defaultModel.getValueAt(row, column-1) + "'"; 
	      s2 = "'" + defaultModel.getValueAt(row, column) + "'";
	      s3 = "'" + defaultModel.getValueAt(row, column+1) + "'";
  	   }
  	   if(column == 2){
	      s1 = "'" + defaultModel.getValueAt(row, column-2) + "'"; 
	      s2 = "'" + defaultModel.getValueAt(row, column-1) + "'";
	      s3 = "'" + defaultModel.getValueAt(row, column) + "'";
  	   }
      String temp = "insert into 客房(m_id,m_name,m_price) values("+s3+","+s2+","+s1+")";
 	    //System.out.println("Connection Successful!");   
 	   stm.executeUpdate(temp);
 	   stm.close();
 	   con.close();
 	   JOptionPane.showMessageDialog(this,"编辑成功！");
 	   jTable1.removeAll();
 	   this.显示();
 	   jTable1.updateUI(); 
  }
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new 客房管理().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改
    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.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.table.DefaultTableModel defaultModel;
    private java.sql.Connection con;
    private java.sql.Statement stm;
    private java.sql.ResultSet rs;
    Object colname[]= { "房间号", "房间类型", "价格"};
    int m_id,m_p;
    String m_name;
    Object a[][]= new Object[24][3];
    // 变量声明结束
    
}