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 = ""; 
    	
    	
    	//加載驅(qū)動程序以連接數(shù)據(jù)庫
      	try 
      	{ 
        	Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); 
        	UseManagerconnection = DriverManager.getConnection( url, username, password ); 
      	} 
      	//捕獲加載驅(qū)動程序異常
      	catch ( ClassNotFoundException cnfex ) 
   		{ 
        	System.err.println("裝載 JDBC/ODBC 驅(qū)動程序失敗。" ); 
        	cnfex.printStackTrace(); 
         	System.exit( 1 );  // terminate program 
      	} 
      	//捕獲連接數(shù)據(jù)庫異常
      	catch ( SQLException sqlex ) 
      	{ 
         	System.err.println( "無法連接數(shù)據(jù)庫" ); 
         	sqlex.printStackTrace(); 
       	 	System.exit( 1 );  // terminate program 
      	}
     }
     
   private void getTable() 
   { 
      try 
      { 
      	 //執(zhí)行SQL語句
      	 String query;
      	 query = "SELECT * FROM UESR_MANAGER"; 
        
         UseManagerstatement = UseManagerconnection.createStatement(); 
         UseManagerresultSet = UseManagerstatement.executeQuery( query );      
         //在表格中顯示查詢結(jié)果
         displayResultSet( UseManagerresultSet);
      } 
      catch ( SQLException sqlex ) { 
         sqlex.printStackTrace(); 
      } 
   }  	
   
    private void displayResultSet( ResultSet rs ) 
      throws SQLException 
   { 
      //定位到達第一條記錄
      boolean moreRecords = rs.next();  
      //如果沒有記錄，則提示一條消息
      if ( ! moreRecords ) { 
         JOptionPane.showMessageDialog( this,"結(jié)果集中無記錄" ); 
         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() ); 
         //在表格中顯示查詢結(jié)果
         //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; 
   } 
}