oos.java~9~

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 {

    public OosFrame() {
        super();
        setSize(600, 350);
        setVisible(true);
        try {
            OosTableModel oostableModel = new OosTableModel(driver, RL, sqlStr,
                    user, password);
            JTable resultTable = new JTable(oostableModel);
            resultTable.setRowHeight(20);
            Container c = getContentPane();
            c.add(new JScrollPane(resultTable));
        } 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();
        }
    }
    void jbInit() throws Exception
        {
        }

    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";
}