jdk13连接10.15.2

需要的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();
		}
	}
}