/*
* ProductBuyInterFrm.java
*
* Created on __DATE__, __TIME__
*/
package com.view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import com.dao.ProductChosenDao;
import com.dao.ProductDao;
import com.dao.ProductTypeDao;
import com.model.Product;
import com.model.ProductType;
import com.util.Dbutil;
import com.util.StringUtil;
/**
*
* @author __USER__
*/
public class ProductBuyInterFrm extends javax.swing.JInternalFrame {
Dbutil dbutil = new Dbutil();
ProductDao productDao = new ProductDao();
ProductTypeDao productTypeDao = new ProductTypeDao();
ProductChosenDao productChosenDao = new ProductChosenDao();
/** Creates new form ProductBuyInterFrm */
public ProductBuyInterFrm() {
initComponents();
this.setLocation(200, 20);
this.fillTable(new Product());
this.fillChosenTable();
this.fillProductType("search");
this.fillProductType("putInto");
}
private void fillProductType(String type) {
Connection con = null;
ProductType productType = null;
try {
con = dbutil.getCon();
ResultSet rs = productTypeDao.productTypeList(con,
new ProductType());
if ("search".equals(type)) {
productType = new ProductType();
productType.setProductTypeName("请选择....");
productType.setId(-1);
this.s_jcbProductType.addItem(productType);
}
while (rs.next()) {
productType = new ProductType();
productType.setId(rs.getInt("id"));
productType.setProductTypeName(rs.getString("productTypeName"));
if ("search".equals(type)) {
this.s_jcbProductType.addItem(productType);
} else if ("putInto".equals(type)) {
this.jcb_productType.addItem(productType);
}
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
dbutil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void fillTable(Product product) {
DefaultTableModel dtm = (DefaultTableModel) productTable.getModel();
dtm.setRowCount(0);//要把前面的数据释放掉
Connection con = null;
try {
con = dbutil.getCon();
ResultSet rs = productDao.productList(con, product);
while (rs.next()) {
Vector v = new Vector();
v.add(rs.getInt("id"));
v.add(rs.getString("productName"));
v.add(rs.getString("productTime"));
v.add(rs.getFloat("price"));
v.add(rs.getString("productDesc"));
v.add(rs.getString("productTypeName"));
dtm.addRow(v);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
dbutil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
private void fillChosenTable() {
DefaultTableModel dtm = (DefaultTableModel) ProductChosenTable
.getModel();
dtm.setRowCount(0);//要把前面的数据释放掉
Connection con = null;
try {
con = dbutil.getCon();
ResultSet rs = productDao.productChosenList(con);
while (rs.next()) {
Vector v = new Vector();
v.add(rs.getInt("id"));
v.add(rs.getString("productName"));
v.add(rs.getString("productTime"));
v.add(rs.getFloat("price"));
v.add(rs.getString("productDesc"));
v.add(rs.getString("productTypeName"));
dtm.addRow(v);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
dbutil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
//GEN-BEGIN:initComponents
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jDialog1 = new javax.swing.JDialog();
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
s_productNameTxt = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
s_productTimeTxt = new javax.swing.JTextField();
jLabel3 = new javax.swing.JLabel();
s_jcbProductType = new javax.swing.JComboBox();
jb_search = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
productTable = new javax.swing.JTable();
jPanel2 = new javax.swing.JPanel();
jScrollPane3 = new javax.swing.JScrollPane();
ProductChosenTable = new javax.swing.JTable();
jb_delete = new javax.swing.JButton();
jb_cost = new javax.swing.JButton();
jb_putProductIntoCar = new javax.swing.JButton();
jScrollPane2 = new javax.swing.JScrollPane();
productDescTxt = new javax.swing.JTextArea();
jLabel9 = new javax.swing.JLabel();
jcb_productType = new javax.swing.JComboBox();
jLabel8 = new javax.swing.JLabel();
productTimeTxt = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
priceTxt = new javax.swing.JTextField();
jLabel6 = new javax.swing.JLabel();
productNameTxt = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
idTxt = new javax.swing.JTextField();
jLabel4 = new javax.swing.JLabel();
javax.swing.GroupLayout jDialog1Layout = new javax.swing.GroupLayout(jDialog1.getContentPane());
jDialog1.getContentPane().setLayout(jDialog1Layout);
jDialog1Layout.setHorizontalGroup(
jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 400, Short.MAX_VALUE)
);
jDialog1Layout.setVerticalGroup(
jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 300, Short.MAX_VALUE)
);
setClosable(true);
setIconifiable(true);
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("\u6311\u9009\u5546\u54c1"));
jLabel1.setText("\u5546\u54c1\u540d\u79f0");
jLabel2.setText("\u751f\u4ea7\u65e5\u671f");
jLabel3.setText("\u5546\u54c1\u7c7b\u522b");
jb_search.setIcon(new javax.swing.ImageIcon("./images\\search.png")); // NOI18N
jb_search.setText("\u67e5\u8be2");
jb_search.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jb_searchActionPerformed(evt);
}
});
productTable.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"编号", "商品名称", "生产日期", "商品价格", "商品描述", "商品类别"
}
) {
boolean[] canEdit = new boolean [] {
false, false, false, false, false, false
};
public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
productTable.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
productTableMousePressed(evt);
}
});
jScrollPane1.setViewportView(productTable);
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(20, 20, 20)
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(s_productNameTxt, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 61, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(s_productTimeTxt, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel3)
.addGap(18, 18, 18)
.addComponent(s_jcbProductType, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 166, Short.MAX_VALUE)
.addComponent(jb_search)
.addGap(38, 38, 38))
.addComponent(jScrollPa
基于java swing和mysql的超市管理系统 （162个子文件） 
ProductBuyInterFrm.class 17KB ProductManageInterFrm.class 16KB ProductTypeManageInterFrm.class 11KB ProductAddInterFrm.class 9KB my_2048.class 9KB CustomerLogOnFrm.class 8KB ManagerLogOnFrm.class 7KB CustomerAddInterFrm.class 7KB CustomerLogOnInterFrm.class 7KB ProductTypeInterFrm.class 6KB MainFrm.class 6KB gameframe.class 5KB TicTacToe.class 5KB ViewMainFrm.class 5KB ProductDao.class 4KB FuntionMainFrm.class 4KB ProductChosenDao.class 3KB ProductTypeDao.class 3KB Product.class 2KB Game.class 2KB Customer.class 2KB CustomerUserDao.class 2KB Dbutil.class 2KB ManagerUserDao.class 1KB ProductType.class 1KB ManagerUser.class 1KB Game$1.class 1018B ProductManageInterFrm$3.class 985B ProductManageInterFrm$4.class 980B CustomerLogOnInterFrm$1.class 977B ProductTypeManageInterFrm$2.class 962B ProductManageInterFrm$1.class 951B ProductBuyInterFrm$2.class 933B ProductBuyInterFrm$4.class 933B ProductTypeManageInterFrm$4.class 827B ProductTypeManageInterFrm$1.class 827B ProductTypeManageInterFrm$5.class 827B ProductManageInterFrm$5.class 803B ProductManageInterFrm$6.class 802B CustomerLogOnInterFrm$2.class 802B CustomerLogOnInterFrm$3.class 802B ProductManageInterFrm$7.class 802B ProductTypeManageInterFrm$3.class 800B ProductBuyInterFrm$8.class 796B ProductTypeInterFrm$2.class 790B ProductTypeInterFrm$1.class 788B CustomerAddInterFrm$1.class 788B ProductBuyInterFrm$1.class 785B ProductBuyInterFrm$6.class 785B ProductAddInterFrm$1.class 784B ProductAddInterFrm$2.class 784B ProductBuyInterFrm$7.class 783B ProductManageInterFrm$2.class 772B CustomerLogOnFrm$2.class 772B CustomerLogOnFrm$1.class 772B ManagerLogOnFrm$1.class 769B FuntionMainFrm$1.class 767B FuntionMainFrm$3.class 767B ManagerLogOnFrm$2.class 766B ManagerLogOnFrm$3.class 766B FuntionMainFrm$2.class 762B ProductBuyInterFrm$5.class 760B ProductBuyInterFrm$3.class 754B ViewMainFrm$2.class 749B ViewMainFrm$3.class 748B ViewMainFrm$1.class 748B MainFrm$2.class 730B MainFrm$1.class 727B MainFrm$4.class 726B MainFrm$3.class 723B MainFrm$5.class 717B my_2048$1.class 637B StringUtil.class 616B CustomerLogOnFrm$3.class 580B ManagerLogOnFrm$4.class 576B FuntionMainFrm$4.class 572B ViewMainFrm$4.class 560B MainFrm$6.class 544B .classpath 427B ProductBuyInterFrm.form 22KB ProductBuyInterFrm.form 22KB ProductManageInterFrm.form 20KB ProductManageInterFrm.form 20KB ProductTypeManageInterFrm.form 12KB ProductTypeManageInterFrm.form 12KB ProductAddInterFrm.form 10KB ProductAddInterFrm.form 10KB MainFrm.form 9KB MainFrm.form 9KB ManagerLogOnFrm.form 8KB ManagerLogOnFrm.form 8KB CustomerLogOnFrm.form 7KB CustomerLogOnFrm.form 7KB ProductTypeInterFrm.form 7KB ProductTypeInterFrm.form 7KB CustomerAddInterFrm.form 6KB CustomerAddInterFrm.form 6KB ViewMainFrm.form 4KB ViewMainFrm.form 4KB FuntionMainFrm.form 4KB共 162 条
- 1
- 2
资源评论
