hetongjtable.java

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

import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;

public class HetongJTable extends JFrame {

   private DefaultTableModel philosophers;
   private JTable table;

   // PhilosophersJTable constructor
   public HetongJTable(String sql,Vector vecs) 
   {
      super( "业务合同信息" );
      // create a DefaultTableModel to store philosophers
      philosophers = new DefaultTableModel();   
      
        for(int i=0;i<vecs.size();i++){
        	
        	philosophers.addColumn(vecs.get(i));
        }
        System.out.println("21321321312");
      //philosophers.addColumn( "登陆名" );
      //philosophers.addColumn( "联系电话" );
      //philosophers.addColumn( "业务区域(省)" );
      //philosophers.addColumn( "业务区域(市)" );
     	// philosophers.addColumn( "业务区域(县)" );
      // add philosopher names and dates to DefaultTableModel
	
      	//System.out.println(sql);
      	//System.out.println(vecs.size());
      	
		ResultSet resSet;	
    	ResultSetMetaData metaData;
    	Connection dbConn;
        Statement stat;	
   		
		String sql3=sql;
	
		try { 
			Class.forName(Yewu.forName);
   			dbConn=DriverManager.getConnection(Yewu.jdbc);
 
 			stat=dbConn.createStatement();
 		    resSet=stat.executeQuery(sql3);
 		   	int m=1;
 		   	Vector vec1=new Vector();
 			while(resSet.next()){
 				
 				Vector vec=new Vector();
 				vec.add(m++);
 				for(int i=1;i<vecs.size();i++){
 					
 					//	Vector vec=new Vector();
 				vec.add((resSet.getObject(i)).toString().trim());//0
 			

 				}
 				vec1.add(vec);
 			
				//System.out.println(vec.get(3));
 				//philosophers.addRow(vec.toArray() );
 				

 			}
 				for(int i=0;i<vec1.size();i++){
 	     	     	
 	     	     	philosophers.addRow(((Vector)vec1.get(i)).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(220,150,540,275);
			
		}else{
			
			setBounds(340,220,740,300);
		}
     
      	setVisible( true );
      
      	this.addWindowListener(new WindowAdapter(){
        	public void WindowClosing(WindowEvent e){
               	
            
                  System.exit(0);
                  
               }
            });  
      
   }
   
   public static void main(String[] args){ // end PhilosophersJTable constructor
   
   String sql="select distinct yewuTab.kehuname,yewuTab.lianxiname,yewuTab.dianhua,yewuTab.dizhi,beizhu from yewuTab join xinxiTable on yewuTab.kehuname=xinxiTable.kehuname where yewuTab.kehuname like '%寿%' or  yewuTab.kehuname like '%昌乐%' or  yewuTab.kehuname like '%青州%'  ";
   		Vector vec=new Vector();
   		vec.add("序号");
   		vec.add("客户名");
   		vec.add("联系人");
   		vec.add("电话");
   		vec.add("地址");
   		vec.add("备注");
   		new HetongJTable(sql,vec);
   }
	
   // execute application
 
}