long idCurrencyCurs; try { ps = conn.prepareStatement(sql_); ps.setLong(1, idSite); ps.setLong(2, idCurrency); ps.setTimestamp(3, stamp); rs = ps.executeQuery(); if (rs.next()) { curs = rs.getDouble("CURS"); tsCurs = rs.getTimestamp("DATE_CHANGE"); } return tsCurs; } finally { rs.close(); ps.close(); rs = null; ps = null; } }
Other popular examples for PreparedStatement
150: stmt.setLong(1,rId);
151: stmt.setLong(2,scn);
152: stmt.setString(3, srcKey);
153: stmt.setBlob(4, new ByteArrayInputStream(data.getBytes()));
154: stmt.executeUpdate();
-
159: DBHelper.close(stmt);
Full Snippet Info120: stmt.setLong(1, _minwindowscn);
121: stmt.setLong(2, _maxwindowscn);
122: stmt.setInt(3, _maxRowId);
123: stmt.setInt(4, _srcid);
-
134: DBHelper.close(stmt);
Full Snippet Info85: stmt.setFetchDirection(ResultSet.FETCH_FORWARD);
86: stmt.setFetchSize(1);
87: stmt.setLong(1, longID);
88: rs = stmt.executeQuery();
-
97: IOUtils.quietClose(rs, stmt, conn);
Full Snippet Info