客户管理.java

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

        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);
        }
    }                                      
    
    /**
     * @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 d_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 s_id,s_name,d_name from 客户 A,会员 B where B.d_id=A.d_id;");
	    	while(rs.next()){
	    		s_id = rs.getInt(1);
	    		s_name = rs.getString(2);
	    		d_name = rs.getString(3);
	    	a[i][0] = String.valueOf(s_id);
	    	a[i][1] = s_name;
	    	a[i][2] = d_name;
	    	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() + "'";
   	    rSet= stm.executeQuery("select d_id from 会员 where d_id='"+jTextField3.getText()+"';");
	    rSet.next();
	    int temp1= rSet.getInt(1);
   	    String temp = "insert into 客户(s_id,s_name,d_id) values("+s1+","+s2+","+temp1+")";
   	    //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) + "'";
	   }
  	    rSet= stm.executeQuery("select d_id from 会员 where d_name="+s3+";");
	    rSet.next();
	    int temp1= rSet.getInt(1);
        String temp = "insert into 客户(s_id,s_name,d_id) values("+s1+","+s2+","+temp1+")";
  	    //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) + "'";
   	   }
   	   rSet= stm.executeQuery("select d_id from 会员 where d_name="+s3+";");
   	   rSet.next();
   	   int temp1= rSet.getInt(1);
   	   String temp = "insert into 客户(s_id,s_name,d_id) values("+s1+","+s2+","+temp1+")";
	    //System.out.println("Connection Successful!");   
	   stm.executeUpdate(temp);
  	   stm.close();
  	   con.close();
  	   JOptionPane.showMessageDialog(this,"编辑成功！");
  	   jTable1.removeAll();
  	   this.显示();
  	   jTable1.updateUI(); 
   }
   
    // Integer.parseInt(jtf[1].getText())变量声明 - 不进行修改
    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,rSet;
    Object colname[]= {"客户编号", "客户姓名", "会员级别"};
    int s_id;
    String d_name,s_name;
    Object a[][]= new Object[24][3];
    // 变量声明结束
    
}