java swing电商出入库管理系统eclipse开发Mysql数据库CS结构java编程源码

package com.ui; import java.awt.EventQueue; import javax.swing.JInternalFrame; import javax.swing.JDesktopPane; import java.awt.BorderLayout; import java.awt.Color; import java.awt.Dimension; import java.awt.SystemColor; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.SwingConstants; import javax.swing.table.DefaultTableCellRenderer; import javax.swing.table.TableColumn; import com.util.DBO; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JTextArea; import javax.swing.JComboBox; import javax.swing.JButton; import java.awt.event.ActionListener; import java.sql.ResultSet; import java.awt.event.ActionEvent; import java.awt.event.KeyAdapter; import java.awt.event.KeyEvent; public class shangpin extends JInternalFrame { private JTable table; private JTextField spid; private JTextField spmc; private JTextField cj; private JTextField sl; private JTextField jg; private JTextArea js; private JComboBox cc; private JComboBox ys; JButton btnNewButton_3; JButton btnNewButton_4; private JTextField spmca; /** * Launch the application. */ public static void main(String[] args) { EventQueue.invokeLater(new Runnable() { public void run() { try { shangpin frame = new shangpin(); frame.setVisible(true); } catch (Exception e) { e.printStackTrace(); } } }); } public void Action() { /**查询所有商品信息的方法**/ String[] headtitle = { "商品编号","商品","介绍","尺寸","颜色","厂家","数量","价格" };//商品表格的标题 Object[][] tabledata = null; String sql = "select * from shangpin where 1=1 ";//要查询的商品的sql语句 String txtspmc = spmca.getText();// 商品名称 if (txtspmc != null&&!txtspmc.equals("")) { sql+=" and spmc like '%"+txtspmc+"%'"; } sql+=" order by spid"; 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("spid");//商品编号信息 tabledata[m][1] = rs.getString("spmc");//商品名称信息 tabledata[m][2] = rs.getString("js");//介绍信息 tabledata[m][3] = rs.getString("cc");//尺寸信息 tabledata[m][4] = rs.getString("ys");//颜色信息 tabledata[m][5] = rs.getString("cj");//厂家信息 tabledata[m][6] = rs.getString("sl");//数量信息 tabledata[m][7] = rs.getString("jg");//价格信息 m++; } table.setModel(new javax.swing.table.DefaultTableModel(tabledata, headtitle)); table.getTableHeader().setPreferredSize( new Dimension(table.getTableHeader() .getPreferredSize().width, 20)); table.setSelectionBackground(Color.GREEN); //表格居中 DefaultTableCellRenderer tcr = new DefaultTableCellRenderer();// 设置table内容居中 // tcr.setHorizontalAlignment(JLabel.CENTER); tcr.setHorizontalAlignment(SwingConstants.CENTER);// 这句和上句作用一样 table.setDefaultRenderer(Object.class, tcr); btnNewButton_3.setVisible(false); btnNewButton_4.setVisible(false); hideColumn(table,0); hideColumn(table,2); } catch (Exception e) { e.printStackTrace(); } finally { if (db != null) { db.close(); } } resetForm(); } public void resetForm(){ //把控件信息清空 this.spid.setText("");//商品编号信息赋值成空 this.spmc.setText("");//商品名称信息赋值成空 this.js.setText("");//介绍信息赋值成空 //this.cc.setText("");//尺寸信息赋值成空 //this.ys.setText("");//颜色信息赋值成空 this.cj.setText("");//厂家信息赋值成空 this.sl.setText("");//数量信息赋值成空 this.jg.setText("");//价格信息赋值成空 DBO db=new DBO(); String sql=""; ResultSet rs=null; try { sql="select * from zdms where lx='尺码' "; rs=db.query(sql); while(rs.next()) { cc.addItem(rs.getString("zd")); } sql="select * from zdms where lx='颜色' "; rs=db.query(sql); while(rs.next()) { ys.addItem(rs.getString("zd")); } }catch(Exception e1) { e1.printStackTrace(); }finally { db.close(); } } /** * Create the frame. */ public shangpin() { setTitle("\u5546\u54C1\u7BA1\u7406"); setClosable(true); setBounds(100, 100, 690, 474); JDesktopPane desktopPane = new JDesktopPane(); desktopPane.setBackground(SystemColor.textHighlight); getContentPane().add(desktopPane, BorderLayout.CENTER); JScrollPane scrollPane = new JScrollPane(); scrollPane.setBounds(10, 72, 352, 362); desktopPane.add(scrollPane); table = new JTable(); scrollPane.setViewportView(table); spid = new JTextField(); spid.setBounds(462, 25, 66, 21); desktopPane.add(spid); spid.setColumns(10); spid.setVisible(false); JLabel lblNewLabel = new JLabel("\u5546\u54C1\u540D\u79F0"); lblNewLabel.setBounds(372, 65, 54, 15); desktopPane.add(lblNewLabel); spmc = new JTextField(); spmc.setBounds(436, 62, 195, 21); desktopPane.add(spmc); spmc.setColumns(10); JLabel lblNewLabel_1 = new JLabel("\u4ECB \u7ECD"); lblNewLabel_1.setBounds(372, 101, 54, 15); desktopPane.add(lblNewLabel_1); js = new JTextArea(); js.setBounds(436, 96, 195, 124); desktopPane.add(js); JLabel lblNewLabel_2 = new JLabel("\u5C3A \u5BF8"); lblNewLabel_2.setBounds(372, 238, 54, 15); desktopPane.add(lblNewLabel_2); JLabel lblNewLabel_3 = new JLabel("\u989C \u8272"); lblNewLabel_3.setBounds(372, 272, 54, 15); desktopPane.add(lblNewLabel_3); JLabel lblNewLabel_4 = new JLabel("\u5382 \u5BB6"); lblNewLabel_4.setBounds(372, 297, 54, 15); desktopPane.add(lblNewLabel_4); cj = new JTextField(); cj.setBounds(436, 294, 195, 21); desktopPane.add(cj); cj.setColumns(10); cc = new JComboBox(); cc.setBounds(436, 234, 195, 23); desktopPane.add(cc); ys = new JComboBox(); ys.setBounds(436, 263, 195, 23); desktopPane.add(ys); JLabel lblNewLabel_5 = new JLabel("\u6570 \u91CF"); lblNewLabel_5.setBounds(372, 331, 54, 15); desktopPane.add(lblNewLabel_5); sl = new JTextField(); sl.addKeyListener(new KeyAdapter() { @Override public void keyTyped(KeyEvent e) { int keyChar = e.getKeyChar(); if(keyChar >= KeyEvent.VK_0 && keyChar <= KeyEvent.VK_9){ }else{ e.consume(); //关键，屏蔽掉非法输入 } } }); sl.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent arg0) { } }); sl.setBounds(436, 328, 66, 21); desktopPane.add(sl); sl.setColumns(10); jg = new JTextField(); jg.setBounds(560, 328, 66, 21); desktopPane.add(jg); jg.setColumns(10); JLabel lblNewLabel_6 = new JLabel("\u4EF7 \u683C"); lblNewLabel_6.setBounds(518, 331, 54, 15); desktopPane.add(lblNewLabel_6); JButton btnNewButton = new JButton("\u6DFB\u52A0"); btnNewButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent arg0) { /***商品信息添加方法**/ // TODO add your handling code here: String txtspmc = spmc.getText();// 商品名称 String txtjs = js.getText();// 介绍 String txtcc = cc.getSelectedItem().toString();// 尺寸 String txtys = ys.getSelectedItem().toString();// 颜色 String txtcj = cj.getText();// 厂家 String txtsl = sl.getText();// 数量 String txtjg = jg.getText();// 价格 String sql = "";// if (txtspmc == null || txtspmc.equals("")) { JOptionPane.showMessageDialog(null, "商品名称不能为空！", "警告", JOptionPane.WARNING_MESSAGE); return; } if (txtjs == null || txtjs.equals("")) { JOptionPane.showMessageDialog(null, "介绍不能为空！