Derby 连接

import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.SQLWarning; public class DerbyConnect { private static final String driver = "org.apache.derby.jdbc.EmbeddedDriver"; private static final String url = "jdbc:derby:test;create=true"; static void printSQLException(SQLException se){ while(se != null){ System.out.print("SQLException:State:" + se.getSQLState());//获取此 SQLException 对象的 SQLState。 System.out.print("Severity:" + se.getErrorCode());//Severity:严重的 errorcode:供应商错误代码 System.out.println(se.getMessage()); se = se.getNextException();//通过 setNextException(SQLException ex) 获取链接到此 SQLException 对象的异常。 } } static void printSQLWarning(SQLWarning sw){ while(sw != null){ System.out.print("SQLWarning:State: " + sw.getSQLState()); System.out.print(";Severity:" + sw.getErrorCode()); System.out.println(sw.getMessage()); sw = sw.getNextWarning(); } } public static void main(String[] args){ Connection con = null; DatabaseMetaData dbmd = null; try{ Class.forName(driver); con = DriverManager.getConnection(url); SQLWarning swarn = con.getWarnings(); if(swarn != null){ printSQLWarning(swarn); } dbmd = con.getMetaData(); System.out.println("\n----------------------------------------------------"); System.out.println("数据库产品名称：" + dbmd.getDatabaseProductName()); System.out.println("数据库版本:：" + dbmd.getDatabaseProductVersion()); System.out.println("驱动程序的名称：" + dbmd.getDriverName()); System.out.println("驱动程序的版本：：" + dbmd.getDriverVersion()); System.out.println("数据库的地址：：" + dbmd.getURL()); System.out.println("\n----------------------------------------------------"); }catch(SQLException se){ printSQLException(se); }catch(ClassNotFoundException ce){ System.out.println("JDBC Driver" + driver + "not found in ClassPath"); }finally{ if(con != null){ try{ con.close(); }catch(SQLException se){ printSQLException(se); } } } } } /* * ---------------------------------------------------- 数据库产品名称：Apache Derby 数据库版本:：10.4.2.1 - (706043) 驱动程序的名称：Apache Derby Embedded JDBC Driver 驱动程序的版本：：10.4.2.1 - (706043) 数据库的地址：：jdbc:derby:test ---------------------------------------------------- */