day_tips.java

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

import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Font;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
import java.util.GregorianCalendar;
import java.util.Calendar;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;

public class Day_Tips extends JFrame
{
    BorderLayout borderLayout1 = new BorderLayout();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JPanel jPanel3 = new JPanel();
    BorderLayout borderLayout2 = new BorderLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable();
    JLabel jLabel1 = new JLabel();
    XYLayout xYLayout1 = new XYLayout();
    XYLayout xYLayout2 = new XYLayout();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    Icon pic = null;
    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;
    Vector header;
    Vector data;
    DefaultTableModel tableModel1 = null;
    Calendar today = null;
    Calendar Open_date = null;
    long millis = 0;
    long the_rest = 0;
    String sql = null;

    public Day_Tips()
    {
        this.setSize(408, 320);
        this.setResizable(false);
        this.setTitle("每日提示");
        Toolkit kit=Toolkit.getDefaultToolkit();
        Image image = kit.createImage(".\\images\\title.ico");
        setIconImage(image);
        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);
        init_table();
        try
        {
            jbInit();
        } catch (Exception exception)
        {
            exception.printStackTrace();
        }
        this.setVisible(true);
    }

    private void jbInit() throws Exception
    {
        getContentPane().setLayout(borderLayout1);
        jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        jLabel4.setForeground(Color.red);
        pic = new ImageIcon(".\\images\\08.jpg");
        jLabel1.setToolTipText("");
        this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        jLabel2.setIcon(pic);
        jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
        jPanel2.setOpaque(true);
        jPanel2.setPreferredSize(new Dimension(10, 130));
        jPanel2.setLayout(borderLayout2);
        jPanel1.setBackground(Color.white);
        jPanel1.setPreferredSize(new Dimension(10, 122));
        jPanel1.setLayout(xYLayout2);
        jScrollPane1.getViewport().setBackground(SystemColor.control);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        jLabel1.setForeground(Color.red);
        jLabel1.setText("以下药品库存量小于或仅有50,请及时补充库存");
        jPanel3.setLayout(xYLayout1);
        jLabel2.setOpaque(true);
        jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        jLabel3.setText("距离08北京奥运还有");
        this.getContentPane().add(jPanel3, java.awt.BorderLayout.CENTER);
        jPanel1.add(jLabel2, new XYConstraints(0, 0, 88, 122));
        jPanel1.add(jLabel3, new XYConstraints(151, 18, 178, 30));
        this.getContentPane().add(jPanel2, java.awt.BorderLayout.SOUTH);
        jScrollPane1.getViewport().add(jTable1);
        jPanel2.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jPanel1.add(jLabel4, new XYConstraints(213, 66, 55, 30));
        jPanel3.add(jLabel1, new XYConstraints(5, 14, -1, -1));
        pic = new ImageIcon(".\\images\\08.jpg");
        today = new GregorianCalendar();
        Open_date = new GregorianCalendar(2008, Calendar.AUGUST, 8);
        millis = Open_date.getTimeInMillis() - today.getTimeInMillis();
        the_rest = millis / (24 * 60 * 60 * 1000) + 1;
        jLabel4.setText(String.valueOf(the_rest)+" 天");
        new Load_DB_Driver();
        sql = "SELECT 药品编号,药品名称,药品类别,单位,进货价格,库存量 FROM Medicine_Data where 库存量<=50";
        add_table_data(sql);
        this.validate();
    }

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

    public void init_table()
    {
        header = new Vector();
        header.addElement("药品编号");
        header.addElement("药品名称");
        header.addElement("药品类别");
        header.addElement("单位");
        header.addElement("进货价格");
        header.addElement("库存量");
        tableModel1 = new DefaultTableModel(header,0);
        jTable1.setModel(tableModel1);
        for(int i= 0;i<6;i++)
        jTable1.getColumnModel().getColumn(i).setPreferredWidth(81);
    }

    public void add_table_data(String sql)
    {
        try
           {
               Connection con = DriverManager.getConnection(conURL, Username,
                       Password);
               Statement s = con.createStatement();
               ResultSet rs = s.executeQuery(sql);
               while(rs.next())
               {
                   data = new Vector();
                   data.addElement(rs.getString(1));
                   data.addElement(rs.getString(2));
                   data.addElement(rs.getString(3));
                   data.addElement(rs.getString(4));
                   data.addElement(rs.getString(5));
                   data.addElement(rs.getString(6));
                   tableModel1.addRow(data);
               }
               jTable1.setModel(tableModel1);
               rs.close();
               con.close();
           }
           catch(SQLException ex)
           {
               JOptionPane.showMessageDialog(null,"SQLException:" + ex.getMessage(),"警告!",JOptionPane.WARNING_MESSAGE);
           }
    }


}