mysql数据库模式信息提取
此程序实现将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());
相关文档：
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySQLDriverCS;
&nb ......
Mysql数据库提供两种类型的索引，如果没正确设置，索引的利用效率会大打折扣却完全不知问题出在这。
CREATE TABLE test (
id INT NOT NULL,
last_name CHAR(30) NOT NULL,
first_name CHAR(30) NOT NULL,
PRIMARY KEY (id),
INDEX name (last_name,first_name)
);
以上� ......
......
mysql 起动错误解决办法- -
Access denied for user ''@'localhost' to d ......
