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

master 口 master D系纟烁 o 口用户喪 Y 口视图 D CHECK_CONSTRAINTS Pl COLUMN.DOMAIN.USAGE D COLUMN_PRIVILEGES □ COLUMNS Pl CONSTRAINT_COLUMN_USAGE 「dT卍HIT T-BLE USAGE package databasevisit; mport java.awt.BorderLayout; mport java.awt.eve nt. Item Eve nt; mport java.awt.event.Item Liste ner; mport java.sql.Connection; mport java.sql.DatabaseMetaData; mport java.sql.DriverMa nager; mport java.sql.ResultSet; mport java.sql.Stateme nt; import java.util.Vector; mport javax.swing JComboBox; mport javax.swi ng」F rame; mport javax.swi ng」ScrollPa ne; mport javax.swing JTree; mport javax.swi ng. ScrollPa neCon sta nts; mport javax.swing.tree.DefaultMutableTreeNode; import javax.swing.tree.DefaultTreeModel; public class DatabaseTableStructureViewerBasedOnTreeView { * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub DemoWindow6 dw = new DemoWindow6(基于树状视图的的数据库表结构查看器 H); 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 Databaselnfo(db); JComboBox jcb = n ull; //显示数据库表结构的树状视图 JTree jt = null; //设置树状视图的滚动条 int v = ScrollPaneConstants.VERTICAL SCROLLBAR AS NEEDED; int h = ScrollPaneConstants.HORIZONTAL SCROLLBAR AS NEEDED; JScrollPa ne jsp = n ull; public DemoWindow6(String title) { super(title); //创建显示所有数据库名称的组合框 jcb = new JComboBox(di.getDatabaseNames()); //默认选中第一个数据库，即master jcb.setSelectedlndex(O); //创建显示数据库表结构的树状视图 jt = new JTree(di.getTablesl nfo(db)); //创建树状视图的滚动面板 jsp = new JScrollPane(jt, v, h); //窗体布局 add(jcb, BorderLayout.NORTH); add(jsp); //添加事件监听器 jcb.addltemListe ner(this); } public void itemStateChanged(ltemEvent e) { // TODO Auto-generated method stub 讦(e.getStateChange() == ItemEvent.SELECTED) { //获取所选数据库的名称 Stri