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

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);/ 获取数据库表结构信息类class DatabaseInfo / 数据库连接Connection con;public DatabaseInfo(String databaseName) / 打开数据库连接init(databaseName);public void init(String databaseName) try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver);con = DriverManager.getConnection(jdbc:sqlserver:/localhost:1433;DatabaseName=+ databaseName, sa, jocean); catch (Exception e) / TODO Auto-generated catch blocke.printStackTrace();public Vector getDatabaseNames() Vector allDatabases = new Vector();try / 创建数据库命令Statement stm = con.createStatement();/ 获取所有数据库的名称ResultSet rs = stm.executeQuery(SELECT name FROM sys.databases);while (rs.next() allDatabases.add(rs.getString(name); catch (Exception e) System.out.println(e.getMessage();return allDatabases;/ 返回含有数据库表结构信息的嵌套树状视图节点public DefaultMutableTreeNode getTablesInfo(String databaseName) DefaultMutableTreeNode dmtn = new DefaultMutableTreeNode(databaseName);try / 获取数据库元数据信息DatabaseMetaData dmd = con.getMetaData();/ 获取关系表信息的结果集ResultSet res = dmd.getTables(null, null, null, null);/ 创建树状视图三个节点，分别包含数据库的三种结构信息，即系统表、用户表和视图DefaultMutableTreeNode systemTableNode = new DefaultMutableTreeNode(系统表);DefaultMutableTreeNode tableNode = new DefaultMutableTreeNode(用户表);DefaultMutableTreeNode ViewNode = new DefaultMutableTreeNode(视图);while (res.next() String objectName = res.getString(TABLE_NAME);/ 得到表类型String objectType = res.getString(TABLE_TYPE);/ 如果是系统表if (objectType.equals(SYSTEM TABLE) / 在系统表树状视图节点下添加对应的新节点DefaultMutableTreeNode subdm = new DefaultMutableTreeNode(objectName);systemTableNode.add(subdm);/ 继续添加该表的结构信息appendNode(dmd, subdm, objectName);/ 如果是用户表 else if (objectType.equals(TABLE) DefaultMutableTreeNode subdm = new DefaultMutableTreeNode(objectName);tableNode.add(subdm);appendNode(dmd, subdm, objectName);/ 如果是视图else if (objectType.equals(VIEW) DefaultMutableTreeNode subdm = new DefaultMutableTreeNode(objectName);ViewNode.add(subdm);appendNode(dmd, subdm, objectName);/ 在树状视图的根节点中添加系统表，用户表和视图3个节点dmtn.add(systemTableNode);dmtn.add(tableNode);dmtn.add(ViewNode); catch (Exception e) System.out.println(e.getMessage();return dmtn;/ 添加关系表结构信息的函数private void appendNode(Da