質問編集履歴
2
VALUE→VALUES
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -542,7 +542,7 @@
|
|
|
542
542
|
|
|
543
543
|
this.connect();
|
|
544
544
|
|
|
545
|
-
String sql ="INSERT INTO users(user_id,user_name,password)VALUE(?,?,?)";
|
|
545
|
+
String sql ="INSERT INTO users(user_id,user_name,password)VALUES(?,?,?)";
|
|
546
546
|
|
|
547
547
|
PreparedStatement pstmt = conn.prepareStatement(sql);
|
|
548
548
|
|
1
追記部分
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -525,3 +525,85 @@
|
|
|
525
525
|
}
|
|
526
526
|
|
|
527
527
|
```
|
|
528
|
+
|
|
529
|
+
|
|
530
|
+
|
|
531
|
+
--追記--
|
|
532
|
+
|
|
533
|
+
```java
|
|
534
|
+
|
|
535
|
+
//ユーザーの作成
|
|
536
|
+
|
|
537
|
+
public int Make_user(String id, String name, String pass) {
|
|
538
|
+
|
|
539
|
+
try {
|
|
540
|
+
|
|
541
|
+
|
|
542
|
+
|
|
543
|
+
this.connect();
|
|
544
|
+
|
|
545
|
+
String sql ="INSERT INTO users(user_id,user_name,password)VALUE(?,?,?)";
|
|
546
|
+
|
|
547
|
+
PreparedStatement pstmt = conn.prepareStatement(sql);
|
|
548
|
+
|
|
549
|
+
pstmt.setString(1, id);
|
|
550
|
+
|
|
551
|
+
pstmt.setString(2, name);
|
|
552
|
+
|
|
553
|
+
pstmt.setString(3, pass);
|
|
554
|
+
|
|
555
|
+
int rs = pstmt.executeUpdate(sql);
|
|
556
|
+
|
|
557
|
+
if(rs == 1) {
|
|
558
|
+
|
|
559
|
+
return 0;
|
|
560
|
+
|
|
561
|
+
}else {
|
|
562
|
+
|
|
563
|
+
|
|
564
|
+
|
|
565
|
+
return -1;
|
|
566
|
+
|
|
567
|
+
}
|
|
568
|
+
|
|
569
|
+
|
|
570
|
+
|
|
571
|
+
}catch (SQLException e) {
|
|
572
|
+
|
|
573
|
+
|
|
574
|
+
|
|
575
|
+
e.printStackTrace();
|
|
576
|
+
|
|
577
|
+
}finally {
|
|
578
|
+
|
|
579
|
+
|
|
580
|
+
|
|
581
|
+
this.close();
|
|
582
|
+
|
|
583
|
+
}
|
|
584
|
+
|
|
585
|
+
|
|
586
|
+
|
|
587
|
+
return -1;
|
|
588
|
+
|
|
589
|
+
}
|
|
590
|
+
|
|
591
|
+
|
|
592
|
+
|
|
593
|
+
```
|
|
594
|
+
|
|
595
|
+
新しくユーザー作成機能を作ろうとしたのですが
|
|
596
|
+
|
|
597
|
+
|
|
598
|
+
|
|
599
|
+
|
|
600
|
+
|
|
601
|
+
at dao.DBIO.Make_user(DBIO.java:137) int rs = pstmt.executeUpdate(sql);
|
|
602
|
+
|
|
603
|
+
|
|
604
|
+
|
|
605
|
+
at servlet.Makeuser.doGet(Makeuser.java:40) int result = dbio.Make_user(text1,text2,text3); （サーブレット呼び出し側）
|
|
606
|
+
|
|
607
|
+
|
|
608
|
+
|
|
609
|
+
のところでエラーが出てしまいます。
|