SSM-SalesSystem

IDE：Idea

版本控制：git

项目管理：Maven

框架：Spring+SpringMVC+Mybatis

数据库：mysql

服务器：tomcat

如何看项目效果？

将out/artifacts/ROOT中的ROOT放入你的tomcat的webapps下面

修改位于ROOT/WEB-INF/classes/db.properties的配置

设置默认数据库ssm，在sql中添加下面的语句，然后打开浏览器进入localhost:8080

---

how to easy work this project?

do you see the out/artifacts/ROOT

first: put the ROOT floder into your tomcat webapp floder

second: open ROOT/WEB-INF/classes/db.properties

now you must write your sql driver,name and password

third:set the database ssm and write below statement into your sql

finally open your browser and enter localhost:8080

---

create table person( id int auto_increment primary key comment "主键", userName varchar(100) comment "用户名", password varchar(100) comment "密码md5加密", nickName varchar(50) comment "用户昵称", userType tinyint(3) comment "类型，买家0，卖家1") ENGINE=InnoDB DEFAULT CHARSET=utf8;

create table content( id int auto_increment primary key comment "主键",
price double comment "当前价格", title varchar(100) comment "标题", icon VARCHAR(100) comment "图片", abstract varchar(200) comment "摘要", text LONGTEXT comment "正文" ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

create table trx( id int auto_increment primary key comment "主键",
contentId int comment "内容ID", personId int comment "用户ID", price double comment "购买价格", num varchar(100)comment "交易数量", time bigint comment "购买时间") ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into person (id, userName, password, nickName, userType) values('1','buyer','37254660e226ea65ce6f1efd54233424','buyer','0');

insert into person (id, userName, password, nickName, userType) values('2','seller','981c57a5cfb0f868e064904b8745766f','seller','1');

insert into person (id, userName, password, nickName, userType) values('3','admin','099af53f601532dbd31e0ea99ffdeb64','admin','1');