gui.java

一个java与数据库连接的好例子

package com.eap;

import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;

import javax.swing.JFrame;
import javax.swing.JButton;
import javax.swing.JPanel;

import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.JFileChooser;
import javax.swing.event.TableModelEvent;
import javax.swing.event.TableModelListener;
import javax.swing.table.AbstractTableModel;
import java.sql.*;
import java.awt.Color;
import javax.swing.*;
import javax.swing.table.*;

public class GUI extends JFrame implements ActionListener{ 
	
	
	private JTextField 	
		filename = new JTextField(25), 
		dir = new JTextField(25);
	
	private ExampleFileFilter mdbFilter;
	
	//private String strDriver;
	private String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\port.mdb"; 
	private Connection con=null;
	private Statement stmt=null;
	private ResultSet rs=null;
	private ResultSet recordRow=null;
	private int columnCount=0;
	private int rowCount=0;
	Object[][] data=null;
	Object[][] content=null;
	private Object[] column={"工号","项目1","项目2","项目3","项目4"};
	private String savePath="d:\\eap\\";
	private JTable table ;
	private JButton btnBrowse = new JButton("Select DBM");
	private JButton btnSave = new JButton("Save DOC");
	private JPanel jp = new JPanel();
	private JPanel jp2 = new JPanel();
	
	Container cp = getContentPane();
	TableColumnModel mode=null;
	public GUI(){
		super("EAP Limited Corp.");
		mdbFilter = new ExampleFileFilter("mdb", "mdb Microsoft Access DataBase");
		
		//jp.add(btnBrowse);
		jp.add(btnSave);
		jp2.add(filename);
		jp2.add(dir);
		//btnSave.setEnabled(false);
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");   
		}catch(Exception e){System.out.println("the driver is not found!");}
		try{
			con = DriverManager.getConnection(strurl,"","");
			stmt = con.createStatement();
			recordRow = stmt.executeQuery("select   count(*)   from   EAP");
			try{
				if(recordRow.next())
					rowCount =   recordRow.getInt(1);
				recordRow.close();
			}catch(Exception e){}
			
			rs = stmt.executeQuery("select   *   from   EAP");
			columnCount = rs.getMetaData().getColumnCount();  
		}catch(Exception e){System.out.println("the error in create connection");}
		
		
		data=new String[rowCount][columnCount];
		content = new String[4][3];
		data=rs2array(rs);
		try{
			rs = stmt.executeQuery("select * from refer");
		}catch(Exception e){}
		content = rs2content(rs);
  		//System.out.println(data[1][1].toString());以后可对data操作！！
		table=new JTable(data,column);
		mode=table.getColumnModel();
		
		table.setBackground(new Color(164,194,90));
		//table.setGridColor(Color.cyan);
		
		cp.add(new JScrollPane(table));
	    table.setEnabled(false);
	    //btnBrowse.setBounds(startCol,startRow,100,30);//col  row ,width,heigth
	    btnBrowse.addActionListener(this);
	    btnSave.addActionListener(this);
	   
		cp.add(BorderLayout.NORTH,jp);
	    cp.add(BorderLayout.SOUTH,jp2);
	
	  /* try{
	    	rs.close();
	    	stmt.close();
	    	con.close();
	    }catch(Exception e){}*/
	    
	   
	    
	    
		addWindowListener(new   WindowAdapter()   
		    {   
		    	public   void   windowClosing(WindowEvent   e)   
		    	{   
		    			dispose();   
		    			System.exit(0);   
		    	}   
		    });   
	}
	public String getContent(Object[] item,String score){
		String ret="";
		int point;
		for(int i=1;i<item.length;i++){
			if (item[i].toString().compareTo("1")>=0 && item[i].toString().compareTo("4")<0){
				ret=ret+content[i-1][0]+"\r";
			}else if(item[i].toString().compareTo("4")>=0 && item[i].toString().compareTo("7")<0){
				ret=ret+content[i-1][1]+"\r";
			}else if(item[i].toString().compareTo("7")>=0 ){
				ret=ret+content[i-1][2]+"\r";
			}
		}
		return ret;
	}
	public Object[][] rs2array(ResultSet rs){
		Object[][] ret=new String[rowCount][5];
		int   i=0;   
		String aa=null;
		try{  
			while(rs.next())   
			  {   
			      
				  aa= rs.getString(1);
				  ret[i][0]   =   aa;     
			      ret[i][1]   =   rs.getString(2);     
			      ret[i][2]   =   rs.getString(3); 
			      ret[i][3]   =   rs.getString(4); 
			      ret[i][4]   =   rs.getString(5); 
			      i=i+1;
			      
			  }   
		}catch(Exception e){System.out.println("Error in function");}
		return ret;
	}
	public Object[][] rs2content(ResultSet rs){
		Object[][] ret=new String[4][3];
		int   i=0;   
		String aa=null;
		try{  
			while(rs.next())   
			  {  
				  ret[i][0]   =  rs.getString(1);   
			      ret[i][1]   =   rs.getString(2);     
			      ret[i][2]   =   rs.getString(3); 
			      
			      i=i+1;
			   }   
		}catch(Exception e){System.out.println("Error in function");}
		return ret;
	}
	
	public void actionPerformed(ActionEvent e){
				
		if(e.getSource()==btnBrowse)
		{
			 
			JFileChooser c = new JFileChooser();
			  c.addChoosableFileFilter(mdbFilter);
		      int rVal = c.showOpenDialog(this);
		      if(rVal == JFileChooser.APPROVE_OPTION) {
		        filename.setText(c.getSelectedFile().getName());
		        dir.setText(c.getCurrentDirectory().toString());
		        //table.setModel(new DataModel(test));
		        //table.setColumnModel(mode);
		       
		        btnSave.setEnabled(true);
		      }
		      if(rVal == JFileChooser.CANCEL_OPTION) {
		        filename.setText("You pressed cancel");
		        dir.setText("");
		      }

		}
		if(e.getSource()==btnSave){
			String fileName=savePath;
			
			for(int i=0;i<data.length;i++){
				String eachContent=data[i][0]+":\r    你好!\r";
				
				eachContent=eachContent+getContent(data[i],"");
				CreateNewDoc.writeWordFile(fileName+data[i][0]+".doc",eachContent);
			}		
			//System.out.println("you click the Save button!");
			String text = "共："+rowCount+"个文件，已保存到d:\\eap";
			JOptionPane.showMessageDialog(null,text,"提示",JOptionPane.INFORMATION_MESSAGE);
		}
	}
	
	
	
	
}