reg_medicine.java~4~

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

import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Dimension;
import javax.swing.BorderFactory;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.awt.Font;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
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.awt.event.WindowEvent;
import java.awt.event.WindowAdapter;

public class Reg_Medicine extends JFrame
{
    BorderLayout borderLayout1 = new BorderLayout();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    Object[] gys = {"宝芝林","春和堂","哈药六厂","999药业","广州陈李济药厂","北京同仁堂药厂"};
    BorderLayout borderLayout2 = new BorderLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable();
    JTextField jTextField1 = new JTextField();
    XYLayout xYLayout1 = new XYLayout();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JTextField jTextField4 = new JTextField();
    JTextField jTextField5 = new JTextField();
    JComboBox jComboBox1 = new JComboBox(gys);
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    String Driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String conURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CASY";
    String Username = "sa";
    String Password = "111111";
    String Order = null;
    int kucun_tianjia = 0;
    Vector header;
    Vector data;
    DefaultTableModel tableModel1 = null;
    JPanel jPanel3 = new JPanel();
    JButton jButton3 = new JButton();
    XYLayout xYLayout2 = new XYLayout();
    JLabel jLabel7 = new JLabel();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    public Reg_Medicine()
    {
        this.setSize(550, 400);
        this.setResizable(false);
        this.setTitle("药品入库登记");
        this.addWindowListener(new WindowAdapter()
        {
            public void windowClosing(WindowEvent e)
            {
                new mainWin();
                dispose();
            }
        });

        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.setVisible(true);
    }

    private void jbInit() throws Exception
    {
        getContentPane().setLayout(borderLayout1);
        jPanel2.setBackground(new Color(236, 233, 173));
        jPanel2.setLayout(xYLayout1);
        jPanel1.setLayout(borderLayout2);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel1.setText("药品编号");
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel2.setText("药品名称");
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel3.setText("入库数量");
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel4.setText("供应商");
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jLabel5.setText("订单号");
        jLabel6.setText("订购日期");
        jButton1.setText("确认/入库");
        jButton1.addActionListener(new Reg_Medicine_jButton1_actionAdapter(this));
        jButton2.setText("取  消");
        jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        jTextField2.setEnabled(false);
        jPanel2.setMinimumSize(new Dimension(10, 150));
        jPanel2.setPreferredSize(new Dimension(10, 150));
        jPanel1.setPreferredSize(new Dimension(452, 160));
        jPanel3.setBorder(BorderFactory.createEtchedBorder());
        jPanel3.setLayout(xYLayout2);
        jButton3.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton3.setText("订单号");
        jButton3.addActionListener(new Reg_Medicine_jButton3_actionAdapter(this));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel7.setText("排序:");
        jButton4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton4.setText("订购日期");
        jButton4.addActionListener(new Reg_Medicine_jButton4_actionAdapter(this));
        jButton5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jButton5.setText("供应商");
        jButton1.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton2.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton3.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton4.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton5.setCursor(new Cursor(Cursor.HAND_CURSOR));
        jButton5.addActionListener(new Reg_Medicine_jButton5_actionAdapter(this));
        this.getContentPane().add(jPanel2, java.awt.BorderLayout.SOUTH);
        jPanel2.add(jTextField5, new XYConstraints(291, 106, 106, 24));
        jPanel2.add(jButton2, new XYConstraints(438, 88, 87, 37));
        jPanel2.add(jButton1, new XYConstraints(438, 24, -1, 37));
        jPanel2.add(jLabel2, new XYConstraints(16, 110, -1, -1));
        jPanel2.add(jLabel1, new XYConstraints(16, 66, -1, -1));
        jPanel2.add(jLabel4, new XYConstraints(242, 66, 40, -1));
        jPanel2.add(jLabel3, new XYConstraints(230, 22, -1, -1));
        jPanel2.add(jLabel5, new XYConstraints(28, 22, 40, -1));
        jPanel2.add(jLabel6, new XYConstraints(234, 111, -1, -1));
        jPanel2.add(jTextField1, new XYConstraints(81, 62, 106, 24));
        jPanel2.add(jTextField2, new XYConstraints(81, 106, 106, 24));
        jPanel2.add(jTextField4, new XYConstraints(81, 18, 106, 24));
        jPanel2.add(jComboBox1, new XYConstraints(291, 62, 106, -1));
        jPanel2.add(jTextField3, new XYConstraints(291, 18, 106, 24));
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
        jPanel1.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jScrollPane1.getViewport().add(jTable1);
        this.getContentPane().add(jPanel3, java.awt.BorderLayout.CENTER);
        jPanel3.add(jLabel7, new XYConstraints(31, 16, -1, -1));
        jPanel3.add(jButton4, new XYConstraints(227, 7, -1, 32));
        jPanel3.add(jButton3, new XYConstraints(118, 7, 80, 32));
        jPanel3.add(jButton5, new XYConstraints(345, 7, 80, 32));
        init_table();
        jPanel1.validate();
        jPanel2.validate();
        new Load_DB_Driver();
        try
        {
            Connection init_con = DriverManager.getConnection(conURL,Username,Password);
            Statement stm= init_con.createStatement();
            String sql = "select * from Medicine_Buy";
            ResultSet rss = stm.executeQuery(sql);
            while(rss.next())
            {
                data = new Vector();
                data.addElement(rss.getString(1));
                data.addElement(rss.getString(2));
                data.addElement(rss.getString(3));
                data.addElement(rss.getString(4));
                data.addElement(rss.getString(5));
                data.addElement(rss.getString(6));
                tableModel1.addRow(data);
                jTable1.setModel(tableModel1);
            }
            stm.close();
            init_con.close();
        }
        catch(SQLException ex)
        {
            JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
        }
        this.validate();
    }

    public void DB_Update(String sql)
    {
        try
        {
            Connection con = DriverManager.getConnection(conURL, Username,Password);
            Statement s = con.createStatement();
            s.executeUpdate(sql);
            s.close();
            con.close();
        }
        catch(SQLException ex)
        {