jsp-hyukshop
所属分类：数据库系统
开发工具：Java
文件大小：10422KB
下载次数：0
上传日期：2022-11-05 15:29:09
上 传 者：
sh-1993
说明： 使用Java Servlet的在线购物中心项目
(Online Shopping mall Project using Java Servlet)
文件列表:
.classpath (816, 2022-11-05)
.project (873, 2022-11-05)
.settings (0, 2022-11-05)
.settings\.jsdtscope (555, 2022-11-05)
.settings\org.eclipse.core.resources.prefs (75, 2022-11-05)
.settings\org.eclipse.jdt.core.prefs (537, 2022-11-05)
.settings\org.eclipse.wst.common.component (456, 2022-11-05)
.settings\org.eclipse.wst.common.project.facet.core.xml (334, 2022-11-05)
.settings\org.eclipse.wst.jsdt.ui.superType.container (49, 2022-11-05)
.settings\org.eclipse.wst.jsdt.ui.superType.name (6, 2022-11-05)
LICENSE (1069, 2022-11-05)
WebContent (0, 2022-11-05)
WebContent\META-INF (0, 2022-11-05)
WebContent\META-INF\MANIFEST.MF (36, 2022-11-05)
WebContent\META-INF\context.xml (349, 2022-11-05)
WebContent\WEB-INF (0, 2022-11-05)
WebContent\WEB-INF\lib (0, 2022-11-05)
WebContent\WEB-INF\lib\commons-codec-1.9.jar (263965, 2022-11-05)
WebContent\WEB-INF\lib\commons-lang3-3.9.jar (503880, 2022-11-05)
WebContent\WEB-INF\lib\commons-logging-1.2.jar (61829, 2022-11-05)
WebContent\WEB-INF\lib\gson-2.8.5.jar (241622, 2022-11-05)
WebContent\WEB-INF\lib\jstl-1.2.jar (414240, 2022-11-05)
WebContent\WEB-INF\lib\lombok.jar (1914266, 2022-11-05)
WebContent\WEB-INF\lib\lucy-xss-1.6.3.jar (129073, 2022-11-05)
WebContent\WEB-INF\lib\lucy-xss-servlet-2.0.1.jar (17184, 2022-11-05)
WebContent\WEB-INF\lib\mysql-connector-java-8.0.21.jar (2397321, 2022-11-05)
WebContent\WEB-INF\web.xml (1532, 2022-11-05)
WebContent\css (0, 2022-11-05)
WebContent\css\style-cart.css (4341, 2022-11-05)
WebContent\css\style-checkout.css (6319, 2022-11-05)
WebContent\css\style-common.css (3756, 2022-11-05)
WebContent\css\style-favorite.css (1233, 2022-11-05)
WebContent\css\style-footer.css (623, 2022-11-05)
WebContent\css\style-header.css (1670, 2022-11-05)
WebContent\css\style-index.css (1105, 2022-11-05)
WebContent\css\style-pageForAll.css (884, 2022-11-05)
WebContent\css\style-product.css (5378, 2022-11-05)
WebContent\css\style-qna.css (1218, 2022-11-05)
... ...
# JSP
### : 21.01.13 ~ 21.01.29
### : (chmh0805@naver.com)
### EC2 : ~~http://15.1***.166.37/shop~~ EC2 .
### : https://youtu.be/UMdEGoW_ulQ
##
- Windows 10
- JDK 1.8
- Tomcat 9.0
- STS Tool
- MySQL 8.0
- Lombok
- Gson
- JSTL
- Naver Lucy Filter
- SHA-256
- Encoding : UTF-8
## , ,
1.
- https://www.brandi.co.kr/
2.
- https://www.trenbe.com/
3.
- https://www.balaan.co.kr/
##
- , .
## API
1. API
- https://developers.kakao.com/product/kakaoLogin
2. API
- https://nid.naver.com/user2/campaign/introNaverIdLogin.nhn
- , / id user insert.
- user id, id SELECT .
3. API ( )
- https://www.iamport.kr/getstarted
4. summernote API
- https://summernote.org/
5. sweetalert2
- https://sweetalert2.github.io/
## MySQL
```sql
CREATE USER 'shopuser'@'%' identified by 'shop0805';
GRANT ALL privileges on *.* TO 'shopuser'@'%';
create database shopdb;
```
## MySQL
```sql
use shopdb;
```
```sql
CREATE TABLE product(
id int primary key auto_increment,
productName varchar(120) unique not null,
companyId int not null,
price long not null,
soldCount int default 0,
detail longtext not null,
imgUrl_1 varchar(100) not null,
imgUrl_2 varchar(100),
imgUrl_3 varchar(100),
imgUrl_4 varchar(100),
writerId int,
createDate timestamp default now(),
updateDate timestamp default now()
);
```
```sql
CREATE TABLE user(
id int primary key auto_increment,
username varchar(20) unique default null,
name varchar(20) not null,
email varchar(50) not null,
phone varchar(13) not null,
address varchar(120) not null,
password char(***) not null,
kakaoId long,
naverId long,
auth varchar(10) default 'user',
createDate timestamp default now()
);
```
```sql
CREATE TABLE company (
id int primary key auto_increment,
name varchar(40) unique not null,
url varchar(80) unique
);
```
```sql
CREATE TABLE favorite(
id int primary key auto_increment,
userId int not null,
productId int not null,
createDate timestamp default now()
);
```
```sql
CREATE TABLE cart(
id int primary key auto_increment,
userId int not null,
productId int not null,
createDate timestamp default now()
);
```
```sql
CREATE TABLE qna(
id int primary key auto_increment,
userId int not null,
productId int not null,
optionNo int not null,
password varchar(4),
detail longtext,
createDate timestamp default now()
);
```
```sql
CREATE TABLE review(
id int primary key auto_increment,
userId int not null,
productId int not null,
detail longtext not null,
createDate timestamp default now(),
updateDate timestamp default now()
);
```
#
1.
- SHA-256 DB .
2.
3.
4.
/
5.
6.
- Carousel .
- grid Layout .
7.
- SELECT company . ( .)
- header , filter .
8.
9.
- .
10.
- product , ORDER BY soldCount DESC .
11.
- .
12.
- admin , .
- , , , .
13.
- , SHA-256 DB .
14.
15. -
- product select .
- . ( )
- . ( )
- . ( )
-
-
- .
16. -
- , .
- sticky position .
- , .
17. - Q&A
- .
- Q&A , .
- .
18. , Q&A
19. Q&A
- .
20.
- , .
21. Q&A
- , .
- .
22.
- , summernote .
23. Q&A
- , summernote .
24.
- .
- .
25.
- .
- / .
- .
- .
26.
- .
- .
- .
27.
28.
- .
29.
- , .
30.
- / .
近期下载者：
相关文件：
收藏者：