javaweb实战之商城项目开发（一）

1、javawebjavaweb项功能结构sqlCREATE DATABASE shop;use shop;create table user(id int(11) primary key auto_increment,username varchar(100),password varchar(100),nickname varchar(100),type int(5);INSERT INTO user VALUES (null,admin,7946521,管理员,1);CREATE TABLE address(id INT(10) PRIMARY KEY AUTO_INCREMENT,name

2、 VARCHAR(255),phone VARCHAR(100),postcode VARCHAR(100),user_id INT(10),CONSTRAINT FOREIGN KEY (user_id) REFERENCES user(id);INSERT INTO address VALUES (NULL ,安徽阳,1234567890,236000,1);SELECT t1.*,t2.* FROM address t1 LEFT JOIN user t2 ON t1.user_id = t2.id where t1.user_id =1 ;create table orders(id

3、int(11) primary key auto_increment,buy_date datetime,pay_date datetime,confirm_date datetime,status int(5),user_id int(11),address_id int(11),CONSTRAINT FOREIGN KEY(user_id) REFERENCES user(id),CONSTRAINT FOREIGN KEY(address_id) REFERENCES address(id);create table category(id int(11) primary key aut

4、o_increment,name varchar(100);create table goods(id int(11) primary key auto_increment,name varchar(100),price double,intro text,img varchar(100),stock int(10),c_id int(10),CONSTRAINT FOREIGN KEY(c_id) REFERENCES category(id);create table goods_orders(id int(11) primary key auto_increment,goods_id i

5、nt(10),orders_id int(10),CONSTRAINT FOREIGN KEY(goods_id) REFERENCES goods(id),CONSTRAINT FOREIGN KEY(orders_id) REFERENCES orders(id);项准备modelUser.java.Adress.javaUser.package com.model;import java.util.List;/* Created by nl101 on 2016/2/22.*/public class User private int id;/idprivate String usern

6、ame;private String password;private String nickname;/昵称private int type;/1表管理员,2表注册户private List addresses;public List getAddresses() return addresses;public void setAddresses(List addresses) this.addresses = addresses;public int getId() return id;public void setId(int id) this.id = id;public String

7、 getUsername() return username;public void setUsername(String username) this.username = username;public String getPassword() return password;public void setPassword(String password) this.password = password;public String getNickname() return nickname;public void setNickname(String nickname) this.nic

8、kname = nickname;public int getType() return type;public void setType(int type) this.type = type;package com.model;/* Created by nl101 on 2016/2/22.*/public class Address private int id;private String name;private String phone;private String postcode;/直接给user对象,来代替user_idprivate User user;public int getId() return id;public void setId(int id) this.id = id;public String getName() return name;public void setName(String name) = name;public String getPhone() return phone;public void setPhone(String phone) this.phone = phone;public String getPostcode() return postcode;public void setPos