利用java的socket通信，swing组件，access数据库实现的网吧购物系统,本文件为服务端源码

package mainframe; import java.awt.BorderLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.sql.SQLException; import java.util.Vector; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JMenuItem; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JPopupMenu; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableModel; import dao.ShopStorageDAO; /** * This code was edited or generated using CloudGarden's Jigloo SWT/Swing GUI * Builder, which is free for non-commercial use. If Jigloo is being used * commercially (ie, by a corporation, company or business for any purpose * whatever) then you should purchase a license for each developer using Jigloo. * Please visit www.cloudgarden.com for details. Use of Jigloo implies * acceptance of these licensing terms. A COMMERCIAL LICENSE HAS NOT BEEN * PURCHASED FOR THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED LEGALLY FOR * ANY CORPORATE OR COMMERCIAL PURPOSE. */ public class GoodsManagerDialog extends javax.swing.JDialog { /** * */ private static final long serialVersionUID = 1L; // 界面上相关无素的定义 private JPanel goodsManagerPanel; private JButton updateButton; private JPopupMenu findPopupMenu; private JTable goodsListTable; private JLabel goodInfLabel; private JButton findButton; private JButton deleteButton; private JButton addButton; private JScrollPane goodsManagerScrollPane1; // 弹出式菜单的定义 private JMenuItem findAllMenuItem; private JMenuItem findtype1MenuItem; private JMenuItem findtype2MenuItem; private JMenuItem findtype3MenuItem; private JMenuItem findtype4MenuItem; // 表格数据模型的定义 private Vector<Vector<String>> goodsList; private Vector<Object> goodsHeader; private TableModel goodsListTableModel; // 数据访问对象的定义 private ShopStorageDAO dao; // 添加修改子对话框的定义 private AddUpDelDialog addDialog; // 是否选择了修改行 private boolean isSelected; // 要查找的商品类型 private String findType; // 构造方法 public GoodsManagerDialog(JFrame frame) { super(frame); this.goodsList = new Vector<Vector<String>>(); this.goodsHeader = new Vector<Object>(); this.dao = new ShopStorageDAO(); this.addDialog = new AddUpDelDialog(); this.isSelected = false; this.findType = ""; initGUI(); } private void initGUI() { try { { this.goodsHeader.add("商品名称"); this.goodsHeader.add("商品单价"); this.goodsHeader.add("商品分类"); this.goodsHeader.add("商品库存"); } this.setTitle("商品管理");// 购物服务端 { goodsManagerPanel = new JPanel(); getContentPane().add(goodsManagerPanel, BorderLayout.CENTER); goodsManagerPanel.setLayout(null); { addButton = new JButton(); goodsManagerPanel.add(addButton); addButton.setText("\u589e\u52a0"); addButton.setBounds(42, 21, 91, 35); addButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { addButtonActionPerformed(evt); } }); } { updateButton = new JButton(); goodsManagerPanel.add(updateButton); updateButton.setText("\u4fee\u6539"); updateButton.setBounds(182, 21, 91, 35); updateButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { updateButtonActionPerformed(evt); } }); } { deleteButton = new JButton(); goodsManagerPanel.add(deleteButton); deleteButton.setText("\u5220\u9664"); deleteButton.setBounds(329, 21, 91, 35); deleteButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { deleteButtonActionPerformed(evt); } }); } { findButton = new JButton(); goodsManagerPanel.add(findButton); findButton.setText("\u67e5\u8be2"); findButton.setBounds(483, 21, 91, 35); findButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { findButtonActionPerformed(evt); } }); } { goodInfLabel = new JLabel(); goodsManagerPanel.add(goodInfLabel); goodInfLabel.setText("\u5546\u54c1\u4fe1\u606f\uff1a"); goodInfLabel.setBounds(42, 70, 98, 28); } { goodsManagerScrollPane1 = new JScrollPane(); goodsManagerPanel.add(goodsManagerScrollPane1); goodsManagerScrollPane1.setBounds(49, 112, 532, 294); { goodsListTableModel = new DefaultTableModel(goodsList, goodsHeader) { private static final long serialVersionUID = 1L; public boolean isCellEditable(int row, int column) { return false; } }; goodsListTable = new JTable(); goodsManagerScrollPane1.setViewportView(goodsListTable); goodsListTable.setModel(goodsListTableModel); goodsListTable.setBounds(392, 21, 532, 287); goodsListTable.addMouseListener(new MouseAdapter() { public void mouseClicked(MouseEvent evt) { goodsListTable1MouseClicked(evt); } }); } } { findPopupMenu = new JPopupMenu(); { findAllMenuItem = new JMenuItem(); findPopupMenu.add(findAllMenuItem); findAllMenuItem.setText("查询全部"); findAllMenuItem.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { findAllMenuItemActionPerformed(evt); } }); } { findtype1MenuItem = new JMenuItem(); findPopupMenu.add(findtype1MenuItem); findtype1MenuItem.setText("查询饮料"); findtype1MenuItem .addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { findType1MenuItemActionPerformed(evt); } }); } { findtype2MenuItem = new JMenuItem(); findPopupMenu.add(findtype2MenuItem); findtype2MenuItem.setText("查询香烟"); findtype2MenuItem .addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { findType2MenuItemActionPerformed(evt); } }); } { findtype3MenuItem = new JMenuItem(); findPopupMenu.add(findtype3MenuItem); findtype3MenuItem.setText("查询点卡"); findtype3MenuItem .addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { findType3MenuItemActionPerformed(evt); } }); } { findtype4MenuItem = new JMenuItem(); findPopupMenu.add(findtype4MenuItem); findtype4MenuItem.setText("查询食物"); findtype4MenuItem .addActionListener(new ActionListener() { public void actionPerformed(ActionEvent evt) { findType4MenuItemActionPerformed(evt); } }); } setComponentPopupMenu(goodsManagerPanel, findPopupMenu); } } this.setSize(629, 459); } catch (Exception e) { e.printStackTrace(); } } /** * Auto-generated method for setting the popup menu for a component */ //弹出式菜单的单击显示事件 private void setComponentPopupMenu(final java.awt.Component parent, final javax.swing.JPopupMenu menu) { parent.addMouseListener(new java.awt.event.MouseAdapter() { public void mousePressed(java.awt.event.MouseEvent e) { if (e.isPopupTrigger()) menu.show(parent, e.getX(), e.getY()); } public void mouseReleased(java.awt.event.MouseEvent e) { if (e.isPopupTrigger()) menu.show(parent, e.getX(), e.getY()); } }); } /* 添加按钮事件 */ private void addButtonActionPerformed(ActionEvent evt) { /* 使用新的对话框，所有数据都为空 */ AddUpDelDialog addDialog = new AddUpDelDialog(); addDialog.setModal(true); addDialog.setLocation(70, 50); addDialog.getTitleLa