oosframe.java~52~

JAVA超市管理系统

package project1;
import javax.swing.JFrame;
import java.awt.*;
import javax.swing.JTable;
import java.sql.*;
import java.util.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

class OosFrame extends JFrame {
    ImageIcon image11 = new ImageIcon(project1.MainFrame.class.getResource("image11.png"));
    JLabel label1=new JLabel();
    JLabel label2=new JLabel();
    public OosFrame() {
        super();
        setSize(750, 570);
        setLocation(160,110);
        setTitle("缺货单");
        setResizable(false);
        //setVisible(true);
        try {
            OosTableModel oostableModel = new OosTableModel(driver, RL, sqlStr,
                    user, password);
            JTable resultTable = new JTable(oostableModel);
            resultTable.setRowHeight(25);
            JPanel panel=new JPanel();
            JPanel panel2=new JPanel();
            //JPanel panel3=new JPanel();
            panel.setLayout(new BorderLayout());
            panel.setBackground(Color.white);

        jMenu1.setText("新单");
        jMenu2.setText("插入行");
        jMenu3.setText("删除行");
        jMenu4.setText("导出EXCEL");
        jMenu5.setText("关闭");
        this.setJMenuBar(jMenuBar1);

    label1.setIcon(image11);
    label1.setText("");
    label2.setText("");
    label1.setBounds(new Rectangle(144, 1, 189, 51));
    label2.setBounds(new Rectangle(144, 2, 189, 51));
    label1.setLocation(200,900);
    panel2.setBackground(Color.white);
    panel2.add(label1,BorderLayout.CENTER);
    panel2.add(label2,BorderLayout.SOUTH);
    panel.add(panel2,BorderLayout.NORTH);


            panel.add(new JScrollPane(resultTable),BorderLayout.CENTER);
            Container c = getContentPane();
            c.setBackground(Color.white);
            c.add(panel,BorderLayout.CENTER);
    /*label1.setIcon(image11);
    label1.setText("");
    label1.setBounds(new Rectangle(119, 5, 181, 41));
    JPanel panel = new JPanel();
    panel.setLayout(null);
    panel.setBounds(new Rectangle(13, 49, 435, 318));
    this.getContentPane().add(panel, java.awt.BorderLayout.CENTER);
    panel.add(label1);
    panel.add(resultTable);
    panel.setBackground(Color.white);*/

        } catch (ClassNotFoundException ex) {
            JOptionPane.showMessageDialog(null, "Cloudscape driver not found",
                                          "Driver not found",
                                          JOptionPane.ERROR_MESSAGE);
            System.exit(1);
        } catch (SQLException sqlException) {
            JOptionPane.showMessageDialog(null, sqlException.getMessage(),
                                          "DatabaseError",
                                          JOptionPane.ERROR_MESSAGE);
        }
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        /*try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }*/
    }

    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenu1 = new JMenu();
    JMenu jMenu2 = new JMenu();
    JMenu jMenu3 = new JMenu();
    JMenu jMenu4 = new JMenu();
    JMenu jMenu5 = new JMenu();



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