Revision 34183
Added by Michele Artini over 9 years ago
| DatabaseUtils.java | ||
|---|---|---|
| 2 | 2 |
|
| 3 | 3 |
import java.util.List; |
| 4 | 4 |
|
| 5 |
import org.apache.commons.logging.Log; |
|
| 6 |
import org.apache.commons.logging.LogFactory; |
|
| 5 | 7 |
import org.springframework.beans.factory.annotation.Required; |
| 6 | 8 |
import org.springframework.jdbc.core.JdbcTemplate; |
| 7 | 9 |
|
| ... | ... | |
| 9 | 11 |
|
| 10 | 12 |
private JdbcTemplate jdbcTemplate; |
| 11 | 13 |
|
| 14 |
private static final Log log = LogFactory.getLog(DatabaseUtils.class); |
|
| 15 |
|
|
| 12 | 16 |
public List<String> search(final String sql) {
|
| 17 |
log.debug(sql); |
|
| 13 | 18 |
return jdbcTemplate.query(sql, new JsonRowMapper()); |
| 14 | 19 |
} |
| 15 | 20 |
|
| 16 | 21 |
public int update(final String sql) {
|
| 22 |
log.debug(sql); |
|
| 17 | 23 |
return jdbcTemplate.update(sql); |
| 18 | 24 |
} |
| 19 | 25 |
|
Also available in: Unified diff
sql setup file