showsturesult.java~9~

来自「自己写的学生选课系统,多多关照.以后共同学习」· JAVA~9~ 代码 · 共 79 行

package student;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import java.util.Vector;
import java.sql.ResultSet;
import java.sql.*;
import javax.swing.JOptionPane;

public class ShowStuResult extends JFrame {
    DefaultTableModel model = new DefaultTableModel();
    Vector tempVector = new Vector(1, 1);
    JLabel jLabel1 = new JLabel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable(model);

    public ShowStuResult() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        setTitle("显示结果");
        setSize(430,400);
        setLocation(400,400);
        setVisible(true);
        getContentPane().setLayout(null);
        jLabel1.setText("下面为你要查询的结果：");
        jLabel1.setBounds(new Rectangle(18, 19, 137, 25));
        jScrollPane1.setToolTipText("");
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(jTable1);
        jScrollPane1.setBounds(new Rectangle(11, 56, 409, 237));

        model.addColumn("学号");
       model.addColumn("姓名");
       model.addColumn("密码");
       model.addColumn("性别");
       model.addColumn("年龄");
       model.addColumn("专业");
        model.addRow(tempVector);


    }

//把传入的结果集放在这里显示
    public void resultShow(ResultSet rs) {
        try {
            while (rs.next()) {

                tempVector = new Vector(1, 1);
                tempVector.add(rs.getString("Sno"));
                tempVector.add(rs.getString("Sname"));
                tempVector.add(rs.getString("Spsw"));
                tempVector.add(rs.getString("Ssex"));
                tempVector.add(rs.getString("Sage"));
                tempVector.add(rs.getString("Sdept"));
                model.addRow(tempVector);

            }
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(this, "显示失败！");
        }

    }


}