oos.java~7~

来自「JAVA超市管理系统」· JAVA~7~ 代码 · 共 52 行

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 {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        try
        {
            OosTableModel Oos_tableModel=new OosTableModel(driver,RL,sqlStr,user,password);
            JTable Oos_Table = new JTable(Oos_tableModel);
            Container c=getContentPane();
            c.add(new JScrollPane(Oos_Table));
        }
        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);
        }
    }

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