databasemetadatautil.java#1.1.1.1

来自「数据库远程同步软件NetBeans项目源文件 项目采用Jdesktop集成组件」· 1 代码 · 共 76 行

package com.qixuan.jdbc.util;

import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class DatabaseMetaDataUtil {
	private Connection connection;
	private List tableNames;
	private String DataBaseName;
	public DatabaseMetaDataUtil(Connection connection) {
		super();
		this.connection=connection;
		//init();
	}
	public DatabaseMetaDataUtil(String driverClass,String url,String userName,String password) {
		super();
		this.setConnection(driverClass, url, userName, password);
		//init();
	}
	private void init(){
		try {
			DatabaseMetaData dbmd = connection.getMetaData();			
			ResultSet rs = dbmd.getTables(null,null,null,new String[]{"TABLE"});
			DataBaseName=dbmd.getDatabaseProductName();
			tableNames=new ArrayList<String>();
			while(rs.next()) {
				String tableName = rs.getString(3);	
				tableNames.add(tableName);
				//System.out.println(tableName);
				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public Connection getConnection() {
		return connection;
	}
	public void setConnection(Connection connection) {
		this.connection = connection;
	}
	public List getTableNames() {
		init();
		return tableNames;
	}
	public void setTableNames(List tableNames) {
		this.tableNames = tableNames;
	}
	public void setConnection(String driverClass,String url,String userName,String password) {
		try {
			Class.forName(driverClass);
			connection = DriverManager.getConnection(url,userName,password);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	public String getDataBaseName() {
		return DataBaseName;
	}
	public void setDataBaseName(String dataBaseName) {
		DataBaseName = dataBaseName;
	}
	
}