1217.swing在线拍卖系统.zip

package com.view; import com.util.Dbutil; import java.sql.Connection; import java.sql.ResultSet; import java.util.Vector; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import com.dao.AuctionDao; import com.dao.CustomerUserDao; import com.dao.ProductChosenDao; import com.dao.ProductDao; import com.dao.ProductTypeDao; import com.model.Customer; import com.model.Product; import com.model.ProductType; import com.util.Dbutil; import com.util.StringUtil; import javax.swing.JTextField; import javax.swing.GroupLayout.Alignment; import javax.swing.LayoutStyle.ComponentPlacement; import javax.swing.GroupLayout; import java.awt.Color; import java.awt.event.MouseEvent; import javax.swing.JLabel; /** *商品购买 * @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(); AuctionDao auctionDao = new AuctionDao(); 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) { e.printStackTrace(); } finally { try { dbutil.closeCon(con); } catch (Exception e) { 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) { e.printStackTrace(); } finally { try { dbutil.closeCon(con); } catch (Exception e) { 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(); } } } 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