usemanagerframe.java

这是一个JAVA开发的商场VIP消费管理系统

		Tablepanel.setPreferredSize(new Dimension(450, 100));
		Tablepanel.setBorder(BorderFactory.createEtchedBorder());
 		Tablepanel.add( scroller ,BorderLayout.CENTER);
 		
        return Tablepanel;
    } // createButtonPanel()
    
    private void UseInfoInput()
    {
   	  if( UseNameField.getText().equals( "" ))
   		{
   			JOptionPane.showMessageDialog( this,"请输入用户名" ); 
         	//setTitle( "无记录显示" ); 
         	return; 	
   		}
   		
      	try 
      	{ 
      		 Databaseconnection();
      		 String UseQuery = "select * from UESR_MANAGER where 用户名 = '"+UseNameField.getText()+"'";
      		 String UseInput = "INSERT INTO UESR_MANAGER VALUES('"
      		 					+ UseNameField.getText()+"','"+PasswordField.getText()+"')";
      		
      		 UseManagerstatement = UseManagerconnection.createStatement();
         	 UseManagerresultSet = UseManagerstatement.executeQuery( UseQuery );  
         	 
         	 boolean moreRecords = UseManagerresultSet.next();     
         	 
         	 if ( moreRecords ) 
      		 { 
         		JOptionPane.showMessageDialog( this,"对不起，此帐号已被使用，请重新选择帐号" ); 
         		//setTitle( "无记录显示" );
         		UseManagerconnection.close(); 
         		return; 
      		 }  
      		 //InsertInputstatement =  Insertconnection.createStatement();
      		 int insert = UseManagerstatement.executeUpdate( UseInput );//executeUpdate返回一个整型值
      		 
      		 if (insert == 1)
      		 {
      		 	JOptionPane.showMessageDialog( this,"帐号注册成功！" );
      		 	getTable();
      		 	UseNameField.setText("");
   		   		PasswordField.setText("");
   		   		
      		 } 
      	} 
      	catch ( SQLException sqlex ) 
      	{ 
        	sqlex.printStackTrace(); 
      	}
    }
    
    private void UseInfoDelete()
    {
   	  if( UseNameField.getText().equals( "" ))
   		{
   			JOptionPane.showMessageDialog( this,"请输入用户名" ); 
         	//setTitle( "无记录显示" ); 
         	return; 	
   		}
   		
      	try 
      	{ 
      		 Databaseconnection();
      		 String UseDelete = "DELETE *  FROM UESR_MANAGER WHERE 用户名 = '"+UseNameField.getText()+"'";
      		 					
      		
      		 UseManagerstatement = UseManagerconnection.createStatement();
         	 
      		 int DELETE = UseManagerstatement.executeUpdate( UseDelete );//executeUpdate返回一个整型值
      		 
      		 if (DELETE == 1)
      		 {
      		 	JOptionPane.showMessageDialog( this,"帐号删除成功！" );
      		 	getTable();
      		 	UseNameField.setText("");
   		   		PasswordField.setText("");
   		   	 } 
      	} 
      	catch ( SQLException sqlex ) 
      	{ 
        	sqlex.printStackTrace(); 
      	}
    }
    
    private void UseInfoChange()
    {
   	  if( UseNameField.getText().equals( "" ))
   		{
   			JOptionPane.showMessageDialog( this,"请输入用户名" ); 
         	//setTitle( "无记录显示" ); 
         	return; 	
   		}
   		
      	try 
      	{ 
      		 Databaseconnection();
      		 String UseQuery  = "select *  FROM UESR_MANAGER WHERE 用户名 = '"+UseNameField.getText()+"'";
      		 String UseDelete = "DELETE *  FROM UESR_MANAGER WHERE 用户名 = '"+UseNameField.getText()+"'";
      		 String UseInsert = "INSERT INTO UESR_MANAGER VALUES('"
      		 					+ UseNameField.getText()+"','"+PasswordField.getText()+"')";
      		 					
      		
      		 UseManagerstatement = UseManagerconnection.createStatement();
         	 UseManagerresultSet = UseManagerstatement.executeQuery( UseQuery );  
         	 
         	 boolean moreRecords = UseManagerresultSet.next();     
         	 
         	 if ( !moreRecords ) 
      		 { 
         		JOptionPane.showMessageDialog( this,"对不起，你输入的帐号不存在，请重新输入" ); 
         		//setTitle( "无记录显示" );
         		UseManagerconnection.close(); 
         		return; 
      		 }  
         	 
      		 int DELETE = UseManagerstatement.executeUpdate( UseDelete );//executeUpdate返回一个整型值
      		 int INSERT = UseManagerstatement.executeUpdate( UseInsert );//executeUpdate返回一个整型值
      		 
      		 if (DELETE == 1)
      		 {
      		 	JOptionPane.showMessageDialog( this,"帐号口令更改成功,请记住新密码！" );
      		 	getTable();
      		 	UseNameField.setText("");
   		   		PasswordField.setText("");
   		   	 } 
      	} 
      	catch ( SQLException sqlex ) 
      	{ 
        	sqlex.printStackTrace(); 
      	}
    }
    
    private void Databaseconnection()
    {
    	String url = "jdbc:odbc:VipQuery"; 
    	String username = ""; 
    	String password = ""; 
    	
    	
    	//加载驱动程序以连接数据库
      	try 
      	{ 
        	Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); 
        	UseManagerconnection = DriverManager.getConnection( url, username, password ); 
      	} 
      	//捕获加载驱动程序异常
      	catch ( ClassNotFoundException cnfex ) 
   		{ 
        	System.err.println("装载 JDBC/ODBC 驱动程序失败。" ); 
        	cnfex.printStackTrace(); 
         	System.exit( 1 );  // terminate program 
      	} 
      	//捕获连接数据库异常
      	catch ( SQLException sqlex ) 
      	{ 
         	System.err.println( "无法连接数据库" ); 
         	sqlex.printStackTrace(); 
       	 	System.exit( 1 );  // terminate program 
      	}
     }
     
   private void getTable() 
   { 
      try 
      { 
      	 //执行SQL语句
      	 String query;
      	 query = "SELECT * FROM UESR_MANAGER"; 
        
         UseManagerstatement = UseManagerconnection.createStatement(); 
         UseManagerresultSet = UseManagerstatement.executeQuery( query );      
         //在表格中显示查询结果
         displayResultSet( UseManagerresultSet);
      } 
      catch ( SQLException sqlex ) { 
         sqlex.printStackTrace(); 
      } 
   }  	
   
    private void displayResultSet( ResultSet rs ) 
      throws SQLException 
   { 
      //定位到达第一条记录
      boolean moreRecords = rs.next();  
      //如果没有记录，则提示一条消息
      if ( ! moreRecords ) { 
         JOptionPane.showMessageDialog( this,"结果集中无记录" ); 
         setTitle( "无记录显示" ); 
         return; 
      } 
      Vector columnHeads = new Vector(); 
      Vector rows = new Vector(); 
      try { 
         //获取字段的名称
         ResultSetMetaData rsmd = rs.getMetaData(); 
         for ( int i = 1; i <= rsmd.getColumnCount(); ++i ) 
            columnHeads.addElement( rsmd.getColumnName( i ) ); 
         //获取记录集
         do { 
            rows.addElement( getNextRow( rs, rsmd ) ); 
         } while ( rs.next() ); 
         //在表格中显示查询结果
         //table = new JTable( rows, columnHeads ); 
         //JScrollPane scroller = new JScrollPane( table ); 
         
         
         JPanel Tablepanel = new JPanel();
         Tablepanel.setLayout(new BorderLayout());
         UseTable = new JTable(rows, columnHeads);
        	
		 JScrollPane scroller = new JScrollPane(UseTable); 
		 scroller.setPreferredSize(new Dimension(440, 95));
        
        
		 //Tablepanel.setLayout( new BorderLayout() );
		 Tablepanel.setPreferredSize(new Dimension(450, 100));
		 Tablepanel.setBorder(BorderFactory.createEtchedBorder());
 		 Tablepanel.add( scroller ,BorderLayout.CENTER);
         
         Container c = getContentPane(); 
         c.remove(1); 
         c.add( Tablepanel, BorderLayout.CENTER ); 
         //刷新Table
         c.validate(); 
      } 
      catch ( SQLException sqlex ) { 
         sqlex.printStackTrace(); 
      } 
   } 
   private Vector getNextRow( ResultSet rs, 
                              ResultSetMetaData rsmd ) 
       throws SQLException 
   { 
      Vector currentRow = new Vector(); 
      for ( int i = 1; i <= rsmd.getColumnCount(); ++i ) 
         currentRow.addElement( rs.getString( i ) ); 
      //返回一条记录   
      return currentRow; 
   } 
}