基于树状视图的数据库表结构查看器.docxVIP

package databasevisit;import java.awt.BorderLayout;import java.awt.event.ItemEvent;import java.awt.event.ItemListener;import java.sql.Connection;import java.sql.DatabaseMetaData;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import java.util.Vector;import javax.swing.JComboBox;import javax.swing.JFrame;import javax.swing.JScrollPane;import javax.swing.JTree;import javax.swing.ScrollPaneConstants;import javax.swing.tree.DefaultMutableTreeNode;import javax.swing.tree.DefaultTreeModel;public class DatabaseTableStructureViewerBasedOnTreeView {/** * @param args */public static void main(String[] args) {// TODO Auto-generated method stubDemoWindow6 dw = new DemoWindow6(基于树状视图的的数据库表结构查看器);dw.setBounds(dw.getToolkit().getScreenSize().width / 3, dw.getToolkit().getScreenSize().height / 3,dw.getToolkit().getScreenSize().width / 3, dw.getToolkit().getScreenSize().height / 3);dw.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);dw.setVisible(true);}}class DemoWindow6 extends JFrame implements ItemListener {String db = master;// 获取数据库结构信息DatabaseInfo di = new DatabaseInfo(db);JComboBox jcb = null;// 显示数据库表结构的树状视图JTree jt = null;// 设置树状视图的滚动条int v = ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;int h = ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;JScrollPane jsp = null;public DemoWindow6(String title) {super(title);// 创建显示所有数据库名称的组合框jcb = new JComboBox(di.getDatabaseNames());// 默认选中第一个数据库，即masterjcb.setSelectedIndex(0);// 创建显示数据库表结构的树状视图jt = new JTree(di.getTablesInfo(db));// 创建树状视图的滚动面板jsp = new JScrollPane(jt, v, h);// 窗体布局add(jcb, BorderLayout.NORTH);add(jsp);// 添加事件监听器jcb.addItemListener(this);}public void itemStateChanged(ItemEvent e) {// TODO Auto-generated method stubif (e.getStateChange() == ItemEvent.SELECTED) {// 获取所选数据库的名称String selectdb = (String) jcb.getSelectedItem();// 打开数据库连接di.init(selectdb);// 设置树状视图显示新选数据库的表结构信息jt.setModel(new DefaultTreeModel(di.getTablesInfo(selectdb)));// 更新滚动面板jsp.setViewportView(jt);}}}// 获取数据库表结构信息