1940java swing零售库存管理系统myeclipse开发Mysql数据库CS结构java编程源码

/* * cgd.java * * Created on __DATE__, __TIME__ */ package com.ui; import java.awt.Color; import java.awt.Dimension; import java.awt.event.KeyEvent; import java.sql.ResultSet; import javax.swing.JOptionPane; import javax.swing.JTable; import javax.swing.SwingConstants; import javax.swing.table.DefaultTableCellRenderer; import javax.swing.table.TableColumn; import com.util.DBO; import com.util.StaticMethod; /** * * @author __USER__ */ public class cgd extends javax.swing.JInternalFrame { /** Creates new form cgd */ public cgd() { initComponents(); cgdid.setVisible(false); this.Action(); } public void Action() { /**查询所有采购单信息的方法**/ String[] headtitle = { "采购单编号", "单号", "供应商", "标题", "说明", "商品", "数量", "采购时间" };//采购单表格的标题 Object[][] tabledata = null; String sql = "select * from cgd order by cgdid";//要查询的采购单的sql语句 DBO db = new DBO(); ResultSet rs = null; try { int i = 0; rs = db.query(sql);//执行查询方法 while (rs.next()) { i++; } tabledata = new Object[i][15]; rs = db.query(sql); int m = 0; rs = db.query(sql); //把查询结构放到二维数组 while (rs.next()) { tabledata[m][0] = rs.getString("cgdid");//采购单编号信息 tabledata[m][1] = rs.getString("dh");//单号信息 tabledata[m][2] = rs.getString("gys");//供应商信息 tabledata[m][3] = rs.getString("bt");//标题信息 tabledata[m][4] = rs.getString("sm");//说明信息 tabledata[m][5] = rs.getString("sp");//商品信息 tabledata[m][6] = rs.getString("sl");//数量信息 tabledata[m][7] = rs.getString("cgsj");//采购时间信息 m++; } jTable1.setModel(new javax.swing.table.DefaultTableModel(tabledata, headtitle)); this.jTable1.getTableHeader().setPreferredSize( new Dimension(this.jTable1.getTableHeader() .getPreferredSize().width, 20)); jTable1.setSelectionBackground(Color.GREEN); //表格居中 DefaultTableCellRenderer tcr = new DefaultTableCellRenderer();// 设置table内容居中 // tcr.setHorizontalAlignment(JLabel.CENTER); tcr.setHorizontalAlignment(SwingConstants.CENTER);// 这句和上句作用一样 jTable1.setDefaultRenderer(Object.class, tcr); jButton4.setVisible(false); jButton5.setVisible(false); hideColumn(jTable1, 0); } catch (Exception e) { e.printStackTrace(); } finally { if (db != null) { db.close(); } } resetForm(); } public static void hideColumn(JTable table, int column) { TableColumn tc = table.getColumnModel().getColumn(column); tc.setMaxWidth(0); tc.setPreferredWidth(0); tc.setWidth(0); tc.setMinWidth(0); table.getTableHeader().getColumnModel().getColumn(column) .setMaxWidth(0); table.getTableHeader().getColumnModel().getColumn(column) .setMinWidth(0); } public void resetForm() { //把控件信息清空 this.cgdid.setText("");//采购单编号信息赋值成空 java.util.Date now = new java.util.Date(); java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat( "mmssssss"); // System.out.print(formatter.format(now)); String ddid = "" + formatter.format(now); this.dh.setText(ddid);//单号信息赋值成空 //this.gys.setText("");//供应商信息赋值成空 this.bt.setText("");//标题信息赋值成空 this.sm.setText("");//说明信息赋值成空 DBO db = new DBO(); String sql = ""; ResultSet rs = null; this.sp.removeAllItems(); this.gys.removeAllItems(); try { sql = "select * from shangpin "; rs = db.query(sql); while (rs.next()) { this.sp.addItem(rs.getString("spmc")); } sql = "select * from gys"; rs = db.query(sql); while (rs.next()) { this.gys.addItem(rs.getString("gysmc")); } } catch (Exception e) { e.printStackTrace(); } finally { db.close(); } this.sl.setText("");//数量信息赋值成空 this.cgsj.setText(StaticMethod.getStringDate());//采购时间信息赋值成空 } /** This method is called from within the constructor to * initialize the form. * WARNING: Do NOT modify this code. The content of this method is * always regenerated by the Form Editor. */ //GEN-BEGIN:initComponents // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); cgdid = new javax.swing.JTextField(); jLabel1 = new javax.swing.JLabel(); dh = new javax.swing.JTextField(); jLabel2 = new javax.swing.JLabel(); gys = new javax.swing.JComboBox(); jLabel3 = new javax.swing.JLabel(); bt = new javax.swing.JTextField(); jLabel4 = new javax.swing.JLabel(); sp = new javax.swing.JComboBox(); jLabel5 = new javax.swing.JLabel(); sl = new javax.swing.JTextField(); jLabel6 = new javax.swing.JLabel(); cgsj = new javax.swing.JTextField(); jLabel7 = new javax.swing.JLabel(); jScrollPane2 = new javax.swing.JScrollPane(); sm = new javax.swing.JTextArea(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); jButton4 = new javax.swing.JButton(); jButton5 = new javax.swing.JButton(); setBackground(java.awt.SystemColor.activeCaption); setClosable(true); setTitle("\u91c7\u8d2d\u5355\u7ba1\u7406"); jTable1.setModel(new javax.swing.table.DefaultTableModel( new Object[][] { { null, null, null, null }, { null, null, null, null }, { null, null, null, null }, { null, null, null, null } }, new String[] { "Title 1", "Title 2", "Title 3", "Title 4" })); jScrollPane1.setViewportView(jTable1); jLabel1.setText("\u5355\u53f7"); dh.setEnabled(false); jLabel2.setText("\u4f9b\u5e94\u5546"); gys.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" })); jLabel3.setText("\u6807\u9898"); jLabel4.setText("\u5546\u54c1"); sp.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" })); jLabel5.setText("\u6570\u91cf"); sl.addKeyListener(new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { slKeyTyped(evt); } }); jLabel6.setText("\u91c7\u8d2d\u65f6\u95f4"); cgsj.setEditable(false); jLabel7.setText("\u8bf4\u660e"); sm.setColumns(20); sm.setRows(5); jScrollPane2.setViewportView(sm); jButton1.setText("\u6dfb\u52a0"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jButton2.setText("\u8be6\u60c5"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jButton3.setText("\u5173\u95ed"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); jButton4.setText("\u4fee\u6539"); jButton4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton4ActionPerformed(evt); } }); jButton5.setText("\u5220\u9664"); jButton5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton5ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout( getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout.createSequentialGroup() .addContainerGap() .addComponent(jScrollPane1,