基于SSM的健身房管理系统

2020 年 5 月 10 日
筆記
JAVA, Mix, mybatis, MySQL, SpringMVC

基于SSM的健身房管理系统

The project was made in 2020-05-05~2020-05-10

谨以此片博文记录下我的第一个Java小Demo

项目展示

用户登录页

用户注册页

用户主页

用户购买健身卡(商城)页

管理员登录页

管理员主页

管理员添加用户页

管理员编辑用户页

细节1：常驻工具栏（内含搜索栏）

细节2：登录账号密码实时反馈（AJAX）

**细节3：翻页功能&可选每页显示条数 **

细节4：人性化的交互设计

项目环境

JDK: 1.8
IDE: IDEA 201903
DataBase: MySQL 8.0
Mybatis: 3.5.2
POM: Maven
Tomcat 9
Bootstrap 3
JQuery 2
lombok 插件
分页插件: PageHelper 5.1.11
涉及技术 MySQL数据库，Spring，JavaWeb及MyBatis，简单的前端知识

项目详情

设计数据库

大二没有好好学系统设计与分析，画的图一塌糊涂。

包含两个实体类，用户&管理员

生成该数据库的sql文件在该链接跳转GitHub /sql 目录下

生成表如图示

设计要实现的功能

应该叫做用例图吧，但我的好多符号都是错的，再次后悔没有好好学习！

制作前端页面Demo

设计该图的网址

其实这一步放在后面也合适，我为了让自己吃大饼，就先设计了一下。

环境配置

项目文件结构如图所示

基本步骤

新建Maven项目，添加web支持

导入pom依赖

<dependencies>
   <!--Junit-->
   <dependency>
       <groupId>junit</groupId>
       <artifactId>junit</artifactId>
       <version>4.12</version>
   </dependency>
   <!--数据库驱动-->
   <dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
       <version>5.1.47</version>
   </dependency>
   <!-- 数据库连接池 -->
   <dependency>
       <groupId>com.mchange</groupId>
       <artifactId>c3p0</artifactId>
       <version>0.9.5.2</version>
   </dependency>

   <!--Servlet - JSP -->
   <dependency>
       <groupId>javax.servlet</groupId>
       <artifactId>servlet-api</artifactId>
       <version>2.5</version>
   </dependency>
   <dependency>
       <groupId>javax.servlet.jsp</groupId>
       <artifactId>jsp-api</artifactId>
       <version>2.2</version>
   </dependency>
   <dependency>
       <groupId>javax.servlet</groupId>
       <artifactId>jstl</artifactId>
       <version>1.2</version>
   </dependency>

   <!--Mybatis-->
   <dependency>
       <groupId>org.mybatis</groupId>
       <artifactId>mybatis</artifactId>
       <version>3.5.2</version>
   </dependency>
   <dependency>
       <groupId>org.mybatis</groupId>
       <artifactId>mybatis-spring</artifactId>
       <version>2.0.2</version>
   </dependency>

   <!--Spring-->
   <dependency>
       <groupId>org.springframework</groupId>
       <artifactId>spring-webmvc</artifactId>
       <version>5.1.9.RELEASE</version>
   </dependency>
   <dependency>
       <groupId>org.springframework</groupId>
       <artifactId>spring-jdbc</artifactId>
       <version>5.1.9.RELEASE</version>
   </dependency>
</dependencies>

Maven资源过滤

<build>
   <resources>
       <resource>
           <directory>src/main/java</directory>
           <includes>
               <include>**/*.properties</include>
               <include>**/*.xml</include>
           </includes>
           <filtering>false</filtering>
       </resource>
       <resource>
           <directory>src/main/resources</directory>
           <includes>
               <include>**/*.properties</include>
               <include>**/*.xml</include>
           </includes>
           <filtering>false</filtering>
       </resource>
   </resources>
</build>

建立基本结构框架（如上所示[点此跳转](# 环境配置)

建立基本配置

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
       PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
       "//mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

</configuration>

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="//www.springframework.org/schema/beans"
      xmlns:xsi="//www.w3.org/2001/XMLSchema-instance"
     xsi:schemaLocation="//www.springframework.org/schema/beans
       //www.springframework.org/schema/beans/spring-beans.xsd">

</beans>

Mybatis层编写

数据库配置文件 database.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=123456IDEA关联数据库

IDEA关联数据库

编写MyBatis的核心配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
       PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
       "//mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
   
   <typeAliases>
       <package name="com.kuang.pojo"/>
   </typeAliases>
   <mappers>
       <mapper resource="com/kuang/dao/BookMapper.xml"/>
   </mappers>

</configuration>

POJO Mapper Services的编写

POJO

User

@Data  //使用lombok插件即可省写get set
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String username;
    private String password;
    private String name;
    private String sex;
    private String telephone;
    private int age;
    private String begintime;
    private String endtime;
    private int remainday;
    private int addday;

    public static void main(String[] args) {
        User u = new User();
        u.getTelephone();
    }
}

Admin

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Admin {
    private int id;
    private String username;
    private String password;
    private String name;
    private String telephone;
}

Mapper

编写DAO层的Mapper接口

1 userMapper

public interface UserMapper {
    //通过id查询
    User queryUserById(int id);
//    查询到期时间
    Date queryDateById(int id);
    //修改账号密码
    int updateNP(User user);
    //login
    User userLogin(User user);
    //会员注册
    int userRegister(User user);
}

2 adminMapper

@Mapper
@Component
public interface AdminMapper{
    //查询会员
    List<User> queryUser();
    //新增会员
    int addUser(User user);
    //删除会员
    int deleteUserById(int id);
    //更新会员
    int updateUser(User user);
    //根据id查询一个会员
    User queryUserById(int id);
    //根据姓名查询一个会员
    User queryUserByName(String name);
    //login
    Admin adminLogin(Admin admin);
    //查询用户总数
    int selectTotal();
    //    分页
    @Select("select * from gymms.user")
    @Results({
            // 用户信息，只要指定id列与属性的映射关系，其他列会自动封装（属性与列一致）
            @Result(property = "id", column = "id"),
            // 信息
            @Result(property = "id", column = "id"),
            @Result(property = "username", column = "username"),
            @Result(property = "password", column = "password"),
            @Result(property = "name", column = "name"),
            @Result(property = "sex", column = "sex"),
            @Result(property = "telephone", column = "telephone"),
            @Result(property = "age", column = "age"),
            @Result(property = "begintime", column = "begintime"),
            @Result(property = "endtime", column = "endtime"),
            @Result(property = "remainday", column = "remainday")
    })
    List<User> findAll();
}

编写接口对应的 Mapper.xml 文件

1 userMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "//mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.cc.dao.UserMapper">
    <select id="queryDate" resultType="User">
        select remainday from gymms.user
      where id = #{id}
    </select>
<!--    查询用户-->
    <select id="queryUserById" resultType="User">
        select * from gymms.user
      where id = #{id}
    </select>
    <!--更新User-->
    <update id="updateUser" parameterType="User">
      update gymms.user
      set username = #{username},password = #{password}
      where id = #{id}
   </update>
    <!--根据账号密码查询,返回一个User-->
    <select id="userLogin" resultType="User">
        select * from gymms.user
      where username = #{username} and password = #{password}
    </select>
<!--    会员注册-->
    <!--增加一个会员-->
    <insert id="userRegister" parameterType="User">
      insert into gymms.user(username,password,name,sex,telephone,age,begintime,endtime,remainday)
      values (#{username},#{password},#{name},#{sex},#{telephone},#{age},#{begintime},#{endtime},#{remainday})
   </insert>
</mapper>

2 adminMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "//mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.cc.dao.AdminMapper">
    <!--增加一个会员-->
    <insert id="addUser" parameterType="User">
      insert into gymms.user(username,password,name,sex,telephone,age,begintime,endtime,remainday)
      values (#{username},#{password},#{name},#{sex},#{telephone},#{age},#{begintime},#{endtime},#{remainday})
   </insert>
    <!--根据id删除一个User-->
    <delete id="deleteUserById" parameterType="int">
      delete from gymms.user where id=#{id}
   </delete>
    <!--更新User-->
    <update id="updateUser" parameterType="User">
      update gymms.user
      set username = #{username},password = #{password},name = #{name},sex = #{sex},telephone = #{telephone},
      age = #{age},endtime = #{endtime},remainday = #{remainday}
      where id = #{id}
   </update>
    <!--根据id查询,返回一个User-->
    <select id="queryUserById" resultType="User">
      select * from gymms.user
      where id = #{id}
   </select>
    <!--根据姓名查询,返回一个User-->
    <select id="queryUserByName" resultType="User">
      select * from gymms.user
      where name = #{name}
   </select>
    <!--查询全部Book-->
    <select id="queryUser" resultType="User">
      SELECT * from gymms.user
   </select>
    <!--根据账号密码查询,返回一个Admin-->
    <select id="adminLogin" resultType="Admin">
        select * from gymms.admin
      where username = #{username} and password = #{password}
    </select>
    <select id="selectTotal" resultType="int">
        select count(*) from gymms.user
    </select>
</mapper>

编写Service层的接口和实现类

1 userService

public interface UserService {
    //    查询到期时间
    Date queryDateById(int id);
    //修改账号密码
    int updateNP(User user);
    //login
    User userLogin(User user);
    //通过id查询
    User queryUserById(int id);
    //会员注册
    int userRegister(User user);
}

2 adminService

public interface AdminService {
    //查询会员
    List<User> queryUser();
    //新增会员
    int addUser(User user);
    //删除会员
    int deleteUserById(int id);
    //更新会员
    int updateUser(User user);
    //根据id查询一个会员
    User queryUserById(int id);
    //根据姓名查询一个会员
    User queryUserByName(String name);
    //login
    Admin adminLogin(Admin admin);
    //查询用户总数
    int selectTotal();
    //    分页
    List<User> findAll();

    /**
     * 分页查询
     * @param pageNum  当然页
     * @param pageSize 页大小
     * @return 返回PageHelper提供的封装分页参数的PageInfo对象
     */
    PageInfo<User> findByPage(int pageNum, int pageSize);
}

3 userServiceImpl

public class UserServiceImpl implements UserService {
    private UserMapper userMapper;
    public void setUserMapper(UserMapper userMapper) {
        this.userMapper = userMapper;
    }
    public Date queryDateById(int id) {
        return userMapper.queryDateById(id);
    }
    public int updateNP(User user) {
        return userMapper.updateNP(user);
    }
    public User userLogin(User user) {
        return userMapper.userLogin(user);
    }
    public User queryUserById(int id) {
        return userMapper.queryUserById(id);
    }
    public int userRegister(User user) {
        return userMapper.userRegister(user);
    }
}

4 adminServiceImpl

public class AdminServiceImpl implements AdminService {
    private AdminMapper adminMapper;
    public void setAdminMapper(AdminMapper adminMapper) {
        this.adminMapper = adminMapper;
    }
    public List<User> queryUser() {
        return adminMapper.queryUser();
    }
    public int addUser(User user) {
        return adminMapper.addUser(user);
    }
    public int deleteUserById(int id) {
        return adminMapper.deleteUserById(id);
    }
    public int updateUser(User user) {
        return adminMapper.updateUser(user);
    }
    public User queryUserById(int id) { 
        return adminMapper.queryUserById(id); 
    }
    public User queryUserByName(String name) { 
        return adminMapper.queryUserByName(name); 
    }
    public Admin adminLogin(Admin admin) {
        return adminMapper.adminLogin(admin);
    }
    public int selectTotal() {
        return adminMapper.selectTotal();
    }
    public List<User> findAll() {
        return adminMapper.findAll();
    }
    public PageInfo<User> findByPage(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        List<User> list = adminMapper.findAll();
        PageInfo<User> pageInfo = new PageInfo<>(list);
        return pageInfo;
    }
}

Spring层

配置Spring整合MyBatis，我们这里数据源使用c3p0连接池；
编写Spring整合Mybatis的相关的配置文件；

spring-dao.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="//www.springframework.org/schema/beans"
       xmlns:xsi="//www.w3.org/2001/XMLSchema-instance"
       xmlns:context="//www.springframework.org/schema/context"
       xsi:schemaLocation="//www.springframework.org/schema/beans
       //www.springframework.org/schema/beans/spring-beans.xsd
       //www.springframework.org/schema/context
       //www.springframework.org/schema/context/spring-context.xsd">

    <!-- 配置整合mybatis -->
    <!-- 1.关联数据库文件 -->
    <context:property-placeholder location="classpath:database.properties"/>

    <!-- 2.数据库连接池 -->
    <!--数据库连接池
        dbcp 半自动化操作 不能自动连接
        c3p0 自动化操作（自动的加载配置文件 并且设置到对象里面）
    -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <!-- 配置连接池属性 -->
        <property name="driverClass" value="${jdbc.driver}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>

        <!-- c3p0连接池的私有属性 -->
        <property name="maxPoolSize" value="30"/>
        <property name="minPoolSize" value="10"/>
        <!-- 关闭连接后不自动commit -->
        <property name="autoCommitOnClose" value="false"/>
        <!-- 获取连接超时时间 -->
        <property name="checkoutTimeout" value="10000"/>
        <!-- 当获取连接失败重试次数 -->
        <property name="acquireRetryAttempts" value="2"/>
    </bean>

    <!-- 3.配置SqlSessionFactory对象 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 注入数据库连接池 -->
        <property name="dataSource" ref="dataSource"/>
        <!-- 配置MyBaties全局配置文件:mybatis-config.xml -->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
    </bean>

    <!-- 4.配置扫描Dao接口包，动态实现Dao接口注入到spring容器中 -->
    <!--解释 ：//www.cnblogs.com/jpfss/p/7799806.html-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- 注入sqlSessionFactory -->
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <!-- 给出需要扫描Dao接口包 -->
        <property name="basePackage" value="com.cc.dao"/>
    </bean>
</beans>

Spring整合service层

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="//www.springframework.org/schema/beans"
       xmlns:xsi="//www.w3.org/2001/XMLSchema-instance"
       xmlns:context="//www.springframework.org/schema/context"
       xsi:schemaLocation="//www.springframework.org/schema/beans
   //www.springframework.org/schema/beans/spring-beans.xsd
   //www.springframework.org/schema/context
   //www.springframework.org/schema/context/spring-context.xsd">
    <!-- 扫描service相关的bean -->
    <context:component-scan base-package="com.cc.service" />
    <!--AdminServiceImpl注入到IOC容器中-->
    <bean id="AdminServiceImpl" class="com.cc.service.AdminServiceImpl">
        <property name="adminMapper" ref="adminMapper"/>
    </bean>
    <!--UserServiceImpl注入到IOC容器中-->
    <bean id="UserServiceImpl" class="com.cc.service.UserServiceImpl">
        <property name="userMapper" ref="userMapper"/>
    </bean>
    <!-- 配置事务管理器 -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!-- 注入数据库连接池 -->
        <property name="dataSource" ref="dataSource" />
    </bean>
</beans>

SpringMVC层

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="//xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="//www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="//xmlns.jcp.org/xml/ns/javaee //xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <!--DispatcherServlet-->
    <servlet>
        <servlet-name>DispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <!--一定要注意:我们这里加载的是总的配置文件，之前被这里坑了！-->
            <param-value>classpath:applicationContext.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>DispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <!--encodingFilter-->
    <filter>
        <filter-name>encodingFilter</filter-name>
        <filter-class>
            org.springframework.web.filter.CharacterEncodingFilter
        </filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>utf-8</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!--Session过期时间-->
    <session-config>
        <session-timeout>15</session-timeout>
    </session-config>
</web-app>

spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="//www.springframework.org/schema/beans"
       xmlns:xsi="//www.w3.org/2001/XMLSchema-instance"
       xmlns:context="//www.springframework.org/schema/context"
       xmlns:mvc="//www.springframework.org/schema/mvc"
       xsi:schemaLocation="//www.springframework.org/schema/beans
   //www.springframework.org/schema/beans/spring-beans.xsd
   //www.springframework.org/schema/context
   //www.springframework.org/schema/context/spring-context.xsd
   //www.springframework.org/schema/mvc
   //www.springframework.org/schema/mvc/spring-mvc.xsd">
    <!-- 配置SpringMVC -->
    <!-- 1.开启SpringMVC注解驱动 -->
    <mvc:annotation-driven>
    </mvc:annotation-driven>
    <!-- 2.静态资源默认servlet配置-->
    <mvc:default-servlet-handler/>
    <!-- 3.配置jsp 显示ViewResolver视图解析器 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
        <property name="prefix" value="/WEB-INF/jsp/" />
        <property name="suffix" value=".jsp" />
    </bean>
    <!-- 日期转换 -->
    <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter">
        <property name="webBindingInitializer">
            <bean class="com.cc.utils.convertDate"/>
        </property>
    </bean>
    <!-- 4.扫描web相关的bean -->
    <context:component-scan base-package="com.cc.controller" />

</beans>

Spring配置整合文件，applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="//www.springframework.org/schema/beans"
       xmlns:xsi="//www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="//www.springframework.org/schema/beans
       //www.springframework.org/schema/beans/spring-beans.xsd">
    <!--3. 创建SqlSessionFactoryBean，注入连接池-->
    <bean class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <import resource="classpath:spring/spring-dao.xml"/>
    <import resource="classpath:spring/spring-service.xml"/>
    <import resource="classpath:spring/spring-mvc.xml"/>

</beans>

Controller&视图层

UserController

package com.cc.controller;

import com.cc.pojo.User;
import com.cc.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

@Controller
@RequestMapping("/user")
public class UserController {

    @Autowired
    @Qualifier("UserServiceImpl")
    private UserService userService;

    @RequestMapping("/toLogin")
    public String toLoginUser(Model model,
                              HttpServletRequest request
                              ) {
        try {
            String username = request.getParameter("username");
            String password = request.getParameter("password");

            System.out.println(username+"  "+password);
            User user =new User();
            user.setUsername(username);
            user.setPassword(password);
            User users = userService.userLogin(user);
            if (users.getId() > 0) {
//            model.addAttribute("user", users);
                model.addAttribute("user", users);
                return "userMain";
            }
        } catch (Exception e) {
            model.addAttribute("error","Wrong username or password!");
            return "redirect:/";
        }
        return "redirect:/";
    }

    @ResponseBody
    @RequestMapping("/toLogintest")
    public String userLogin(String name,String pwd) {
        String msg = "Wrong username or password!";
        //模拟数据库中存在数据
        if ((name != null) && (pwd != null)) {
            //        从数据库检索是否存在该用户
            User user = new User();
            user.setUsername(name);
            user.setPassword(pwd);
            try {
                User users = userService.userLogin(user);
                if (users.getUsername().equals(name) && users.getPassword().equals(pwd)) {
                    msg = "Login Success";
                }
                return msg;
            }catch (Exception e){}
            return msg; //g
        }
        return msg;
    }

    @RequestMapping("/userBuy")
    public String userBuyCard(Model model,int id) throws ParseException {
        User user = userService.queryUserById(id);
        System.out.println(user);
        model.addAttribute("user",user );
        return "userMall";
    }
    @RequestMapping("/userMianPage")
    public String userMianPage(Model model,int id) throws ParseException {
        User user = userService.queryUserById(id);
        System.out.println(user);
        model.addAttribute("user",user );
        return "userMain";
    }
//    跳转注册页面
    @RequestMapping("/toUserRegister")
    public String toAddPaper() {
        return "register";
    }
    //注册
    @RequestMapping("/userRegister")
    public String registerUser(User user) throws ParseException {
        SimpleDateFormat sp = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
        String date = sp.format(new Date());
        user.setBegintime(date);
        user.setEndtime(date);
        user.setRemainday(0);
        userService.userRegister(user);
        return "redirect:/user/toLogin";
    }
}

AdminController

package com.cc.controller;

import com.cc.pojo.Admin;
import com.cc.pojo.User;
import com.cc.service.AdminService;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.List;

@Controller
@RequestMapping("/admin")
public class AdminController {
    @Autowired
    @Qualifier("AdminServiceImpl")
    private AdminService adminService;
    
    @RequestMapping("/toAddUser")
    public String toAddPaper() {
        return "register";
    }

    @RequestMapping("/addUser")
    public String addPaper(User user) throws ParseException {
        System.out.println(user);
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); // 日期格式
        Date date = dateFormat.parse(user.getBegintime()); // 指定日期
        Calendar cl = Calendar.getInstance();
        cl.setTime(date);
        cl.add(Calendar.DATE, user.getRemainday());
        String temp = "";
        temp = dateFormat.format(cl.getTime());
        user.setEndtime(temp);
        adminService.addUser(user);
        return "redirect:/admin/findByPage";
    }
    @RequestMapping("/toUpdateUser")
    public String toUpdateUser(Model model, int id) {
        User user = adminService.queryUserById(id);
        System.out.println(user);
        model.addAttribute("user",user );
        return "updateUser";
    }

    @RequestMapping("/updateUser")
    public String updateUser(Model model, User user) throws ParseException {
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); // 日期格式
        Date date = dateFormat.parse(user.getBegintime()); // 指定日期
        Calendar cl = Calendar.getInstance();
        cl.setTime(date);
        int allday = user.getRemainday()+user.getAddday();
        cl.add(Calendar.DATE, allday);
        String temp = "";
        temp = dateFormat.format(cl.getTime());
        user.setEndtime(temp);
        user.setRemainday(allday);
        adminService.updateUser(user);
        User users = adminService.queryUserById(user.getId());
        model.addAttribute("user", users);
        return "redirect:/admin/findByPage";
    }
    @RequestMapping("/del/{userId}")
    public String deleteBook(@PathVariable("userId") int id) {
        adminService.deleteUserById(id);
        return "redirect:/admin/findByPage";
    }
    @RequestMapping("/toaLogin")
    public String toaLogin() {
        return "/aLogin";
    }
    @RequestMapping("/aLogin")
    public String toLoginUser(Admin admin) {
        System.out.println(admin.getUsername()+admin.getPassword());
        try {
            Admin admins = adminService.adminLogin(admin);
            if (admins.getId() > 0) {
//            model.addAttribute("user", users);
                return "redirect:/admin/findByPage";
            }
        }catch (Exception e){
            return "/aLogin";
        }
        return "/aLogin";
    }
@RequestMapping("/findAll")
public ModelAndView findAll() {
    //1.1 调用service
    List<User> list = adminService.findAll();
    //1.2 返回结果
    ModelAndView mv = new ModelAndView();
    mv.setViewName("order-list");
    mv.addObject("list", list);
    return mv;
}

    @RequestMapping("/findByPage")
    public String findByPage(Model model,
            @RequestParam(defaultValue = "1") int pageNum,
            @RequestParam(defaultValue = "11") int pageSize) {
        PageInfo<User> pageInfo = adminService.findByPage(pageNum, pageSize);
//        PageInfo pageInfo = adminService.findByPage(pageNum, pageSize);
        //1.1 调用service
        //1.2 返回结果
        model.addAttribute("list", pageInfo.getList());
        model.addAttribute("pageInfo", pageInfo);
        return "allUserPage";
    }
    @RequestMapping("/searchUser")
    public String searchUser(Model model, String name) {
        try {
            User user = adminService.queryUserByName(name);
            System.out.println(user);
            model.addAttribute("user", user);
            if (user.getName() == null) {
                return "redirect:/admin/findByPage";
            }
            return "updateUser";
        }catch (Exception e){
            return "redirect:/admin/findByPage";
        }
    }
//    商城
@RequestMapping("/buy")
public String buyCard() throws ParseException {
    return "mall";
}

}

视图层

详情见GitHub

拓展与展望

以下功能在以后可拓展开发

结束与总结

这个小Demo做了五六天,分页那里卡了接近两天，无数的坑等着踩。

期间也体会到了编程的乐趣，每天晚上都肝的快快乐乐。

所有代码放在GitHub供大家交流学习。

今天母亲节呀，祝我妈妈母亲节快乐！晚安！

Tags: JAVA Mix mybatis MySQL SpringMVC

基于SSM的健身房管理系统

基于SSM的健身房管理系统

项目展示

项目环境

项目详情

设计数据库

设计要实现的功能

制作前端页面Demo

环境配置

基本步骤

POJO Mapper Services的编写

POJO

Mapper

Spring层

SpringMVC层

Controller&视图层

视图层

拓展与展望

结束与总结

VirMach 便宜 VPS

QNews

基于SSM的健身房管理系统

基于SSM的健身房管理系统

项目展示

项目环境

项目详情

设计数据库

设计要实现的功能

制作前端页面Demo

环境配置

基本步骤

POJO Mapper Services的编写

POJO

Mapper

Spring层

SpringMVC层

Controller&视图层

视图层

拓展与展望

结束与总结

分享此文：

Related Posts

PHP流程控制语句

Android studio如何连接三星手机

MySQL 入门（3）：事务隔离

董明珠快手直播带货首秀：30分钟破亿！

VirMach 便宜 VPS

QNews

熱門文章

熱門搜尋