medicine_information.java

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

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Font;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.*;

public class medicine_information extends JFrame
{
    BorderLayout borderLayout1 = new BorderLayout();
    JTabbedPane jTabbedPane1 = new JTabbedPane();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    XYLayout xYLayout1 = new XYLayout();
    Object[] danwei = {"盒","包","袋","罐","粒","片","瓶"};
    Object[] youxiaoqi = {"6个月","一年","18个月","二年","30个月","三年","三年以上"};
    Object[] jixing = {"针剂","片剂","胶囊","口服液","冲剂","丸剂"};
    Object[] leibie = {"中药","西药","中成药","中成药（外用）","消毒","参茸"};
    JComboBox jComboBox1 = new JComboBox(leibie);
    JComboBox jComboBox2 = new JComboBox(youxiaoqi);
    JComboBox jComboBox3 = new JComboBox(danwei);
    JComboBox jComboBox4 = new JComboBox(jixing);
    JPanel jPanel3 = new JPanel();
    JTextField jTextField5 = new JTextField();
    JTextField jTextField6 = new JTextField();
    JTextField jTextField7 = new JTextField();
    JTextField jTextField8 = new JTextField();
    JTextField jTextField9 = new JTextField();
    JLabel jLabel14 = new JLabel();
    XYLayout xYLayout2 = new XYLayout();
    JTextField jTextField10 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    XYLayout xYLayout3 = new XYLayout();
    JPanel jPanel4 = new JPanel();
    JPanel jPanel5 = new JPanel();
    JLabel jLabel15 = new JLabel();
    XYLayout xYLayout4 = new XYLayout();
    JTextField jTextField11 = new JTextField();
    JLabel jLabel16 = new JLabel();
    JTextField jTextField12 = new JTextField();
    JPanel jPanel6 = new JPanel();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    XYLayout xYLayout5 = new XYLayout();
    XYLayout xYLayout6 = new XYLayout();
    JLabel jLabel17 = new JLabel();
    JLabel jLabel18 = new JLabel();
    JTextField jTextField13 = new JTextField();
    JLabel jLabel19 = new JLabel();
    JTextField jTextField14 = new JTextField();
    JTextField jTextField15 = new JTextField();
    JLabel jLabel20 = new JLabel();
    JLabel jLabel21 = new JLabel();
    JLabel jLabel22 = new JLabel();
    JTextField jTextField16 = new JTextField();
    JLabel jLabel23 = new JLabel();
    JTextField jTextField17 = new JTextField();
    JTextField jTextField18 = new JTextField();
    JLabel jLabel24 = new JLabel();
    JLabel jLabel25 = new JLabel();
    JLabel jLabel26 = new JLabel();
    JTextField jTextField19 = new JTextField();
    JLabel jLabel27 = new JLabel();
    JTextField jTextField20 = new JTextField();
    JTextField jTextField21 = new JTextField();
    JLabel jLabel28 = new JLabel();
    JLabel jLabel29 = new JLabel();
    JLabel jLabel31 = new JLabel();
    JTextField jTextField22 = new JTextField();
    JButton jButton5 = new JButton();
    JTextField jTextField24 = new JTextField();
    JTextField jTextField25 = new JTextField();
    JTextField jTextField26 = new JTextField();
    JTextField jTextField27 = new JTextField();

    String query;
    String save;
    String Driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String conURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CASY";
    String Username = "sa";
    String Password = "111111";
    JButton jButton6 = new JButton();
    public medicine_information()
    {
        try
        {
            this.setSize(new Dimension(676, 518));
            this.setVisible(true);
            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);

            jbInit();
            this.setDefaultCloseOperation(EXIT_ON_CLOSE);
        }
        catch (Exception exception)
        {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception
    {
        getContentPane().setLayout(borderLayout1);
        jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel2.setForeground(Color.red);
        jLabel2.setText("药品名称");
        jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel3.setForeground(Color.red);
        jLabel3.setText("通用名称");
        jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel4.setForeground(Color.red);
        jLabel4.setText(" 单 位 ");
        jLabel5.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel5.setForeground(Color.red);
        jLabel5.setText(" 剂 型 ");
        jLabel6.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel6.setForeground(Color.red);
        jLabel6.setText("包装数量");
        jLabel8.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel8.setForeground(Color.red);
        jLabel8.setText(" 有效期");
        jLabel7.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel7.setForeground(Color.red);
        jLabel7.setText(" 批 号 ");
        jTabbedPane1.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel1.setForeground(Color.red);
        this.getContentPane().setBackground(SystemColor.control);
        jPanel1.setBackground(new Color(66, 227, 0));
        jPanel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 10));
        jLabel9.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel9.setForeground(Color.red);
        jLabel9.setText(" 产 地 ");
        jLabel10.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel10.setForeground(Color.red);
        jLabel10.setText("进货价格");
        jLabel11.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel11.setForeground(Color.red);
        jLabel11.setText("批发价格");
        jLabel12.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel12.setForeground(Color.red);
        jLabel12.setText("零售价格");
        jLabel13.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel13.setForeground(Color.red);
        jLabel13.setText("药品类别");
        jPanel3.setBackground(Color.orange);
        jPanel3.setLayout(xYLayout2);
        jPanel1.setLayout(xYLayout1);
        jLabel1.setText("药品编号");
        jLabel14.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jLabel14.setForeground(Color.blue);
        jLabel14.setText("药品编号");
        jButton1.setText("修  改");
        jButton1.addActionListener(new
                                   medicine_information_jButton1_actionAdapter(this));
        jButton2.setText("新资料");
        jPanel2.setLayout(xYLayout3);
        jPanel4.setBackground(Color.orange);
        jPanel4.setLayout(xYLayout4);
        jPanel5.setBackground(new Color(66, 227, 0));
        jPanel5.setLayout(xYLayout6);
        jLabel15.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jLabel15.setText("药品编号");
        jLabel16.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jLabel16.setText("药品名称");
        jPanel6.setBackground(Color.orange);
        jPanel6.setLayout(xYLayout5);
        jButton3.setText("保  存");
        jButton3.addActionListener(new
                                   medicine_information_jButton3_actionAdapter(this));
        jButton4.setText("取  消");
        jLabel17.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel17.setForeground(Color.red);
        jLabel17.setText(" 单 位 ");
        jLabel18.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel18.setForeground(Color.red);
        jLabel18.setText(" 有效期");
        jLabel19.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel19.setForeground(Color.red);
        jLabel19.setText("零售价格");
        jLabel20.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel20.setForeground(Color.red);
        jLabel20.setText("药品编号");
        jLabel21.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel21.setForeground(Color.red);
        jLabel21.setText("药品类别");
        jLabel22.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel22.setForeground(Color.red);
        jLabel22.setText("通用名称");
        jLabel23.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel23.setForeground(Color.red);
        jLabel23.setText("药品名称");
        jLabel24.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel24.setForeground(Color.red);
        jLabel24.setText(" 产 地 ");
        jLabel25.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel25.setForeground(Color.red);
        jLabel25.setText("批发价格");
        jLabel26.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel26.setForeground(Color.red);
        jLabel26.setText(" 批 号 ");
        jLabel27.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel27.setForeground(Color.red);
        jLabel27.setText("包装数量");
        jLabel28.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel28.setForeground(Color.red);
        jLabel28.setToolTipText("");
        jLabel28.setText("进货价格");
        jLabel29.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLabel29.setForeground(Color.red);
        jLabel29.setText(" 剂 型 ");
        jPanel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 10));
        jLabel31.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jLabel31.setForeground(Color.blue);
        jLabel31.setText("药品名称");
        jButton5.setText("查  询");
        jButton5.addActionListener(new
                                   medicine_information_jButton5_actionAdapter(this));
        jTextField13.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField14.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField15.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField16.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField17.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField18.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField19.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField20.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField21.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField24.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField25.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField26.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTextField27.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jButton6.setText("清  空");
        jButton6.addActionListener(new
                                   medicine_information_jButton6_actionAdapter(this));
        jTabbedPane1.add(jPanel2, "数据浏览");
        this.getContentPane().add(jTabbedPane1, java.awt.BorderLayout.CENTER);
        jPanel6.add(jButton3, new XYConstraints(463, 8, 82, 32));
        jPanel6.add(jButton4, new XYConstraints(567, 7, 82, 32));
        jPanel1.add(jTextField6, new XYConstraints(472, 167, 148, 25));
        jPanel1.add(jLabel1, new XYConstraints(16, 66, 66, 34));
        jPanel1.add(jTextField1, new XYConstraints(125, 71, 148, 25));
        jPanel1.add(jLabel2, new XYConstraints(16, 114, 66, 34));
        jPanel1.add(jTextField2, new XYConstraints(125, 119, 148, 25));
        jPanel1.add(jLabel3, new XYConstraints(16, 162, 66, 34));
        jPanel1.add(jTextField3, new XYConstraints(125, 167, 148, 25));
        jPanel1.add(jLabel13, new XYConstraints(16, 210, 66, 34));
        jPanel1.add(jComboBox1, new XYConstraints(125, 215, 148, 25));
        jPanel1.add(jLabel8, new XYConstraints(16, 258, 66, 34));
        jPanel1.add(jComboBox2, new XYConstraints(125, 263, 148, 25));
        jPanel1.add(jLabel4, new XYConstraints(16, 306, 66, 34));
        jPanel1.add(jComboBox3, new XYConstraints(125, 311, 148, 25));
        jPanel1.add(jComboBox4, new XYConstraints(125, 359, 148, 25));
        jPanel1.add(jLabel5, new XYConstraints(16, 354, 66, 34));
        jPanel1.add(jLabel6, new XYConstraints(358, 66, 66, 34));
        jPanel1.add(jLabel9, new XYConstraints(358, 114, 66, 34));
        jPanel1.add(jLabel12, new XYConstraints(358, 162, 66, 34));
        jPanel1.add(jLabel10, new XYConstraints(358, 210, 66, 34));
        jPanel1.add(jLabel11, new XYConstraints(358, 258, 66, 34));