Changeset 3367 for DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/java/eu/dasish/annotation/backend/dao/impl/JdbcSourceDao.java

Timestamp:

08/13/13 11:18:07 (11 years ago)

Author:

olhsha

Message:

correction getting the list of annotation IDs, where annotations are filtered by link, text, etc. So far body is considered as a text (got from xmls list of elements, vis get(0)). NOT TESTED yet!

Getting sourceIDs of the sources referreing to a given link

File:

• DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/java/eu/dasish/annotation/backend/dao/impl/JdbcSourceDao.java (modified) (1 diff)

DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/java/eu/dasish/annotation/backend/dao/impl/JdbcSourceDao.java

@@ -260 +260 @@
     @Override
     public List<Number> getSourcesForLink(String link){
-      String sql = "SELECT "+source_id+" FROM "+sourceTableName+ "WHERE "+link_uri+" LIKE '%"+link+"%'";
-      List<Number> result = getSimpleJdbcTemplate().query(sql, internalIDRowMapper);
+      StringBuilder sql = new StringBuilder("SELECT ");
+      sql.append(source_id).append(" FROM ").append(sourceTableName).append(" WHERE ").append(link_uri).append(" LIKE '%").append(link).append("%'");
+      List<Number> result = getSimpleJdbcTemplate().query(sql.toString(), internalIDRowMapper);
       return result;
     }