[graduation project] design and implementation of SSM second-hand trading website based on jsp+mysql+Spring+mybatis

Administrator: commodity classification management, commodity management, commodity order management, user management and other functions.
User role: view all goods, log in and register, view goods by category, publish goods, view the seller's home page, contact the seller, leave a message for goods, view orders, modify and view personal data.

Main technologies:

HTML+CSS+JavaScript+jsp+mysql+Spring+mybatis

System home page:

Login code implementation:

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title>System login - Supermarket order management system</title>
    <link type="text/css" rel="stylesheet" href="${pageContext.request.contextPath }/css/style.css" />
    <script type="text/javascript">
	/* if(top.location!=self.location){
	      top.location=self.location;
	 } */
    </script>
</head>
<body class="login_bg">
    <section class="loginBox">
        <header class="loginHeader">
            <h1>Second hand trading platform</h1>
        </header>
        <section class="loginCont">
	        <form class="loginForm" action="${pageContext.request.contextPath }/login.do"  name="actionForm" id="actionForm"  method="post" >
				<div class="info">${error }</div>
				<div class="inputbox">
                    <label for="user">user name:</label>
					<input type="text" class="input-text" id="userCode" name="userCode" placeholder="enter one user name" required/>
				</div>	
				<div class="inputbox">
                    <label for="mima">password:</label>
                    <input type="password" id="userPassword" name="userPassword" placeholder="Please input a password" required/>
                </div>	
				<div class="subBtn">
					
                    <input type="submit" value="Sign in"/>
                    <input type="reset" value="Reset"/>
                </div>	
			</form>
        </section>
    </section>
</body>
</html>

Product details:

Click purchase to create an order information:

Personal Center:

Administrator login:

Main code implementation:

/**
 * .
 *
 *
 *
 *
 */

package io.renren.modules.sys.controller;


import com.google.code.kaptcha.Constants;
import com.google.code.kaptcha.Producer;
import io.renren.common.utils.R;
import io.renren.modules.sys.shiro.ShiroUtils;
import org.apache.shiro.authc.*;
import org.apache.shiro.subject.Subject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.imageio.ImageIO;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.awt.image.BufferedImage;
import java.io.IOException;

/**
 * Login related
 *
 * @author Mark s.com
 */
@Controller
public class SysLoginController {
	@Autowired
	private Producer producer;
	
	@RequestMapping("captcha.jpg")
	public void captcha(HttpServletResponse response)throws IOException {
        response.setHeader("Cache-Control", "no-store, no-cache");
        response.setContentType("image/jpeg");

        //Generate text verification code
        String text = producer.createText();
        //Generate picture verification code
        BufferedImage image = producer.createImage(text);
        //Save to shiro session
        ShiroUtils.setSessionAttribute(Constants.KAPTCHA_SESSION_KEY, text);
        
        ServletOutputStream out = response.getOutputStream();
        ImageIO.write(image, "jpg", out);
	}
	
	/**
	 * Sign in
	 */
	@ResponseBody
	@RequestMapping(value = "/sys/login", method = RequestMethod.POST)
	public R login(String username, String password, String captcha) {
		String kaptcha = ShiroUtils.getKaptcha(Constants.KAPTCHA_SESSION_KEY);
		if(!captcha.equalsIgnoreCase(kaptcha)){
			return R.error("Incorrect verification code");
		}
		try{
			Subject subject = ShiroUtils.getSubject();
			UsernamePasswordToken token = new UsernamePasswordToken(username, password);//md5+Jiayan
			subject.login(token);
		}catch (UnknownAccountException e) {
			return R.error(e.getMessage());
		}catch (IncorrectCredentialsException e) {
			return R.error("Incorrect account or password");
		}catch (LockedAccountException e) {
			return R.error("Account has been locked,Please contact the administrator");
		}catch (AuthenticationException e) {
			return R.error("Account verification failed");
		}
	    
		return R.ok();
	}
	
	/**
	 * sign out
	 */
	@RequestMapping(value = "logout", method = RequestMethod.GET)
	public String logout() {
		ShiroUtils.logout();
		return "redirect:login.html";
	}
	
}

Main functions of administrator:

Classification management:

Commodity management:

Order management:

User management;

Main table design:

User table:

CREATE TABLE `NewTable` (
`user_id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`username`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'user name' ,
`password`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'password' ,
`salt`  varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'salt' ,
`email`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'mailbox' ,
`mobile`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'cell-phone number' ,
`status`  tinyint(4) NULL DEFAULT NULL COMMENT 'Status 0: Disabled 1: normal' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT 'Creation time' ,
PRIMARY KEY (`user_id`),
UNIQUE INDEX `username` (`username`) USING BTREE 
)

Order form:

CREATE TABLE `NewTable` (
`order_id`  bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Order table PK id' ,
`order_no`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'order number' ,
`user_id`  bigint(20) NOT NULL DEFAULT 0 COMMENT 'User primary key id' ,
`total_price`  int(11) NOT NULL DEFAULT 1 COMMENT 'Total order price' ,
`pay_status`  bigint(20) NOT NULL DEFAULT 0 COMMENT 'Payment status:0.Unpaid,1.Payment successful,-1:Payment failure' , ,
`pay_time`  datetime NULL DEFAULT NULL COMMENT 'Payment time' ,
`order_status`  bigint(20) NOT NULL DEFAULT 0 COMMENT 'Order status:0.To be paid 1.Paid 2.Distribution completed 3:Issue succeeded 4.Successful trade -1.Manual shutdown -2.Timeout shutdown -3.Merchant closure' ,
`extra_info`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'order body' ,
`user_name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Consignee Name ' ,
`user_phone`  varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Consignee mobile number' ,
`user_address`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Consignee receiving address' ,
PRIMARY KEY (`order_id`)
)

Commodity list:

CREATE TABLE `NewTable` (
`goods_id`  bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Commodity table primary key id' ,
`goods_name`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Trade name' ,
`goods_intro`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Product introduction' ,
`goods_category_id`  bigint(20) NOT NULL DEFAULT 0 COMMENT 'Association classification id' ,
`goods_cover_img`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '/admin/dist/img/no-img.png' COMMENT 'Commodity master map' ,
`goods_detail_content`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Product details' ,
`original_price`  int(11) NOT NULL DEFAULT 1 COMMENT 'commodity price' ,
`selling_price`  int(11) NOT NULL DEFAULT 1 COMMENT 'Actual selling price of goods' ,

`tag`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Commodity label' ,
`goods_sell_status`  tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Product on shelf status 0-Off shelf 1-Put on the shelf' ,
`create_user`  int(11) NOT NULL DEFAULT 0 COMMENT 'Adder primary key id' ,
PRIMARY KEY (`goods_id`)
)