yewudanganjtable.java

业务信息管理平台,适用于企业内部信息管理,合同管理

// PhilosophersJTable.java
// MVC architecture using JTable with a DefaultTableModel


import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
// Java extension packages	
import javax.swing.*;
import javax.swing.table.*;

public class YewudanganJTable extends JFrame {

   private DefaultTableModel philosophers;
   private JTable table;

   // PhilosophersJTable constructor
   public YewudanganJTable(String name,String truename) 
   {
      super( "业务员档案信息" );

      // create a DefaultTableModel to store philosophers
      philosophers = new DefaultTableModel();      
      
      // add Columns to DefaultTableModel
      philosophers.addColumn( "业务员姓名" );
      philosophers.addColumn( "登陆名" );
      philosophers.addColumn( "联系电话" );
      philosophers.addColumn( "业务区域" );
     
      // add philosopher names and dates to DefaultTableModel
	
      	
		ResultSet resSet;	
    	ResultSetMetaData metaData;
    	Connection dbConn;
        Statement stat;	
   
		String sql3;
	
		try { 
			Class.forName(Yewu.forName);
   			dbConn=DriverManager.getConnection(Yewu.jdbc);
 
			if(name.equals("master")||name.equals("root")){
				 sql3="select distinct truename,name,tel,quyu from zhuceTable where name!='master' and name!='root'";
			}else{
				
				 sql3="select distinct truename,name,tel,quyu from zhuceTable where truename='"+truename+"' and name!='master' and name!='root'";
			}
  
 			stat=dbConn.createStatement();
 		    resSet=stat.executeQuery(sql3);
 		   
 			while(resSet.next()){
 				Vector vec=new Vector();
 				vec.add(resSet.getObject("truename").toString());//0
 				vec.add(resSet.getObject("name").toString());//1
 				vec.add(resSet.getObject("tel").toString());
 				vec.add(resSet.getObject("quyu").toString());
			
				
 				philosophers.addRow( vec.toArray() );

 			}	
 		
 			stat.close();
 			dbConn.close();    
       }catch(Exception ex){
       		System.out.println(ex);
       }
		
		
		

      

      table = new JTable( philosophers ); 
     
      
      Container container = getContentPane();       
      container.add( new JScrollPane( table ),BorderLayout.CENTER );      
    
      
     // setDefaultCloseOperation( EXIT_ON_CLOSE );  
      
      
      
      	int iii=(int)(Toolkit.getDefaultToolkit().getScreenSize().getWidth()); 
   		
		if(iii==800){
			
			setBounds(150,150,540,275);
			
		}else{
			
			setBounds(340,220,540,300);
		}
     
      	setVisible( true );
      
      	this.addWindowListener(new WindowAdapter(){
        	public void WindowClosing(WindowEvent e){
               	
            
                  System.exit(0);
                  
               }
            });  
      
   } // end PhilosophersJTable constructor

   // execute application
 
}