| Revision | 89 (tree) |
|---|---|
| Time | 2015-08-23 14:54:52 |
| Author | t_nakayama1971 |
(empty log message)
| @@ -91,8 +91,9 @@ | ||
| 91 | 91 | conn.setAutoCommit(false); |
| 92 | 92 | |
| 93 | 93 | String query = QueryUtil.getSqlFromFile("SelectBatchMessage", this.getClass()); |
| 94 | - try (PreparedStatement psmt = QueryUtil.statementReadonly( | |
| 95 | - conn, query, Collections.singletonMap("MsgId", kid))) { | |
| 94 | + try (PreparedStatement psmt = QueryUtil.createStatement( | |
| 95 | + query, Collections.singletonMap("MsgId", kid), | |
| 96 | + Jdbc.wrap(conn)::readonlyStatement)) { | |
| 96 | 97 | try (ResultSet rs = psmt.executeQuery()) { |
| 97 | 98 | while (rs.next()) { |
| 98 | 99 | msg.setHardMessage(rs.getString(Env.getEnv("Message.MsgId")), |
| @@ -11,6 +11,12 @@ | ||
| 11 | 11 | import java.util.Objects; |
| 12 | 12 | |
| 13 | 13 | import batch.util.ParameterUtil; |
| 14 | +import common.db.JdbcSource; | |
| 15 | +import common.db.jdbc.Jdbc; | |
| 16 | +import common.sql.QueryUtil; | |
| 17 | +import core.config.Env; | |
| 18 | +import core.config.Factory; | |
| 19 | +import core.exception.PhysicalException; | |
| 14 | 20 | import net.sf.jasperreports.engine.JRException; |
| 15 | 21 | import net.sf.jasperreports.engine.JRResultSetDataSource; |
| 16 | 22 | import net.sf.jasperreports.engine.JasperCompileManager; |
| @@ -20,11 +26,6 @@ | ||
| 20 | 26 | import net.sf.jasperreports.engine.JasperReport; |
| 21 | 27 | import project.batch.ProjectBatch; |
| 22 | 28 | import project.batch.ProjectPerform; |
| 23 | -import common.db.JdbcSource; | |
| 24 | -import common.sql.QueryUtil; | |
| 25 | -import core.config.Env; | |
| 26 | -import core.config.Factory; | |
| 27 | -import core.exception.PhysicalException; | |
| 28 | 29 | |
| 29 | 30 | /** |
| 30 | 31 | * 汎用帳票印刷バッチ |
| @@ -106,8 +107,8 @@ | ||
| 106 | 107 | conn.setAutoCommit(false); |
| 107 | 108 | |
| 108 | 109 | String qry = getQuery(prms); |
| 109 | - try (PreparedStatement psmt = | |
| 110 | - QueryUtil.statementReadonly(conn, qry, super.toBindMap(prms))) { | |
| 110 | + try (PreparedStatement psmt = QueryUtil.createStatement( | |
| 111 | + qry, super.toBindMap(prms), Jdbc.wrap(conn)::readonlyStatement)) { | |
| 111 | 112 | if (psmt != null) { |
| 112 | 113 | if (0 < DEFAULT_FETCH_SIZE) { |
| 113 | 114 | psmt.setFetchSize(DEFAULT_FETCH_SIZE); |
| @@ -10,14 +10,13 @@ | ||
| 10 | 10 | |
| 11 | 11 | import org.apache.commons.lang3.ArrayUtils; |
| 12 | 12 | |
| 13 | -import project.svc.generic.csv.extract.QueryBuilder; | |
| 14 | - | |
| 15 | 13 | import common.db.JdbcSource; |
| 14 | +import common.db.jdbc.Jdbc; | |
| 16 | 15 | import common.sql.QueryUtil; |
| 17 | - | |
| 18 | 16 | import core.exception.PhysicalException; |
| 19 | 17 | import core.util.ArrayUtil; |
| 20 | 18 | import core.util.BooleanUtil; |
| 19 | +import project.svc.generic.csv.extract.QueryBuilder; | |
| 21 | 20 | |
| 22 | 21 | /** |
| 23 | 22 | * クエリビルダ |
| @@ -127,8 +126,9 @@ | ||
| 127 | 126 | */ |
| 128 | 127 | private boolean setHeaderInfo(final String file) { |
| 129 | 128 | try (Connection conn = JdbcSource.getConnection()) { |
| 130 | - try (PreparedStatement psmt = QueryUtil.statementReadonly( | |
| 131 | - conn, QueryUtil.getSqlFromFile(file), this.param)) { | |
| 129 | + try (PreparedStatement psmt = QueryUtil.createStatement( | |
| 130 | + QueryUtil.getSqlFromFile(file), this.param, | |
| 131 | + Jdbc.wrap(conn)::readonlyStatement)) { | |
| 132 | 132 | try (ResultSet rs = psmt.executeQuery()) { |
| 133 | 133 | if (rs.next()) { |
| 134 | 134 | this.schema = rs.getString("SCHEMA_NAME"); |
| @@ -163,8 +163,9 @@ | ||
| 163 | 163 | List<Integer> page = new ArrayList<>(); |
| 164 | 164 | |
| 165 | 165 | try (Connection conn = JdbcSource.getConnection()) { |
| 166 | - try (PreparedStatement psmt = QueryUtil.statementReadonly( | |
| 167 | - conn, QueryUtil.getSqlFromFile(file), this.param)) { | |
| 166 | + try (PreparedStatement psmt = QueryUtil.createStatement( | |
| 167 | + QueryUtil.getSqlFromFile(file), this.param, | |
| 168 | + Jdbc.wrap(conn)::readonlyStatement)) { | |
| 168 | 169 | try (ResultSet rs = psmt.executeQuery()) { |
| 169 | 170 | while (rs.next()) { |
| 170 | 171 | label.add(rs.getString("ITEM_LABEL")); |
| @@ -210,8 +211,9 @@ | ||
| 210 | 211 | List<String> item = new ArrayList<>(); |
| 211 | 212 | |
| 212 | 213 | try (Connection conn = JdbcSource.getConnection()) { |
| 213 | - try (PreparedStatement psmt = QueryUtil.statementReadonly( | |
| 214 | - conn, QueryUtil.getSqlFromFile(file), this.param)) { | |
| 214 | + try (PreparedStatement psmt = QueryUtil.createStatement( | |
| 215 | + QueryUtil.getSqlFromFile(file), this.param, | |
| 216 | + Jdbc.wrap(conn)::readonlyStatement)) { | |
| 215 | 217 | try (ResultSet rs = psmt.executeQuery()) { |
| 216 | 218 | while (rs.next()) { |
| 217 | 219 | ope.add(rs.getString("OPERATOR")); |