JTabel数据显示事例

 
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
 
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.JTableHeader;
 
@SuppressWarnings("serial")
public class JTable数据绑定示例 extends JFrame {
    private JScrollPane scpDemo;
    @SuppressWarnings("unused")
	private JTableHeader jth;
    private JTable tabDemo;
    private JButton btnShow;
 
    public JTable数据绑定示例() {
        super("JTable数据绑定示例");
        this.setSize(1000, 500);
        this.setLayout(null);
        this.setLocation(0, 50);

        this.scpDemo = new JScrollPane(tabDemo,
                JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,		//设置垂直滚动条在需要的时候显示
                JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
        this.scpDemo.setBounds(10, 50, 800, 270);
        this.btnShow = new JButton("显示数据");
        this.btnShow.setBounds(10, 10, 300, 30);
 
        this.btnShow.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent ae) {
                btnShow_ActionPerformed(ae);
            }
        });
        add(this.scpDemo);
        add(this.btnShow);
        this.setVisible(true);
    }
 
    public void btnShow_ActionPerformed(ActionEvent ae) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection(
                    "jdbc:mysql://127.0.0.1:3306/db1", "root", "116533");
 
            Statement pstm = conn.createStatement();
            String sql1 = "select count(*) from tb_Result where Dattime >= '2014-06-09' and Dattime <= '2014-06-09' and Resultname = '哈'"; 
            String sql2 = "select * from tb_Result where Dattime >= '2014-06-09' and Dattime <= '2014-06-09' and Resultname = '哈'";
             
            ResultSet rs1 = pstm.executeQuery(sql1);
            int count = 0;
            //得到总记录数
            if (rs1.next()) {
                count=rs1.getInt(1);
            }
            //关闭第一个结果集
            rs1.close();
             
            Object[][] info = new Object[count][16];
            count = 0;
            //查询
            ResultSet rs2 = pstm.executeQuery(sql2);
            while (rs2.next()) {
                info[count][0] = rs2.getString("Resultform");
                info[count][1] = rs2.getString("Resultname");
                info[count][2] = rs2.getString("Resultword");
                info[count][3] = rs2.getString("Resultnum");
                info[count][4] = rs2.getString("Subject");
                info[count][5] = rs2.getString("Resulttype");
                info[count][6] = rs2.getString("Resultlan");
                info[count][7] = rs2.getString("Dattime");
                info[count][8] = rs2.getString("Workname");
                info[count][9] = rs2.getString("Test");
                info[count][10] = rs2.getString("Demo");
                info[count][11] = rs2.getString("Result");
                info[count][12] = rs2.getString("Province");
                info[count][13] = rs2.getString("Keyid");
                info[count][14] = rs2.getString("Text");
                info[count][15] = rs2.getString("Booker");
               
                count++;
            }
             
            /*for(Object []o:info){
                System.out.println(o[0]);
                System.out.println(o[1]);
                System.out.println(o[2]);
            }*/
             
             
            String[] title = {"Resultform","Resultname","Resultword","Resultnum","Subject","Resulttype","Resultlan","Dattime","Workname","Test","Demo","Result","Province","Keyid","Text","Booker"};
            // 创建JTable
            this.tabDemo = new JTable(info, title);
            // 显示表头
            this.jth = this.tabDemo.getTableHeader();
            // 将JTable加入到带滚动条的面板中
            this.scpDemo.getViewport().add(tabDemo);
        } catch (Exception sqle) {
            JOptionPane.showMessageDialog(null, "错误:"+sqle.getMessage(), "错误",
                    JOptionPane.ERROR_MESSAGE);
        }
    }
 
    public static void main(String[] args) {
        new JTable数据绑定示例();
    }
 
}

JTable排序 点击打开链接