public static List<NewsPoll> selectAll() throws FtdException { List<NewsPoll> newsPolls = new ArrayList<NewsPoll>(); DBClient dbClient = SysMgr.getInstance().getDbClient(); String sql = "select * from news_poll"; CachedRowSet rs = null; try { rs = dbClient.executeQuery(sql); if (rs != null) { while (rs.next()) { NewsPoll np = new NewsPoll(); np.setNewsId(rs.getInt("news_id")); np.setNewsTitle(rs.getString("news_title")); np.setPollImgUrl(rs.getString("poll_img_url")); np.setArticleId(rs.getInt("article_id")); np.setActive(rs.getInt("is_active")); newsPolls.add(np); } } } catch (SQLException e) { throw new FtdException(e, "db.sql.error"); } finally { if (rs != null) try { rs.close(); } catch (SQLException e) { // do nothing } } return newsPolls; }
/** * @throws Exception * @tests java.sql.rowset.joinRowSet#getWhereClause() */ public void testGetWhereClause_MultipleCachedRowSet() throws Exception { String whereClause; // Creates another cached rowset. CachedRowSet crset2; crset2 = newNoInitialInstance(); crset2.setCommand("SELECT * FROM BOOKS"); crset2.setUrl(DERBY_URL); crset2.execute(); // Tests when there are on jdbcRowSet and one CachedRowSet. jrs.addRowSet(crset2, 1); jrs.addRowSet(crset, 1); if (System.getProperty("Testing Harmony") == "true") { whereClause = jrs.getWhereClause(); assertNotNull(whereClause); } else { try { whereClause = jrs.getWhereClause(); fail("Should throw NullPointerException."); } catch (NullPointerException e) { // Expected. } } crset.setTableName("Table1"); crset2.setTableName("Table2"); if (System.getProperty("Testing Harmony") == "true") { whereClause = jrs.getWhereClause(); assertNotNull(whereClause); } else { try { whereClause = jrs.getWhereClause(); fail("Should throw SQLException."); } catch (SQLException e) { // Expected. } } crset.setMatchColumn("ID"); crset2.setMatchColumn("AUTHORID"); whereClause = jrs.getWhereClause(); assertNotNull(whereClause); jrs = newJoinRowSet(); jrs.addRowSet(crset2, "AUTHORID"); jrs.addRowSet(crset, "ID"); whereClause = jrs.getWhereClause(); assertNotNull(whereClause); crset2.close(); }
public static void main(String[] args) { boolean successFlag = false; CreateConnection.loadProperties(); try (Connection conn = CreateConnection.getConnection(); ) { // Perform Scrollable Query queryBookAuthor(conn); queryAuthorWork(conn); joinRowQuery(); } catch (java.sql.SQLException ex) { System.out.println(ex); } finally { if (bookAuthors != null) { try { bookAuthors.close(); } catch (SQLException ex) { ex.printStackTrace(); } } if (authorWork != null) { try { authorWork.close(); } catch (SQLException ex) { ex.printStackTrace(); } } if (jrs != null) { try { jrs.close(); } catch (SQLException ex) { ex.printStackTrace(); } } } }
@Test public void testGetInfoRowSet() { CachedRowSet rws; try { rws = new CachedRowSetImpl(); rws.setCommand(ALLEGATO5_FIND_BYPK); rws.setInt(1, 6); rws.execute(conn); rws.next(); allegato5 = Allegato5Assembler.getInfo(rws); rws.close(); db.closeConnection(conn); } catch (SQLException e) { fail(e.getMessage()); } catch (DBAccessException e) { fail(e.getMessage()); } }