stockframe.java~19~

JAVA超市管理系统

package project1;

import java.awt.BorderLayout;
import java.awt.BorderLayout;
import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.table.*;
import java.awt.event.*;
import javax.swing.*;

public class StockFrame extends JFrame {
    ImageIcon image12 = new ImageIcon(project1.MainFrame.class.getResource("image12.png"));
    ImageIcon image13 = new ImageIcon(project1.MainFrame.class.getResource("image13_.png"));
    ImageIcon image14 = new ImageIcon(project1.MainFrame.class.getResource("image14_.png"));
    public StockFrame() {
        super();
        setSize(750, 570);
        setLocation(160,110);
        setTitle("采购单");
        setResizable(false);
        try {
            StockTableModel stocktableModel = new StockTableModel(driver, RL, sqlStr,
                    user, password);
            JTable resultTable = new JTable(stocktableModel);
            resultTable.setRowHeight(25);



        getContentPane().setLayout(null);
        panel.setBackground(Color.white);
        panel.setBounds(new Rectangle( -1, 1, 762, 517));
        panel.setLayout(null);
        this.setJMenuBar(jMenuBar1);
        jMenu1.setText("新单");
        jMenu2.setText("插入行");
        jMenu3.setText("删除行");
        jMenu4.setText("导出EXCEL");
        jMenu5.setText("关闭");
        panel1.setBackground(Color.white);
        panel1.setBounds(new Rectangle(3, 2, 751, 111));
        panel1.setLayout(null);
        panel2.setBackground(Color.white);
        panel2.setBounds(new Rectangle(3,70,751,460));
        panel2.setLayout(null);
        jLabel1.setIcon(image12);
        jLabel1.setBounds(new Rectangle(272, 7, 170, 32));
        jLabel2.setIcon(image13);
        jLabel2.setBounds(new Rectangle(49, 64, 62, 28));
        jTextField1.setBounds(new Rectangle(126, 64, 170, 28));
        jLabel3.setIcon(image14);
        jLabel3.setBounds(new Rectangle(390, 64, 61, 24));
        jTextField2.setBounds(new Rectangle(463, 64, 209, 25));
        jMenuBar1.add(jMenu1);
        jMenuBar1.add(jMenu2);
        jMenuBar1.add(jMenu3);
        jMenuBar1.add(jMenu4);
        jMenuBar1.add(jMenu5);
        this.getContentPane().add(panel);
        panel.add(panel1);
        panel1.add(jLabel1);
        panel1.add(jLabel2);
        panel1.add(jTextField1);
        panel1.add(jLabel3);
        panel1.add(jTextField2);
        panel2.add(new JScrollPane(resultTable),BorderLayout.CENTER);
        panel.add(panel2);

        } catch (Exception exception) {
            exception.printStackTrace();
        }
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    JPanel panel = new JPanel();
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenu1 = new JMenu();
    JMenu jMenu2 = new JMenu();
    JMenu jMenu3 = new JMenu();
    JMenu jMenu4 = new JMenu();
    JMenu jMenu5 = new JMenu();
    JPanel panel1 = new JPanel();
    JPanel panel2=new JPanel();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField2 = new JTextField();

    String RL = "jdbc:microsoft:sqlserver://localhost;DatabaseName=pos_mis";
    String user ="sa";
    String password = "220300124";
    String sqlStr = "select 商品表.商品名称,单位,缺货表.数量 from 商品表,缺货表 where 商品表.商品编码=缺货表.商品编码";
    String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private void jbInit() throws Exception {
    }

}