/
ISqlTemplate.java
107 lines (59 loc) · 3.59 KB
/
ISqlTemplate.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
package org.jumpmind.db.sql;
import java.util.List;
import java.util.Map;
import java.util.Set;
/**
* This interface insulates the application from the data connection technology.
*/
public interface ISqlTemplate {
public byte[] queryForBlob(String sql, Object... args);
public String queryForClob(String sql, Object... args);
public <T> T queryForObject(String sql, Class<T> clazz, Object... params);
public <T> T queryForObject(String sql, ISqlRowMapper<T> mapper, Object... params);
public int queryForInt(String sql, Map<String,Object> params);
public int queryForInt(String sql, Object... args);
public String queryForString(String sql, Object... args);
public long queryForLong(String sql, Object... args);
public Row queryForRow(String sql, Object... args);
public Map<String, Object> queryForMap(String sql, Object... params);
public <T> Map<String, T> queryForMap(String sql, ISqlRowMapper<T> mapper, String keyColumn,
Object... args);
public <T> Map<String, T> queryForMap(String sql, String keyColumn, String valueColumn,
Object... args);
public <T> ISqlReadCursor<T> queryForCursor(String sql, ISqlRowMapper<T> mapper,
Object[] params, int[] types);
public <T> ISqlReadCursor<T> queryForCursor(String sql, ISqlRowMapper<T> mapper);
public List<Row> query(String sql);
public List<Row> query(String sql, Object[] params, int[] types);
public <T> List<T> query(String sql, ISqlRowMapper<T> mapper, Map<String,Object> namedParams);
public <T> List<T> query(String sql, ISqlRowMapper<T> mapper, Object... params);
public <T> List<T> query(String sql, ISqlRowMapper<T> mapper, Object[] params, int[] types);
public <T> List<T> query(String sql, int maxRowsToFetch, ISqlRowMapper<T> mapper, Object[] params, int[] types);
public <T> List<T> query(String sql, int maxRowsToFetch, ISqlRowMapper<T> mapper, Object... params);
public <T> List<T> query(String sql, int maxRowsToFetch, ISqlRowMapper<T> mapper, Map<String,Object> params);
public <T, W> Map<T, W> query(String sql, String keyCol, String valueCol, Object[] params,
int[] types);
public int update(boolean autoCommit, boolean failOnError, int commitRate, ISqlResultsListener listener, String... sql);
public int update(boolean autoCommit, boolean failOnError, int commitRate, ISqlResultsListener listener, ISqlStatementSource source);
public int update(boolean autoCommit, boolean failOnError, int commitRate, String... sql);
public int update(String sql, Object[] values, int[] types);
public int update(String sql, Object... values);
public void testConnection();
public SqlException translate(Exception ex);
public boolean isUniqueKeyViolation(Exception ex);
public boolean isForeignKeyViolation(Exception ex);
public ISqlTransaction startSqlTransaction();
public int getDatabaseMajorVersion();
public int getDatabaseMinorVersion();
public String getDatabaseProductName();
public String getDatabaseProductVersion();
public String getDriverName();
public String getDriverVersion();
public Set<String> getSqlKeywords();
public boolean supportsGetGeneratedKeys();
public boolean isStoresUpperCaseIdentifiers();
public boolean isStoresLowerCaseIdentifiers();
public boolean isStoresMixedCaseQuotedIdentifiers();
public long insertWithGeneratedKey(final String sql, String column, final String sequenceName,
final Object[] args, final int[] types);
}