mysql数据库模式信息提取

最新推荐文章于 2022-09-13 23:58:38 发布

zyming0815

最新推荐文章于 2022-09-13 23:58:38 发布

阅读量1.7k

点赞数

分类专栏： java技术文章标签：数据库 mysql string menu null tree

本文链接：https://blog.csdn.net/zyming0815/article/details/4573349

版权

java技术专栏收录该内容

4 篇文章 0 订阅

订阅专栏

此程序实现将mysql数据库的模式信息展示出来。下面我简要地说明一下。

1.树形结构的实现。

SimplePanel pl=new SimplePanel(); private void buildFrameLayout(){ try{ pane = getContentPane(); //关闭面板 setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); //BorderLayout布局管理器 JPanel panel = new JPanel(); final JScrollPane scrollPane = new JScrollPane(); //panel.setBounds(24, 10, 173, 317); panel.add(scrollPane); //初始化根节点 DefaultMutableTreeNode root=new DefaultMutableTreeNode(connection.getCatalog()); //获得表名 Vector<Object> vector = getTableNames(); DefaultMutableTreeNode menu_accp = null; for(int i = 0; i < vector.size(); i++){ String strName = (String)vector.get(i); //初始化枝节点 menu_accp = new DefaultMutableTreeNode(strName); Vector<Object> vectorColumn = getColumnNames(strName); DefaultMutableTreeNode menu_accp_son = null; //添加枝节点数据 root.add(menu_accp); for(int j = 0; j < vectorColumn.size(); j++){ //初始化叶子节点 menu_accp_son = new DefaultMutableTreeNode((String)vectorColumn.get(j)); //添加叶子节点数据 menu_accp.add(menu_accp_son); } } tree = new JTree(root); TreeSelectionModel model = tree.getSelectionModel(); //一次只能选择一个树节点 model.setSelectionMode(TreeSelectionModel.SINGLE_TREE_SELECTION); //显示树 scrollPane.setViewportView(tree); pane.add(panel,BorderLayout.WEST); //注册点击节点事件 tree.addTreeSelectionListener(new TreeSelectionListener() { public void valueChanged(TreeSelectionEvent e) { DefaultMutableTreeNode node = (DefaultMutableTreeNode) tree .getLastSelectedPathComponent(); // 可选用户对象 Object nodeInfo = node.getUserObject(); if (node.getLevel()==0) { //根节点不处理 } else if (node.getLevel()==1){ //枝节点 pl.getPanel(connection, nodeInfo.toString(),node.getParent().toString(),node.getLevel()); } else { //叶子节点 pl.getPanel(connection, nodeInfo.toString(),node.getParent().toString(),node.getLevel()); } } }); pane.add(pl,BorderLayout.CENTER); }catch(Exception e){e.printStackTrace();} }

2.信息展示的实现。

public ColumnModel(Connection connection, String selectTable) throws SQLException { Statement stmt = connection.createStatement(); // 执行数据查找 ResultSet rset = stmt.executeQuery("SELECT * FROM " + selectTable); // 结果集元数据 ResultSetMetaData rsmd = rset.getMetaData(); // 列长 int count = rsmd.getColumnCount(); String[] tableHeads = { "属性ID", "属性名" }; // 将表格头转换过向量类型,以备表格模型使用 columnHeaders = new Vector<Object>(); for (int i = 0; i < tableHeads.length; i++) { columnHeaders.add(tableHeads[i]); } tableData = new Vector<Object>(count); for (int i = 1; i <= count; i++) { Vector<Object> rowData = new Vector<Object>(count); rowData.add(i); rowData.add(rsmd.getColumnName(i)); tableData.addElement(rowData); } } public ColumnModel(Connection connection, String selectNode, String parentNode) throws SQLException { Statement stmt = connection.createStatement(); // 执行数据查找 ResultSet rset = stmt.executeQuery("SELECT * FROM " + parentNode); // 结果集元数据 ResultSetMetaData rsmd = rset.getMetaData(); // 列长 int count = rsmd.getColumnCount(); String[] tableHeads = { "属性ID", "数据类型", "(最大)长度", "小数位" }; // 将表格头转换过向量类型,以备表格模型使用 columnHeaders = new Vector<Object>(); for (int i = 0; i < tableHeads.length; i++) { columnHeaders.add(tableHeads[i]); } tableData = new Vector<Object>(count); int strInt = 0; for (int i = 1; i <= count; i++) { if (rsmd.getColumnName(i).equals(selectNode)) { strInt = i; break; } } Vector<Object> rowData = new Vector<Object>(count); rowData.add(strInt); rowData.add(rsmd.getColumnTypeName(strInt)); rowData.add(rsmd.getColumnDisplaySize(strInt)); rowData.add(rsmd.getPrecision(strInt)); tableData.addElement(rowData); } //======================================================= public RowModel(Connection connection, String selectTable) throws SQLException { // 执行数据查找 DatabaseMetaData dbMetaData = connection.getMetaData(); // 结果集元数据 // ResultSetMetaData rsmd = rset.getMetaData(); // 获取表的主外键的描述 ResultSet tablePrimaryKeyInfo = dbMetaData.getPrimaryKeys(null, null, selectTable); // 列长 int count = 3; String[] tableHeads = { "键名", "键属性(组)", "键类型" }; // 将表格头转换过向量类型,以备表格模型使用 columnHeaders = new Vector<Object>(); for (int i = 0; i < tableHeads.length; i++) { columnHeaders.add(tableHeads[i]); } String strTest = "("; String strTest1 = ""; while (tablePrimaryKeyInfo.next()) { strTest += tablePrimaryKeyInfo.getString("COLUMN_NAME") + " "; strTest1 = tablePrimaryKeyInfo.getString("PK_NAME"); } strTest = strTest.trim().replace(' ', ',') + ")"; tableData = new Vector<Object>(count); Vector<Object> rowData = new Vector<Object>(count); rowData.add("PK_INTER"); rowData.add(strTest); rowData.add(strTest1); tableData.addElement(rowData); } public RowModel(Connection connection, String selectNode, String parentNode) throws SQLException { Statement stmt = connection.createStatement(); // 执行数据查找 ResultSet rset = stmt.executeQuery("SELECT * FROM " + parentNode); // 结果集元数据 ResultSetMetaData rsmd = rset.getMetaData(); DatabaseMetaData dbMetaData = connection.getMetaData(); ResultSet columnInfo = dbMetaData.getColumns(null, null, parentNode, selectNode); // 列长 int count = rsmd.getColumnCount(); String[] tableHeads = { "属性ID", "DEFAULT", "NOT NULL" }; // 将表格头转换过向量类型,以备表格模型使用 columnHeaders = new Vector<Object>(); for (int i = 0; i < tableHeads.length; i++) { columnHeaders.add(tableHeads[i]); } tableData = new Vector<Object>(count); int strInt = 0; for (int i = 1; i <= count; i++) { if (rsmd.getColumnName(i).equals(selectNode)) { strInt = i; break; } } while (columnInfo.next()) { Vector<Object> rowData = new Vector<Object>(count); rowData.add(strInt); rowData.add(columnInfo.getString("COLUMN_DEF")); rowData.add(columnInfo.getString("IS_NULLABLE")); tableData.addElement(rowData); } } //======================================================= public ComponentModel(Connection connection, String selectTable) throws SQLException { // 执行数据查找 DatabaseMetaData dbMetaData = connection.getMetaData(); ResultSet tableForeignKeyInfo = dbMetaData.getImportedKeys(null, null, selectTable); String[] tableHeads = { "外键", "外键属性", "引用的关系", "引用的属性", "更新规则", "删除规则" }; // 将表格头转换过向量类型,以备表格模型使用 columnHeaders = new Vector<Object>(); for (int i = 0; i < tableHeads.length; i++) { columnHeaders.add(tableHeads[i]); } // 列长 int count = columnHeaders.size(); tableData = new Vector<Object>(count); while (tableForeignKeyInfo.next()) { Vector<Object> rowData = new Vector<Object>(count); rowData.add("FK_ENTER"); rowData.add(tableForeignKeyInfo.getString("FKCOLUMN_NAME")); rowData.add(tableForeignKeyInfo.getString("PKTABLE_NAME")); rowData.add(tableForeignKeyInfo.getString("PKCOLUMN_NAME")); short sht = Short.parseShort(tableForeignKeyInfo .getString("UPDATE_RULE")); String strTest = ""; switch (sht) { // 如果已经被导入，则不允许更新主键 case 3: strTest = "importedNoAction"; break; // 将导入的键更改为与主键更新一致 case 0: strTest = "importedKeyCascade"; break; // 如果已更新导入键的主键，则将导入键更改为 NULL case 2: strTest = "importedKeySetNull"; break; // 如果已更新导入键的主键，则将导入键更改为默认值 case 4: strTest = "importedKeySetDefault"; break; // 与 importedKeyNoAction 相同（为了与 ODBC 2.x 兼容） case 1: strTest = "importedKeyRestrict"; break; default: break; } rowData.add(strTest); short sht1 = Short.parseShort(tableForeignKeyInfo .getString("DELETE_RULE")); String strTest1 = ""; switch (sht1) { case 3: strTest1 = "importedKeyNoAction"; break; case 0: strTest1 = "importedKeyCascade"; break; case 2: strTest1 = "importedKeySetNull"; break; case 4: strTest1 = "importedKeyRestrict"; break; case 1: strTest1 = "importedKeySetDefault"; break; default: break; } rowData.add(strTest1); tableData.addElement(rowData); } } public ComponentModel(Connection connection, String selectNode, String parentNode) throws SQLException { Statement stmt = connection.createStatement(); // 执行数据查找 ResultSet rset = stmt.executeQuery("SELECT * FROM " + parentNode); // 结果集元数据 ResultSetMetaData rsmd = rset.getMetaData(); // 列长 int count = rsmd.getColumnCount(); String[] tableHeads = { "属性ID", "是否只读", "是否只写" }; // 将表格头转换过向量类型,以备表格模型使用 columnHeaders = new Vector<Object>(); for (int i = 0; i < tableHeads.length; i++) { columnHeaders.add(tableHeads[i]); } tableData = new Vector<Object>(count); int strInt = 0; for (int i = 1; i <= count; i++) { if (rsmd.getColumnName(i).equals(selectNode)) { strInt = i; break; } } Vector<Object> rowData = new Vector<Object>(count); rowData.add(strInt); rowData.add(rsmd.isReadOnly(strInt)); rowData.add(rsmd.isWritable(strInt)); tableData.addElement(rowData); }

最终的实现效果如下：