goodscanform.java

一个货物管理系

package good;
import good.DataConn;

import java.awt.Container;
import java.awt.GridLayout;
import java.sql.*;
import java.util.Vector;

import javax.swing.JDesktopPane;
import javax.swing.JFrame;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;


public class Goodscanform extends JFrame {
	public Goodscanform() {
		Vector goodHeads, goodRows, goodRecords = null;	
		ResultSet rs;		
		String sql="";
		goodHeads = new Vector();		
		goodRows = new Vector();
		
		try {
			
			DataConn storCon = new DataConn();
			storCon.dataConnDerectForMySql();
			sql="select goodid,goodname,goodnumber,goodprice"+
			    " from goods";
			String title[]={"货物编号","货物名称","货物数量","货物价格"}; 
			rs = storCon.executeDerectQuery(sql);
			ResultSetMetaData rsmd = rs.getMetaData();
			int numberOfColumns = rsmd.getColumnCount();
			for (int i = 0; i <= numberOfColumns-1; i++) {
				String columnName = title[i];
				goodHeads.addElement(columnName);
			}			
			while (rs.next()) {
				goodRecords = new Vector();
				for (int i = 1; i <= numberOfColumns; i++) {					
					String ss = rs.getString(i);
					goodRecords.addElement(ss == null ? "" : ss.trim());
					
				}
				goodRows.addElement(goodRecords);				
			}
			
			rs.close();
			storCon.closeConn();
		} catch (SQLException w) {
			w.printStackTrace();
		}  			
		Container c = this.getContentPane();;		
		JPanel statusPanel = new JPanel();
		JTable goodTable = new JTable(goodRows, goodHeads);	
		JScrollPane sp = new JScrollPane(goodTable);	
		c.add(statusPanel);	
		statusPanel.add(sp);
		this.setTitle("库存货物浏览");
		this.setSize(500,500);
		this.setBounds(0,50,480,310);
		//this.add(c);
		this.show();
		
		
	}




}