Derby测试类

freemenff

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;/** * @author freemenff *  */public class Test {/** * @param args */public static void main(String[] args) {/** * 网络服务器模式：支撑来自不同 JVM的多个连接想访问一个数据库startNetworkServer.bat * jdbcDriver:org.apache.derby.jdbc.ClientDriver * jdbcUrl:jdbc:derby://localhost:1527/testDB;create=false *//** * 内嵌模式：同一个JVM * jdbcDriver:org.apache.derby.jdbc.EmbeddedDriver * jdbcUrl:jdbc:derby:testDB;create=true; */String driver = "org.apache.derby.jdbc.EmbeddedDriver";String connectionURL = "jdbc:derby:testDB;create=true;";Connection conn = null;PreparedStatement psmt = null;ResultSet rs = null;try {Class.forName(driver).newInstance();conn = DriverManager.getConnection(connectionURL);psmt = conn.prepareStatement("create table person (id int primary key not null, name varchar(12) not null)");psmt.executeUpdate();System.out.println("testCreateTable");psmt = conn.prepareStatement("insert into person values(1, 'name5')");psmt.executeUpdate();System.out.println("testInsertTable");psmt = conn.prepareStatement("select * from person where id=?");psmt.setInt(1, 1);rs = psmt.executeQuery();while (rs.next()) {int id = rs.getInt(1);String name = rs.getString(2);System.out.println(id + "@" + name);}} catch (InstantiationException e) {e.printStackTrace();} catch (IllegalAccessException e) {e.printStackTrace();} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {if (rs != null) {try {rs.close();} catch (SQLException e) {e.printStackTrace();}rs = null;}if (psmt != null) {try {psmt.close();} catch (SQLException e) {e.printStackTrace();}psmt = null;}if (conn != null) {try {conn.close();} catch (SQLException e) {e.printStackTrace();}conn = null;}}}}