基于javaweb的水产品商城系统(java+jsp+bootstrap+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的水产品商城系统(java+JSP+bootstrap+servlet+Mysql)
项目介绍
本项目分为前后台,分为管理员与普通用户两种角色,管理员登录后台,普通用户登录前台;
管理员登录包含以下功能:
管理员登录,修改管理员信息,订单管理,客户管理,水产管理,类目管理等功能。
用户角色包含以下功能: 查看首页,用户登录,修改个人信息,按分类查看水产,查看热销水产,查看新水产,查看商品详情,查看我的购物车,提交订单,查看我的订单等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否Maven项目:否;
技术栈
JSP+CSS+jQuery+bootstrap+mysql+servlet
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中src/utils/DBUtil.java配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/jsp_scp_shop/ 登录 注:tomcat中配置项目路径必须为jsp_scp_shop,否则会有异常; 用户账号/密码:user/123456 管理员账号/密码:admin/admin
用户管理控制层:
@Controller
@RequestMapping(“/user”)
public class UserController extends BaseController {
/**
- 依赖注入 start dao/service/===
*/
@Autowired
private UserService userService;
// --------------------------------------- 华丽分割线 ------------------------------
/查询列表【不分页】**************/
/**
-
【不分页 => 查询列表 => 无条件】
-
@Title: listAll
-
@Descriiption: TODO(这里用一句话描述这个方法的作用)
-
@param @return 设定文件
-
@author
-
@return String 返回类型
-
@throws
*/
@RequestMapping(value = “/listAll”)
public String listAll(User user, Model model, HttpServletRequest request, HttpServletResponse response){
List listAll = userService.listAll();
model.addAttribute(“list”, listAll);
return “user/user”;
/**
-
【不分页=》查询列表=>有条件】
-
@Title: listByEntity
-
@Descriiption: TODO(这里用一句话描述这个方法的作用)
-
@param @return 设定文件
-
@author
-
@return String 返回类型
-
@throws
*/
@RequestMapping(value = “/listByEntity”)
public String listByEntity(User user, Model model, HttpServletRequest request, HttpServletResponse response){
List listAll = userService.listAllByEntity(user);
model.addAttribute(“list”, listAll);
return “user/user”;
/**
-
【不分页=》查询列表=>有条件】
-
@Title: listByMap
-
@Descriiption: TODO(这里用一句话描述这个方法的作用)
-
@param @return 设定文件
-
@author
-
@return String 返回类型
-
@throws
*/
@RequestMapping(value = “/listByMap”)
public String listByMap(User user, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(user.getUserName())){
params.put(“userName”, user.getUserName());
if(!isEmpty(user.getPassWord())){
params.put(“passWord”, user.getPassWord());
if(!isEmpty(user.getPhone())){
params.put(“phone”, user.getPhone());
if(!isEmpty(user.getRealName())){
params.put(“realName”, user.getRealName());
if(!isEmpty(user.getSex())){
params.put(“sex”, user.getSex());
if(!isEmpty(user.getAddress())){
params.put(“address”, user.getAddress());
if(!isEmpty(user.getEmail())){
params.put(“email”, user.getEmail());
List listAll = userService.listByMap(params);
model.addAttribute(“list”, listAll);
return “user/user”;
/查询列表【分页】**************/
/**
-
分页查询 返回list对象(通过对象)
-
@param request
-
@param response
-
@return
*/
@RequestMapping(value = “/findByObj”)
public String findByObj(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager pagers = userService.findByEntity(user);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, user);
return “user/user”;
/**
-
分页查询 返回list对象(通过对By Sql)
-
@param request
-
@param response
-
@return
*/
@RequestMapping(value = “/findBySql”)
public String findBySql(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM user WHERE 1=1 ";
if(!isEmpty(user.getUserName())){
sql += " and userName like ‘%“+user.getUserName()+”%’";
if(!isEmpty(user.getPassWord())){
sql += " and passWord like ‘%“+user.getPassWord()+”%’";
if(!isEmpty(user.getPhone())){
sql += " and phone like ‘%“+user.getPhone()+”%’";
if(!isEmpty(user.getRealName())){
sql += " and realName like ‘%“+user.getRealName()+”%’";
if(!isEmpty(user.getSex())){
sql += " and sex like ‘%“+user.getSex()+”%’";
if(!isEmpty(user.getAddress())){
sql += " and address like ‘%“+user.getAddress()+”%’";
if(!isEmpty(user.getEmail())){
sql += " and email like ‘%“+user.getEmail()+”%’";
sql += " ORDER BY ID DESC ";
Pager pagers = userService.findBySqlRerturnEntity(sql);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, user);
return “user/user”;
/**
-
分页查询 返回list对象(通过Map)
-
@param request
-
@param response
-
@return
*/
@RequestMapping(value = “/findByMap”)
public String findByMap(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(user.getUserName())){
params.put(“userName”, user.getUserName());
if(!isEmpty(user.getPassWord())){
params.put(“passWord”, user.getPassWord());
if(!isEmpty(user.getPhone())){
params.put(“phone”, user.getPhone());
if(!isEmpty(user.getRealName())){
params.put(“realName”, user.getRealName());
if(!isEmpty(user.getSex())){
params.put(“sex”, user.getSex());
if(!isEmpty(user.getAddress())){
params.put(“address”, user.getAddress());
if(!isEmpty(user.getEmail())){
params.put(“email”, user.getEmail());
//分页查询
Pager pagers = userService.findByMap(params);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, user);
return “user/user”;
/【增删改】********************/
/**
-
跳至添加页面
-
@return
*/
@RequestMapping(value = “/add”)
public String add() {
return “user/add”;
/**
-
跳至详情页面
-
@return
*/
@RequestMapping(value = “/view”)
public String view(Model model,HttpServletRequest request) {
Object attribute = request.getSession().getAttribute(“userId”);
if (attribute == null){
return “redirect:/login/uLogin”;
JSONObject js = new JSONObject();
Integer userId = Integer.valueOf(attribute.toString());
User obj = userService.load(userId);
model.addAttribute(“obj”,obj);
return “user/view”;
/**
-
添加执行
-
@return
*/
@RequestMapping(value = “/exAdd”)
public String exAdd(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
userService.insert(user);
return “redirect:/user/findBySql.action”;
/**
-
跳至修改页面
-
@return
*/
@RequestMapping(value = “/update”)
public String update(Integer id,Model model) {
User obj = userService.load(id);
model.addAttribute(“obj”,obj);
return “user/update”;
/**
-
添加修改
-
@return
*/
@RequestMapping(value = “/exUpdate”)
public String exUpdate(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
Object attribute = request.getSession().getAttribute(“userId”);
if (attribute == null){
return “redirect:/login/uLogin”;
JSONObject js = new JSONObject();
user.setId(Integer.valueOf(attribute.toString()));
userService.updateById(user);
//2.通过主键id修改
//userService.updateById(user);
return “redirect:/user/view.action”;
/**
-
删除通过主键
-
@return
*/
@RequestMapping(value = “/delete”)
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
userService.deleteById(id);
/以下是多种删除方式/
// //2.通过实体条件删除
// userService.deleteByEntity(user);
// //3.通过参数删除
// //通过map查询