Java ScriptRunner.setAutoCommit方法代码示例

import org.apache.ibatis.jdbc.ScriptRunner; //导入方法依赖的package包/类
/**
 * 
 * @param connection
 * @param in
 * @throws Exception
 */
public static void executeSqlScript(Connection connection, InputStream in) throws Exception {
	if (null == connection || null == in) {
		return;
	}
	ScriptRunner runner = new ScriptRunner(connection);
	runner.setAutoCommit(true);
	Reader reader = null;
	try {
		reader = new InputStreamReader(in, "utf-8"); //$NON-NLS-1$
		runner.runScript(reader);
	} catch (Throwable e) {
		throw new Exception("An error occured while try to execute SQL script.", e);
	} finally {
		IOUtils.closeQuietly(reader);
		IOUtils.closeQuietly(in);
		runner.closeConnection();
	}
}
 

import org.apache.ibatis.jdbc.ScriptRunner; //导入方法依赖的package包/类
private void run() throws IOException, SQLException {
    MysqlDataSource dataSource = new MysqlDataSource();
    dataSource.setUrl("jdbc:mysql://" + host + ":" + port + "/" + database);
    dataSource.setUser(username);
    dataSource.setPassword(password);

    try (FileInputStream inputStream = new FileInputStream(file)) {
        ScriptRunner runner = new ScriptRunner(dataSource.getConnection());
        runner.setAutoCommit(true);
        runner.setStopOnError(true);
        runner.runScript(new InputStreamReader(inputStream));
        runner.closeConnection();
    }
}
 

import org.apache.ibatis.jdbc.ScriptRunner; //导入方法依赖的package包/类
@Override
public void afterStart() {
    /*
    测试的数据库(启动后创建)
     */
    Reader config = null;
    Reader sql = null;
    SqlSession sqlSession = null;
    try {
        config = Resources.getResourceAsReader("mybatis-config.xml");
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(config);
        sqlSession = sessionFactory.openSession(true);

        Connection connection = sqlSession.getConnection();
        ScriptRunner runner = new ScriptRunner(connection);
        runner.setAutoCommit(true);

        sql = Resources.getResourceAsReader("easycontroller.sql");
        runner.runScript(sql);

        runner.closeConnection();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        IOUtils.closeQuietly(sqlSession);
        IOUtils.closeQuietly(sql);
        IOUtils.closeQuietly(config);
    }
}
 

import org.apache.ibatis.jdbc.ScriptRunner; //导入方法依赖的package包/类
public static void runScript(DataSource ds, String resource) throws IOException, SQLException {
    Connection connection = ds.getConnection();
    try {
        ScriptRunner runner = new ScriptRunner(connection);
        runner.setAutoCommit(true);
        runner.setStopOnError(false);
        runner.setLogWriter(null);
        runner.setErrorLogWriter(null);
        runScript(runner, resource);
    } finally {
        connection.close();
    }
}
 

import org.apache.ibatis.jdbc.ScriptRunner; //导入方法依赖的package包/类
private static void runReaderScript(Connection conn, SqlSession session, Reader reader) throws Exception {
  ScriptRunner runner = new ScriptRunner(conn);
  runner.setLogWriter(null);
  runner.setSendFullScript(true);
  runner.setAutoCommit(true);
  runner.setStopOnError(false);
  runner.runScript(reader);
}
 

import org.apache.ibatis.jdbc.ScriptRunner; //导入方法依赖的package包/类
public static void runScript(DataSource ds, String resource) throws IOException, SQLException {
  Connection connection = ds.getConnection();
  try {
    ScriptRunner runner = new ScriptRunner(connection);
    runner.setAutoCommit(true);
    runner.setStopOnError(false);
    runner.setLogWriter(null);
    runner.setErrorLogWriter(null);
    runScript(runner, resource);
  } finally {
    connection.close();
  }
}
 

import org.apache.ibatis.jdbc.ScriptRunner; //导入方法依赖的package包/类
public static void runScript(DataSource ds, String resource)
		throws IOException, SQLException {
	Connection connection = ds.getConnection();
	try {
		ScriptRunner runner = new ScriptRunner(connection);
		runner.setAutoCommit(true);
		runner.setStopOnError(false);
		runner.setLogWriter(new PrintWriter(System.out));
		runner.setErrorLogWriter(new PrintWriter(System.err));
		runScript(runner, resource);
	} finally {
		connection.close();
	}
}
 

import org.apache.ibatis.jdbc.ScriptRunner; //导入方法依赖的package包/类
private void executeSQL(Connection connection, Reader reader) throws SQLException {
    ScriptRunner runner = new ScriptRunner(connection);
    runner.setAutoCommit(true);
    runner.setStopOnError(true);

    try {
        runner.runScript(reader);
    } catch (RuntimeSqlException e) {
        throw new SQLException(e); // Force to handle the exception by myself
    }
}
 

import org.apache.ibatis.jdbc.ScriptRunner; //导入方法依赖的package包/类
@SneakyThrows
private static void loadInitializeData(Injector injector, Reader reader) {
    DataSource dataSource = injector.getInstance(DataSource.class);

    try (final Connection connection = dataSource.getConnection()) {
        ScriptRunner runner = new ScriptRunner(connection);
        runner.setAutoCommit(true);
        runner.setStopOnError(true);
        runner.runScript(reader);
    } // Auto close connection
}