Java UnpooledDataSource类代码示例

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@Test
public void shouldRunScriptsUsingProperties() throws Exception {
  Properties props = Resources.getResourceAsProperties(JPETSTORE_PROPERTIES);
  DataSource dataSource = new UnpooledDataSource(
      props.getProperty("driver"),
      props.getProperty("url"),
      props.getProperty("username"),
      props.getProperty("password"));
  ScriptRunner runner = new ScriptRunner(dataSource.getConnection());
  runner.setAutoCommit(true);
  runner.setStopOnError(false);
  runner.setErrorLogWriter(null);
  runner.setLogWriter(null);
  runJPetStoreScripts(runner);
  assertProductsTableExistsAndLoaded();
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeClass
public static void setUp() throws Exception {
  Class.forName("org.hsqldb.jdbcDriver");
  Connection c = DriverManager.getConnection("jdbc:hsqldb:mem:annots", "sa", "");
  Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/substitution_in_annots/CreateDB.sql");
  ScriptRunner runner = new ScriptRunner(c);
  runner.setLogWriter(null);
  runner.setErrorLogWriter(null);
  runner.runScript(reader);
  c.commit();
  reader.close();

  Configuration configuration = new Configuration();
  Environment environment = new Environment("test", new JdbcTransactionFactory(), new UnpooledDataSource("org.hsqldb.jdbcDriver", "jdbc:hsqldb:mem:annots", null));
  configuration.setEnvironment(environment);
  
  configuration.addMapper(SubstitutionInAnnotsMapper.class);
  
  sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeEach
public void setup() throws Exception {
    Class.forName(JDBC_DRIVER);
    InputStream is = getClass().getResourceAsStream("/examples/joins/CreateJoinDB.sql");
    try (Connection connection = DriverManager.getConnection(JDBC_URL, "sa", "")) {
        ScriptRunner sr = new ScriptRunner(connection);
        sr.setLogWriter(null);
        sr.runScript(new InputStreamReader(is));
    }
    
    UnpooledDataSource ds = new UnpooledDataSource(JDBC_DRIVER, JDBC_URL, "sa", "");
    Environment environment = new Environment("test", new JdbcTransactionFactory(), ds);
    Configuration config = new Configuration(environment);
    config.addMapper(JoinMapper.class);
    sqlSessionFactory = new SqlSessionFactoryBuilder().build(config);
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeEach
public void setup() throws Exception {
    Class.forName(JDBC_DRIVER).newInstance();
    InputStream is = getClass().getResourceAsStream("/examples/generated/always/CreateGeneratedAlwaysDB.sql");
    try (Connection connection = DriverManager.getConnection(JDBC_URL, "sa", "")) {
        ScriptRunner sr = new ScriptRunner(connection);
        sr.setLogWriter(null);
        sr.runScript(new InputStreamReader(is));
    }
    
    UnpooledDataSource ds = new UnpooledDataSource(JDBC_DRIVER, JDBC_URL, "sa", "");
    Environment environment = new Environment("test", new JdbcTransactionFactory(), ds);
    Configuration config = new Configuration(environment);
    config.addMapper(GeneratedAlwaysAnnotatedMapper.class);
    sqlSessionFactory = new SqlSessionFactoryBuilder().build(config);
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeEach
public void setup() throws Exception {
    Class.forName(JDBC_DRIVER);
    InputStream is = getClass().getResourceAsStream("/examples/groupby/CreateGroupByDB.sql");
    try (Connection connection = DriverManager.getConnection(JDBC_URL, "sa", "")) {
        ScriptRunner sr = new ScriptRunner(connection);
        sr.setLogWriter(null);
        sr.runScript(new InputStreamReader(is));
    }
    
    UnpooledDataSource ds = new UnpooledDataSource(JDBC_DRIVER, JDBC_URL, "sa", "");
    Environment environment = new Environment("test", new JdbcTransactionFactory(), ds);
    Configuration config = new Configuration(environment);
    config.addMapper(GroupByMapper.class);
    sqlSessionFactory = new SqlSessionFactoryBuilder().build(config);
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeEach
public void setup() throws Exception {
    Class.forName(JDBC_DRIVER);
    InputStream is = getClass().getResourceAsStream("/examples/simple/CreateSimpleDB.sql");
    try (Connection connection = DriverManager.getConnection(JDBC_URL, "sa", "")) {
        ScriptRunner sr = new ScriptRunner(connection);
        sr.setLogWriter(null);
        sr.runScript(new InputStreamReader(is));
    }
    
    UnpooledDataSource ds = new UnpooledDataSource(JDBC_DRIVER, JDBC_URL, "sa", "");
    Environment environment = new Environment("test", new JdbcTransactionFactory(), ds);
    Configuration config = new Configuration(environment);
    config.addMapper(SimpleTableAnnotatedMapper.class);
    sqlSessionFactory = new SqlSessionFactoryBuilder().build(config);
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeEach
public void setup() throws Exception {
    Class.forName(JDBC_DRIVER);
    InputStream is = getClass().getResourceAsStream("/examples/animal/data/CreateAnimalData.sql");
    try (Connection connection = DriverManager.getConnection(JDBC_URL, "sa", "")) {
        ScriptRunner sr = new ScriptRunner(connection);
        sr.setLogWriter(null);
        sr.runScript(new InputStreamReader(is));
    }
    
    UnpooledDataSource ds = new UnpooledDataSource(JDBC_DRIVER, JDBC_URL, "sa", "");
    Environment environment = new Environment("test", new JdbcTransactionFactory(), ds);
    Configuration config = new Configuration(environment);
    config.addMapper(AnimalDataMapper.class);
    sqlSessionFactory = new SqlSessionFactoryBuilder().build(config);
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeClass
public static void setUp() throws Exception {
  // Launch PostgreSQL server. Download / unarchive if necessary.
  String url = postgres.start(EmbeddedPostgres.cachedRuntimeConfig(Paths.get(System.getProperty("java.io.tmpdir"), "pgembed")), "localhost", SocketUtil.findFreePort(), "multiple_resultsets", "postgres", "root", Collections.emptyList());

  Configuration configuration = new Configuration();
  Environment environment = new Environment("development", new JdbcTransactionFactory(), new UnpooledDataSource(
      "org.postgresql.Driver", url, null));
  configuration.setEnvironment(environment);
  configuration.setMapUnderscoreToCamelCase(true);
  configuration.addMapper(Mapper.class);
  sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);

  try (SqlSession session = sqlSessionFactory.openSession();
      Connection conn = session.getConnection();
      Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/usesjava8/multiple_resultsets/CreateDB.sql")) {
    ScriptRunner runner = new ScriptRunner(conn);
    runner.setLogWriter(null);
    runner.runScript(reader);
  }
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeClass
public static void setUp() throws Exception {
  //  Launch PostgreSQL server. Download / unarchive if necessary.
  String url = postgres.start(EmbeddedPostgres.cachedRuntimeConfig(Paths.get(System.getProperty("java.io.tmpdir"), "pgembed")), "localhost", SocketUtil.findFreePort(), "postgres_genkeys", "postgres", "root", Collections.emptyList());

  Configuration configuration = new Configuration();
  Environment environment = new Environment("development", new JdbcTransactionFactory(), new UnpooledDataSource(
      "org.postgresql.Driver", url, null));
  configuration.setEnvironment(environment);
  configuration.setUseGeneratedKeys(true);
  configuration.addMapper(Mapper.class);
  sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);

  try (SqlSession session = sqlSessionFactory.openSession();
      Connection conn = session.getConnection();
      Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/usesjava8/postgres_genkeys/CreateDB.sql")) {
    ScriptRunner runner = new ScriptRunner(conn);
    runner.setLogWriter(null);
    runner.runScript(reader);
  }
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeClass
public static void setUp() throws Exception {
  // Launch PostgreSQL server. Download / unarchive if necessary.
  String url = postgres.start(EmbeddedPostgres.cachedRuntimeConfig(Paths.get(System.getProperty("java.io.tmpdir"), "pgembed")), "localhost", SocketUtil.findFreePort(), "keycolumn", "postgres", "root", Collections.emptyList());

  Configuration configuration = new Configuration();
  Environment environment = new Environment("development", new JdbcTransactionFactory(), new UnpooledDataSource(
      "org.postgresql.Driver", url, null));
  configuration.setEnvironment(environment);
  configuration.addMapper(InsertMapper.class);
  sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);

  try (SqlSession session = sqlSessionFactory.openSession();
      Connection conn = session.getConnection();
      Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/usesjava8/keycolumn/CreateDB.sql")) {
    ScriptRunner runner = new ScriptRunner(conn);
    runner.setLogWriter(null);
    runner.runScript(reader);
  }
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeClass
public static void setUp() throws Exception {
  // Launch PostgreSQL server. Download / unarchive if necessary.
  String url = postgres.start(EmbeddedPostgres.cachedRuntimeConfig(Paths.get(System.getProperty("java.io.tmpdir"), "pgembed")), "localhost", SocketUtil.findFreePort(), "refcursor", "postgres", "root", Collections.emptyList());

  Configuration configuration = new Configuration();
  Environment environment = new Environment("development", new JdbcTransactionFactory(), new UnpooledDataSource(
      "org.postgresql.Driver", url, null));
  configuration.setEnvironment(environment);
  configuration.addMapper(OrdersMapper.class);
  sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);

  try (SqlSession session = sqlSessionFactory.openSession();
      Connection conn = session.getConnection();
      Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/usesjava8/refcursor/CreateDB.sql")) {
    ScriptRunner runner = new ScriptRunner(conn);
    runner.setLogWriter(null);
    runner.runScript(reader);
  }
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
@BeforeClass
public static void setUp() throws Exception {
  Class.forName("org.hsqldb.jdbcDriver");
  Connection c = DriverManager.getConnection("jdbc:hsqldb:mem:annots", "sa", "");
  Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/substitution_in_annots/CreateDB.sql");
  ScriptRunner runner = new ScriptRunner(c);
  runner.setLogWriter(null);
  runner.setErrorLogWriter(null);
  runner.runScript(reader);
  c.commit();
  reader.close();

  Configuration configuration = new Configuration();
  Environment environment = new Environment("test", new JdbcTransactionFactory(), new UnpooledDataSource("org.hsqldb.jdbcDriver", "jdbc:hsqldb:mem:annots", null));
  configuration.setEnvironment(environment);

  configuration.addMapper(SubstitutionInAnnotsMapper.class);

  sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
  c.close();
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
private SqlSessionFactory getSqlSessionFactoryJavaConfig() throws Exception {
  Class.forName("org.hsqldb.jdbcDriver");
  Connection c = DriverManager.getConnection("jdbc:hsqldb:mem:xmlextref", "sa", "");
  initDb(c);

  Configuration configuration = new Configuration();
  Environment environment = new Environment("development", new JdbcTransactionFactory(), new UnpooledDataSource(
      "org.hsqldb.jdbcDriver", "jdbc:hsqldb:mem:xmlextref", null));
  configuration.setEnvironment(environment);

  configuration.addMapper(ResultMapReferencePersonMapper.class);
  configuration.addMapper(ResultMapReferencePetMapper.class);
  c.close();

  return new SqlSessionFactoryBuilder().build(configuration);
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
private SqlSessionFactory getSqlSessionFactoryJavaConfig() throws Exception {
  Class.forName("org.hsqldb.jdbcDriver");
  Connection c = DriverManager.getConnection("jdbc:hsqldb:mem:xmlextref", "sa", "");
  initDb(c);

  Configuration configuration = new Configuration();
  Environment environment = new Environment("development", new JdbcTransactionFactory(), new UnpooledDataSource(
      "org.hsqldb.jdbcDriver", "jdbc:hsqldb:mem:xmlextref", null));
  configuration.setEnvironment(environment);

  configuration.addMapper(MultipleCrossIncludePersonMapper.class);
  configuration.addMapper(MultipleCrossIncludePetMapper.class);
  c.close();

  return new SqlSessionFactoryBuilder().build(configuration);
}
 

import org.apache.ibatis.datasource.unpooled.UnpooledDataSource; //导入依赖的package包/类
private SqlSessionFactory getSqlSessionFactoryJavaConfig() throws Exception {
  Class.forName("org.hsqldb.jdbcDriver");
  Connection c = DriverManager.getConnection("jdbc:hsqldb:mem:xmlextref", "sa", "");
  initDb(c);

  Configuration configuration = new Configuration();
  Environment environment = new Environment("development", new JdbcTransactionFactory(), new UnpooledDataSource(
      "org.hsqldb.jdbcDriver", "jdbc:hsqldb:mem:xmlextref", null));
  configuration.setEnvironment(environment);

  configuration.addMapper(ParameterMapReferencePersonMapper.class);
  configuration.addMapper(ParameterMapReferencePetMapper.class);
  c.close();

  return new SqlSessionFactoryBuilder().build(configuration);
}