編集履歴

質問編集履歴

テーブルの追加

2018/09/12 19:56

投稿

machamp

スコア7

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -166,103 +166,71 @@
 	private Integer category_id;
-	public Integer getId() {
-		return id;
-	}
-	public void setId(Integer id) {
-		this.id = id;
-	}
-	public String getName() {
-		return name;
-	}
-	public void setName(String name) {
-		this.name = name;
-	}
-	public Integer getPrice() {
-		return price;
-	}
-	public void setPrice(Integer price) {
-		this.price = price;
-	}
-	public String getImage_pass() {
-		return image_pass;
-	}
-	public void setImage_pass(String image_pass) {
-		this.image_pass = image_pass;
-	}
-	public String getShow_image_pass() {
-		return show_image_pass;
-	}
-	public void setShow_image_pass(String show_image_pass) {
-		this.show_image_pass = show_image_pass;
-	}
-	public Integer getCategory_id() {
-		return category_id;
-	}
-	public void setCategory_id(Integer category_id) {
-		this.category_id = category_id;
-	}
+```
+```beans
+@NamedQueries({
+	@NamedQuery(
+			name = "checkRegisterdEmail",
+			query = "SELECT COUNT(u) FROM User AS u WHERE u.email = :email"
+			),
+	@NamedQuery(
+			name = "checkLoginCode",
+			query = "SELECT u FROM User AS u WHERE u.email = :email AND u.password = :password"
+			)
+})
+@Table(name = "users")
+@Entity
+public class User {
+	@Id
+	@Column(name = "id")
+	@GeneratedValue(strategy = GenerationType.IDENTITY)
+	private Integer id;
+	@Column(name = "name", length = 12, nullable = false)
+	private String name;
+	@Column(name = "address", nullable = false)
+	private String address;
+	@Column(name = "email", nullable = false, unique = true)
+	private String email;
+	@Column(name = "password", nullable = false)
+	private String password;
 }
@@ -270,156 +238,6 @@
-```beans
-@NamedQueries({
-	@NamedQuery(
-			name = "checkRegisterdEmail",
-			query = "SELECT COUNT(u) FROM User AS u WHERE u.email = :email"
-			),
-	@NamedQuery(
-			name = "checkLoginCode",
-			query = "SELECT u FROM User AS u WHERE u.email = :email AND u.password = :password"
-			)
-})
-@Table(name = "users")
-@Entity
-public class User {
-	@Id
-	@Column(name = "id")
-	@GeneratedValue(strategy = GenerationType.IDENTITY)
-	private Integer id;
-	@Column(name = "name", length = 12, nullable = false)
-	private String name;
-	@Column(name = "address", nullable = false)
-	private String address;
-	@Column(name = "email", nullable = false, unique = true)
-	private String email;
-	@Column(name = "password", nullable = false)
-	private String password;
-	public Integer getId() {
-		return id;
-	}
-	public void setId(Integer id) {
-		this.id = id;
-	}
-	public String getName() {
-		return name;
-	}
-	public void setName(String name) {
-		this.name = name;
-	}
-	public String getAddress() {
-		return address;
-	}
-	public void setAddress(String address) {
-		this.address = address;
-	}
-	public String getEmail() {
-		return email;
-	}
-	public void setEmail(String email) {
-		this.email = email;
-	}
-	public String getPassword() {
-		return password;
-	}
-	public void setPassword(String password) {
-		this.password = password;
-	}
-}
-```
 発生しているエラー :
@@ -434,7 +252,7 @@
-説明 The server encountered an internal error that prevented it from fulfilling this request.
@@ -577,3 +395,55 @@
 宜しくお願い致します。
+追記：　テーブルの定義
+itemsテーブル
++-----------------+--------------+------+-----+---------+----------------+
+| Field           | Type         | Null | Key | Default | Extra          |
++-----------------+--------------+------+-----+---------+----------------+
+| id              | int(11)      | NO   | PRI | NULL    | auto_increment |
+| name            | varchar(100) | NO   |     | NULL    |                |
+| price           | int(11)      | NO   |     | NULL    |                |
+| image_pass      | varchar(100) | NO   |     | NULL    |                |
+| show_image_pass | varchar(100) | NO   |     | NULL    |                |
+| category_id     | int(11)      | NO   |     | NULL    |                |
++-----------------+--------------+------+-----+---------+----------------+
+cartテーブル
++-------------+----------+------+-----+---------+----------------+
+| Field       | Type     | Null | Key | Default | Extra          |
++-------------+----------+------+-----+---------+----------------+
+| id          | int(11)  | NO   | PRI | NULL    | auto_increment |
+| cart_status | int(11)  | NO   |     | 0       |                |
+| item_id     | int(11)  | NO   |     | NULL    |                |
+| order_at    | datetime | YES  |     | NULL    |                |
+| order_num   | int(11)  | YES  |     | NULL    |                |
+| user_id     | int(11)  | NO   |     | NULL    |                |
++-------------+----------+------+-----+---------+----------------+