viewtable2.java

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 ViewTable2 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 ViewTable2() {
        super();
        setSize(600, 420);
        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(0, 1, 605, 422));
        panel.setLayout(null);
        this.setTitle("采购单");
        panel1.setBackground(Color.white);
        panel1.setBounds(new Rectangle( -1, 0, 607, 64));
        panel1.setLayout(null);
        jLabel1.setIcon(image11);
        jLabel1.setBounds(new Rectangle(219, 2, 169, 41));
        panel2.setBackground(Color.white);
        panel2.setBounds(new Rectangle(0, 65, 606, 356));
        panel2.setLayout(borderLayout1);
        this.getContentPane().add(panel);
        panel.add(panel1);
        panel1.add(jLabel1);
        panel.add(panel2);
    }
    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";

}