inform.java

java图书销售系统。。。。。。。。。。。。。。。。。。。。

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;


import javax.swing.JFrame;



import javax.swing.JButton;
import javax.swing.JPanel;
import javax.swing.JTextArea;


public class InForm extends JFrame{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	private JFrame frame;
	private	JPanel p1,p2;
	private Connection connection ;
    private Statement stmt;
    private ResultSet rest;
    private JTextArea a1;
	private JButton b1;
	public InForm(){
		frame = new JFrame();
		p1 = new JPanel();
		p2 = new JPanel();
	    connection = null;
	    stmt  = null;
	    rest = null;
	    a1 =  new JTextArea();
		b1 = new JButton("关     闭");
	
	}
	
	public void launchFrame(){
		try
		  {
		  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		  connection=DriverManager.getConnection("jdbc:odbc:database");
		  stmt=connection.createStatement();
		  rest=stmt.executeQuery("Select * from InForm");
		  ResultSetMetaData data=rest.getMetaData();
		  int col=data.getColumnCount();
		  for(int i=1;i<=col;i++){
		   if(i<col){
		    a1.append(data.getColumnName(i) + '\t');
		    
		   }
		   else{
		    a1.append(data.getColumnName(i) + '\n');
		    
		   }
		  }
		
		  while(rest.next()){
		   for(int i=1;i<=col;i++){
		    if(i<col){
		     a1.append(rest.getString(i) + '\t');
		     
		    }
		    else{
		     a1.append(rest.getString(i) + '\n');
		     
		    }
		   }
		 
		  }
		  }catch(Exception e){
		   System.out.println(e.toString());
		  }
		  finally{
		   try{
		          rest.close();
		          stmt.close();
		           connection.close();
		   }catch(Exception e){
		    System.out.println(e.getMessage());
		   }
		  }
		p1.add(a1);			 
		frame.getContentPane().add(p1,BorderLayout.CENTER);
		b1.addActionListener(new ActionListener(){
			   public void actionPerformed(ActionEvent e)
			   { frame.setVisible(false);
				   }
			   
	    } 
			   );
		p2.add(b1);
		frame.getContentPane().add(p2,BorderLayout.SOUTH);
		frame.setVisible(true);
		frame.setSize(700,400);	
		frame.setTitle("购入报表");
		
	}
	
	
	
	public static void main(String[] args){
		InForm seel = new InForm();
		seel.launchFrame();
	}

}