outputframe.java

学生成绩查询系统

package 学生成绩;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.Vector;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.BoxLayout;
import javax.swing.JButton;
import javax.swing.table.DefaultTableModel;
import 学生成绩.Main;

public class OutputFrame extends JPanel{
	 DataBaseManager db=new DataBaseManager();
	  Vector vectques = new Vector();
	  Vector title = new Vector();
	  DefaultTableModel model;  //  @jve:decl-index=0:visual-constraint="16,19"
	
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	private JButton jButton = null;
    
	
	public OutputFrame() {

	    
		try {
			initialize();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}

	}

	/**
	 * This method initializes this
	 * @throws SQLException 
	 * 
	 */
	private void initialize() throws SQLException {
	    title.addElement("学号");
	    title.addElement("姓名");
	    title.addElement("数学");
	    title.addElement("英语");
	    title.addElement("语文");
	    read();
	    model = new DefaultTableModel(vectques, title);
	    jTable = new JTable(model);
	    jTable.setEnabled(false);
	    jTable.setVisible(true);
        jTable.setPreferredScrollableViewportSize(new Dimension(527,250));
		
		
		this.setLayout(null);
        this.setSize(new java.awt.Dimension(527,317));
        this.add(getJScrollPane(), null);
        this.add(getJButton(), null);
        

	}

	
	  public void read() throws SQLException {
			String strSQL;
			strSQL="select * from result";
			db.res=db.getResult(strSQL);

		          while (db.res.next()) {
		            Vector temp = new Vector();
		            temp.addElement(db.res.getString(1) );
		            temp.addElement(db.res.getString(2));
		            temp.addElement(db.res.getString(3));
		            temp.addElement(db.res.getString(4));
		            temp.addElement(db.res.getString(5));
		            vectques.addElement(temp);


		      }
		    }

	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 * @throws SQLException 
	 */
	  
	  private JScrollPane getJScrollPane() throws SQLException {
		  if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setLocation(new java.awt.Point(4,4));
			jScrollPane.setViewportView(jTable);
			jScrollPane.setSize(new java.awt.Dimension(527,250));
		}
		
		return jScrollPane;
	}


	void close()
	{
		this.close();
	}
	
	private JButton getJButton() {
		if (jButton == null) {
			jButton = new JButton();
			jButton.setLocation(new java.awt.Point(208,266));
			jButton.setText("返回");
			jButton.setSize(new java.awt.Dimension(120,35));
			jButton.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					
					close();
										
				}
			});
		}
		return jButton;
	}
	
	
}  //  @jve:decl-index=0:visual-constraint="128,19"