編集履歴

質問編集履歴

DTO,メソッドを追記しました。

2018/07/28 10:28

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -16,20 +16,514 @@
 ```java
+public boolean create(Gyomu gyomu) throws SQLException, ClassNotFoundException {
+		Connection conn = null;
+		try {
+			conn = connectManager.getConn(false);
+			// INSERT文の準備（idは自動連番なので指定しない）WHERE句で指定する
+			// StringBuilderで文字列の連結ができる
+			StringBuilder sb = new StringBuilder();
-sb.append("INSERT");
+			   sb.append("INSERT");
-sb.append(" INTO GYOMUHOKOKU( ");
+	           sb.append(" INTO GYOMUHOKOKU(");
-sb.append(" HOKOKUHIDUKE");
+	           sb.append("HOKOKUHIDUKE");
-sb.append(" )VALUES(");
+	           sb.append(")VALUES(");
+	           sb.append("?);");
+            // sb.toStringで、文字列にする
+            // sbのままだと、prepareStatementが受け取れない
+            PreparedStatement pStmt = conn.prepareStatement(sb.toString());
+			pStmt.setString(1, gyomu.getHokokuhiduke());
+			int result = pStmt.executeUpdate();
+			StringBuilder sb2 = new StringBuilder();
+			//HOKOKUSAKIテーブルのINSERT文の発行
+			sb2.append("  INSERT ");
+			sb2.append("  INTO HOKOKUSAKI(");
+			sb2.append("  HOKOKUSAKISEQ");
+			sb2.append("  , STETUSID = ?");
+			sb2.append("  , USERID = ?");
+			sb2.append("  , HOKOKUSAKINAME = ?");
- sb.append(" '?'); ");
+			sb2.append("  , CREATEDATE = ?");
+			sb2.append("  , CREATEUSER = ?");
+			sb2.append("  , UPDATEDATE = ?");
+			sb2.append("  , UPDATEUSER = ?");
+			sb2.append(")");
+			sb2.append("VALUES ( ");
+			sb2.append("  ( ");
+			sb2.append("  SELECT");
+			sb2.append("  coalesce(MAX(HOKOKUSAKISEQ), '0') + 1 ");
+			sb2.append("  FROM");
+			sb2.append("  HOKOKUSAKI");
+			sb2.append("  ) ");
+			sb.append("  ,?");
+            sb.append("  ,?");
+            sb.append("  ,?");
+            sb.append("  ,?");
+            sb.append("  ,?");
+            sb.append("  ,?");
+            sb.append("  ,?");
+			sb2.append(");");
+			PreparedStatement pStmt2 = conn.prepareStatement(sb2.toString());
+			// INSERT文中の「?」に使用する値を設定し、SQLを完成
+			pStmt2.setString(1, gyomu.getStetusid());
+			pStmt2.setString(2, gyomu.getUserId());
+			pStmt2.setString(3, gyomu.getHokokusakiname());
+			pStmt2.setString(4, gyomu.getCreatedate());
+			pStmt2.setString(5, gyomu.getCreateuser());
+			pStmt2.setString(6, gyomu.getUpdatedate());
+			pStmt2.setString(7, gyomu.getUpdateuser());
+			// INSERT文を実行
+			int result2 = pStmt2.executeUpdate();
+			if (result != 1 && result2 != 1) {
+				conn.rollback();
+				return false;
+			}
+			conn.commit();
+		} catch (SQLException e) {
+			e.printStackTrace();
+			return false;
+		} finally {
+			connectManager.close(conn);
+		}
+		return false;
+	}
 ```
+```java
+package dto;
+public class Gyomu {
+	private String kanrino;
+	private String stetusid;
+	private String stetusname;
+	private String hokokuhiduke;
+	private String yotei;
+	private String userId;
+	private String username;
+	private String hokokusakiseq;
+	private String hokokusakiname;
+	private String zisseki;
+	private String tokkizikou;
+	private String shokan;
+	private String kakunosaki;
+	private String zikaiyotei;
+	private String komento;
+	private String biko;
+	private String createdate;
+	private String createuser;
+	private String updatedate;
+	private String updateuser;
+	public String getKanrino() {
+		return kanrino;
+	}
+	public void setKanrino(String kanrino) {
+		this.kanrino = kanrino;
+	}
+	public String getStetusid() {
+		return stetusid;
+	}
+	public void setStetusid(String stetusid) {
+		this.stetusid = stetusid;
+	}
+	public String getStetusname() {
+		return stetusname;
+	}
+	public void setStetusname(String stetusname) {
+		this.stetusname = stetusname;
+	}
+	public String getHokokuhiduke() {
+		return hokokuhiduke;
+	}
+	public void setHokokuhiduke(String hokokuhiduke) {
+		this.hokokuhiduke = hokokuhiduke;
+	}
+	public String getYotei() {
+		return yotei;
+	}
+	public void setYotei(String yotei) {
+		this.yotei = yotei;
+	}
+	public String getUserId() {
+		return userId;
+	}
+	public void setUserId(String userId) {
+		this.userId = userId;
+	}
+	public String getUsername() {
+		return username;
+	}
+	public void setUsername(String username) {
+		this.username = username;
+	}
+	public String getHokokusakiseq() {
+		return hokokusakiseq;
+	}
+	public void setHokokusakiseq(String hokokusakiseq) {
+		this.hokokusakiseq = hokokusakiseq;
+	}
+	public String getHokokusakiname() {
+		return hokokusakiname;
+	}
+	public void setHokokusakiname(String hokokusakiname) {
+		this.hokokusakiname = hokokusakiname;
+	}
+	public String getZisseki() {
+		return zisseki;
+	}
+	public void setZisseki(String zisseki) {
+		this.zisseki = zisseki;
+	}
+	public String getTokkizikou() {
+		return tokkizikou;
+	}
+	public void setTokkizikou(String tokkizikou) {
+		this.tokkizikou = tokkizikou;
+	}
+	public String getShokan() {
+		return shokan;
+	}
+	public void setShokan(String shokan) {
+		this.shokan = shokan;
+	}
+	public String getKakunosaki() {
+		return kakunosaki;
+	}
+	public void setKakunosaki(String kakunosaki) {
+		this.kakunosaki = kakunosaki;
+	}
+	public String getZikaiyotei() {
+		return zikaiyotei;
+	}
+	public void setZikaiyotei(String zikaiyotei) {
+		this.zikaiyotei = zikaiyotei;
+	}
+	public String getKomento() {
+		return komento;
+	}
+	public void setKomento(String komento) {
+		this.komento = komento;
+	}
+	public String getBiko() {
+		return biko;
+	}
+	public void setBiko(String biko) {
+		this.biko = biko;
+	}
+	public String getCreatedate() {
+		return createdate;
+	}
+	public void setCreatedate(String createdate) {
+		this.createdate = createdate;
+	}
+	public String getCreateuser() {
+		return createuser;
+	}
+	public void setCreateuser(String createuser) {
+		this.createuser = createuser;
+	}
+	public String getUpdatedate() {
+		return updatedate;
+	}
+	public void setUpdatedate(String updatedate) {
+		this.updatedate = updatedate;
+	}
+	public String getUpdateuser() {
+		return updateuser;
+	}
+	public void setUpdateuser(String updateuser) {
+		this.updateuser = updateuser;
+	}
+}
+```
 ```SQL

TABLE文を記述しました。

2018/07/28 10:28

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -27,3 +27,65 @@
  sb.append(" '?'); ");
 ```
+```SQL
+CREATE TABLE "SYSTEM"."GYOMUHOKOKU"
+   (	"KANRINO" NUMBER GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 99999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE,
+	"HOKOKUHIDUKE" DATE,
+	"YOTEI" NVARCHAR2(1000),
+	"ZISSEKI" NVARCHAR2(1000),
+	"TOKKIZIKOU" NVARCHAR2(1000),
+	"SHOKAN" NVARCHAR2(1000),
+	"KAKUNOSAKI" NVARCHAR2(1000),
+	"ZIKAIYOTEI" NVARCHAR2(1000),
+	"KOMENTO" NVARCHAR2(1000),
+	"BIKO" NVARCHAR2(1000),
+	"CREATEDATE" DATE,
+	"CREATEUSER" NVARCHAR2(10),
+	"UPDATEDATE" DATE,
+	"UPDATEUSER" NVARCHAR2(10),
+	 CONSTRAINT "GYOMUHOKOKU_PKC" PRIMARY KEY ("KANRINO")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "SYSTEM"  ENABLE
+   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
+ NOCOMPRESS LOGGING
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
+  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "SYSTEM"
+```