一. 项目功能结构
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), kode pos varchar (100), user_id int (10), kendala kunci asing (user_id) merujuk pengguna (id)); masukkan ke dalam nilai alamat (null, '安徽阜阳', '1234567890', '236000', '1'); pilih t1.*, T2.* Dari alamat t1, '236000', '1'); Pilih t1.*, T2.* Dari alamat T1 lggg LIFT. ;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)); buat barang tabel (id int (11) kunci utama auto_increment, name varchar (100), harga ganda, teks intro, img varchar (100), stok int (10), c_id int (10), Kunci Kunci Asing (C_ID) Katin (ID); Buat ID (ID ID (ID); ID (ID); ID (ID); ID Table (ID); ID (ID), CREATING BOGING (ID); int (10), orders_id int (10), kendala kunci asing (goods_id) referensi barang (id), kendala kunci asing (orders_id) referensi pesanan (id));
二. 项目准备
1. 实体类实现
分别建立 dao, filter, model, util 的包, 并在 model 中实现实体类, 这里以 user.java 为例.
注意对于数据库中外键, 比如 Adress 表中有外键 user_id, 那么在 adress.java 中就可以直接给个 pengguna 对象, 在取 Adress 表的时候就把 pengguna 一并取出来.
User.java
Paket com.model; import java.util.list;/*** Dibuat oleh NL101 pada 2016/2/22.*/Pengguna kelas publik {private int id; // Idprivate string username; kata sandi string pribadi; private string nickname; // 昵称 tipe int swasta; // 1 表示管理员, 2 表示注册用户 Daftar pribadi <alamat> alamat; Daftar Public; setAddresses (Daftar <Sahua> alamat) {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 string username) {this. 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
Paket com.model;/*** Dibuat oleh NL101 pada 2016/2/22.*/Alamat kelas publik {private int id; Nama string pribadi; Telepon String Privat; Private String Postcode; // 直接给 User 对象, 来代替 User_Idprivate User Pengguna; Public Int Getid () {Return ID;} public void setid (int id) {this.id public getId () {return ID;} public void setid (int iD) {this.id public getId () {return id void public setid (int id) {this.id.id = {public ID; setName (name string) {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;} public void setPostCode (string postcode) {this.postcode; postcode public publ setUser (pengguna pengguna) {this.user = user;}}2. 分页框架准备
分页主要是写 pager.java 和 SystemContext.java 以及 Systemfilter.java 三个类. 可以参开前面的博文, jsp 通用分页框架
完整建立后如下
关于 Javaweb 实现简单的商城项目就给大家介绍到这里 ， ，