需要的jar包:derby.jar和derbyshared.jar
下载地址:https://download.csdn.net/download/JavaAlpha/12494368
代码如下:
package test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
/**
* @ClassName: TestDerby
* @Description: jdk13连接10.15.2
* @author JavaAlpha
* @date 2020年6月3日下午10:33:31
*/
public class TestDerby {
public static void main(String[] args) {
try {
// Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
Class.forName("org.apache.derby.iapi.jdbc.AutoloadedDriver").newInstance();
System.out.println("Load the embedded driver");
Connection conn = null;
Properties props = new Properties();
props.put("user", "user1");
props.put("password", "user1");
conn = DriverManager.getConnection("jdbc:derby:d:\\db_train;create=true");
System.out.println("create and connect to db_train");
Statement s = conn.createStatement();
ResultSet rs = s.executeQuery("SELECT * FROM test");
System.out.println("name\t\tscore");
while (rs.next()) {
StringBuilder builder = new StringBuilder(rs.getString(1));
builder.append("\t");
builder.append(rs.getInt(1));
System.out.println(builder.toString());
}
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
}