shoufei.java

小区物业管理系统

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

public class Shoufei extends JFrame {
	
	private Connection c1;
	private String Mouaction;
	private JTable display;
	
	public Shoufei(){
		try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				c1 = DriverManager.getConnection("jdbc:odbc:estate");
			}
		catch(Exception err)
		{
			err.printStackTrace();
		}//建立数据库连接；
		
		display = new JTable();
		Container temp = getContentPane();
        temp.setLayout(new BorderLayout());
      	temp.add(display,BorderLayout.CENTER);
      	getpriceTable();
      	setSize(500,300);
      	show();
	}
		
	
	/*public void actionPerformed(ActionEvent e){
		Mouaction = e.getActionCommand();
		try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				c1 = DriverManager.getConnection("jdbc:odbc:estate");
			}
		catch(Exception err)
		{
			err.printStackTrace();
		}//建立数据库连接；
		
		getpriceTable();
		
	}*/
	
	public void getpriceTable(){
		try
			{
				Vector columnName = new Vector();
				Vector rows = new Vector();//定义向量，进行数据库数据操作
				
				String sql="SELECT * FROM unit_price_info";
				Statement stmt1  = c1.createStatement();
				ResultSet rsl1 = stmt1.executeQuery(sql);
				ResultSetMetaData rsmd1 = rsl1.getMetaData();//获取表的字段名称
				
				columnName.addElement("收费项目");
				columnName.addElement("单价(单位：元）");
				
				while(rsl1.next())
				{                                              // 获取记录集
            		Vector currentRow = new Vector();
            		for ( int i = 2; i <= rsmd1.getColumnCount(); ++i )
            		{
         				currentRow.addElement( rsl1.getString( i ) );
      				}
            		rows.addElement( currentRow);
            	}
            	
            	display = new JTable(rows,columnName);
            	JScrollPane scroller = new JScrollPane(display);
            	Container temp = getContentPane();
            	
            	temp.add(scroller,BorderLayout.CENTER);
            	temp.validate();				
			}
			catch(SQLException sqlex)
			{
				sqlex.printStackTrace();
			}
		}
		
		public static void main(String args[]){
			Shoufei s1 = new Shoufei();
			s1.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		}
		
			
	}