package?amountoperation;
import?java.awt.*;
import?javax.swing.*;
import?com.borland.jbcl.layout.*;
import?javax.swing.table.*;
import?java.awt.event.*;
import?java.sql.ResultSet;
import?db.DbSql;

public?class?AmountOperation?extends?JInternalframe?{
????XYLayout?xYLayout1?=?new?XYLayout（）;
????JLabel?jLabel1?=?new?JLabel（）;
????JButton?jButton1?=?new?JButton（）;
????JScrollPane?jScrollPane1?=?new?JScrollPane（）;//帶滾動(dòng)條的面板
????JTable?jTable1?=?new?JTable（）;
????JButton?jButton2?=?new?JButton（）;
????JButton?jButton4?=?new?JButton（）;
????String?colhead[]?=?{“物品編號(hào)“?“物品名稱“?“單位“?“數(shù)量“?“進(jìn)倉(cāng)日期“};
???DefaultTableModel?dtm?=?new?DefaultTableModel（colhead?0）;//表示初始化0條空記錄
????JComboBox?jComboBox1?=?new?JComboBox（）;
?????String?sql?=?“select?pro_name?from??productinfo“;

????public?AmountOperation（）?{
????????try?{
????????????jbInit（）;
????????}?catch?（Exception?exception）?{
????????????exception.printStackTrace（）;
????????}
????}

????//進(jìn)入時(shí)查詢
????public?void?selectAll（）?throws?Exception?{
????????try?{
????????????ResultSet?rs;
????????????DbSql?dbo?=?new?DbSql（）;
????????????String?sq1?=?“select?p.pro_idp.pro_namep.unitp.amountc.comedate“
?????????????????????????+“?from?productinfo?as?p?comedepot?as?c?where?p.pro_id?=?c.pro_id“;
????????????dbo.open（）;
????????????rs?=?dbo.selects（sq1）;
????????????while?（rs.next（））?{
????????????????String?id?=?rs.getString（1）;
????????????????String?name?=?rs.getString（2）;
????????????????String?unit?=?rs.getString（3）;
????????????????String?amount?=?rs.getString（4）;
????????????????String?date?=?rs.getString（5）;
????????????????String?val[]?=?{id?name?unit?amount?date};?//向表格添加值
????????????????dtm.addRow（val）;
????????????}
????????????dbo.close（）;

????????}?catch?（Exception?ex）?{
????????????ex.printStackTrace（）;
????????}
????}

????private?void?jbInit（）?throws?Exception?{
????????getContentPane（）.setLayout（xYLayout1）;
?????????this.selectAll（）;???//把進(jìn)入時(shí)查詢的數(shù)據(jù)添加到表格
????????xYLayout1.setWidth（507）;
????????xYLayout1.setHeight（280）;
????????jLabel1.setText（“產(chǎn)品名稱“）;
????????jButton4.addActionListener（new?AmountOperation_jButton4_actionAdapter（this））;
????????jButton2.addActionListener（new?AmountOperation_jButton2_actionAdapter（this））;
????????jButton1.addActionListener（new?AmountOperation_jButton1_actionAdapter（this））;
????????jButton4.setText（“退出“）;
????????jButton2.setText（“增加數(shù)量“）;
????????jScrollPane1.setBorder（BorderFactory.createLoweredBevelBorder（））;//在面板上添加工具條
????????jButton1.setText（“查詢“）;
????????jScrollPane1.getViewport（）.add（jTable1）;//把表格添加帶滾動(dòng)條的面板
????????this.getContentPane（）.add（jLabel1?new?XYConstraints（4?7?68?25））;
????????jTable1.setModel（dtm）;//把摸板添加進(jìn)表格
????????this.getContentPane（）.add（jScrollPane1
??????????????????????????????????new?XYConstraints（7?40?492?231））;
????????this.getContentPane（）.add（jComboBox1?new?XYConstraints（57?7?120?25））;
????????this.getContentPane（）.add（jButton1?new?XYConstraints（2

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2009-07-19?17:11??depository\
?????文件???????12991??2009-06-20?15:56??depository\0.JPG
?????文件???????51658??2009-06-24?09:15??depository\00.jpg
?????文件???????48783??2009-06-24?15:52??depository\01.jpg
?????文件???????39494??2009-06-24?17:08??depository\02.jpg
?????文件???????20337??2009-06-25?10:29??depository\1.JPG
?????文件???????20257??2009-06-25?09:47??depository\2.JPG
?????文件???????20343??2009-06-25?09:48??depository\3.JPG
?????文件???????20014??2009-06-25?09:50??depository\4.JPG
?????文件???????20319??2009-06-25?09:51??depository\5.JPG
?????文件???????20678??2009-06-25?09:58??depository\6.jpg
?????文件???????21042??2009-06-25?09:56??depository\7.jpg
?????文件???????20254??2009-06-25?09:52??depository\8.jpg
?????文件????????9691??2009-07-18?19:47??depository\9.jpg
?????目錄???????????0??2009-07-19?15:55??depository\bak\
?????目錄???????????0??2009-07-19?16:10??depository\bak\amountoperation\
?????文件????????8264??2009-07-18?19:21??depository\bak\amountoperation\AmountOperation.java~12~
?????文件????????8272??2009-07-18?19:54??depository\bak\amountoperation\AmountOperation.java~13~
?????文件????????8272??2009-07-18?19:55??depository\bak\amountoperation\AmountOperation.java~14~
?????文件????????8272??2009-07-18?19:55??depository\bak\amountoperation\AmountOperation.java~15~
?????文件????????8272??2009-07-18?19:56??depository\bak\amountoperation\AmountOperation.java~16~
?????文件????????8354??2009-07-18?20:48??depository\bak\amountoperation\AmountOperation.java~17~
?????文件????????8469??2009-07-18?20:55??depository\bak\amountoperation\AmountOperation.java~18~
?????文件????????7878??2009-07-19?16:05??depository\bak\amountoperation\AmountOperation.java~19~
?????文件????????7764??2009-07-19?16:07??depository\bak\amountoperation\AmountOperation.java~20~
?????文件????????7772??2009-07-19?16:07??depository\bak\amountoperation\AmountOperation.java~21~
?????文件????????5349??2009-06-23?14:17??depository\bak\amountoperation\frameAdd.java~1~
?????文件????????5347??2009-07-16?16:10??depository\bak\amountoperation\frameAdd.java~2~
?????文件????????5347??2009-07-16?16:11??depository\bak\amountoperation\frameAdd.java~3~
?????文件????????5349??2009-07-18?20:38??depository\bak\amountoperation\frameAdd.java~4~
?????目錄???????????0??2009-07-19?13:29??depository\bak\clientserver\
............此處省略170個(gè)文件信息