jdk13連接配接10.15.2

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