j_studenttable.java

简单的学生管理系统系统

import java.awt.Rectangle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

public class J_studentTable extends JFrame {

	private static final long serialVersionUID = 1L;

	private JPanel jContentPane = null;

	private JScrollPane jScrollPane = null;

	private JTable jTable = null;
    
	Connection connection;  //  @jve:decl-index=0:
	
	Statement statement;  //  @jve:decl-index=0:
	
	ResultSet resultSet;
	
	Vector  columnNames=new Vector();  //  @jve:decl-index=0:
	
	Vector rows=new Vector();  //  @jve:decl-index=0:
	
	ResultSetMetaData metaData;
	
	DefaultTableModel dt=new DefaultTableModel();

	/**
	 * This is the default constructor
	 */
	public J_studentTable() {
		super();
		try 
		{
			initialize();
		} catch (SQLException e)
		{
		}
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 * @throws SQLException 
	 * @throws ClassNotFoundException 
	 */
	private void initialize() throws SQLException 
	{
		this.setSize(300, 200);
		this.setContentPane(getJContentPane());
		this.setTitle("人员查询结果");

		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");			
			connection=DriverManager.getConnection("jdbc:odbc:studentSqlDatabase","sa","");			
			statement=connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
	    			ResultSet.CONCUR_UPDATABLE);
			resultSet=statement.executeQuery("select * from "+J_Denglu.m_strbanji);								
			metaData=resultSet.getMetaData();			
			int numberOfCol=metaData.getColumnCount();			
			int b=1; 
			while(b<=numberOfCol) 
			{ 
			dt.addColumn(metaData.getColumnName(b++)); 
			} 			
			columnNames=new Vector();			
			Vector newRow; 
			while(resultSet.next()) 
			{ 
			   newRow=new Vector(); 
			   int c=1; 
			   while(c<=numberOfCol) 
			   { 
			      newRow.addElement(resultSet.getString(c++)); 
			   } 
			   dt.addRow(newRow); 
			}
		 jTable.setModel(dt); 
		}
		catch (ClassNotFoundException e) 
		{
			e.printStackTrace();
		}
	}
	/**
	 * This method initializes jContentPane
	 * 
	 * @return javax.swing.JPanel
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(null);
			jContentPane.add(getJScrollPane(), null);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(3, 3, 288, 94));
			jScrollPane.setViewportView(getJTable());
		}
		return jScrollPane;
	}

	/**
	 * This method initializes jTable	
	 * 	
	 * @return javax.swing.JTable	
	 */
	private JTable getJTable() {
		if (jTable == null) {
			jTable = new JTable();
		jTable.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseClicked(java.awt.event.MouseEvent e) {
/*					int mousecount=e.getClickCount();
					if(mousecount==2)
					{
						
					}*/
				}
			});
		}
		return jTable;
	}

}