List of usage examples for java.sql Statement close
void close() throws SQLException;
Statement
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. From source file:com.manydesigns.portofino.persistence.QueryUtils.java
/** * Runs a SQL query against a session. The query can contain placeholders for the parameters, as supported by * {@link PreparedStatement}. <br> * INSERT UPDATE DELETE DROP CREATE ALTER TRUNCATE RENAME sueprpan add * /*www . java 2 s . c o m*/ * @param session the session * @param queryString the query * @param parameters parameters to substitute in the query * @return the results of the query as an Object[] (an array cell per column) */ public static int runSqlDml(Session session, final String queryString, final Object[] parameters) { final List<Integer> result = new ArrayList<Integer>(); try { session.doWork(new Work() { public void execute(Connection connection) throws SQLException { Statement stmt = connection.createStatement(); try { result.add(stmt.executeUpdate(queryString)); } finally { stmt.close(); } } }); } catch (HibernateException e) { result.add(-1); session.getTransaction().rollback(); session.beginTransaction(); throw e; } if (result.size() > 0) { return result.get(0); } return -1; }
From source file:com.manydesigns.portofino.persistence.QueryUtils.java
/** * Runs a SQL query against a session. The query is processed with an {@link OgnlSqlFormat}, so it can access values * from the OGNL context.<br>//from w w w . ja v a 2 s .co m * INSERT UPDATE DELETE DROP CREATE ALTER TRUNCATE RENAME hongliangpan add * * @param session the session * @param sql the query string * @return the results of the query as an Object[] (an array cell per column) */ public static int runSqlDml(Session session, String sql) { OgnlSqlFormat sqlFormat = OgnlSqlFormat.create(sql); final String queryString = sqlFormat.getFormatString(); final List<Integer> result = new ArrayList<Integer>(); try { session.doWork(new Work() { public void execute(Connection connection) throws SQLException { Statement stmt = connection.createStatement(); try { result.add(stmt.executeUpdate(queryString)); } finally { stmt.close(); } } }); } catch (HibernateException e) { result.add(-1); session.getTransaction().rollback(); session.beginTransaction(); throw e; } if (result.size() > 0) { return result.get(0); } return -1; }
From source file:sk.upjs.ics.paz1c.mp3library.SqliteMigration.java
private void execute(String sql) throws SQLException { Statement stmt = c.createStatement(); stmt.executeUpdate(sql);/*from www . ja v a 2 s .c o m*/ stmt.close(); }
From source file:com.aurel.track.dbase.UpdateDbSchema.java
/** * Gets the database version//from w ww . jav a 2 s . c o m * @param dbConnection * @return */ public static int getDBVersion(Connection dbConnection) { Statement istmt = null; ResultSet rs = null; try { istmt = dbConnection.createStatement(); rs = istmt.executeQuery("SELECT DBVERSION FROM TSITE"); if (rs == null || !rs.next()) { LOGGER.info("TSITE is empty."); } else { return rs.getInt(1); } } catch (Exception e) { LOGGER.debug(ExceptionUtils.getStackTrace(e)); } finally { try { if (rs != null) { rs.close(); } } catch (Exception e) { LOGGER.debug(ExceptionUtils.getStackTrace(e)); } try { if (istmt != null) { istmt.close(); } } catch (Exception e) { LOGGER.debug(ExceptionUtils.getStackTrace(e)); } try { if (dbConnection != null) { dbConnection.close(); } } catch (Exception e) { LOGGER.debug(ExceptionUtils.getStackTrace(e)); } } return 0; }
From source file:com.oracle.tutorial.jdbc.CoffeesTable.java
public static void viewTable(Connection con) throws SQLException { Statement stmt = null; String query = "select COF_NAME, SUP_ID, PRICE, SALES, TOTAL from COFFEES"; try {//w w w . j a v a2s .c o m stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(query); while (rs.next()) { String coffeeName = rs.getString("COF_NAME"); int supplierID = rs.getInt("SUP_ID"); float price = rs.getFloat("PRICE"); int sales = rs.getInt("SALES"); int total = rs.getInt("TOTAL"); System.out.println(coffeeName + ", " + supplierID + ", " + price + ", " + sales + ", " + total); } } catch (SQLException e) { JDBCTutorialUtilities.printSQLException(e); } finally { if (stmt != null) { stmt.close(); } } }
From source file:com.persistent.cloudninja.utils.ProvisionConnectionUtility.java
public void closeStatement(Statement statement) { if (statement != null) { try {/* ww w . j a va 2s . co m*/ statement.close(); } catch (SQLException sqlException) { sqlException.printStackTrace(); } } }
From source file:org.softdays.mandy.AbstractDbSetupTest.java
public void execute(final String sql) { try {/*from w w w . j ava 2 s.c o m*/ final Connection c = this.databaseTester.getConnection().getConnection(); final Statement s = c.createStatement(); s.executeUpdate(sql); s.close(); } catch (final Exception e) { Assert.fail(e.getMessage()); } }
From source file:it.unibas.spicy.persistence.relational.SimpleDbConnectionFactory.java
public void close(Statement statement) { try {/*from w w w.j a v a 2 s . co m*/ if (statement != null) { statement.close(); } } catch (SQLException sqle) { logger.fatal(sqle.toString()); } }
From source file:com.linuxrouter.netcool.session.QueryUtils.java
public Boolean executeUpdate(String dbName, String sql) { Long start = System.currentTimeMillis(); try {//from www . j a v a 2 s . c o m //connection caching... Connection con = null; if (connectionMap.get(dbName) == null) { BasicDataSource ds = DbUtils.getSimpleDataSourceByName(dbName); con = ds.getConnection(); connectionMap.put(dbName, con); } else { con = connectionMap.get(dbName); } Statement st = con.createStatement(); st.executeUpdate(sql); st.close(); } catch (SQLException ex) { logger.error("Erro ao executar query:", ex); return false; } Long end = System.currentTimeMillis(); return true; }
From source file:com.buddycloud.mediaserver.business.jdbc.schema.Schema.java
@SuppressWarnings("unchecked") public void runScript(MetaDataSource dataSource, String sqlFile) throws IOException, FileNotFoundException, SQLException { List<String> readLines = IOUtils.readLines(new FileInputStream(sqlFile)); Connection connection = dataSource.getConnection(); StringBuilder statementStr = new StringBuilder(); for (String line : readLines) { statementStr.append(line);/* www . ja v a2s. co m*/ if (line.endsWith(SQL_DELIMITER)) { Statement statement = connection.createStatement(); statement.execute(statementStr.toString()); statement.close(); statementStr.setLength(0); } } connection.close(); }