JAVA仓库管理系统源代码 含SQL数据库

package depotmenu; import java.awt.*; import javax.swing.*; import com.borland.jbcl.layout.*; import java.awt.event.*; import depotmanage.*; import comedeput.*; import godeput.*; import stock.*; import clientserver.*; import controller.*; import amountoperation.AmountOperation; public class DepotMenu extends JFrame { JMenuBar jMenuBar1 = new JMenuBar(); JMenu jMenu1 = new JMenu(); JMenuItem jMenuItem2 = new JMenuItem(); JMenuItem jMenuItem3 = new JMenuItem(); JMenu jMenu2 = new JMenu(); JMenuItem jMenuItem4 = new JMenuItem(); JMenuItem jMenuItem5 = new JMenuItem(); JMenuItem jMenuItem6 = new JMenuItem(); JMenu jMenu3 = new JMenu(); JMenuItem jMenuItem9 = new JMenuItem(); JMenuItem jMenuItem10 = new JMenuItem(); JMenuItem jMenuItem11 = new JMenuItem(); JMenu jMenu4 = new JMenu(); JMenuItem jMenuItem12 = new JMenuItem(); JMenuItem jMenuItem13 = new JMenuItem(); JMenuItem jMenuItem14 = new JMenuItem(); JMenu jMenu5 = new JMenu(); JMenuItem jMenuItem15 = new JMenuItem(); XYLayout xYLayout1 = new XYLayout(); JToolBar jToolBar1 = new JToolBar(); JButton jButton1 = new JButton(); // 工具栏按钮 JButton jButton2 = new JButton(); JButton jButton3 = new JButton(); JButton jButton4 = new JButton(); JButton jButton5 = new JButton(); JButton jButton6 = new JButton(); JButton jButton7 = new JButton(); JButton jButton8 = new JButton(); JLabel jLabel13 = new JLabel(); JButton jButton9 = new JButton(); JMenuItem jMenuItem1 = new JMenuItem(); JPanel jPanel1 = new JPanel(); String ids = ""; public DepotMenu(String ids) { this.ids = ids; try { jbInit(); } catch (Exception exception) { exception.printStackTrace(); } } private void jbInit() throws Exception { getContentPane().setLayout(xYLayout1); this.setJMenuBar(jMenuBar1); xYLayout1.setWidth(602); xYLayout1.setHeight(421); jMenuItem2.addMouseListener(new DepotMenu_jMenuItem2_mouseAdapter(this)); jMenuItem3.addMouseListener(new DepotMenu_jMenuItem3_mouseAdapter(this)); jMenuItem13.addMouseListener(new DepotMenu_jMenuItem13_mouseAdapter(this)); jMenuItem14.addMouseListener(new DepotMenu_jMenuItem14_mouseAdapter(this)); jMenuItem15.addMouseListener(new DepotMenu_jMenuItem15_mouseAdapter(this)); jMenuItem9.addMouseListener(new DepotMenu_jMenuItem9_mouseAdapter(this)); jMenuItem10.addMouseListener(new DepotMenu_jMenuItem10_mouseAdapter(this)); jMenuItem11.addMouseListener(new DepotMenu_jMenuItem11_mouseAdapter(this)); jButton9.setBounds(new Rectangle(220, 227, 113, 52)); jMenuItem12.addMouseListener(new DepotMenu_jMenuItem12_mouseAdapter(this)); jToolBar1.setBorder(BorderFactory.createLoweredBevelBorder()); jMenuBar1.setBorder(BorderFactory.createEtchedBorder()); jMenuItem1.setText("退出"); jMenuItem1.addMouseListener(new DepotMenu_jMenuItem1_mouseAdapter(this)); jPanel1.setBorder(null); jPanel1.setDebugGraphicsOptions(0); this.getContentPane().add(jToolBar1, java.awt.BorderLayout.NORTH); jMenu1.setToolTipText(""); jMenu1.setText("基本设置"); jMenuItem2.setText("厂商资料"); jMenuItem3.setText("入库类别"); jMenu2.setText("仓库管理"); jMenuItem4.setText("入库资料"); jMenuItem4.addMouseListener(new DepotMenu_jMenuItem4_mouseAdapter(this)); jMenuItem5.setText("出库资料"); jMenuItem5.addMouseListener(new DepotMenu_jMenuItem5_mouseAdapter(this)); jMenuItem6.setText("库存资料"); jMenuItem6.addMouseListener(new DepotMenu_jMenuItem6_mouseAdapter(this)); jButton1.addActionListener(new jbu1(this)); jButton2.addActionListener(new jbu2(this)); jButton3.addActionListener(new jbu3(this)); jButton4.addActionListener(new jbu4(this)); jButton5.addActionListener(new jbu5(this)); jButton6.addActionListener(new jbu6(this)); jButton7.addActionListener(new jbu7(this)); jButton8.addActionListener(new jbu8(this)); jButton9.addActionListener(new jbu9(this)); jMenu3.setText("综合管理"); jMenuItem9.setText("入库管理"); jMenuItem10.setText("出库管理"); jMenuItem11.setText("库存管理"); jMenu4.setText("系统管理"); jMenuItem12.setText("数据备份"); jMenuItem13.setText("用户管理"); jMenuItem14.setText("密码更改"); jMenu5.setText("帮助"); jMenuItem15.setText("关于."); jMenuBar1.setBackground(SystemColor.inactiveCaptionBorder); jMenuBar1.add(jMenu1); jMenuBar1.add(jMenu2); jMenuBar1.add(jMenu3); jMenuBar1.add(jMenu4); jMenuBar1.add(jMenu5); jMenu1.addSeparator(); jMenu1.add(jMenuItem2); jMenu1.addSeparator(); jMenu1.add(jMenuItem3); jMenu1.addSeparator(); jMenu1.add(jMenuItem1); jMenu2.add(jMenuItem4); jMenu2.add(jMenuItem5); jMenu2.add(jMenuItem6); jMenu3.add(jMenuItem9); jMenu3.add(jMenuItem10); jMenu3.addSeparator(); jMenu3.add(jMenuItem11); jMenu4.add(jMenuItem12); jMenu4.addSeparator(); jMenu4.add(jMenuItem13); jMenu4.add(jMenuItem14); jMenu5.add(jMenuItem15); jToolBar1.add(jButton1); // 添加按钮到工具栏 jToolBar1.add(jButton2); jToolBar1.add(jButton3); jToolBar1.add(jButton4); jToolBar1.add(jButton5); jToolBar1.add(jButton9); jToolBar1.add(jButton6); jToolBar1.add(jButton7); jToolBar1.add(jButton8); this.getContentPane().add(jPanel1, new XYConstraints(1, 53, 700, 424)); ImageIcon i2 = new ImageIcon("1.jpg"); // 创建图片 ImageIcon i3 = new ImageIcon("2.jpg"); ImageIcon i4 = new ImageIcon("3.jpg"); ImageIcon i5 = new ImageIcon("4.jpg"); ImageIcon i6 = new ImageIcon("5.jpg"); ImageIcon i7 = new ImageIcon("6.jpg"); ImageIcon i8 = new ImageIcon("7.jpg"); ImageIcon i9 = new ImageIcon("8.jpg"); ImageIcon i10 = new ImageIcon("9.jpg"); jButton1.setIcon(i2); // 添加图片到按钮上 jButton2.setIcon(i3); jButton3.setIcon(i4); jButton4.setIcon(i5); jButton5.setIcon(i6); jButton6.setIcon(i7); jButton7.setIcon(i8); jButton8.setIcon(i9); jButton9.setIcon(i10); this.setSize(700, 520); double width = Toolkit.getDefaultToolkit().getScreenSize().getWidth(); double height = Toolkit.getDefaultToolkit().getScreenSize().getHeight(); double width1 = this.getWidth(); double height1 = this.getHeight(); int x = (int) (width - width1) / 2; int y = (int) (height - height1) / 2; this.setLocation(x, y); this.setResizable(false); //禁止修改大小 this.setTitle("仓库管理系统 欢迎: " + ids); this.setVisible(true); } public void jMenuItem1_mousePressed(MouseEvent e) { System.exit(0); } public void jMenuItem4_mousePressed(MouseEvent e) { jPanel1.add(new ComeDeput()); } public void jMenuItem5_mousePressed(MouseEvent e) { jPanel1.add(new GoDeput()); } public void jMenuItem6_mousePressed(MouseEvent e) { jPanel1.add(new Stock()); } public void jMenuItem2_mousePressed(MouseEvent e) { jPanel1.add(new ClientInquire()); } public void jMenuItem3_mousePressed(MouseEvent e) { jPanel1.add(new DepotManage()); } public void jMenuItem13_mousePressed(MouseEvent e) { jPanel1.add(new Admin());