JAVAWEB實現(xiàn)簡單的商城項目(一)實例代碼解析

更新時間：2016年02月23日 10:32:11 作者：茶飲月

本文給大家分享一段實例代碼給大家介紹JAVAWEB實現(xiàn)簡單的商城項目(一)，非常具有參考價值，感興趣的朋友一起學習吧

一.項目功能結(jié)構(gòu)

1.功能

這里寫圖片描述

2.實體

這里寫圖片描述

3.對應sql語句

CREATE 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 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 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 auto_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 int(10),
orders_id int(10),
CONSTRAINT FOREIGN KEY(goods_id) REFERENCES goods(id),
CONSTRAINT FOREIGN KEY(orders_id) REFERENCES orders(id)
);

二.項目準備

1.實體類實現(xiàn)

分別建立dao,filter,model,util的包,并在model中實現(xiàn)實體類,這里以User.java為例.

注意對于數(shù)據(jù)庫中外鍵,比如adress表中有外鍵user_id,那么在Adress.java中就可以直接給個User對象,在取adress表的時候就把user一并取出來.

User.java

package com.model;
import java.util.List;
/**
* Created by nl101 on 2016/2/22.
*/
public class User {
private int id;//id
private String username;
private String password;
private String nickname;//昵稱
private int type;//1表示管理員,2表示注冊用戶
private List<Address> addresses;
public List<Address> getAddresses() {
return addresses;
}
public void setAddresses(List<Address> addresses) {
this.addresses = addresses;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String 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.nickname = nickname;
}
public int getType() {
return type;
}
public void setType(int type) {
this.type = type;
}
}

Adress.java

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_id
private 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) {
this.name = name;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getPostcode() {
return postcode;
}
public void setPostcode(String postcode) {
this.postcode = postcode;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
}

2.分頁框架準備

分頁主要是寫pager.java和SystemContext.java以及SystemFilter.java三個類.可以參開前面的博文,jsp通用分頁框架

完整建立后如下

這里寫圖片描述