mainwin.java~147~

来自「使用Java语言开发的数据库课程设计——医药管理信息系统。」· JAVA~147~ 代码 · 共 735 行 · 第 1/2 页

import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Dimension;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.Insets;
import javax.swing.BorderFactory;
import javax.swing.border.Border;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Color;
import javax.swing.border.TitledBorder;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import java.awt.Font;
import javax.swing.filechooser.*;
import java.util.Vector;


public class mainWin extends JFrame
{
    JMenuBar menuBar = new JMenuBar();
    JMenu jMenu1 = new JMenu();
    JMenu jMenu2 = new JMenu();
    JMenu jMenu3 = new JMenu();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem8 = new JMenuItem();
    JMenuItem jMenuItem10 = new JMenuItem();
    JMenuItem jMenuItem11 = new JMenuItem();
    JMenuItem jMenuItem12 = new JMenuItem();
    JButton jButton[] = new JButton[8];
    JToolBar  toolBar = new JToolBar();
    BorderLayout borderLayout1 = new BorderLayout();
    String ImageName[] = {"药品录入.gif","供应商录入.gif","药品采购.gif","药品销售.gif",
                          "基本查询.gif","入库明细.gif","销售明细.gif","用户管理.gif"};
    Icon image1 = new ImageIcon(".\\images\\" + ImageName[0]);
    Icon image2 = new ImageIcon(".\\images\\" + ImageName[1]);
    Icon image3 = new ImageIcon(".\\images\\" + ImageName[2]);
    Icon image4 = new ImageIcon(".\\images\\" + ImageName[3]);
    Icon image5 = new ImageIcon(".\\images\\" + ImageName[4]);
    Icon image6 = new ImageIcon(".\\images\\" + ImageName[5]);
    Icon image7 = new ImageIcon(".\\images\\" + ImageName[6]);
    Icon image8 = new ImageIcon(".\\images\\" + ImageName[7]);
    Icon background = new ImageIcon(".\\images\\main.jpg");
    Icon pic = new ImageIcon(".\\images\\cheer_up.gif");

    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();
    Border border1 = BorderFactory.createEmptyBorder();
    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    BorderLayout borderLayout2 = new BorderLayout();
    JMenuItem jMenuItem3 = new JMenuItem();
    JMenuItem jMenuItem7 = new JMenuItem();
    JMenu jMenu4 = new JMenu();
    JMenuItem jMenuItem4 = new JMenuItem();
    JMenuItem jMenuItem5 = new JMenuItem();
    JMenuItem jMenuItem6 = new JMenuItem();
    TitledBorder titledBorder1 = new TitledBorder("");
    JMenuItem jMenuItem13 = new JMenuItem();
    String Driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String conURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CASY";
    String Username = "sa";
    String Password = "111111";
    JMenuItem jMenuItem9 = new JMenuItem();
    JMenuItem jMenuItem14 = new JMenuItem();
    JMenuItem jMenuItem15 = new JMenuItem();
    TitledBorder titledBorder2 = new TitledBorder("");
    public mainWin()
    {
        new Load_DB_Driver();
        this.setDefaultCloseOperation(EXIT_ON_CLOSE);
        this.setTitle("医药管理系统");
        this.setResizable(false);
        this.setSize(650,500);
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = getSize();
        if (frameSize.height > screenSize.height)
        {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width)
        {
            frameSize.width = screenSize.width;
        }
        setLocation((screenSize.width - frameSize.width) / 2,
                    (screenSize.height - frameSize.height) / 2);

        try
        {
            jbInit();

        }
        catch (Exception exception)
        {
            exception.printStackTrace();
        }
        this.validate();
        this.setVisible(true);
    }

    private void jbInit() throws Exception
    {
        this.getContentPane().setLayout(borderLayout1);
        jMenu1.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 16));
        jMenu1.setBorder(null);
        jMenu1.setText("【基本信息】");
        jMenu2.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 16));
        jMenu2.setText("【基本业务】");
        jMenu3.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 16));
        jMenu3.setActionCommand("【用户管理】");
        jMenu3.setText("【用户管理】");
        jMenuItem1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem1.setActionCommand("药品总览");
        jMenuItem1.setText("库存药品总览");
        jMenuItem1.addActionListener(new mainWin_jMenuItem1_actionAdapter(this));
        jMenuItem2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem2.setActionCommand("采购明细");
        jMenuItem2.setText("历史采购明细");
        jMenuItem2.addActionListener(new mainWin_jMenuItem2_actionAdapter(this));
        jMenuItem8.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem8.setText("数据录入");
        jMenuItem8.addActionListener(new mainWin_jMenuItem8_actionAdapter(this));
        jMenuItem10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem10.setText("数据查询");
        jMenuItem10.addActionListener(new mainWin_jMenuItem10_actionAdapter(this));
        jMenuItem11.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem11.setText("修改密码");
        jMenuItem11.addActionListener(new mainWin_jMenuItem11_actionAdapter(this));
        jMenuItem12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem12.setText("添加/删除");
        jMenuItem12.addActionListener(new mainWin_jMenuItem12_actionAdapter(this));
        jButton1.setAlignmentX((float) 1.0);
        jButton1.setBorder(BorderFactory.createEtchedBorder());
        jButton1.setMaximumSize(new Dimension(40, 40));
        jButton1.setPreferredSize(new Dimension(36, 36));
        jButton1.setToolTipText("药品总览");
        jButton1.setIcon(image1);
        jButton1.setMargin(new Insets(2, 2, 2, 2));
        jButton1.addActionListener(new mainWin_jButton1_actionAdapter(this));
        jButton2.setAlignmentX((float) 1.0);
        jButton2.setBorder(BorderFactory.createEtchedBorder());
        jButton2.setMaximumSize(new Dimension(40, 40));
        jButton2.setPreferredSize(new Dimension(36, 36));
        jButton2.setToolTipText("药品查询");
        jButton2.setIcon(image2);
        jButton2.setMargin(new Insets(2, 2, 2, 2));
        jButton2.addActionListener(new mainWin_jButton2_actionAdapter(this));
        jButton3.setAlignmentX((float) 1.0);
        jButton3.setBorder(BorderFactory.createEtchedBorder());
        jButton3.setMaximumSize(new Dimension(40, 40));
        jButton3.setPreferredSize(new Dimension(36, 36));
        jButton3.setToolTipText("新货入库");
        jButton3.setIcon(image3);
        jButton3.setMargin(new Insets(2, 2, 2, 2));
        jButton3.addActionListener(new mainWin_jButton3_actionAdapter(this));
        jButton4.setAlignmentX((float) 1.0);
        jButton4.setBorder(BorderFactory.createEtchedBorder());
        jButton4.setMaximumSize(new Dimension(40, 40));
        jButton4.setPreferredSize(new Dimension(36, 36));
        jButton4.setToolTipText("取药登记");
        jButton4.setIcon(image4);
        jButton4.setMargin(new Insets(2, 2, 2, 2));
        jButton4.addActionListener(new mainWin_jButton4_actionAdapter(this));
        jButton5.setAlignmentX((float) 1.0);
        jButton5.setBorder(BorderFactory.createEtchedBorder());
        jButton5.setMaximumSize(new Dimension(40, 40));
        jButton5.setPreferredSize(new Dimension(36, 36));
        jButton5.setToolTipText("删除药品记录");
        jButton5.setIcon(image5);
        jButton5.setMargin(new Insets(2, 2, 2, 2));
        jButton5.addActionListener(new mainWin_jButton5_actionAdapter(this));
        jButton6.setAlignmentX((float) 1.0);
        jButton6.setBorder(BorderFactory.createEtchedBorder());
        jButton6.setMaximumSize(new Dimension(40, 40));
        jButton6.setPreferredSize(new Dimension(36, 36));
        jButton6.setToolTipText("备份/还原数据库");
        jButton6.setIcon(image6);
        jButton6.setMargin(new Insets(2, 2, 2, 2));
        jButton6.addActionListener(new mainWin_jButton6_actionAdapter(this));
        jButton7.setAlignmentX((float) 1.0);
        jButton7.setBorder(BorderFactory.createEtchedBorder());
        jButton7.setMaximumSize(new Dimension(40, 40));
        jButton7.setPreferredSize(new Dimension(36, 36));
        jButton7.setToolTipText("每日提示");
        jButton7.setIcon(image7);
        jButton7.setMargin(new Insets(2, 2, 2, 2));
        jButton7.addActionListener(new mainWin_jButton7_actionAdapter(this));
        jButton8.setAlignmentX((float) 1.0);
        jButton8.setBorder(BorderFactory.createEtchedBorder());
        jButton8.setMaximumSize(new Dimension(40, 40));
        jButton8.setPreferredSize(new Dimension(36, 36));
        jButton8.setToolTipText("修改密码");
        jButton8.setIcon(image8);
        jButton8.setMargin(new Insets(2, 2, 2, 2));
        jButton8.addActionListener(new mainWin_jButton8_actionAdapter(this));
        toolBar.setMargin(new Insets(5, 5, 5, 5));
        jLabel1.setIcon(background);
        jPanel1.setLayout(borderLayout2);
        jMenuItem7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem7.setText("历史开销明细");
        jMenuItem7.addActionListener(new mainWin_jMenuItem7_actionAdapter(this));
        jMenuItem3.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem3.setText("备份数据库");
        jMenuItem3.addActionListener(new mainWin_jMenuItem3_actionAdapter(this));
        jMenu4.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 16));
        jMenu4.setText("【关于本软件】");
        jMenuItem4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem4.setText("开发小组");
        jMenuItem4.addActionListener(new mainWin_jMenuItem4_actionAdapter(this));
        jMenuItem5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem5.setText("软件版本");
        jMenuItem5.addActionListener(new mainWin_jMenuItem5_actionAdapter(this));
        jMenuItem6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem6.setText("每日提醒");
        jMenuItem6.addActionListener(new mainWin_jMenuItem6_actionAdapter(this));
        jMenuItem13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem13.setActionCommand("新货入库");
        jMenuItem13.setText("新货入库登记");
        jMenuItem13.addActionListener(new mainWin_jMenuItem13_actionAdapter(this));
        jMenuItem9.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem9.setText("数据删除");
        jMenuItem9.addActionListener(new mainWin_jMenuItem9_actionAdapter(this));
        jMenuItem14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem14.setText("还原数据");
        jMenuItem14.addActionListener(new mainWin_jMenuItem14_actionAdapter(this));
        jMenuItem15.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jMenuItem15.setText("医用取药登记");
        jMenuItem15.addActionListener(new mainWin_jMenuItem15_actionAdapter(this));
        menuBar.add(jMenu1);
        menuBar.add(jMenu2);
        menuBar.add(jMenu3);
        menuBar.add(jMenu4);
        jMenu1.add(jMenuItem1);
        jMenu1.add(jMenuItem2);
        jMenu1.add(jMenuItem7);
        jMenu2.add(jMenuItem8);
        jMenu2.add(jMenuItem9);
        jMenu2.add(jMenuItem10);
        jMenu2.add(jMenuItem3);
        jMenu2.add(jMenuItem14);
        jMenu2.addSeparator();
        jMenu2.add(jMenuItem13);
        jMenu2.add(jMenuItem15);
        jMenu3.add(jMenuItem11);
        jMenu3.add(jMenuItem12);
        toolBar.add(jButton1);
        toolBar.add(jButton2);
        toolBar.add(jButton3);
        toolBar.add(jButton4);
        toolBar.add(jButton5);
        toolBar.add(jButton6);
        toolBar.add(jButton7);
        toolBar.add(jButton8);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);
        jPanel1.add(jLabel1, java.awt.BorderLayout.CENTER);
        jPanel1.add(toolBar, java.awt.BorderLayout.NORTH);
        jMenu4.add(jMenuItem4);
        jMenu4.add(jMenuItem5);
        jMenu4.add(jMenuItem6);
        this.setJMenuBar(menuBar);
    }

    public void Connect_DB()
    {
        try
        {
            Class.forName(Driver);
        }
        catch(ClassNotFoundException ee)
        {
            JOptionPane.showMessageDialog(null,"ForName:" + ee.getMessage(),"警告!",
                                 JOptionPane.WARNING_MESSAGE);
        }
    }

    public void DB_bak_rec(String sql)
    {
        try
           {
               Connection con = DriverManager.getConnection(conURL,Username,Password);
               Statement s= con.createStatement();
               s.executeUpdate(sql);
               JOptionPane.showMessageDialog(null, "☆　操作成功 !!　☆", "系统消息",JOptionPane.WARNING_MESSAGE);
               s.close();
               con.close();
           }
           catch(SQLException ex)
           {
               JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
           }

    }

    public static void main(String[] args)
    {
        new mainWin();
    }

    public void jButton1_actionPerformed(ActionEvent e)
    {
        new Medicine_information();
        dispose();
    }

    public void jMenuItem1_actionPerformed(ActionEvent e)
    {
        new Medicine_information();
        dispose();
    }

    public void jMenuItem4_actionPerformed(ActionEvent e)
    {
        JOptionPane.showConfirmDialog(null,
                                       "幕后老板 :  AP0506214     ★ 梁超洪 -- 大老板要收货啦,快要加班赶工啊!"+'\n'
                                      +"总设计师 :  AP0506201     ★ 蔡焯光 -- 我唔捞啦!!"+'\n'
                                      +"代码民工 :  AP0506221     ★ 区铎启 -- 我只眼要爆啦,老板加薪啊!!"+'\n'
                                      +'\n'
                                      +"Copyright@2008-2100,AP05062, All Right Reserved ",
                                      " AP05062班 三剑客 研发 ",JOptionPane.DEFAULT_OPTION,
                     JOptionPane.WARNING_MESSAGE, pic);
    }

    public void jMenuItem12_actionPerformed(ActionEvent e)
    {
        JOptionPane.showMessageDialog(null,"只有超级管理员才能执行此操作,现在验证你的身份!!!","系统提示",JOptionPane.WARNING_MESSAGE);
        String pw = JOptionPane.showInputDialog(null,"请输入超级管理员帐号的密码: ","身份验证",JOptionPane.WARNING_MESSAGE);

        try
        {
            Connection con = DriverManager.getConnection(conURL,Username,Password);
            Statement s= con.createStatement();
            ResultSet rs = s.executeQuery("SELECT * FROM identify WHERE ID ='AP0506221' and password = '"+ pw +"'");
            if(!rs.next()) JOptionPane.showMessageDialog(null," 密码错误 !!","系统提示",JOptionPane.ERROR_MESSAGE);
            else
            {
                JOptionPane.showMessageDialog(null, "☆　通过验证 !!　☆", "系统消息",JOptionPane.WARNING_MESSAGE);
                new User_Manage();
            }
            s.close();
            con.close();
        }
        catch(SQLException ex)
        {
            JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
        }
    }

    public void jMenuItem8_actionPerformed(ActionEvent e)
    {
        new medicine_data_input();
        dispose();
    }

    public void jMenuItem11_actionPerformed(ActionEvent e)
    {
        new Password_modify();