import java.sql.*;
public class ODBC_Connection {
private Connection conn = null;
private final String url = "jdbc:odbc:wangba";
private final String username = "sa";
private final String password = "123456";
private Connection getConnection( ) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url, username, password);
if (conn != null)
System.out.println("【信息】连接数据库成功！");
} catch (Exception e) {
System.out.println("【错误】连接数据库失败：" + e.getMessage( ));
e.printStackTrace( );
}
return conn;
}
private void closeConnection( ) {
try {
if (conn != null)
conn.close( );
conn = null;
System.out.println("【信息】数据库连接关闭成功！");
} catch (Exception e) {
System.out.println("【错误】数据库连接关闭失败：" + e.getMessage( ));
e.printStackTrace( );
}
}
public void displayDbProperties( ) {
try {
conn = this.getConnection( );
if (conn != null) {
DatabaseMetaData dm = conn.getMetaData();
System.out.println("驱动程序信息：");
System.out.println("\t名称： " + dm.getDriverName( ));
System.out.println("\t版本： " + dm.getDriverVersion( ));
System.out.println("数据库信息：");
System.out.println("\t名称：" + dm.getDatabaseProductName( ));
System.out.println("\t版本： " + dm.getDatabaseProductVersion( ));
System.out.println("可用编目：");
ResultSet rs=dm.getCatalogs( );
while(rs.next( )) {
System.out.println("\t"+rs.getString(1));
}
rs.close( );
rs=null;
dm=null;
closeConnection( );
} else
System.out.println("【错误】连接数据库失败！");
} catch (Exception e) {
e.printStackTrace( );
}
}
public static void main(String[ ] args) {
new ODBC_Connection( ).displayDbProperties( );
}
}
