Java DbUtils.closeQuietly方法代碼示例

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
public static void main(String[] args) {
	Connection conn = null;

	final String url = "jdbc:h2:./target/test;AUTO_SERVER=TRUE";
	final String driver = "org.h2.Driver";
	final String usr = "sa";
	final String pwd = "";

	try {
		DbUtils.loadDriver(driver);
		conn = DriverManager.getConnection(url, usr, pwd);
		QueryRunner query = new QueryRunner();
		List<Map<String, Object>> mapList = (List<Map<String, Object>>) query
				.query(conn, "select * from user", new MapListHandler());
		for (int i = 0; i < mapList.size(); i++) {
			Map<String, Object> map = (Map<String, Object>) mapList.get(i);
			System.out.println("------> " + map.get("userId") + "\t"
					+ map.get("firstName") + "\t" + map.get("emailId"));
		}
	} catch (SQLException se) {
		se.printStackTrace();
	} finally {
		DbUtils.closeQuietly(conn);
	}
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
public static Connection getConnection(String dbname) throws SQLException {
    String dbpath = getDbPath(dbname);
    String jdbcurl = "jdbc:h2:file:" + dbpath + ";DB_CLOSE_ON_EXIT=FALSE";
    LOG.info("connect jdbcurl = {}", jdbcurl);
    Connection conn = DriverManager.getConnection(jdbcurl, "sa", "");

    DataSource ds = new CustomFlywayDataSource(new PrintWriter(System.out), conn);
    Flyway flyway = new Flyway();
    flyway.setDataSource(ds);
    // explicitly set h2db driver loaded (= including this jar file) class loader
    flyway.setClassLoader(conn.getClass().getClassLoader());
    flyway.migrate();
    LOG.info("db[{}] migration success", dbname);

    // may be already closed -> reconnect.
    DbUtils.closeQuietly(conn);
    conn = DriverManager.getConnection(jdbcurl, "sa", "");

    return conn;
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
private long runLibraryScript(final String scriptSQL, final Connection conn) throws DeployException {
runScript(scriptSQL, conn);
PreparedStatement stmt = null;
ResultSet results = null;
try {
    stmt = conn.prepareStatement("SELECT LAST_INSERT_ID() FROM lams_learning_library");
    results = stmt.executeQuery();
    if (results.next()) {
	return results.getLong("LAST_INSERT_ID()");
    } else {
	throw new DeployException("Could not get learning_library_id");
    }
} catch (SQLException sqlex) {
    throw new DeployException("Failed to run learning library script", sqlex);
} finally {
    DbUtils.closeQuietly(stmt);
    DbUtils.closeQuietly(results);
}

   }
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
private long runToolInsertScript(final String scriptSQL, final Connection conn) throws DeployException {
runScript(scriptSQL, conn);
PreparedStatement stmt = null;
ResultSet results = null;
try {
    stmt = conn.prepareStatement("SELECT LAST_INSERT_ID() FROM lams_tool");
    results = stmt.executeQuery();
    if (results.next()) {
	return results.getLong("LAST_INSERT_ID()");
    } else {
	throw new DeployException("Could not get learning_library_id");
    }
} catch (SQLException sqlex) {
    throw new DeployException("Failed to run tool insert script", sqlex);
} finally {
    DbUtils.closeQuietly(stmt);
    DbUtils.closeQuietly(results);
}

   }
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
public String queryTool(String toolSig, String column) {
Connection conn = getConnection();
PreparedStatement stmt = null;
ResultSet results = null;
try {
    stmt = conn
	    .prepareStatement("select " + column + " from lams_tool where tool_signature= \"" + toolSig + "\"");
    System.out.println("SQL stmt: " + stmt);
    results = stmt.executeQuery();

    if (results.first()) {
	return results.getString(column);

    }
} catch (SQLException se) {

    throw new DeployException("Could not get entry from lams_tool: " + column + "\n" + se.getMessage());

} finally {
    DbUtils.closeQuietly(stmt);
}
return "ERROR";
   }
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
@Test
public void testDeploy() throws Exception {
    getAppContext.valueOf(1)
            .cleanEnvironment()
            .deploy();

    // ensuring that we can modify
    DbDeployerAppContext dbDeployerAppContext = getAppContext.valueOf(2);
    dbDeployerAppContext
            .cleanEnvironment()
            .setupEnvInfra()
            .deploy();

    JdbcHelper jdbc = new JdbcHelper();

    Connection conn = ds.getConnection();
    try {
        List<Map<String, Object>> results = jdbc.queryForList(conn, "select * from " + dbDeployerAppContext.getEnvironment().getPhysicalSchema("schema1") + ".TABLE_A order by a_id");
        assertEquals(3, results.size());
        this.validateResults(results.get(0), 2, 3, "fasdfasd", "2013-02-02 11:11:11.65432", 9);
        this.validateResults(results.get(1), 3, 4, "ABC", null, 9);
        this.validateResults(results.get(2), 4, 2, "ABC", "2012-01-01 12:12:12", null);
    } finally {
        DbUtils.closeQuietly(conn);
    }
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
/**
    * Runs the sql statements and will return the last inserted id from the particular
    * table.
    * 
    * @param scriptSQL
    *            The sql to run
    * @param conn
    * @param tablename
    *            The table which to query for the last inserted id.
    * @return the last inserted id from <code>tablename</code>
    * @throws DeployException
    */
   private long runLibraryScript(final String scriptSQL, final Connection conn, String tablename)
    throws DeployException {
runScript(scriptSQL, conn);
PreparedStatement stmt = null;
ResultSet results = null;
try {
    stmt = conn.prepareStatement("SELECT LAST_INSERT_ID() FROM " + tablename);
    results = stmt.executeQuery();
    if (results.next()) {
	return results.getLong("LAST_INSERT_ID()");
    } else {
	throw new DeployException("Could not get the last inserted id from table " + tablename);
    }
} catch (SQLException sqlex) {
    throw new DeployException("Failed to run learning library script", sqlex);
} finally {
    DbUtils.closeQuietly(stmt);
    DbUtils.closeQuietly(results);
}

   }
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
public static void main(String[] args) 
{
	try
	{
		EnaValidator enaValidator = new EnaValidator();
		enaValidator.init(args,null);
		enaValidator.initValidator();
		int failedCount =enaValidator.validateFiles();
		
		if(failedCount==0)
			System.exit(0);
		if(failedCount>0)
			System.exit(3);
	}
	catch (Exception e)
	{
		e.printStackTrace();
		System.exit(1);
		
	}
	finally
	{
		DbUtils.closeQuietly(con);

	}
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
private int getRecordCount(int validRecordValue1, int validRecordValue2) throws HarvestException
{
	PreparedStatement pstmt=null;
	ResultSet rs = null;
	try {
		pstmt = this.dbConnection.prepareStatement(
				String.format(GET_RECORD_COUNT, this.dbTableName));
		pstmt.setInt(1, validRecordValue1);
		pstmt.setInt(2, validRecordValue2);
		rs = pstmt.executeQuery();
		rs.first();
		return rs.getInt(1);
	} catch (SQLException e) {
		throw new HarvestException(Config.Exceptions.RESOURCE_DEPENDENCY_ERROR_CODE,
				"Trouble getting record count from workspace DB", e );
	}
	finally
	{	
		DbUtils.closeQuietly(rs);
		DbUtils.closeQuietly(pstmt);
	}
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
/**
 * try to drop the session table
 * @throws HarvestException
 */
public void dropTable() throws HarvestException
{
	if (this.dbConnection==null)
		this.dbConnection = this.getConnection();
	if (this.dbConnection!=null)
	{
		Statement stmt = null;
		try
		{
			stmt = this.dbConnection.createStatement();
			stmt.execute(String.format(DROP_TABLE_STMT, this.dbTableName));
		}
		catch (SQLException e) {
			// table doesn't exist, doesn't matter keep on chugging
		}
		finally
		{
			DbUtils.closeQuietly(stmt);
		}
	}
	
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
/**
 * Main log method that everything else calls, This puts the message into the db
 * @param msg
 * @param level
 */
private void log(String msg, String level)
{
	PreparedStatement insert_log_pstmt=null;
	try {
		insert_log_pstmt = this.dbConnection.prepareStatement(
				LOG_INSERT_STMT);
		insert_log_pstmt.setString(1, this.uuid);
		insert_log_pstmt.setString(2, msg);
		insert_log_pstmt.setString(3, level);
		insert_log_pstmt.execute();
		insert_log_pstmt.close();
	} catch (SQLException e) {
		// TODO we got some massive issues, what to do if we can't log to db
		e.printStackTrace();
	}
	finally
	{
		DbUtils.closeQuietly(insert_log_pstmt);
	}
	
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
/**
 * Closes up all the cached prepared statements to release all locks and free some
 * memory up. Might be unnecessary but i helped with locks during development
 */
private void cleanupPreparedStatments()
{
	DbUtils.closeQuietly(this.insertURIPstmt);
	this.insertURIPstmt = null;
	DbUtils.closeQuietly(this.populateRecordPstmt);
	this.populateRecordPstmt = null;
	DbUtils.closeQuietly(this.updateHandlesPstmt);
	this.updateHandlesPstmt = null;
	
	for(PreparedStatement pstmt:this.updateRecordPstmts.values())
	{
		DbUtils.closeQuietly(pstmt);
	}
	this.updateRecordPstmts = new HashMap<String, PreparedStatement>();
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
/**
 * Delete a specified session of harvested records
 * @param setSpec
 * @param sessionId
 * @throws HarvestException
 */
public void removeSessionHarvestedRecords(String setSpec, String sessionId) throws HarvestException
{
	PreparedStatement pstmt=null;
	try {
		pstmt = this.harvestConnection.prepareStatement(REMOVE_HARVESTED_RECORDS_STMT);
		pstmt.setString(1, setSpec);
		pstmt.setString(2, sessionId);
		pstmt.execute();

	} catch (SQLException e) {
		throw new HarvestException(Config.Exceptions.RESOURCE_DEPENDENCY_ERROR_CODE,
			String.format("Trouble removing old session from harvested " +
				"records db. SessionId:%s  SetSpec: %s",setSpec, sessionId), e );
	}
	finally
	{	
		DbUtils.closeQuietly(pstmt);
	}
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
@Override
public String getDbcode(String prefix) throws SQLException {
	if(prefix==null)
		return null;
	 String sql=	"select dbcode from cv_database_prefix where prefix= ?";
	  ResultSet rs = null;
	  PreparedStatement ps = null;
		try
		{
			ps = connection.prepareStatement(sql);
			ps.setString(1, prefix);
			rs = ps.executeQuery();
			if(rs.next())
			{
    			return rs.getString(1);
			}
		}finally
		{
			DbUtils.closeQuietly(rs);
			DbUtils.closeQuietly(ps);
		}
		
		
	  return null;
}
 

import org.apache.commons.dbutils.DbUtils; //導入方法依賴的package包/類
@Override
public Long getSequenceLength(String accession) throws SQLException
{
	ResultSet rs = null;
	PreparedStatement ps = null;
	try
	{
		ps = connection.prepareStatement("select seqlen from bioseq where sequence_acc=? or seq_accid=?");
		ps.setString(1,accession);
		ps.setString(2, accession);
		rs = ps.executeQuery();
		if (rs.next())
		{
			return rs.getLong(1);
		}

		return 0L;
	} finally
	{
		DbUtils.closeQuietly(rs);
		DbUtils.closeQuietly(ps);
	}
}