質問編集履歴

1

テーブル定義追記  部分

2019/09/10 06:44

投稿

kokok
kokok

スコア145

test CHANGED
File without changes
test CHANGED
@@ -152,15 +152,11 @@
152
152
 
153
153
  }
154
154
 
155
- /**
155
+
156
-
157
- * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
158
-
159
- */
160
156
 
161
157
  protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
162
158
 
163
- // TODO Auto-generated method stub
159
+
164
160
 
165
161
  doGet(request, response);
166
162
 
@@ -260,13 +256,7 @@
260
256
 
261
257
  }
262
258
 
263
-
264
-
265
-
266
-
267
-
268
-
269
-
259
+
270
260
 
271
261
  public void close() {
272
262
 
@@ -620,11 +610,7 @@
620
610
 
621
611
 
622
612
 
623
- /**
613
+
624
-
625
- * Servlet implementation class Address
626
-
627
- */
628
614
 
629
615
  @WebServlet("/Address")
630
616
 
@@ -662,9 +648,7 @@
662
648
 
663
649
  ArrayList<String> post = addrdb.getpost();
664
650
 
665
- //request.setAttribute("result", result);
651
+
666
-
667
- //request.setAttribute("post", post);
668
652
 
669
653
  HttpSession session = request.getSession(true);
670
654
 
@@ -696,7 +680,7 @@
696
680
 
697
681
  protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
698
682
 
699
- // TODO Auto-generated method stub
683
+
700
684
 
701
685
  doGet(request, response);
702
686
 
@@ -899,3 +883,25 @@
899
883
 
900
884
 
901
885
  少しでもアドバイス頂けるとほんとに助かります。
886
+
887
+
888
+
889
+ ---テーブル定義追記---
890
+
891
+ CREATE TABLE webkensyu.addresses
892
+
893
+ (
894
+
895
+ address_id INT NOT NULL,
896
+
897
+ address_code CHAR(8) NOT NULL,
898
+
899
+ address_prefecture VARCHAR(4) NOT NULL,
900
+
901
+ address_city VARCHAR(10) NOT NULL,
902
+
903
+ address_street VARCHAR(255),
904
+
905
+ CONSTRAINT PRIMARY KEY (address_id)
906
+
907
+ );