import javax

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

import java.util.*;

import javax.swing.table.*;

import javax.swing.event.TreeSelectionEvent;

import javax.swing.event.TreeSelectionListener;

import javax.swing.tree.*;

public class theThirdWork extends JFrame{

JSplitPane pane;

JTree tree;

JSlider slider;

Vector vect = new Vector();

String title[] = { \"流水号\", \"人员姓名\", \"上次考核\", \"本次考核\",\"变更次数\",\"变更日期\" };

AbstractTableModel tm = new AbstractTableModel() {

public int getColumnCount() {

return title.length;

}

public int getRowCount() {

return vect.size();

}

public Object getValueAt(int row, int column) {

if (!vect.isEmpty())

return ((Vector) vect.get(row)).get(column);

else

return null;

}

public String getColumnName(int column) {

return title[column];

}

public void setValueAt(Object value, int row, int column) {

}

public boolean isCellEditable(int row, int column) {

return false;

}

};

JTable jt = new JTable(tm);

public theThirdWork()throws SQLException, ClassNotFoundException{

pane=new JSplitPane();

setTitle(\"人事管理系统\");

String s[]={\"人员考核\",\"考核历史查询\"};

final Hashtable hashtable1=new Hashtable();

final Hashtable hashtable2=new Hashtable();

hashtable1.put(\"人事管理系统\",hashtable2);

hashtable2.put(\"基本信息系统\",\"\");

hashtable2.put(\"人员调动管理\",\"\");

hashtable2.put(\"人员考核管理\",s);

hashtable2.put(\"劳资管理\",\"\");

tree=new JTree(hashtable1);

JScrollPane sp=new JScrollPane();

sp.setViewportView(tree);

pane.setLeftComponent(sp);

tree.addTreeSelectionListener(new TreeSelectionListener() {

public void valueChanged(TreeSelectionEvent evt) {

jTreeValueChanged(evt);

}

});

//pane.setRightComponent(jt);

Connection c = connect();

Statement s1 = c.createStatement();

String sql = \"select * from 表1\";

ResultSet r = s1.executeQuery(sql);

showResult(r);

getContentPane().add(pane);

setSize(600,400);

setVisible(true);

setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

}

public Connection connect() throws SQLException, ClassNotFoundException {

String dburl = \"jdbc:odbc:driver={Microsoft Access Driver

(*.mdb)};DBQ=C:/work.mdb\";

String user = \"\";

String password = \"\";

Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\");

Connection c = DriverManager.getConnection(dburl, user, password);

return c;

}

public void showResult(ResultSet rs) throws SQLException {

vect.removeAllElements();

tm.fireTableStructureChanged();

while (rs.next()) {

Vector rec_vector = new Vector();

rec_vector.addElement(rs.getString(1));

rec_vector.addElement(rs.getString(2));

rec_vector.addElement(rs.getString(3));

rec_vector.addElement(rs.getString(4));

rec_vector.addElement(rs.getString(5));

rec_vector.addElement(rs.getDate(6));

vect.addElement(rec_vector);

}

tm.fireTableStructureChanged();

}

private void jTreeValueChanged(javax.swing.event.TreeSelectionEvent evt) {

DefaultMutableTreeNode selectedNode=(DefaultMutableTreeNode)

tree.getLastSelectedPathComponent();

if(selectedNode.toString().equals(\"考核历史查询\")){

pane.setRightComponent(jt);

}

}

public static void main(String[] args) throws SQLException,

ClassNotFoundException {

theThirdWork fm = new theThirdWork();