j_studentmessagetable.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.ImageIcon;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.ListSelectionModel;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.TableModel;
import java.awt.Dimension;

public class J_studentmessagetable extends JPanel {

	private static final long serialVersionUID = 1L;
	
	Connection connection;  //  @jve:decl-index=0
	
	Statement statement;  //  @jve:decl-index=0:
	
	ResultSet resultSet;
	
	public Vector  columnNames=new Vector();  //  @jve:decl-index=0:存放列名
	
	public  Vector rowscount=new Vector();  //  @jve:decl-index=0:存放记录	
	
	ResultSetMetaData metaData;		
	
	TableModel atm = new  AbstractTableModel()
	{
		private static final long serialVersionUID = -3455439221846800419L;  
		
		public int getColumnCount() {	return columnNames.size();}    
		
		public int getRowCount() {return rowscount.size();}	
		
		public String getColumnName(int i){	return columnNames.get(i).toString();}
		
		public Object getValueAt(int i, int j)
		{
			if(!rowscount.isEmpty())
			return ((Vector)rowscount.elementAt(i)).elementAt(j);
			else return null;
		}			
	};
	private  Vector  clickvector=new Vector();  //  @jve:decl-index=0:
	
	private JScrollPane jScrollPane = null;
	
	private JTable jTable=new JTable();  //  @jve:decl-index=0:visual-constraint="428,10"

	public J_studentmessagetable() {
		super();
		try 
		{
			initialize();
		} 
		catch (SQLException e)
		{
		}
	}
	private void initialize() throws SQLException {
		this.setSize(465, 367);
		this.setLayout(null);	
		this.add(getJScrollPane(), null);	
	
		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) 
			{ 			
			columnNames.add(metaData.getColumnName(b++));
			} 											
			Vector newRow; 
			while(resultSet.next()) 
			{ 
			   newRow=new Vector(); 
			   int c=1; 
			   while(c<=numberOfCol) 
			   { 
			      newRow.addElement(resultSet.getString(c++)); 
			   } 
			   rowscount.add(newRow);
			}			
			
			 jTable.setRowSelectionAllowed(true);
			 jTable.setSize(new Dimension(430, 345));
			 jTable.setColumnSelectionAllowed(true);
			 jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
		
			
			 mb_mouseclick();	
			 jTable.setModel(atm);
			 jScrollPane.setViewportView(jTable);
			 this.add(jScrollPane);

		}
		catch (ClassNotFoundException e) 
		{
			e.printStackTrace();
		}
		ImageIcon ic=new ImageIcon("shui.jpg");
		JLabel jbl=new JLabel();
		jbl.setIcon(ic);
		jbl.setBounds(new Rectangle(3, 4, 464, 365));
		this.setOpaque(false);
		this.add(jbl, null);
	}
	private void mb_mouseclick() 
	{
		jTable.addMouseListener(new java.awt.event.MouseAdapter()
		{
		 	public void mouseClicked(java.awt.event.MouseEvent e) 
		 	{
		 		try {
		 			if(e.getClickCount()==2)
			 		{
			 			int num=jTable.getSelectedRow();
			 			clickvector=(Vector) rowscount.get(num);
			            J_StudentMessage.mb_clicktable(clickvector);		 					 			
			 		}
				} catch (Exception e1) {	}
		 	
		 	}
		 });
	}
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(4, 2, 455, 273));
		}
		return jScrollPane;
	}

}