Java 對資料庫表名的解析

package cn.edu.nwsuaf.cie.aisa.wsc.operation;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.DatabaseMetaData;

public class DataBaseTableNameRead {
ConnectionSource dbConnectionSourceImpl = null;

public ResultSet getDataBaseTableNameRead() {
dbConnectionSourceImpl = new DBConnectionSourceImpl();
Connection connection = dbConnectionSourceImpl.getConnection();
ResultSet resultSet = null;
try {
DatabaseMetaData meta = (DatabaseMetaData) connection.getMetaData();
resultSet = meta.getTables(null, null, null,
new String[] { "TABLE" });
while (resultSet.next()) {
System.out.println("表名：" + resultSet.getString(3));
System.out.println("表所屬使用者名稱：" + resultSet.getString(2));
System.out.println("名：" + resultSet.getString(1));
System.out.println("------------------------------");
}
connection.close();
} catch (Exception e) {
try {
connection.close();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
// TODO Auto-generated catch block
e.printStackTrace();
}
return resultSet;
}
}

package cn.edu.nwsuaf.cie.aisa.wsc.operation;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import cn.edu.nwsuaf.cie.aisa.wsc.informationpushmain.InformationPush;

/**
* @author ���ܣ� ���ڣ�2013-7-14 �޸ļ�¼��
*/
public class DBConnectionSourceImpl implements ConnectionSource {
Proopertiess properties  =InformationPush.PROPERTIES;
@Override
public Connection getConnection(){
// TODO Auto-generated method stub
Connection connection = null;
if (InformationPush.PROPERTIES.getDataSource().getDbtype().equals("mysql")) {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String URL = InformationPush.PROPERTIES.getDataSource().getUrl();
String USENAME = InformationPush.PROPERTIES.getDataSource().getUser();
String PASSWORD = InformationPush.PROPERTIES.getDataSource().getPassword();
try {
System.out.println(URL);
connection = (Connection) DriverManager.getConnection(URL,
USENAME, PASSWORD);
return connection;
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println(e.getMessage());
e.printStackTrace();
}

} else if (InformationPush.PROPERTIES.getDataSource().getDbtype().equals("sqlserver")) {

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
String URL = InformationPush.PROPERTIES.getDataSource().getUrl();
String USER = InformationPush.PROPERTIES.getDataSource().getUser();
String PWD = InformationPush.PROPERTIES.getDataSource().getPassword();
try {

connection = DriverManager.getConnection(URL, USER, PWD);
return connection;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

else if (InformationPush.PROPERTIES.getDataSource().getDbtype().equals("oracle")) {

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
String URL = InformationPush.PROPERTIES.getDataSource().getUrl();
String USER = InformationPush.PROPERTIES.getDataSource().getUser();
String PWD = InformationPush.PROPERTIES.getDataSource().getPassword();
try {

connection = DriverManager.getConnection(URL, USER, PWD);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} else if (InformationPush.PROPERTIES.getDataSource().getDbtype().equals("access")) {

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
String URL = InformationPush.PROPERTIES.getDataSource().getUrl();
String USER = InformationPush.PROPERTIES.getDataSource().getUser();
String PWD = InformationPush.PROPERTIES.getDataSource().getPassword();
try {
connection = DriverManager.getConnection(URL, USER, PWD);
return connection;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
return connection;
}
}

package cn.edu.nwsuaf.cie.aisa.wsc.operation;

import java.sql.Connection;

/**
* @author
* ���ڣ�2013-7-14
*/
public interface ConnectionSource {

public Connection getConnection();

}