viewtable4.java~7~

JAVA超市管理系统

package project1;
import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.table.*;
import java.awt.event.*;
import javax.swing.*;
public class ViewTable4 extends JFrame
{
    ImageIcon image11 = new ImageIcon(project1.MainFrame.class.getResource("image12_.png"));
    JPanel panel = new JPanel();
    JPanel panel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JPanel panel2 = new JPanel();
    BorderLayout borderLayout1 = new BorderLayout();
    public ViewTable4() {
            super();
            setSize(650, 450);
            setLocation(220,180);
            setResizable(false);

        try {

            OosTableModel oostableModel = new OosTableModel(driver, RL, sqlStr,
                    user, password);
            JTable resultTable = new JTable(oostableModel);
            resultTable.setRowHeight(25);
            jbInit();
            panel2.add(new JScrollPane(resultTable),BorderLayout.CENTER);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        panel.setBackground(Color.white);
        panel.setBounds(new Rectangle( -1, 0, 641, 422));
        panel.setLayout(null);
        panel1.setBackground(Color.white);
        panel1.setBounds(new Rectangle(1, 1, 634, 67));
        panel1.setLayout(null);
        jLabel1.setIcon(image11);
        jLabel1.setText("jLabel1");
        jLabel1.setBounds(new Rectangle(219, 6, 180, 32));
        panel2.setBackground(Color.white);
        panel2.setBounds(new Rectangle(3, 70, 638, 350));
        panel2.setLayout(borderLayout1);
        this.getContentPane().add(panel);
        panel.add(panel1);
        panel.add(panel2);
        panel1.add(jLabel1);
    }
    String RL = "jdbc:microsoft:sqlserver://localhost;DatabaseName=pos_mis";
    String user ="sa";
    String password = "220300124";
    String sqlStr = "select * from 供应商商品信息";
    String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";

}