• R/O
  • SSH
  • HTTPS

Commit

Tags
No Tags

Frequently used words (click to add to your profile)

javac++androidlinuxc#windowsobjective-ccocoa誰得qtpythonphprubygameguibathyscaphec計画中(planning stage)翻訳omegatframeworktwitterdomtestvb.netdirectxゲームエンジンbtronarduinopreviewer

Commit MetaInfo

Revision89 (tree)
Time2015-08-23 14:54:52
Authort_nakayama1971

Log Message

(empty log message)

Change Summary

Incremental Difference

--- trunk/framework/pjBat/src/project/batch/ProjectPerform.java (revision 88)
+++ trunk/framework/pjBat/src/project/batch/ProjectPerform.java (revision 89)
@@ -91,8 +91,9 @@
9191 conn.setAutoCommit(false);
9292
9393 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)) {
9697 try (ResultSet rs = psmt.executeQuery()) {
9798 while (rs.next()) {
9899 msg.setHardMessage(rs.getString(Env.getEnv("Message.MsgId")),
--- trunk/framework/pjBat/src/project/batch/jasper/PrintBatch.java (revision 88)
+++ trunk/framework/pjBat/src/project/batch/jasper/PrintBatch.java (revision 89)
@@ -11,6 +11,12 @@
1111 import java.util.Objects;
1212
1313 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;
1420 import net.sf.jasperreports.engine.JRException;
1521 import net.sf.jasperreports.engine.JRResultSetDataSource;
1622 import net.sf.jasperreports.engine.JasperCompileManager;
@@ -20,11 +26,6 @@
2026 import net.sf.jasperreports.engine.JasperReport;
2127 import project.batch.ProjectBatch;
2228 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;
2829
2930 /**
3031 * 汎用帳票印刷バッチ
@@ -106,8 +107,8 @@
106107 conn.setAutoCommit(false);
107108
108109 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)) {
111112 if (psmt != null) {
112113 if (0 < DEFAULT_FETCH_SIZE) {
113114 psmt.setFetchSize(DEFAULT_FETCH_SIZE);
--- trunk/framework/pjBat/src/project/batch/generic/csv/ExtractBatchBuilder.java (revision 88)
+++ trunk/framework/pjBat/src/project/batch/generic/csv/ExtractBatchBuilder.java (revision 89)
@@ -10,14 +10,13 @@
1010
1111 import org.apache.commons.lang3.ArrayUtils;
1212
13-import project.svc.generic.csv.extract.QueryBuilder;
14-
1513 import common.db.JdbcSource;
14+import common.db.jdbc.Jdbc;
1615 import common.sql.QueryUtil;
17-
1816 import core.exception.PhysicalException;
1917 import core.util.ArrayUtil;
2018 import core.util.BooleanUtil;
19+import project.svc.generic.csv.extract.QueryBuilder;
2120
2221 /**
2322 * クエリビルダ
@@ -127,8 +126,9 @@
127126 */
128127 private boolean setHeaderInfo(final String file) {
129128 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)) {
132132 try (ResultSet rs = psmt.executeQuery()) {
133133 if (rs.next()) {
134134 this.schema = rs.getString("SCHEMA_NAME");
@@ -163,8 +163,9 @@
163163 List<Integer> page = new ArrayList<>();
164164
165165 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)) {
168169 try (ResultSet rs = psmt.executeQuery()) {
169170 while (rs.next()) {
170171 label.add(rs.getString("ITEM_LABEL"));
@@ -210,8 +211,9 @@
210211 List<String> item = new ArrayList<>();
211212
212213 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)) {
215217 try (ResultSet rs = psmt.executeQuery()) {
216218 while (rs.next()) {
217219 ope.add(rs.getString("OPERATOR"));