会员管理.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 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 * FROM 会员");
	    	while(rs.next()){
	    		d_id = rs.getInt(1);
	    		d_name = rs.getString(2);
	    	a[i][0] = String.valueOf(d_id);
	    	a[i][1] = d_name;
	    	i++;
	    	}
	    	pack();
	    	defaultModel.setDataVector(a,colname);
	    	stm.close();
	    	con.close();
	    	jTable1.updateUI(); 
    	 }
    	 catch (SQLException ex) {
    		 JOptionPane.showMessageDialog(null,ex);
    	 }
	    }

   public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new 会员管理().setVisible(true);
            }
        });
    }
   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 会员");
    	int n = jTable1.getRowCount();
    	//rs.afterLast();
    	//int n = rs.getRow();
   	    //jTextField3.setText(String.valueOf(+2));
   	    String s2 = "'" + jTextField2.getText().trim() + "'",
               s3 = "'" + jTextField3.getText().trim() + "'";
        String temp = "insert into 会员(d_id,d_name) values("+s3+","+s2+")";
   	    //System.out.println("Connection Successful!");   
   	    stm.executeUpdate(temp);
   	    stm.close();
   	    con.close();
   	    JOptionPane.showMessageDialog(this,"输入成功！");
   	    jTextField3.setText("");
   	    jTextField2.setText("");
   	    jTable1.removeAll();
   	    this.显示();
   	    jTable1.updateUI(); 
   }
   public void 添加2() throws java.sql.SQLException{
	   int row = jTable1.getSelectedRow();
	   int column = jTable1.getSelectedColumn();
	   String 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){
	          s2 = "'" + defaultModel.getValueAt(row, column) + "'";
              s3 = "'" + defaultModel.getValueAt(row, column+1) + "'";
  	   }
  	   if(column == 1){
	          s2 = "'" + defaultModel.getValueAt(row, column-1) + "'";
              s3 = "'" + defaultModel.getValueAt(row, column) + "'";
  	   }
       String temp = "insert into 会员(d_id,d_name) values("+s2+","+s3+")";
  	    //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;
		   con = java.sql.DriverManager.getConnection("jdbc:odbc:keith","","");
		   stm = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE, java.sql.ResultSet.CONCUR_UPDATABLE);
	       //int r=jTable1.getSelectedRow();//.getSelectedRow(); 
	       //System.out.println(a[r][0]);
	       stm.executeUpdate("DELETE FROM 会员 Where d_id='"+a[row][0]+"'");
	       if(column == 0){
		          s2 = "'" + defaultModel.getValueAt(row, column) + "'";
	              s3 = "'" + defaultModel.getValueAt(row, column+1) + "'";
	  	   }
	  	   if(column == 1){
		          s2 = "'" + defaultModel.getValueAt(row, column-1) + "'";
	              s3 = "'" + defaultModel.getValueAt(row, column) + "'";
	  	   }
	       String temp = "insert into 会员(d_id,d_name) values("+s2+","+s3+")";
	  	    //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 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 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;
    private Object colname[]= {"会员号", "会员级别"};
    private int d_id;
    private String d_name;
    private Object a[][]= new Object[24][2];
    
    // 变量声明结束
    
}