devbox
数据可视化灵魂
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

（简易SSM框架搭建）物流查询系统_ssm框架实现物流网站

作者：数据可视化灵魂 | 2024-01-30 19:57:58

赞

踩

ssm框架实现物流网站

ssm框架原理是：将Spring、SpringMVC、MyBatis整合在一起，作为数据源较简单的web项目的框架。 它有效规避servlet的繁杂加载驱动等一系列程序，选用MyBatis进行与数据库的连接。

目录

首先：新建工程Maven。

2.在pom.xml文件中进行引用和下载，（导包的过程） 

 3.Mybatis的配置文件db.properties 和log4j.properties(日志)

 4.user类的创建（关联的表都创建相关类）

 5.userMapper.xml文件配置

（主要操作，如果字段名错误，就不能连接到数据库）

 6.配置其他xml文件：

7、数据库

​编辑 ​编辑

8. userMapper

 9.service：接口和实现类

 10.前端界面：

 11.controller

 12.关于加密：MD5

 13.关于分页部分：

  1. 首先：新建工程Maven。

2.在pom.xml文件中进行引用和下载，（导包的过程） 

  1. <?xml version="1.0" encoding="UTF-8"?>
  2.  
  3. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5.   <modelVersion>4.0.0</modelVersion>
  6.  
  7.   <groupId>com.hqyj.poison</groupId>
  8.   <artifactId>ssm</artifactId>
  9.   <version>1.0-SNAPSHOT</version>
  10.   <packaging>war</packaging>
  11.  
  12.   <name>ssm Maven Webapp</name>
  13.   <!-- FIXME change it to the project's website -->
  14.   <url>http://www.example.com</url>
  15.  
  16.   <properties>
  17.     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  18.     <maven.compiler.source>1.7</maven.compiler.source>
  19.     <maven.compiler.target>1.7</maven.compiler.target>
  20.   </properties>
  21.  
  22.   <dependencies>
  23.     <dependency>
  24.       <groupId>junit</groupId>
  25.       <artifactId>junit</artifactId>
  26.       <version>4.11</version>
  27.       <scope>test</scope>
  28.     </dependency>
  29.  
  30.     <!--spring -->
  31.     <dependency>
  32.       <groupId>org.springframework</groupId>
  33.       <artifactId>spring-context</artifactId>
  34.       <version>4.3.13.RELEASE</version>
  35.     </dependency>
  36.     <!--事务-->
  37.     <dependency>
  38.       <groupId>org.springframework</groupId>
  39.       <artifactId>spring-tx</artifactId>
  40.       <version>4.3.13.RELEASE</version>
  41.     </dependency>
  42.  
  43.     <!--spring  jdbc-->
  44.     <dependency>
  45.       <groupId>org.springframework</groupId>
  46.       <artifactId>spring-jdbc</artifactId>
  47.       <version>4.3.13.RELEASE</version>
  48.     </dependency>
  49.     <!--配置webmvc -->
  50.     <dependency>
  51.       <groupId>org.springframework</groupId>
  52.       <artifactId>spring-webmvc</artifactId>
  53.       <version>4.3.13.RELEASE</version>
  54.     </dependency>
  55.  
  56.     <!--配置切面的jar包 -->
  57.     <dependency>
  58.       <groupId>org.springframework</groupId>
  59.       <artifactId>spring-aspects</artifactId>
  60.       <version>4.3.13.RELEASE</version>
  61.     </dependency>
  62.  
  63.     <!-- https://mvnrepository.com/artifact/aopalliance/aopalliance -->
  64.     <dependency>
  65.       <groupId>aopalliance</groupId>
  66.       <artifactId>aopalliance</artifactId>
  67.       <version>1.0</version>
  68.     </dependency>
  69.  
  70.     <!--mybatis，用来加载SqlSessionFactoryBean和MapperScannerConfigurer -->
  71.     <dependency>
  72.       <groupId>org.mybatis</groupId>
  73.       <artifactId>mybatis</artifactId>
  74.       <version>3.5.0</version>
  75.     </dependency>
  76.     <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
  77.     <!--spring整合mybatis的依赖包-->
  78.     <dependency>
  79.       <groupId>org.mybatis</groupId>
  80.       <artifactId>mybatis-spring</artifactId>
  81.       <version>1.3.2</version>
  82.     </dependency>
  83.  
  84.     <!--  mybatis分页需要的jar  -->
  85.     <dependency>
  86.       <groupId>com.github.pagehelper</groupId>
  87.       <artifactId>pagehelper</artifactId>
  88.       <version>5.1.2</version>
  89.     </dependency>
  90.     <!-- 连接池，用来加载DruidDataSource-->
  91.     <dependency>
  92.       <groupId>com.alibaba</groupId>
  93.       <artifactId>druid</artifactId>
  94.       <version>1.0.9</version>
  95.     </dependency>
  96.     <!--json处理工具包 -->
  97.     <dependency>
  98.       <groupId>com.fasterxml.jackson.core</groupId>
  99.       <artifactId>jackson-databind</artifactId>
  100.       <version>2.9.0</version>
  101.     </dependency>
  102.     <!--日志文件 -->
  103.     <dependency>
  104.       <groupId>org.slf4j</groupId>
  105.       <artifactId>slf4j-log4j12</artifactId>
  106.       <version>1.7.22</version>
  107.     </dependency>
  108.     <!--servlet相关jar-->
  109.     <dependency>
  110.       <groupId>javax.servlet</groupId>
  111.       <artifactId>servlet-api</artifactId>
  112.       <version>2.5</version>
  113.     </dependency>
  114.     <dependency>
  115.       <groupId>javax.servlet</groupId>
  116.       <artifactId>jsp-api</artifactId>
  117.       <version>2.0</version>
  118.     </dependency>
  119.    
  120.     <dependency>
  121.       <groupId>mysql</groupId>
  122.       <artifactId>mysql-connector-java</artifactId>
  123.       <version>5.1.38</version>
  124.     </dependency>
  125.  
  126.     <!-- https://mvnrepository.com/artifact/org.apache.shiro/shiro-all -->
  127.     <dependency>
  128.       <groupId>org.apache.shiro</groupId>
  129.       <artifactId>shiro-all</artifactId>
  130.       <version>1.3.2</version>
  131.     </dependency>
  132.  
  133.     <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
  134.     <dependency>
  135.       <groupId>org.projectlombok</groupId>
  136.       <artifactId>lombok</artifactId>
  137.       <version>1.18.12</version>
  138.       <scope>provided</scope>
  139.     </dependency>
  140.  
  141.   </dependencies>
  142.  
  143.   <build>
  144.     <finalName>ssm</finalName>
  145.     <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
  146.       <plugins>
  147.         <plugin>
  148.           <artifactId>maven-clean-plugin</artifactId>
  149.           <version>3.1.0</version>
  150.         </plugin>
  151.         <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
  152.         <plugin>
  153.           <artifactId>maven-resources-plugin</artifactId>
  154.           <version>3.0.2</version>
  155.         </plugin>
  156.         <plugin>
  157.           <artifactId>maven-compiler-plugin</artifactId>
  158.           <version>3.8.0</version>
  159.         </plugin>
  160.         <plugin>
  161.           <artifactId>maven-surefire-plugin</artifactId>
  162.           <version>2.22.1</version>
  163.         </plugin>
  164.         <plugin>
  165.           <artifactId>maven-war-plugin</artifactId>
  166.           <version>3.2.2</version>
  167.         </plugin>
  168.         <plugin>
  169.           <artifactId>maven-install-plugin</artifactId>
  170.           <version>2.5.2</version>
  171.         </plugin>
  172.         <plugin>
  173.           <artifactId>maven-deploy-plugin</artifactId>
  174.           <version>2.8.2</version>
  175.         </plugin>
  176.       </plugins>
  177.     </pluginManagement>
  178.   </build>
  179. </project>

 3.Mybatis的配置文件db.properties 和log4j.properties(日志)

  1. jdbc.driverClassName=com.mysql.jdbc.Driver
  2. jdbc.url=jdbc:mysql://127.0.0.1:3306/ssm?useUnicode=true&characterEncoding=utf8
  3. jdbc.username=root
  4. jdbc.password=123456
  5. maxActive:20
  6. initialSize:1
  7. maxWait:60000
  8. minIdle:10
  1. log4j.rootLogger=DEBUG, Console
  2. #Console
  3. log4j.appender.Console=org.apache.log4j.ConsoleAppender
  4. log4j.appender.Console.layout=org.apache.log4j.PatternLayout
  5. log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
  6. log4j.logger.java.sql.ResultSet=INFO
  7. log4j.logger.org.apache=INFO
  8. log4j.logger.java.sql.Connection=DEBUG
  9. log4j.logger.java.sql.Statement=DEBUG
  10. log4j.logger.java.sql.PreparedStatement=DEBUG

 4.user类的创建（关联的表都创建相关类）

@Data注解可以省略get、set方法，但是使用需要下载lombok插件。

关于@JsonFormat注解，跳转连接如下：jackSon中@JsonFormat注解使用详解_灬叛逆丿文的博客-CSDN博客_jsonformat注解原理

  1. package com.hqyj.poison.entity;
  2.  
  3. import com.fasterxml.jackson.annotation.JsonFormat;
  4. import lombok.Data;
  5. import org.springframework.format.annotation.DateTimeFormat;
  6.  
  7. import java.util.Date;
  8. import java.util.List;
  9.  
  10. @Data
  11. public class User {
  12.     private Integer userId;
  13.     private String userName;
  14.     private String userPwd;
  15.     private String userSex;
  16.     private Integer userAge;
  17.     private String userTel;
  18.     @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
  19.     @DateTimeFormat(pattern = "yyyy-MM-dd")
  20.     private Date userBirthday;
  21.     private String userEmail;
  22.     private List<Role> roleList;
  23. }

 5.userMapper.xml文件配置

（主要操作，如果字段名错误，就不能连接到数据库）

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <!--以当前mapper接口的完全限定名作为命名空间-->
  6. <mapper namespace="com.hqyj.poison.mapper.UserMapper">
  7.     <resultMap id="userMap" type="User">
  8. <!--colum是数据库的字段名；property是java类中的属性名。-->
  9.         <id column="user_id" property="userId"></id>
  10.         <result column="user_name" property="userName"></result>
  11.         <result column="user_tel" property="userTel"></result>
  12.         <result column="user_age" property="userAge"></result>
  13.         <result column="user_sex" property="userSex"></result>
  14.         <result column="user_password" property="userPwd"></result>
  15.         <result column="user_email" property="userEmail"></result>
  16.         <result column="user_birthday" property="userBirthday"></result>
  17.     </resultMap>
  18.  
  19.     <resultMap id="userMap1" type="User">
  20.         <id column="id" property="userId"></id>
  21.         <result column="user_name" property="userName"></result>
  22.         <result column="user_tel" property="userTel"></result>
  23.         <result column="user_age" property="userAge"></result>
  24.         <result column="user_sex" property="userSex"></result>
  25.         <result column="user_password" property="userPwd"></result>
  26.         <result column="user_email" property="userEmail"></result>
  27.         <result column="user_birthday" property="userBirthday"></result>
  28.         <collection property="roleList" ofType="Role">
  29.             <id column="role_id" property="roleId"></id>
  30.             <result column="role_name" property="roleName"></result>
  31.         </collection>
  32.     </resultMap>
  33.     <resultMap id="orderMap" type="Order">
  34.         <id column="order_id" property="orderId"></id>
  35.         <result column="order_no" property="orderNo"></result>
  36.         <result column="order_people" property="orderPeople"></result>
  37.         <result column="order_freight" property="orderFreight"></result>
  38.         <result column="order_tel" property="orderTel"></result>
  39.         <result column="give_method" property="giveMethod"></result>
  40.         <result column="order_time" property="orderTime"></result>
  41.     </resultMap>
  42.  
  43.                         <!--    订单表-->
  44.     <!--    查询订单id与方法名相一致-->
  45.     <select id="selectOrderByQueryBean" resultMap="orderMap">
  46.         select * from orders
  47.         <where>
  48.             <if test="orderTel!=null and orderTel!=''"> and order_tel =#{orderTel} </if>
  49.         </where>
  50.         limit #{startIndex},#{pageSize}
  51.     </select>
  52. <!--订单总数-->
  53.     <select id="selectCountToOrder" resultType="int">
  54.         select count(*) from orders
  55.         <where>
  56.             <if test="orderTel!=null and orderTel!=''"> and order_tel =#{orderTel} </if>
  57.         </where>
  58.     </select>
  59. <!--删除订单-->
  60.     <delete id="deleteOrderById"> delete from orders where order_id = #{orderId} </delete>
  61. <!--    修改订单-->
  62.     <update id="updateOrder"> update orders set
  63.     order_people = #{orderPeople}, order_freight = #{orderFreight}, order_tel = #{orderTel},
  64.     give_method = #{giveMethod}, order_time = #{orderTime}
  65.     where order_id = #{orderId}
  66.  </update>
  67. <!--    按编号查询-->
  68.     <select id="selectOrderByNo" resultMap="orderMap">
  69.         select * from orders where order_no = #{orderNo}
  70.     </select>
  71. <!--增加订单-->
  72.     <insert id="insertOrder">
  73.         insert into orders
  74.         <trim prefix="(" suffix=")" suffixOverrides=",">
  75.             <if test="orderPeople!=null and orderPeople!=''">
  76.                 order_people,
  77.             </if>
  78.             <if test="orderNo!=null and orderNo!=''">
  79.                 order_no,
  80.             </if>
  81.             <if test="orderFreight!=null and orderFreight!=''">
  82.                 order_freight,
  83.             </if>
  84.             <if test="orderTel!=null and orderTel!=''">
  85.                 order_tel,
  86.             </if>
  87.             <if test="giveMethod!=null and giveMethod!=''">
  88.                 give_method,
  89.             </if>
  90.             <if test="orderTime!=null">
  91.                 order_time,
  92.             </if>
  93.         </trim>
  94.         values
  95.         <trim prefix="(" suffix=")" suffixOverrides=",">
  96.             <if test="orderPeople!=null and orderPeople!=''">
  97.                 #{orderPeople},
  98.             </if>
  99.             <if test="orderNo!=null and orderNo!=''">
  100.                 #{orderNo},
  101.             </if>
  102.             <if test="orderFreight!=null and orderFreight!=''">
  103.                 #{orderFreight},
  104.             </if>
  105.             <if test="orderTel!=null and orderTel!=''">
  106.                 #{orderTel},
  107.             </if>
  108.             <if test="giveMethod!=null and giveMethod!=''">
  109.                 #{giveMethod},
  110.             </if>
  111.             <if test="orderTime!=null">
  112.                 #{orderTime},
  113.             </if>
  114.         </trim>
  115.     </insert>
  116.  
  117.  
  118.                         <!--    用户表-->
  119.     <select id="selectUser" resultMap="userMap"> select * from user where user_name=#{userName} </select>
  120. <!--    查询权限-->
  121.     <select id="selectUserAndRole" resultMap="userMap1"> SELECT*FROM user u,user_role m, role r where u.user_id = m.user_id and m.role_id = r.role_id and u.user_name = #{userName} </select>
  122. <!--    查询用户-->
  123.     <select id="selectUserByQueryBean" resultMap="userMap">
  124.         select * from user
  125.         <where>
  126.             <if test="userName!=null and userName!=''"> and user_name like concat(#{userName},"%") </if>
  127.             <if test="userTel!=null and userTel!=''"> and user_tel like concat(#{userTel},"%") </if>
  128.         </where>
  129.         limit #{startIndex},#{pageSize}
  130.     </select>
  131. <!--    查询账号密码是否一致-->
  132.     <select id="queryUsersByIdAndPwd" resultMap="userMap">
  133.         select  * from user where user_name = #{userName} and user_password = #{userPwd}
  134.     </select>
  135. <!--    修改密码-->
  136.     <update id="updateUserPwdByName">
  137.         update user set user_password = #{userPwd} where user_name = #{userName}
  138.     </update>
  139. <!--    统计用户数量-->
  140.     <select id="selectCount" resultType="int">
  141.         select count(*) from user
  142.         <where>
  143.             <if test="userName!=null and userName!=''"> and user_name like concat(#{userName},"%") </if>
  144.             <if test="userTel!=null and userTel!=''"> and user_tel like concat(#{userTel},"%") </if>
  145.         </where>
  146.     </select>
  147. <!--    删除用户-->
  148.     <delete id="deleteUserById"> delete from user where user_id = #{userId} </delete>
  149. <!--    修改用户-->
  150.     <update id="updateUser"> update user set user_name = #{userName}, user_sex = #{userSex}, user_tel = #{userTel}, user_age = #{userAge}, user_birthday = #{userBirthday}, user_email = #{userEmail} where user_id = #{userId} </update>
  151.  
  152.  
  153. <!--    注册-->
  154.     <insert id="registered">
  155.         insert into user
  156.         <trim prefix="(" suffix=")" suffixOverrides=",">
  157.             <if test="userName!=null and userName!=''">
  158.                 user_name,
  159.             </if>
  160.             <if test="userPwd!=null and userPwd!=''">
  161.                 user_password,
  162.             </if>
  163.             <if test="userTel!=null and userTel!=''">
  164.                 user_tel,
  165.             </if>
  166.             <if test="userAge!=null and userAge!=''">
  167.                 user_age,
  168.             </if>
  169.             <if test="userSex!=null and userSex!=''">
  170.                 user_sex,
  171.             </if>
  172.             <if test="userBirthday!=null">
  173.                 user_birthday,
  174.             </if>
  175.             <if test="userEmail!=null and userEmail!=''">
  176.                 user_email,
  177.             </if>
  178.         </trim>
  179.         values
  180.         <trim prefix="(" suffix=")" suffixOverrides=",">
  181.             <if test="userName!=null and userName!=''">
  182.                 #{userName},
  183.             </if>
  184.             <if test="userPwd!=null and userPwd!=''">
  185.                 #{userPwd},
  186.             </if>
  187.             <if test="userTel!=null and userTel!=''">
  188.                 #{userTel},
  189.             </if>
  190.             <if test="userAge!=null and userAge!=''">
  191.                 #{userAge},
  192.             </if>
  193.             <if test="userSex!=null and userSex!=''">
  194.                 #{userSex},
  195.             </if>
  196.             <if test="userBirthday!=null">
  197.                 #{userBirthday},
  198.             </if>
  199.             <if test="userEmail!=null and userEmail!=''">
  200.                 #{userEmail},
  201.             </if>
  202.         </trim>
  203.     </insert>
  204. </mapper>

 6.配置其他xml文件：

applicationContext.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xmlns:aop="http://www.springframework.org/schema/aop"
  6.        xsi:schemaLocation="
  7.         http://www.springframework.org/schema/beans
  8.         http://www.springframework.org/schema/beans/spring-beans.xsd
  9.         http://www.springframework.org/schema/context
  10.         http://www.springframework.org/schema/context/spring-context.xsd
  11.         http://www.springframework.org/schema/aop
  12.         http://www.springframework.org/schema/aop/spring-aop.xsd
  13. ">
  14.     <!--开启注解扫描-->
  15.     <context:component-scan base-package="com.hqyj.poison.*"/>
  16.  
  17.     <!--读取properties文件-->
  18.     <context:property-placeholder location="classpath:properties/*.properties"/>
  19.     <!-- 配置druid数据源 -->
  20.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  21.         <property name="driverClassName" value="${jdbc.driverClassName}" />
  22.         <property name="url" value="${jdbc.url}" />
  23.         <property name="username" value="${jdbc.username}" />
  24.         <property name="password" value="${jdbc.password}" />
  25.         <!-- 最大并发连接数 -->
  26.         <property name="maxActive" value="${maxActive}" />
  27.         <!-- 初始化连接数量 -->
  28.         <property name="initialSize" value="${initialSize}" />
  29.         <!-- 最小空闲连接数 -->
  30.         <property name="minIdle" value="${minIdle}" />
  31.         <!-- 配置获取连接等待超时的时间 -->
  32.         <property name="maxWait" value="${maxWait}" />
  33.     </bean>
  34.  
  35.     <import resource="springMybatis.xml"></import>
  36.     <import resource="springTransaction.xml"></import>
  37.     <import resource="springShiro.xml"></import>
  38. </beans>

 springmvc.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:mvc="http://www.springframework.org/schema/mvc"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xmlns:aop="http://www.springframework.org/schema/aop"
  6.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  7.        xsi:schemaLocation="
  8.         http://www.springframework.org/schema/beans
  9.         http://www.springframework.org/schema/beans/spring-beans.xsd
  10.         http://www.springframework.org/schema/context
  11.         http://www.springframework.org/schema/context/spring-context.xsd
  12.         http://www.springframework.org/schema/aop
  13.         http://www.springframework.org/schema/aop/spring-aop.xsd
  14.         http://www.springframework.org/schema/mvc
  15.         http://www.springframework.org/schema/mvc/spring-mvc.xsd">
  16.  
  17.     <!--开启包扫描-->
  18.     <context:component-scan base-package="com.hqyj.poison.*"></context:component-scan>
  19.     <!--开启mvc的注解驱动-->
  20.     <mvc:annotation-driven></mvc:annotation-driven>
  21.  
  22.     <!--静态资源放行-->
  23.     <mvc:resources mapping="/static/**" location="/static/"></mvc:resources>
  24.  
  25.     <!--配置mvc的视图解析器-->
  26.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  27.         <property name="prefix" value="../view/"></property>
  28.         <property name="suffix" value=".jsp"></property>
  29.     </bean>
  30.     <!-- 开启shiro注解支持 -->
  31.     <bean class="org.apache.shiro.spring.security.interceptor.AuthorizationAttributeSourceAdvisor">
  32.         <property name="securityManager" ref="securityManager" />
  33.     </bean>
  34.     <!-- 开启aop，对类代理 -->
  35.     <aop:config proxy-target-class="true"/>
  36.  
  37. </beans>

springMybatis.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xmlns:aop="http://www.springframework.org/schema/aop"
  6.        xsi:schemaLocation="
  7.         http://www.springframework.org/schema/beans
  8.         http://www.springframework.org/schema/beans/spring-beans.xsd
  9.         http://www.springframework.org/schema/context
  10.         http://www.springframework.org/schema/context/spring-context.xsd
  11.         http://www.springframework.org/schema/aop
  12.         http://www.springframework.org/schema/aop/spring-aop.xsd
  13. ">
  14.  
  15. <!--配置sqlsessionFactory-->
  16.     <bean class="org.mybatis.spring.SqlSessionFactoryBean">
  17.         <!-- 数据源 -->
  18.         <property name="dataSource" ref="dataSource"></property>
  19.         <!--配置映射文件的路径-->
  20.         <property name="mapperLocations" value="classpath:mapper/*.xml"/>
  21.         <!--配置别名-->
  22.         <property name="typeAliasesPackage" value="com.hqyj.poison.entity"></property>
  23.     </bean>
  24.  
  25.     <!--
  26.     接口开发,扫描 com.hqyj.poison.dao包 ，写在此包下的接口即可被扫描到
  27.     通过sqlsessionFactory得到sqlSession
  28.     sqlSession.getMapper(UserMapper.class);(帮我们做了，不用再单独配置)
  29.     -->
  30.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  31.         <property name="basePackage" value="com.hqyj.poison.mapper"/>
  32.     </bean>
  33. </beans>

 springShiro.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3. 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
  4. 	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
  5. 	xsi:schemaLocation="http://www.springframework.org/schema/beans 
  6.     http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
  7.     http://www.springframework.org/schema/context
  8.     http://www.springframework.org/schema/context/spring-context-4.3.xsd
  9.     http://www.springframework.org/schema/aop
  10.     http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
  11.     http://www.springframework.org/schema/tx 
  12.     http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
  13.    	<!-- shiro相关配置 -->
  14. 	
  15. 	<!-- 配置自定义数据源myRealm -->
  16. 	<bean id="myRealm" class="com.hqyj.poison.realm.MyRealm">
  17. <!--		&lt;!&ndash; 注入凭证匹配 &ndash;&gt;-->
  18. 		<property name="credentialsMatcher" ref="credentialsMatcher"></property>
  19. 	</bean>
  20.  
  21. 	<!-- 凭证匹配器 -->
  22. 	<bean id="credentialsMatcher" class="org.apache.shiro.authc.credential.HashedCredentialsMatcher">
  23. 		<property name="hashAlgorithmName" value="md5" />
  24. 		<property name="hashIterations" value="1024" />
  25. 	</bean>
  26. 	<!-- 配置安全管理器 -->
  27. 	<bean id="securityManager" class="org.apache.shiro.web.mgt.DefaultWebSecurityManager">
  28. 		<property name="realm" ref="myRealm"></property>
  29. 	</bean>
  30.  
  31. 	<!-- 配置authc，默认表单的用户名和密码必须是：username，password -->
  32. <!--	<bean id="authc" class="org.apache.shiro.web.filter.authc.FormAuthenticationFilter">-->
  33. <!--		<property name="usernameParam" value="userName"></property>-->
  34. <!--		<property name="passwordParam" value="userPassword"></property>-->
  35. <!--	</bean>-->
  36.  
  37. 	<!-- 配置shiro过滤器 -->
  38. 	<bean id="shiroFilter" class="org.apache.shiro.spring.web.ShiroFilterFactoryBean">
  39. 		<property name="securityManager" ref="securityManager" />
  40. 		<!-- loginUrl认证提交地址，如果没有认证将会请求此地址进行认证，请求此地址将由formAuthenticationFilter进行表单认证 -->
  41. 		<property name="loginUrl" value="/sys/gologin" />
  42. 		<property name="successUrl" value="/sys/index"></property>
  43. 		<!-- 授权不通过（不具备相应权限） 走该地址-->
  44. 		<property name="unauthorizedUrl" value="/sys/error"></property>
  45.  
  46. 		<!-- 过虑器链定义，从上向下顺序执行，一般将/**放在最下边 anon表示放行-->
  47. 		<property name="filterChainDefinitions">
  48. 			<value>
  49. 				/new=anon
  50. 				/sys/login=anon
  51. 				/sys/gologin=anon
  52. 				/sys/error=anon
  53. 				/sys/register=anon
  54. 				/sys/goregister=anon
  55. 				/sys/loginOut=logout
  56. 				/static/**=anon
  57. 				<!-- user表示身份认证通过或通过记住我认证通过的可以访问 -->
  58. <!--				/**=user-->
  59. 				<!-- 所有请求都要认证 -->
  60. 				 /**=authc
  61. 			</value>
  62. 		</property>
  63. 	</bean>
  64.    	
  65. </beans>

springTransaction.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:aop="http://www.springframework.org/schema/aop"
  5.        xmlns:tx="http://www.springframework.org/schema/tx"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  7.        http://www.springframework.org/schema/beans/spring-beans.xsd
  8.        http://www.springframework.org/schema/aop
  9.        http://www.springframework.org/schema/aop/spring-aop.xsd
  10.        http://www.springframework.org/schema/tx
  11.        http://www.springframework.org/schema/tx/spring-tx.xsd">
  12.     <!-- 配置事务管理器 -->
  13.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  14.         <!-- 注入数据源 -->
  15.         <property name="dataSource" ref="dataSource"></property>
  16.     </bean>
  17.     <!-- 配置通知 -->
  18.     <tx:advice id="txAdvice" transaction-manager="transactionManager">
  19.         <tx:attributes>
  20.             <!-- 传播行为 -->
  21.             <tx:method name="add*" propagation="REQUIRED" />
  22.             <tx:method name="update*" propagation="REQUIRED"/>
  23.             <tx:method name="remove*" propagation="REQUIRED"/>
  24.             <tx:method name="query*" propagation="SUPPORTS" read-only="true"/>
  25.         </tx:attributes>
  26.     </tx:advice>
  27.     <aop:config>
  28.         <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.hqyj.poison.service.*.*(..))"/>
  29.     </aop:config>
  30. <!--在 Spring容器中注册事务注解驱动-->
  31. <!--    <tx:annotation-driven transaction-manager="transactionManager" />-->
  32. </beans>

7、数据库

 

 

8. userMapper

每个方法对应到service中：

  1. package com.hqyj.poison.mapper;
  2.  
  3. import com.hqyj.poison.entity.Order;
  4. import com.hqyj.poison.entity.Pwd;
  5. import com.hqyj.poison.entity.User;
  6. import com.hqyj.poison.query.QueryOrderBean;
  7. import com.hqyj.poison.query.QueryUserBean;
  8. import com.hqyj.poison.result.ResultInfo;
  9. import org.aspectj.weaver.ast.Or;
  10.  
  11. import java.util.List;
  12.  
  13. public interface UserMapper {
  14.     User selectUser(String userName);
  15.     User selectUserAndRole(String userName);
  16.     User queryUsersByIdAndPwd(Pwd pwd);
  17.     void registered(User user);
  18.     List<User> selectUserByQueryBean(QueryUserBean queryUserBean);
  19.     Integer selectCount(QueryUserBean queryUserBean);
  20.     void updateUserPwdByName(Pwd pwd);
  21.  
  22.     void deleteUserById(Integer userId);
  23.     void updateUser(User user);
  24.  
  25.     List<Order> selectOrderByQueryBean(QueryOrderBean queryOrderBean);
  26.     Integer selectCountToOrder(QueryOrderBean queryOrderBean);
  27.  
  28.     void deleteOrderById(Integer orderId);
  29.     void updateOrder(Order order);
  30.     void insertOrder(Order order);
  31.  
  32.     Order selectOrderByNo(String orderNo);
  33. }

 9.service：接口和实现类

 

接口：

  1. package com.hqyj.poison.service;
  2.  
  3. import com.hqyj.poison.entity.Order;
  4. import com.hqyj.poison.entity.Pwd;
  5. import com.hqyj.poison.entity.User;
  6. import com.hqyj.poison.query.QueryOrderBean;
  7. import com.hqyj.poison.query.QueryUserBean;
  8. import com.hqyj.poison.result.ResultInfo;
  9.  
  10.  
  11. public interface UserService {
  12.     ResultInfo login(String userName, String userPwd);
  13.     User queryUser(String userName);
  14.     ResultInfo newUser(User user);
  15.     User queryUserAndRole(String userName);
  16.     ResultInfo selectUsers(QueryUserBean queryUserBean);
  17.     User queryUsersByIdAndPwd(Pwd pwd);
  18.     ResultInfo updateUserPwdByName(Pwd pwd);
  19.  
  20.     ResultInfo deleteUserById(Integer userId);
  21.     ResultInfo updateUserById(User user);
  22.  
  23. //    订单表
  24.     ResultInfo selectOrders(QueryOrderBean queryOrderBean);
  25.     ResultInfo deleteOrderById(Integer orderId);
  26.     ResultInfo updateOrderById(Order order);
  27.     ResultInfo insertOrder(Order order);
  28.     Order queryOrders(String orderNo);
  29. }

 实现类：

  1. package com.hqyj.poison.service.impl;
  2.  
  3. import com.hqyj.poison.entity.Order;
  4. import com.hqyj.poison.entity.Pwd;
  5. import com.hqyj.poison.entity.User;
  6. import com.hqyj.poison.mapper.UserMapper;
  7. import com.hqyj.poison.query.QueryOrderBean;
  8. import com.hqyj.poison.query.QueryUserBean;
  9. import com.hqyj.poison.result.ResultInfo;
  10. import com.hqyj.poison.service.UserService;
  11. import org.apache.shiro.SecurityUtils;
  12. import org.apache.shiro.authc.UsernamePasswordToken;
  13. import org.apache.shiro.subject.Subject;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.stereotype.Service;
  16.  
  17. import java.util.List;
  18.  
  19.  
  20. @Service
  21. public class UserServiceImpl implements UserService {
  22.     @Autowired
  23.     private UserMapper userMapper;
  24.     @Override
  25.     public User queryUser(String userName) {
  26.         return userMapper.selectUser(userName);
  27.     }
  28.  
  29.     @Override
  30.     public User queryUserAndRole(String userName) {
  31.         return userMapper.selectUserAndRole(userName);
  32.     }
  33.     @Override
  34.     public ResultInfo newUser(User user) {
  35.         userMapper.registered(user);
  36.         if (user!=null){
  37.             return new ResultInfo("200","success");
  38.         }return new ResultInfo("500","error");
  39.     }
  40.  
  41.     @Override
  42.     public ResultInfo login(String userName, String userPwd) {
  43.         // 获取subject对象
  44.         Subject subject = SecurityUtils.getSubject();
  45.         // 将controller（页面）传递过来的userName和userPwd放入token令牌中
  46.         UsernamePasswordToken token = new UsernamePasswordToken(userName,userPwd);
  47.         try {
  48.             //  登录认证
  49.             subject.login(token);
  50.             //   授权
  51.             subject.checkRoles();
  52.  
  53.             return new ResultInfo("200","success");
  54.         } catch (Exception e) {
  55.             User user = (User) SecurityUtils.getSubject().getSession().getAttribute("u");
  56.             if(user==null){
  57.                 return new ResultInfo("500","账号不存在！");
  58.             }
  59.             return  new ResultInfo("500","密码错误！");
  60.         }
  61.     }
  62.  
  63.     @Override
  64.     public ResultInfo selectUsers(QueryUserBean queryUserBean) {
  65.         List<User> users = userMapper.selectUserByQueryBean(queryUserBean);
  66.         Integer totals = userMapper.selectCount(queryUserBean);
  67.         return new ResultInfo("success",totals,users);
  68.  
  69.     }
  70.  
  71.     @Override
  72.     public User queryUsersByIdAndPwd(Pwd pwd) {
  73.         return userMapper.queryUsersByIdAndPwd(pwd);
  74.  
  75.     }
  76.  
  77.     @Override
  78.     public ResultInfo updateUserPwdByName(Pwd pwd) {
  79.         userMapper.updateUserPwdByName(pwd);
  80.         return new ResultInfo("200","success");
  81.     }
  82.  
  83.     @Override
  84.     public ResultInfo deleteUserById(Integer userId) {
  85.         userMapper.deleteUserById(userId);
  86.         return new ResultInfo("200","删除成功");
  87.     }
  88.  
  89.     @Override
  90.     public ResultInfo updateUserById(User user) {
  91.         userMapper.updateUser(user);
  92.         return new ResultInfo("200","success");
  93.     }
  94.  
  95.     @Override
  96.     public ResultInfo selectOrders(QueryOrderBean queryOrderBean) {
  97.         List<Order> orders = userMapper.selectOrderByQueryBean(queryOrderBean);
  98.         Integer totals = userMapper.selectCountToOrder(queryOrderBean);
  99.         return new ResultInfo("success",totals,orders);
  100.  
  101.     }
  102.  
  103.     @Override
  104.     public ResultInfo deleteOrderById(Integer orderId) {
  105.         userMapper.deleteOrderById(orderId);
  106.         return new ResultInfo("200","删除成功");
  107.     }
  108.  
  109.     @Override
  110.     public ResultInfo updateOrderById(Order order) {
  111.         userMapper.updateOrder(order);
  112.         return new ResultInfo("200","success");
  113.     }
  114.  
  115.     @Override
  116.     public ResultInfo insertOrder(Order order) {
  117.         userMapper.insertOrder(order);
  118.         return new ResultInfo("200","success");
  119.     }
  120.  
  121.     @Override
  122.     public Order queryOrders(String orderNo) {
  123.         return userMapper.selectOrderByNo(orderNo);
  124.     }
  125.  
  126. }

 10.前端界面：

login.jsp登录展示页面：

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 86139
  4.   Date: 2022/7/29
  5.   Time: 10:09
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10. <head>
  11.     <title>登录</title>
  12.     <!-- Google Font: Source Sans Pro -->
  13.     <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
  14.     <link rel="stylesheet" href="../static/plugins/fontawesome-free/css/all.min.css">
  15.     <link rel="stylesheet" href="../static/plugins/icheck-bootstrap/icheck-bootstrap.min.css">
  16.     <link rel="stylesheet" href="../static/dist/css/adminlte.min.css">
  17. </head>
  18. <body class="hold-transition login-page">
  19. <div class="login-box">
  20.     <!-- /.login-logo -->
  21.     <div class="card">
  22.         <div class="card-body login-card-body">
  23.             <p class="login-box-msg">登录</p>
  24.             <form>
  25.                 <div class="input-group mb-3">
  26.                     <input id="username" type="text" class="form-control" placeholder="用户名">
  27.                     <div class="input-group-append">
  28.                         <div class="input-group-text">
  29.                             <span class="fas fa-user-circle"></span>
  30.                         </div>
  31.                     </div>
  32.                 </div>
  33.  
  34.                 <div class="input-group mb-3">
  35.                     <input id="userpwd" type="password" class="form-control" placeholder="密码">
  36.                     <div class="input-group-append">
  37.                         <div class="input-group-text">
  38.                             <span class="fas fa-lock"></span>
  39.                         </div>
  40.                     </div>
  41.                 </div>
  42.                 <div class="input-group mb-3">
  43.                     <span id="mess" style="color: red"></span>
  44.                 </div>
  45.                 <div class="row">
  46.                     <div class="col-8">
  47.                         <div class="icheck-primary">
  48.                             <input type="checkbox" id="remember">
  49.                             <label for="remember">
  50.                                 Remember Me
  51.                             </label>
  52.                         </div>
  53.                     </div>
  54.                     <!-- /.col -->
  55.                     <div class="col-4">
  56.                         <button type="button" onclick="login()" class="btn btn-primary btn-block">登录</button>
  57.                     </div>
  58.                     <!-- /.col -->
  59.                 </div>
  60.             </form>
  61.  
  62.  
  63.             <!-- /.social-auth-links -->
  64.             <button type="button" data-toggle='modal' data-target='#newUser' class="btn btn-primary">注册</button>
  65.  
  66.         <!-- /.login->card-body -->
  67.             <div class="modal fade" id="newUser" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  68.             <div class="modal-dialog" role="document">
  69.                 <div class="modal-content">
  70.                     <div class="modal-header">
  71.                         <h4 class="modal-title" id="myModalLabel">用户新增</h4>
  72.                         <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  73.                     </div>
  74.                     <div class="modal-body">
  75.                         <form class="form-horizontal">
  76.                             <div class="form-group">
  77.                                 <label for="userName2" class="col-sm-2 control-label">用户名</label>
  78.                                 <div class="col-sm-10">
  79.                                     <input type="text" class="form-control" id="userName2" placeholder="用户名">
  80.                                 </div>
  81.                             </div>
  82.                             <div class="form-group">
  83.                                 <label for="userPwd1" class="col-sm-2 control-label">密码</label>
  84.                                 <div class="col-sm-10">
  85.                                     <input type="password" class="form-control" id="userPwd1" placeholder="密码">
  86.                                 </div>
  87.                             </div>
  88.                             <div class="form-group">
  89.                                 <label for="userAge2" class="col-sm-2 control-label">年龄</label>
  90.                                 <div class="col-sm-10">
  91.                                     <input type="number" class="form-control" id="userAge2" placeholder="年龄">
  92.                                 </div>
  93.                             </div>
  94.                             <div class="form-group">
  95.                                 <label class="col-sm-2 control-label">性别</label>
  96.                                 <div class="col-sm-10">
  97.                                     <label class="radio-inline">
  98.                                         <input type="radio" name="gender" id="sex1" value="男" > 男
  99.                                     </label>
  100.                                     <label class="radio-inline">
  101.                                         <input type="radio" name="gender" id="sex2" value="女"> 女
  102.                                     </label>
  103.                                 </div>
  104.                             </div>
  105.                             <div class="form-group">
  106.                                 <label for="userTel2" class="col-sm-2 control-label">电话</label>
  107.                                 <div class="col-sm-10">
  108.                                     <input type="text" class="form-control" id="userTel2" placeholder="电话">
  109.                                 </div>
  110.                             </div>
  111.                             <div class="form-group">
  112.                                 <label for="userBirthday2" class="col-sm-2 control-label">日期</label>
  113.                                 <div class="col-sm-10">
  114.                                     <input type="date" class="form-control" id="userBirthday2" placeholder="日期">
  115.                                 </div>
  116.                             </div>
  117.                             <div class="form-group">
  118.                                 <label for="userEmail2" class="col-sm-2 control-label">邮箱</label>
  119.                                 <div class="col-sm-10">
  120.                                     <input type="email" class="form-control" id="userEmail2" placeholder="邮箱">
  121.                                 </div>
  122.                             </div>
  123.                         </form>
  124.                     </div>
  125.                     <div class="modal-footer">
  126.                         <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
  127.                         <button type="button" onclick="newUser()" class="btn btn-primary">确认</button>
  128.                     </div>
  129.                 </div>
  130.             </div>
  131.             </div>
  132.             <div class="modal fade" id="findpwd" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  133.                 <div class="modal-dialog" role="document">
  134.                     <div class="modal-content">
  135.                         <div class="modal-header">
  136.                             <h4 class="modal-title" id="myModalLabe2">信息验证</h4>
  137.                             <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  138.                         </div>
  139.                         <div class="modal-body">
  140.                             <form class="form-horizontal">
  141.                                 <div class="form-group">
  142.                                     <label for="userName3" class="col-sm-2 control-label">用户名</label>
  143.                                     <div class="col-sm-10">
  144.                                         <input type="text" class="form-control" id="userName3" placeholder="用户名">
  145.                                     </div>
  146.                                 </div>
  147.                                 <div class="form-group">
  148.                                     <label for="userTel3" class="col-sm-2 control-label">电话</label>
  149.                                     <div class="col-sm-10">
  150.                                         <input type="text" class="form-control" id="userTel3" placeholder="电话">
  151.                                     </div>
  152.                                 </div>
  153.                                 <div class="form-group">
  154.                                     <label for="userEmail3" class="col-sm-2 control-label">邮箱</label>
  155.                                     <div class="col-sm-10">
  156.                                         <input type="email" class="form-control" id="userEmail3" placeholder="邮箱">
  157.                                     </div>
  158.                                 </div>
  159.                             </form>
  160.                         </div>
  161.                         <div class="modal-footer">
  162.                             <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
  163.                         </div>
  164.                     </div>
  165.                 </div>
  166.             </div>
  167.         </div>
  168.     </div>
  169.     </div>
  170.  
  171. <!-- /.login-box -->
  172. <script src="../static/plugins/jquery/jquery.min.js"></script>
  173. <script src="../static/plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
  174. <script src="../static/dist/js/adminlte.min.js"></script>
  175.  
  176.  
  177. <script>
  178.     function login() {
  179.         var username = $("#username").val();
  180.         var userpwd = $("#userpwd").val();
  181.         $.ajax({
  182.             url:"../sys/login",
  183.             type:"POST",
  184.             dataType:"json",
  185.             data:{"userName":username,"userPwd":userpwd},
  186.             success:function (data) {
  187.                 if(data.status=="500"){
  188.                     $("#mess").html(data.message);
  189.                 }else {
  190.  
  191.                     window.location.href="../view/index.jsp";
  192.                 }
  193.             },
  194.             error:function (e) {
  195.                 alert("服务器出错！")
  196.             }
  197.         });
  198.     }
  199.     function newUser() {
  200.         //获取编辑模态框中的表单元素的值
  201.         var username = $("#userName2").val();
  202.         var userpwd = $("#userPwd1").val();
  203.         var useremail = $("#userEmail2").val();
  204.         var userage = $("#userAge2").val();
  205.         var userbirthday = $("#userBirthday2").val();
  206.         var usertel = $("#userTel2").val();
  207.         var usersex = $("input[type='radio']:checked").val();
  208.         var user = {
  209.             "userName":username,
  210.             "userPwd":userpwd,
  211.             "userEmail":useremail,
  212.             "userAge":userage,
  213.             "userBirthday":userbirthday,
  214.             "userTel":usertel,
  215.             "userSex":usersex
  216.         };
  217.         $.ajax({
  218.             url:"../new",
  219.             type:"POST",
  220.             data:user,
  221.             dataType:"json",
  222.             success:function (data) {
  223.                 alert(data.status)
  224.                 if(data.status=="200"){
  225.                     $('#newUser').modal('hide');
  226.                     GridManager.refreshGrid('demo-baseCode');
  227.                 }
  228.             },
  229.             error:function (e) {
  230.                 alert("添加失败");
  231.             }
  232.         });
  233.     }
  234. </script>
  235. </body>
  236. </html>

index.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 86139
  4.   Date: 2022/8/10
  5.   Time: 10:10
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10. <head>
  11.     <title>主页</title>
  12.     <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
  13.     <link rel="stylesheet" href="../static/plugins/fontawesome-free/css/all.min.css">
  14.     <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  15.     <link rel="stylesheet" href="../static/plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css">
  16.     <link rel="stylesheet" href="../static/plugins/icheck-bootstrap/icheck-bootstrap.min.css">
  17.     <link rel="stylesheet" href="../static/dist/css/adminlte.min.css">
  18.     <link rel="stylesheet" href="../static/plugins/overlayScrollbars/css/OverlayScrollbars.min.css">
  19.     <link rel="stylesheet" href="../static/plugins/daterangepicker/daterangepicker.css">
  20.     <link rel="stylesheet" href="../static/plugins/summernote/summernote-bs4.min.css">
  21. </head>
  22. <body class="hold-transition sidebar-mini layout-fixed">
  23. <div class="wrapper">
  24.  
  25.     <!-- Navbar -->
  26.     <nav class="main-header navbar navbar-expand navbar-white navbar-light">
  27.         <!-- Left navbar links -->
  28.         <ul class="navbar-nav">
  29.             <li class="nav-item">
  30.                 <a class="nav-link" data-widget="pushmenu" href="#" role="button"><i class="fas fa-bars"></i></a>
  31.             </li>
  32.             <li class="nav-item d-none d-sm-inline-block">
  33.                 <a href="index3.html" class="nav-link">Home</a>
  34.             </li>
  35.             <li class="nav-item d-none d-sm-inline-block">
  36.                 <a href="#" class="nav-link">Contact</a>
  37.             </li>
  38.         </ul>
  39.  
  40.         <ul class="navbar-nav ml-auto">
  41.             <!-- Notifications Dropdown Menu -->
  42.             <li class="nav-item dropdown">
  43.                 <a class="nav-link" data-toggle="dropdown" href="#">
  44.                     <i class="nav-icon fas fa-user-circle"></i>
  45.                     Iron
  46.                     <i class="fas fa-angle-down right"></i>
  47.                 </a>
  48.                 <div class="dropdown-menu dropdown-menu-md dropdown-menu-right">
  49.                     <div class="dropdown-divider"></div>
  50.                     <a href="#" onclick="changePwd()" class="dropdown-item">
  51.                         <i class="fas fa-lock mr-2"></i>修改密码
  52.                     </a>
  53.                     <div class="dropdown-divider"></div>
  54.                     <a href="#" onclick="loginout()" class="dropdown-item">
  55.                         <i class="fas fa-sign-out-alt mr-2"></i>退出
  56.                     </a>
  57.                 </div>
  58.             </li>
  59.         </ul>
  60.     </nav>
  61.     <!-- /.navbar -->
  62.  
  63.     <!-- Main Sidebar Container -->
  64.     <aside class="main-sidebar sidebar-dark-primary elevation-4">
  65.         <!-- Brand Logo -->
  66.         <a href="" class="brand-link">
  67.             <img src="../static/dist/img/AdminLTELogo.png" alt="AdminLTE Logo" class="brand-image img-circle elevation-3" style="opacity: .8">
  68.             <span class="brand-text font-weight-light">物流管理系统</span>
  69.         </a>
  70.  
  71.  
  72.         <!-- Sidebar -->
  73.         <div class="sidebar">
  74.             <!-- Sidebar user panel (optional) -->
  75.             <div class="user-panel mt-3 pb-3 mb-3 d-flex">
  76.                 <div class="image">
  77.                     <img src="../static/dist/img/user2-160x160.jpg" class="img-circle elevation-2" alt="User Image">
  78.                 </div>
  79.                 <div class="info">
  80.                     <a href="#" class="d-block">Alexander Pierce</a>
  81.                 </div>
  82.             </div>
  83.  
  84.  
  85.             <!-- Sidebar Menu -->
  86.             <nav class="mt-2">
  87.                 <ul id="sider" class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
  88.                     <!-- Add icons to the links using the .nav-icon class
  89.                          with font-awesome or any other icon font library -->
  90.                     <li class="nav-item">
  91.                         <a href="#" name="./home.jsp" class="nav-link active">
  92.                             <i class="nav-icon far fa-image"></i>
  93.                             <p>
  94.                                 首页
  95.                             </p>
  96.                         </a>
  97.                     </li>
  98.                     <li class="nav-item">
  99.                         <a href="#" class="nav-link">
  100.                             <i class="nav-icon fas fa-tachometer-alt"></i>
  101.                             <p>
  102.                                 用户管理
  103.                                 <i class="right fas fa-angle-left"></i>
  104.                             </p>
  105.                         </a>
  106.                         <ul class="nav nav-treeview">
  107.                             <li class="nav-item">
  108.                                 <a href="#" name="./user.jsp" class="nav-link">
  109.                                     <i class="far fa-circle nav-icon"></i>
  110.                                     <p>用户列表</p>
  111.                                 </a>
  112.                             </li>
  113.                         </ul>
  114.                     </li>
  115.  
  116.                     <li class="nav-item">
  117.                         <a href="#" class="nav-link">
  118.                             <i class="nav-icon fas fa-tachometer-alt"></i>
  119.                             <p>
  120.                                 物流管理
  121.                                 <i class="right fas fa-angle-left"></i>
  122.                             </p>
  123.                         </a>
  124.                         <ul class="nav nav-treeview">
  125.                             <li class="nav-item">
  126.                                 <a href="#" name="./logistics.jsp" class="nav-link">
  127.                                     <i class="far fa-circle nav-icon"></i>
  128.                                     <p>物流信息</p>
  129.                                 </a>
  130.                             </li>
  131.                         </ul>
  132.                     </li>
  133.                 </ul>
  134.             </nav>
  135.             <!-- /.sidebar-menu -->
  136.         </div>
  137.         <!-- /.sidebar -->
  138.     </aside>
  139.     <div class="content-wrapper">
  140.         <div class="content-header">
  141.             <div class="container-fluid">
  142.                 <div class="row mb-2">
  143.                     <div class="col-sm-6">
  144.                         <h1 class="m-0">Dashboard</h1>
  145.                     </div><!-- /.col -->
  146.                     <div class="col-sm-6">
  147.                         <ol class="breadcrumb float-sm-right">
  148.                             <li class="breadcrumb-item"><a href="#">Home</a></li>
  149.                             <li class="breadcrumb-item active">Dashboard v1</li>
  150.                         </ol>
  151.                     </div><!-- /.col -->
  152.                 </div><!-- /.row -->
  153.             </div><!-- /.container-fluid -->
  154.         </div>
  155.         <section class="content">
  156.             <div class="container-fluid">
  157.                 <iframe id="ifr" src="./home.jsp" frameborder="0" scrolling="no" width="100%" height="100%">
  158.  
  159.                 </iframe>
  160.  
  161.             </div>
  162.         </section>
  163.         <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  164.             <div class="modal-dialog" role="document">
  165.                 <div class="modal-content">
  166.                     <div class="modal-header">
  167.                         <h4 class="modal-title" id="myModalLabel1">修改密码</h4>
  168.                         <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  169.                     </div>
  170.                     <div class="modal-body">
  171.                         <form class="form-horizontal">
  172.                             <input type="hidden" id="userId">
  173.                             <div class="form-group">
  174.                                 <label for="UserName1" class="col-sm-2 control-label">用户名</label>
  175.                                 <div class="col-sm-10">
  176.                                     <input type="text" class="form-control" id="UserName1" placeholder="用户名">
  177.                                 </div>
  178.                             </div>
  179.                             <div class="form-group">
  180.                                 <label for="UserPwd1" class="col-sm-2 control-label">原密码</label>
  181.                                 <div class="col-sm-10">
  182.                                     <input type="text" class="form-control" id="UserPwd1" placeholder="原密码">
  183.                                 </div>
  184.                             </div>
  185.                             <div class="form-group">
  186.                                 <label for="UserPwd2" class="col-sm-2 control-label">新密码</label>
  187.                                 <div class="col-sm-10">
  188.                                     <input type="text" class="form-control" id="UserPwd2" placeholder="新密码">
  189.                                 </div>
  190.                             </div>
  191.                             <div class="form-group">
  192.                                 <label for="UserPwd3" class="col-sm-2 control-label" style="max-width: 20%">确认密码</label>
  193.                                 <div class="col-sm-10">
  194.                                     <input type="text" class="form-control" id="UserPwd3" placeholder="确认密码">
  195.                                 </div>
  196.                             </div>
  197.                         </form>
  198.                     </div>
  199.                     <div class="modal-footer">
  200.                         <button type="button" class="btn btn-default" data-dismiss="modal" onclick="clearall()">关闭</button>
  201.                         <button type="button" onclick="checkPwd()" class="btn btn-primary">确认</button>
  202.                     </div>
  203.                 </div>
  204.             </div>
  205.     </div>
  206. </div>
  207. <!-- jQuery -->
  208. <script src="../static/plugins/jquery/jquery.min.js"></script>
  209. <script src="../static/plugins/jquery-ui/jquery-ui.min.js"></script>
  210.  
  211. <script>
  212.     $.widget.bridge('uibutton', $.ui.button)
  213. </script>
  214.  
  215. <script src="../static/plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
  216. <script src="../static/plugins/jquery-knob/jquery.knob.min.js"></script>
  217. <script src="../static/plugins/moment/moment.min.js"></script>
  218. <script src="../static/plugins/daterangepicker/daterangepicker.js"></script>
  219. <script src="../static/plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
  220. <script src="../static/plugins/summernote/summernote-bs4.min.js"></script>
  221. <script src="../static/plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
  222. <script src="../static/dist/js/adminlte.js"></script>
  223. <script src="../static/dist/js/demo.js"></script>
  224. <%--<script src="../static/dist/js/pages/dashboard.js"></script>--%>
  225.  
  226.  
  227. <script>
  228.     $(document).ready(function () {
  229.         $("#sider a").click(function () {
  230.             $("a").removeClass("active");
  231.             var a = $(this).closest(".menu-open").attr("class")
  232.             var s = $(this).parent("li").parent("ul").attr("class");
  233.             if(!(typeof (s)=="undefined"||s.search("nav-treeview")==(-1))){
  234.                 $(this).parent("li").parent("ul").prev().addClass("active");
  235.                 $(this).addClass("active");
  236.                 var url = $(this).attr("name");
  237.                 $("#ifr").attr("src",url);
  238.             }else {
  239.                 if(a != undefined){
  240.                     $(this).addClass("active");
  241.                     return;
  242.                 }else {
  243.                     $(".menu-open").children("a").trigger("click");
  244.                     $("a").removeClass("active");
  245.                     var url = $(this).attr("name");
  246.                     $("#ifr").attr("src",url);
  247.                 }
  248.                 $(this).addClass("active");
  249.             }
  250.         });
  251.     });
  252.  
  253.     function loginout() {
  254.         $.ajax({
  255.             url:"../sys/loginOut",
  256.             type:"GET",
  257.             success:function (data) {
  258.                     window.location.href="../view/login.jsp";
  259.             }
  260.         })
  261.     }
  262.     function changePwd() {
  263.         $("#myModal").modal('show');
  264.     }
  265.     function clearall() {
  266.         $("#UserName1").val("");
  267.         $("#UserPwd1").val("");
  268.         $("#UserPwd2").val("");
  269.         $("#UserPwd3").val("");
  270.     }
  271.     function checkPwd() {
  272.         var username = $("#UserName1").val();
  273.         var userpwd = $("#UserPwd1").val();
  274.         var newPwd = $("#UserPwd2").val();
  275.         var newPwd2 = $("#UserPwd3").val();
  276.         if (newPwd != newPwd2){
  277.             alert("两次密码不一致")
  278.         }else {
  279.             var user={"userName":username,"userPwd":userpwd,"newPwd":newPwd}
  280.             $.ajax({
  281.                 url:"../user/change",
  282.                 type:"Get",
  283.                 data:user,
  284.                 dataType:"JSON",
  285.                 success:function (data) {
  286.                     alert(data.status)
  287.                     if (data.status == "200"){
  288.                         alert("修改成功")
  289.  
  290.                     }else {
  291.                         alert(data.message)
  292.                     }
  293.                     $("#myModal").modal('hide');
  294.                 }
  295.             })
  296.         }
  297.     }
  298. </script>
  299. </body>
  300. </html>

 error.jsp

  1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  2. <html>
  3. <head>
  4.     <title>Title</title>
  5. </head>
  6. <body>
  7.     权限不足，请联系管理员！
  8. </body>
  9. </html>

 logistics.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 86139
  4.   Date: 2022/8/10
  5.   Time: 10:45
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10. <head>
  11.     <title>用户列表</title>
  12.     <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
  13.     <link rel="stylesheet" href="../static/plugins/fontawesome-free/css/all.min.css">
  14.     <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  15.     <link rel="stylesheet" href="../static/plugins/icheck-bootstrap/icheck-bootstrap.min.css">
  16.     <link rel="stylesheet" href="../static/dist/css/adminlte.min.css">
  17.     <link rel="stylesheet" href="../static/plugins/overlayScrollbars/css/OverlayScrollbars.min.css">
  18.     <link rel="stylesheet" href="../static/plugins/daterangepicker/daterangepicker.css">
  19.     <link rel="stylesheet" href="../static/plugins/summernote/summernote-bs4.min.css">
  20.     <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
  21.     <link rel="stylesheet" href="../static/gridmanager/css/gm.css">
  22.     <script src="../static/gridmanager/js/gm.js"></script>
  23. </head>
  24. <body>
  25. <div class="row">
  26.     <div class="col-12">
  27.         <div class="card">
  28.             <div class="card-header row">
  29.                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  30.                 <div class="col-11">
  31.  
  32.                     <form class="form-inline">
  33.                         <input type="text" class="form-control" id="orderTel" placeholder="收货号码">
  34.                         <button type="button" class="btn btn-default" onclick="searchOrders()">搜索</button>
  35.                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  36.                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  37.                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  38.                         <button type="button" data-toggle='modal' data-target='#myModal1' class="btn btn-primary" id="insert">添加</button>
  39.                     </form>
  40.                 </div>
  41.             </div>
  42.  
  43.             <!-- /.card-header -->
  44.             <div class="card-body">
  45.                 <table id='table-demo-ajaxPageCode'></table>
  46.             </div>
  47.             <!-- /.card-body -->
  48.         </div>
  49.     </div>
  50.     <!-- /.col -->
  51. </div>
  52.  
  53. <%--用户修改--%>
  54. <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  55.     <div class="modal-dialog" role="document">
  56.         <div class="modal-content">
  57.             <div class="modal-header">
  58.                 <h4 class="modal-title" id="myModalLabel1">修改</h4>
  59.                 <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  60.             </div>
  61.             <div class="modal-body">
  62.                 <form class="form-horizontal">
  63.                     <input type="hidden" id="orderId">
  64.                     <div class="form-group">
  65.                         <label for="orderPeople1" class="col-sm-2 control-label">收件人</label>
  66.                         <div class="col-sm-10">
  67.                             <input type="text" class="form-control" id="orderPeople1" placeholder="收件人">
  68.                         </div>
  69.                     </div>
  70.                     <div class="form-group">
  71.                         <label for="orderTel1" class="col-sm-2 control-label">电话</label>
  72.                         <div class="col-sm-10">
  73.                             <input type="text" class="form-control" id="orderTel1" placeholder="电话">
  74.                         </div>
  75.                     </div>
  76.                     <div class="form-group">
  77.                         <label for="orderFreight1" class="col-sm-2 control-label">运费</label>
  78.                         <div class="col-sm-10">
  79.                             <input type="number" class="form-control" id="orderFreight1" placeholder="运费">
  80.                         </div>
  81.                     </div>
  82.                     <div class="form-group">
  83.                         <label for="orderTime1" class="col-sm-2 control-label">日期</label>
  84.                         <div class="col-sm-10">
  85.                             <input type="date" class="form-control" id="orderTime1" placeholder="下单时间">
  86.                         </div>
  87.                     </div>
  88.                     <div class="form-group">
  89.                         <label for="giveMethod1" class="col-sm-2 control-label">物流</label>
  90.                         <div class="col-sm-10">
  91.                             <input type="text" class="form-control" id="giveMethod1" placeholder="配送方式">
  92.                         </div>
  93.                     </div>
  94.                 </form>
  95.             </div>
  96.             <div class="modal-footer">
  97.                 <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
  98.                 <button type="button" onclick="updateOrders()" class="btn btn-primary">确认</button>
  99.             </div>
  100.         </div>
  101.     </div>
  102. </div>
  103.  
  104. <%--用户添加--%>
  105. <div class="modal fade" id="myModal2" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  106.     <div class="modal-dialog" role="document">
  107.         <div class="modal-content">
  108.             <div class="modal-header">
  109.                 <h4 class="modal-title" id="myModalLabel1">添加</h4>
  110.                 <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  111.             </div>
  112.             <div class="modal-body">
  113.                 <form class="form-horizontal">
  114.                     <input type="hidden" id="orderId2">
  115.                     <div class="form-group">
  116.                         <label for="orderNo2" class="col-sm-2 control-label">编号</label>
  117.                         <div class="col-sm-10">
  118.                             <input type="text" class="form-control" id="orderNo2" placeholder="订单编号">
  119.                         </div>
  120.                     </div>
  121.                     <div class="form-group">
  122.                         <label for="orderPeople2" class="col-sm-2 control-label">收件人</label>
  123.                         <div class="col-sm-10">
  124.                             <input type="text" class="form-control" id="orderPeople2" placeholder="收件人">
  125.                         </div>
  126.                     </div>
  127.                     <div class="form-group">
  128.                         <label for="orderTel2" class="col-sm-2 control-label">电话</label>
  129.                         <div class="col-sm-10">
  130.                             <input type="text" class="form-control" id="orderTel2" placeholder="电话">
  131.                         </div>
  132.                     </div>
  133.                     <div class="form-group">
  134.                         <label for="orderFreight2" class="col-sm-2 control-label">运费</label>
  135.                         <div class="col-sm-10">
  136.                             <input type="number" class="form-control" id="orderFreight2" placeholder="运费">
  137.                         </div>
  138.                     </div>
  139.                     <div class="form-group">
  140.                         <label for="orderTime2" class="col-sm-2 control-label">日期</label>
  141.                         <div class="col-sm-10">
  142.                             <input type="date" class="form-control" id="orderTime2" placeholder="下单时间">
  143.                         </div>
  144.                     </div>
  145.                     <div class="form-group">
  146.                         <label for="giveMethod2" class="col-sm-2 control-label">物流</label>
  147.                         <div class="col-sm-10">
  148.                             <input type="text" class="form-control" id="giveMethod2" placeholder="配送方式">
  149.                         </div>
  150.                     </div>
  151.                 </form>
  152.             </div>
  153.             <div class="modal-footer">
  154.                 <button type="button" class="btn btn-default" data-dismiss="modal" onclick="clearall()">关闭</button>
  155.                 <button type="button" onclick="insertOrders()" class="btn btn-primary">确认</button>
  156.             </div>
  157.         </div>
  158.     </div>
  159. </div>
  160. <!-- /.row -->
  161. <!-- jQuery -->
  162. <script src="../static/plugins/jquery/jquery.min.js"></script>
  163. <script src="../static/plugins/jquery-ui/jquery-ui.min.js"></script>
  164. <script src="../static/jqPaginator.js"></script>
  165. <script src="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
  166. <script src="../static/plugins/jquery-knob/jquery.knob.min.js"></script>
  167. <script src="../static/plugins/moment/moment.min.js"></script>
  168. <script src="../static/plugins/daterangepicker/daterangepicker.js"></script>
  169. <script src="../static/plugins/summernote/summernote-bs4.min.js"></script>
  170. <script src="../static/plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
  171. <script src="../static/dist/js/adminlte.js"></script>
  172.  
  173.  
  174. <script>
  175.     var respData;
  176.     var cPage = null;
  177.     var pSize = null;
  178.     var ordertel = null;
  179.     $(function () {
  180.         // queryUsers();
  181.         document.querySelector('#table-demo-ajaxPageCode').GM({
  182.             gridManagerName: 'demo-baseCode',
  183.             ajaxData: function (setting,params) {
  184.                 cPage = params.currentPage;
  185.                 pSize = params.pageSize;
  186.                 queryOrders(cPage,pSize,ordertel);
  187.                 return respData;
  188.             },
  189.             supportAjaxPage: true,
  190.             sizeData: [4,8,12,16],
  191.             pageSize: 4,
  192.             currentPageKey: "currentPage",
  193.             pageSizeKey: "pageSize",
  194.             // ajaxType: 'POST',
  195.             columnData: [
  196.                 {
  197.                     key: 'orderNo',
  198.                     text: '订单编号'
  199.                 },{
  200.                     key: 'orderPeople',
  201.                     text: '收货人'
  202.                 },{
  203.                     key: 'orderFreight',
  204.                     text: '运费'
  205.                 },{
  206.                     key: 'giveMethod',
  207.                     text: '配送方式'
  208.                 },{
  209.                     key: 'orderTime',
  210.                     text: '下单时间'
  211.                 },{
  212.                     key: 'orderTel',
  213.                     text: '电话'
  214.                 },{
  215.                     key: 'orderId',
  216.                     text: '操作',
  217.                     alien:'center',
  218.                     template:function (cell,row,index,key) {
  219.                         return "<button type='button' data-obj='"+JSON.stringify(row) +
  220.                             "' class= 'btn btn-success btn-sm'>编辑</button>&nbsp;&nbsp;&nbsp;&nbsp;" +
  221.                             "<button type='button' class= 'btn btn-success btn-sm' data-id='"+ cell +"'>删除</button>";
  222.                     }
  223.                 }
  224.             ]
  225.         });
  226.  
  227.     });
  228.  
  229.     function queryOrders(cPage,pSize,ordertel) {
  230.         $.ajax({
  231.             url:"../order/orderAll",
  232.             type:"GET",
  233.             dataType:"json",
  234.             async:false,
  235.             data:{"currentPage":cPage,"pageSize":pSize,"orderTel":ordertel},
  236.             success:function (data) {
  237.                 if(data.status=="500"){
  238.                     window.location.href="../sys/error";
  239.                 }else
  240.  
  241.                     respData = {"data":data.data,"totals":data.totals};
  242.             }
  243.         });
  244.     }
  245.  
  246.     function searchOrders() {
  247.         cPage = 1;
  248.         pSize = 2;
  249.         ordertel = $("#orderTel").val();
  250.  
  251.         GridManager.setQuery("demo-baseCode");
  252.     }
  253.  
  254.     $("#table-demo-ajaxPageCode").on("click","button[data-id]",function () {
  255.         var isDel = confirm("确认是否删除");
  256.         if (isDel){
  257.             var id = $(this).data("id");
  258.             $.ajax({
  259.                 url:"../order/"+id,
  260.                 type: "delete",
  261.                 dataType: "json",
  262.                 success:function (data) {
  263.                     if (data.status=="200"){
  264.                         GridManager.refreshGrid('demo-baseCode');
  265.                     }else
  266.                     {
  267.                         alert("权限不足,请联系管理员");
  268.                     }
  269.                 },error:function (e) {
  270.                     alert("删除失败")
  271.                 }
  272.             })
  273.         }
  274.  
  275.     })
  276.  
  277.  
  278.     $("#table-demo-ajaxPageCode").on("click","button[data-obj]",function () {
  279.  
  280.         //    数据回显
  281.         var orders = $(this).data("obj");
  282.         $("#orderId").val(orders.orderId);
  283.         $("#orderPeople1").val(orders.orderPeople);
  284.         $("#orderFreight1").val(orders.orderFreight);
  285.         $("#giveMethod1").val(orders.giveMethod);
  286.         $("#orderTime1").val(orders.orderTime);
  287.         $("#orderTel1").val(orders.orderTel);
  288.  
  289.         //    显示模态版
  290.         $("#myModal").modal('show');
  291.     })
  292.  
  293.     function updateOrders() {
  294.         var id = $("#orderId").val();
  295.         var name = $("#orderPeople1").val();
  296.         var freight = $("#orderFreight1").val();
  297.         var method = $("#giveMethod1").val();
  298.         var time = $("#orderTime1").val();
  299.         var tel = $("#orderTel1").val();
  300.         var orders = {
  301.             "orderId":id,
  302.             "orderPeople":name,
  303.             "orderFreight":freight,
  304.             "giveMethod":method,
  305.             "orderTime":time,
  306.             "orderTel":tel
  307.         };
  308.         $.ajax({
  309.             url:"../order/",
  310.             type:"put",
  311.             contentType:"application/json",
  312.             dataType:"json",
  313.             data:JSON.stringify(orders),
  314.             success:function (data) {
  315.                 if (data.status=="200"){
  316.                     $("#myModal").modal('hide');
  317.                     GridManager.refreshGrid('demo-baseCode');
  318.                     console.log(id)
  319.                 }else {
  320.                     alert("权限不足,无法修改")
  321.                 }
  322.             }
  323.         })
  324.     }
  325.  
  326.     $("#insert").click(function () {
  327.         $("#myModal2").modal('show');
  328.     })
  329.  
  330.     function insertOrders() {
  331.         var no = $("#orderNo2").val();
  332.         var name = $("#orderPeople2").val();
  333.         var freight = $("#orderFreight2").val();
  334.         var method = $("#giveMethod2").val();
  335.         var time = $("#orderTime2").val();
  336.         var tel = $("#orderTel2").val();
  337.         var orders = {
  338.             "orderNo":no,
  339.             "orderPeople":name,
  340.             "orderFreight":freight,
  341.             "giveMethod":method,
  342.             "orderTime":time,
  343.             "orderTel":tel
  344.         };
  345.         $.ajax({
  346.             url:"../order/insert",
  347.             type:"put",
  348.             contentType:"application/json",
  349.             dataType:"json",
  350.             data:JSON.stringify(orders),
  351.             success:function (data) {
  352.                 if (data.status=="200"){
  353.                     alert("添加成功")
  354.                 }else if (data.status=="500"){
  355.                     alert(data.message)
  356.                 }else
  357.                     alert("权限不足")
  358.                 $("#myModal2").modal('hide');
  359.                 GridManager.refreshGrid('demo-baseCode');
  360.  
  361.             }
  362.         })
  363.     }
  364.     function clearall() {
  365.         $("#orderNo2").val("");
  366.         $("#orderPeople2").val("");
  367.         $("#orderFreight2").val("");
  368.         $("#giveMethod2").val("");
  369.         $("#orderTime2").val("");
  370.         $("#orderTel2").val("");
  371.     }
  372. </script>
  373. </body>
  374. </html>

user.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: 86139
  4.   Date: 2022/8/10
  5.   Time: 10:45
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10. <head>
  11.     <title>用户列表</title>
  12.     <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback">
  13.     <link rel="stylesheet" href="../static/plugins/fontawesome-free/css/all.min.css">
  14.     <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  15.     <link rel="stylesheet" href="../static/plugins/icheck-bootstrap/icheck-bootstrap.min.css">
  16.     <link rel="stylesheet" href="../static/dist/css/adminlte.min.css">
  17.     <link rel="stylesheet" href="../static/plugins/overlayScrollbars/css/OverlayScrollbars.min.css">
  18.     <link rel="stylesheet" href="../static/plugins/daterangepicker/daterangepicker.css">
  19.     <link rel="stylesheet" href="../static/plugins/summernote/summernote-bs4.min.css">
  20.     <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
  21.     <link rel="stylesheet" href="../static/gridmanager/css/gm.css">
  22.     <script src="../static/gridmanager/js/gm.js"></script>
  23. </head>
  24. <body>
  25. <div class="row">
  26.     <div class="col-12">
  27.         <div class="card">
  28.             <div class="card-header row">
  29.                 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  30.                 <div class="col-11">
  31.  
  32.                     <form class="form-inline">
  33.                         <label for="username">用户名</label>
  34.                         <input type="text" class="form-control" id="username" placeholder="用户名">
  35.                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  36.                         <label for="usertel">电话</label>
  37.                         <input type="tel" class="form-control" id="usertel" placeholder="电话">
  38.                         <button type="button" class="btn btn-default" onclick="searchUser()">搜索</button>
  39.  
  40.                     </form>
  41.                 </div>
  42.             </div>
  43.  
  44.             <!-- /.card-header -->
  45.             <div class="card-body">
  46.                 <table id='table-demo-ajaxPageCode'></table>
  47.             </div>
  48.             <!-- /.card-body -->
  49.         </div>
  50.     </div>
  51.     <!-- /.col -->
  52. </div>
  53.  
  54. <%--用户修改--%>
  55. <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  56.     <div class="modal-dialog" role="document">
  57.         <div class="modal-content">
  58.             <div class="modal-header">
  59.                 <h4 class="modal-title" id="myModalLabel1">用户修改</h4>
  60.                 <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  61.             </div>
  62.             <div class="modal-body">
  63.                 <form class="form-horizontal">
  64.                     <input type="hidden" id="userId">
  65.                     <div class="form-group">
  66.                         <label for="UserName1" class="col-sm-2 control-label">用户名</label>
  67.                         <div class="col-sm-10">
  68.                             <input type="text" class="form-control" id="UserName1" placeholder="用户名">
  69.                         </div>
  70.                     </div>
  71.                     <div class="form-group">
  72.                         <label for="UserAge1" class="col-sm-2 control-label">年龄</label>
  73.                         <div class="col-sm-10">
  74.                             <input type="number" class="form-control" id="UserAge1" placeholder="年龄">
  75.                         </div>
  76.                     </div>
  77.                     <div class="form-group">
  78.                         <label class="col-sm-2 control-label">性别</label>
  79.                         <div class="col-sm-10">
  80.                             <label class="radio-inline">
  81.                                 <input type="radio" name="gender" id="inlineRadio11" value="男"> 男
  82.                             </label>
  83.                             <label class="radio-inline">
  84.                                 <input type="radio" name="gender" id="inlineRadio21" value="女"> 女
  85.                             </label>
  86.                         </div>
  87.                     </div>
  88.                     <div class="form-group">
  89.                         <label for="UserTel1" class="col-sm-2 control-label">电话</label>
  90.                         <div class="col-sm-10">
  91.                             <input type="text" class="form-control" id="UserTel1" placeholder="电话">
  92.                         </div>
  93.                     </div>
  94.                     <div class="form-group">
  95.                         <label for="UserBir1" class="col-sm-2 control-label">日期</label>
  96.                         <div class="col-sm-10">
  97.                             <input type="date" class="form-control" id="UserBir1" placeholder="日期">
  98.                         </div>
  99.                     </div>
  100.                     <div class="form-group">
  101.                         <label for="UserEmail1" class="col-sm-2 control-label">邮箱</label>
  102.                         <div class="col-sm-10">
  103.                             <input type="email" class="form-control" id="UserEmail1" placeholder="邮箱">
  104.                         </div>
  105.                     </div>
  106.                 </form>
  107.             </div>
  108.             <div class="modal-footer">
  109.                 <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
  110.                 <button type="button" onclick="updateUser()" class="btn btn-primary">确认</button>
  111.             </div>
  112.         </div>
  113.     </div>
  114. </div>
  115. <!-- /.row -->
  116. <!-- jQuery -->
  117. <script src="../static/plugins/jquery/jquery.min.js"></script>
  118. <script src="../static/plugins/jquery-ui/jquery-ui.min.js"></script>
  119. <script src="../static/jqPaginator.js"></script>
  120. <script src="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
  121. <script src="../static/plugins/jquery-knob/jquery.knob.min.js"></script>
  122. <script src="../static/plugins/moment/moment.min.js"></script>
  123. <script src="../static/plugins/daterangepicker/daterangepicker.js"></script>
  124. <script src="../static/plugins/summernote/summernote-bs4.min.js"></script>
  125. <script src="../static/plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
  126. <script src="../static/dist/js/adminlte.js"></script>
  127.  
  128. <script>
  129.     var respData;
  130.     var cPage = null;
  131.     var pSize = null;
  132.     var username = null;
  133.     var usertel = null;
  134.     $(function () {
  135.         // queryUsers();
  136.         document.querySelector('#table-demo-ajaxPageCode').GM({
  137.             gridManagerName: 'demo-baseCode',
  138.             ajaxData: function (setting,params) {
  139.                 cPage = params.currentPage;
  140.                 pSize = params.pageSize;
  141.                 queryUsers(cPage,pSize,username,usertel);
  142.                 return respData;
  143.             },
  144.             supportAjaxPage: true,
  145.             sizeData: [5,10,15,20],
  146.             pageSize: 5,
  147.             currentPageKey: "currentPage",
  148.             pageSizeKey: "pageSize",
  149.             // ajaxType: 'POST',
  150.             columnData: [
  151.                 {
  152.                     key: 'userName',
  153.                     text: '用户名'
  154.                 },{
  155.                     key: 'userSex',
  156.                     text: '性别'
  157.                 },{
  158.                     key: 'userAge',
  159.                     text: '年龄'
  160.                 },{
  161.                     key: 'userTel',
  162.                     text: '电话'
  163.                 },{
  164.                     key: 'userBirthday',
  165.                     text: '日期'
  166.                 },{
  167.                     key: 'userEmail',
  168.                     text: '邮箱'
  169.                 },{
  170.                     key: 'userId',
  171.                     text: '操作',
  172.                     alien:'center',
  173.                     template:function (cell,row,index,key) {
  174.                         return "<button type='button' data-obj='"+JSON.stringify(row) +
  175.                             "' class= 'btn btn-success btn-sm'>编辑</button>&nbsp;&nbsp;&nbsp;&nbsp;" +
  176.                             "<button type='button' class= 'btn btn-success btn-sm' data-id='"+ cell +"'>删除</button>";
  177.                     }
  178.                 }
  179.             ]
  180.         });
  181.  
  182.     });
  183.  
  184.     function queryUsers(cPage,pSize,username,usertel) {
  185.         $.ajax({
  186.             url:"../user/all",
  187.             type:"GET",
  188.             dataType:"json",
  189.             async:false,
  190.             data:{"currentPage":cPage,"pageSize":pSize,"userName":username,"userTel":usertel},
  191.             success:function (data) {
  192.                 if(data.status=="500"){
  193.                     window.location.href="../sys/error";
  194.                 }else
  195.                     respData = {"data":data.data,"totals":data.totals};
  196.             }
  197.         });
  198.     }
  199.  
  200.     $("#table-demo-ajaxPageCode").on("click","button[data-id]",function () {
  201.         var isDel = confirm("确认是否删除");
  202.         if (isDel){
  203.             var id = $(this).data("id");
  204.             $.ajax({
  205.                 url:"../user/"+id,
  206.                 type: "delete",
  207.                 dataType: "json",
  208.                 success:function (data) {
  209.                     if (data.status=="200"){
  210.                         GridManager.refreshGrid('demo-baseCode');
  211.                     }else
  212.                     {
  213.                         alert("权限不足,请联系管理员");
  214.                     }
  215.                 },error:function (e) {
  216.                     alert("删除失败")
  217.                 }
  218.             })
  219.         }
  220.  
  221.     })
  222.     $("#table-demo-ajaxPageCode").on("click","button[data-obj]",function () {
  223.  
  224.         //    数据回显
  225.         var user = $(this).data("obj");
  226.         $("#userId").val(user.userId);
  227.         $("#UserName1").val(user.userName);
  228.         $("#UserAge1").val(user.userAge);
  229.         $("#UserTel1").val(user.userTel);
  230.         $("#UserEmail1").val(user.userEmail);
  231.         $("#UserBir1").val(user.userBirthday);
  232.         var sex = user.userSex;
  233.         if (sex=="男"){
  234.             $("#inlineRadio11").prop("checked",true);
  235.         }else if (sex =="女"){
  236.             $("#inlineRadio21").prop("checked",true);
  237.         }
  238.  
  239.         //    显示模态版
  240.         $("#myModal").modal('show');
  241.     })
  242.  
  243.     function updateUser() {
  244.         var id = $("#userId").val();
  245.         var name = $("#UserName1").val();
  246.  
  247.         var age = $("#UserAge1").val();
  248.         var tel = $("#UserTel1").val();
  249.         var email = $("#UserEmail1").val();
  250.         var bir = $("#UserBir1").val();
  251.         var sex = $("input[type='radio']:checked").val();
  252.         var users = {
  253.             "userId":id,
  254.             "userName":name,
  255.             "userAge":age,
  256.             "userTel":tel,
  257.             "userEmail":email,
  258.             "userBirthday":bir,
  259.             "userSex":sex,
  260.         };
  261.         $.ajax({
  262.             url:"../user/",
  263.             type:"put",
  264.             contentType:"application/json",
  265.             dataType:"json",
  266.             data:JSON.stringify(users),
  267.             success:function (data) {
  268.                 if (data.status=="200"){
  269.                     $("#myModal").modal('hide');
  270.                     GridManager.refreshGrid('demo-baseCode');
  271.                     console.log(id)
  272.                 }
  273.             }
  274.         })
  275.     }
  276.     function searchUser() {
  277.         cPage = 1;
  278.         pSize = 2;
  279.         username = $("#username").val();
  280.         usertel = $("#usertel").val();
  281.         GridManager.setQuery("demo-baseCode");
  282.     }
  283. </script>
  284.  
  285. </body>
  286. </html>

 11.controller

usercontroller

  1. package com.hqyj.poison.controller;
  2.  
  3.  
  4. import com.hqyj.poison.entity.Pwd;
  5. import com.hqyj.poison.entity.User;
  6. import com.hqyj.poison.query.QueryOrderBean;
  7. import com.hqyj.poison.query.QueryUserBean;
  8. import com.hqyj.poison.result.ResultInfo;
  9. import com.hqyj.poison.service.UserService;
  10. import com.hqyj.poison.utils.MD5Util;
  11. import org.apache.ibatis.annotations.Param;
  12. import org.apache.shiro.authz.annotation.Logical;
  13. import org.apache.shiro.authz.annotation.RequiresRoles;
  14. import org.apache.shiro.crypto.hash.SimpleHash;
  15. import org.springframework.beans.factory.annotation.Autowired;
  16. import org.springframework.stereotype.Controller;
  17. import org.springframework.web.bind.annotation.*;
  18.  
  19. @Controller
  20. @RequestMapping("/user")
  21. public class UserController {
  22.     @Autowired
  23.     private UserService userService;
  24.  
  25.     @RequiresRoles(value = {"admin"})
  26. //角色权限限制
  27.     @RequestMapping("/all")
  28.     @ResponseBody
  29.     public ResultInfo queryUsers(QueryUserBean queryUserBean){
  30.         return userService.selectUsers(queryUserBean);
  31.     }
  32.  
  33.     @RequiresRoles(value = {"admin","user"},logical = Logical.OR)
  34. //or代表二选一皆可；and代表同时满足
  35.     @RequestMapping("/change")
  36.     @ResponseBody
  37.     public ResultInfo queryUsersByIdAndPwd(Pwd pwd){
  38.         System.out.println(pwd.getUserName());
  39.         System.out.println(pwd.getUserPwd());
  40.         System.out.println(pwd.getNewPwd());
  41.         String password =  new SimpleHash("MD5",pwd.getUserPwd(),pwd.getUserName(),1024).toString();
  42.         pwd.setUserPwd(password);
  43.         User users = userService.queryUsersByIdAndPwd(pwd);
  44.  
  45.         if (users!=null){
  46.             String md5 = MD5Util.getPasswordByMD5(pwd.getNewPwd(),pwd.getUserName());
  47.             System.out.println(md5);
  48.             pwd.setUserPwd(md5);
  49.            return userService.updateUserPwdByName(pwd);
  50.         }
  51.         return new ResultInfo("500","密码错误");
  52.     }
  53.  
  54.     @RequiresRoles(value = {"admin"})
  55.     @DeleteMapping("/{id}")
  56.     @ResponseBody
  57.     public ResultInfo deleteUsers(@PathVariable("id") Integer userId){
  58.         return userService.deleteUserById(userId);
  59.     }
  60.  
  61.     @RequiresRoles(value = {"admin"})
  62.     @PutMapping("/")
  63.     @ResponseBody
  64.     public ResultInfo updateUser(@RequestBody User user){
  65.         return userService.updateUserById(user);
  66.     }
  67.  
  68. }

 newUsercontroller

  1. package com.hqyj.poison.controller;
  2.  
  3. import com.hqyj.poison.entity.User;
  4. import com.hqyj.poison.result.ResultInfo;
  5. import com.hqyj.poison.service.UserService;
  6. import com.hqyj.poison.utils.MD5Util;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.stereotype.Controller;
  9. import org.springframework.web.bind.annotation.GetMapping;
  10. import org.springframework.web.bind.annotation.PostMapping;
  11. import org.springframework.web.bind.annotation.RequestMapping;
  12. import org.springframework.web.bind.annotation.ResponseBody;
  13.  
  14.  
  15. @Controller
  16. @RequestMapping("/new")
  17. public class newUserController {
  18.     @Autowired
  19.     private UserService userService;
  20.     @PostMapping
  21.     @ResponseBody
  22.     public ResultInfo newUser(User user){
  23. //注册密码加密
  24.         String md5 = MD5Util.getPasswordByMD5(user.getUserPwd(), user.getUserName());
  25.         user.setUserPwd(md5);
  26.         return userService.newUser(user);
  27.     }
  28. }

ExceptionController(处理异常的cotroller） 

  1. package com.hqyj.poison.controller;
  2.  
  3. import com.hqyj.poison.result.ResultInfo;
  4. import org.apache.shiro.authz.AuthorizationException;
  5. import org.springframework.core.Ordered;
  6. import org.springframework.core.annotation.Order;
  7. import org.springframework.web.bind.annotation.ControllerAdvice;
  8. import org.springframework.web.bind.annotation.ExceptionHandler;
  9. import org.springframework.web.bind.annotation.ResponseBody;
  10.  
  11. import javax.servlet.http.HttpServletRequest;
  12.  
  13. @ControllerAdvice
  14. public class ExceptionController {
  15.     /**
  16.      * 集中处理 controller 层 AuthorizationException 异常
  17.      */
  18.     @ExceptionHandler(value= {AuthorizationException.class})
  19.     @Order(Ordered.HIGHEST_PRECEDENCE)
  20.     @ResponseBody
  21.     public ResultInfo handlerAccessDeniedException(HttpServletRequest request,
  22.                                                    AuthorizationException exception){
  23.         return new ResultInfo("500", "noPermission");
  24.     }
  25.  
  26. }

 SystemCotroller

  1. package com.hqyj.poison.controller;
  2.  
  3. import com.hqyj.poison.entity.User;
  4. import com.hqyj.poison.result.ResultInfo;
  5. import com.hqyj.poison.service.UserService;
  6. import org.apache.shiro.SecurityUtils;
  7. import org.apache.shiro.authz.annotation.RequiresAuthentication;
  8. import org.apache.shiro.subject.Subject;
  9. import org.springframework.beans.factory.annotation.Autowired;
  10. import org.springframework.stereotype.Controller;
  11. import org.springframework.web.bind.annotation.GetMapping;
  12. import org.springframework.web.bind.annotation.PostMapping;
  13. import org.springframework.web.bind.annotation.RequestMapping;
  14. import org.springframework.web.bind.annotation.ResponseBody;
  15.  
  16. @Controller
  17. @RequestMapping("/sys")
  18. public class SystemController {
  19.     @Autowired
  20.     private UserService userService;
  21.     @PostMapping("/login")
  22.     @ResponseBody
  23.     public ResultInfo login(String userName, String userPwd){
  24.         return userService.login(userName,userPwd);
  25.     }
  26.  
  27.     @RequiresAuthentication
  28.     @GetMapping("/loginOut")
  29.     public ResultInfo logout() {
  30.         //在这里执行退出系统前需要清空的数据
  31.         Subject subject = SecurityUtils.getSubject();
  32.         if(subject.isAuthenticated()) {
  33.             subject.logout();
  34.         }
  35.         System.out.println("退出登录成功");
  36.         return new ResultInfo("200","success");
  37.     }
  38. }
odercontroller
  1. package com.hqyj.poison.controller;
  2.  
  3.  
  4. import com.hqyj.poison.entity.Order;
  5. import com.hqyj.poison.entity.User;
  6. import com.hqyj.poison.query.QueryOrderBean;
  7. import com.hqyj.poison.result.ResultInfo;
  8. import com.hqyj.poison.service.UserService;
  9. import org.apache.shiro.authz.annotation.Logical;
  10. import org.apache.shiro.authz.annotation.RequiresRoles;
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.stereotype.Controller;
  13. import org.springframework.web.bind.annotation.*;
  14.  
  15. @Controller
  16. @RequestMapping("/order")
  17. public class OrderController {
  18.     @Autowired
  19.     private UserService userService;
  20.  
  21.     @RequiresRoles(value = {"admin","user"},logical = Logical.OR)
  22.     @RequestMapping("/orderAll")
  23.     @ResponseBody
  24.     public ResultInfo queryOrder(QueryOrderBean queryOrderBean){
  25.         return userService.selectOrders(queryOrderBean);
  26.     }
  27.  
  28.     @RequiresRoles(value = {"admin"})
  29.     @DeleteMapping("/{id}")
  30.     @ResponseBody
  31.     public ResultInfo deleteOrder(@PathVariable("id") Integer orderId){
  32.         return userService.deleteOrderById(orderId);
  33.     }
  34.  
  35.     @RequiresRoles(value = {"admin"})
  36.     @PutMapping("/")
  37.     @ResponseBody
  38.     public ResultInfo updateOrder(@RequestBody Order order){
  39.         return userService.updateOrderById(order);
  40.     }
  41.  
  42.     @RequiresRoles(value = {"admin"})
  43.     @PutMapping("/insert")
  44.     @ResponseBody
  45.     public ResultInfo insertOrder(@RequestBody Order order){
  46.         String orderNo = order.getOrderNo();
  47.         Order orders = userService.queryOrders(orderNo);
  48.         if (orders==null){
  49.             return userService.insertOrder(order);
  50.         }
  51.         else
  52.             return new ResultInfo("500","该订单已存在");
  53.     }
  54.  
  55.  
  56. }

pageController

  1. package com.hqyj.poison.controller;
  2.  
  3. import org.springframework.stereotype.Controller;
  4. import org.springframework.web.bind.annotation.RequestMapping;
  5.  
  6. @Controller
  7. @RequestMapping("/sys")
  8. public class PageController {
  9.     @RequestMapping("/gologin")
  10.     public String goLogin(){
  11.         return "login";
  12.     }
  13.     @RequestMapping("/index")
  14.     public String goIndex(){
  15.         return "index";
  16.     }
  17.     @RequestMapping("/error")
  18.     public String doError(){
  19.         return "error";
  20.     }
  21. }

 12.关于加密：MD5

Myrealm

  1. package com.hqyj.poison.realm;
  2.  
  3. import com.hqyj.poison.entity.Role;
  4. import com.hqyj.poison.entity.User;
  5. import com.hqyj.poison.service.UserService;
  6. import org.apache.shiro.SecurityUtils;
  7. import org.apache.shiro.authc.AuthenticationException;
  8. import org.apache.shiro.authc.AuthenticationInfo;
  9. import org.apache.shiro.authc.AuthenticationToken;
  10. import org.apache.shiro.authc.SimpleAuthenticationInfo;
  11. import org.apache.shiro.authz.AuthorizationInfo;
  12. import org.apache.shiro.authz.SimpleAuthorizationInfo;
  13. import org.apache.shiro.realm.AuthorizingRealm;
  14. import org.apache.shiro.subject.PrincipalCollection;
  15. import org.apache.shiro.util.ByteSource;
  16. import org.springframework.beans.factory.annotation.Autowired;
  17.  
  18. import java.util.HashSet;
  19. import java.util.List;
  20. import java.util.Set;
  21.  
  22. public class MyRealm extends AuthorizingRealm {
  23.  
  24.     @Autowired
  25.     private UserService userService;
  26.  
  27.     @Override
  28.     protected AuthorizationInfo doGetAuthorizationInfo(PrincipalCollection principalCollection) {
  29.         SimpleAuthorizationInfo simpleAuthorizationInfo = new SimpleAuthorizationInfo();
  30.         // 获取用户名
  31.         String userName = (String) principalCollection.getPrimaryPrincipal();
  32.         //  根据用户名查询所对应的角色
  33.         User user = userService.queryUserAndRole(userName);
  34.         //  用来存放角色名称的集合
  35.         Set<String> roleNames = new HashSet<>();
  36.         //   当前用户对应的角色
  37.         List<Role> roles = user.getRoleList();
  38.         for (Role role : roles) {
  39.             //将用户名所对应的的角色名称放入集合中
  40.             roleNames.add(role.getRoleName());
  41.         }
  42.         simpleAuthorizationInfo.addRoles(roleNames);
  43.  
  44.         return simpleAuthorizationInfo;
  45.     }
  46.  
  47.     @Override
  48.     protected AuthenticationInfo doGetAuthenticationInfo(AuthenticationToken authenticationToken) throws AuthenticationException {
  49.         String userName = (String) authenticationToken.getPrincipal();
  50.         User user = userService.queryUser(userName);
  51. //        将查询出来的用户存放到shiro提供的session中
  52.         SecurityUtils.getSubject().getSession().setAttribute("u",user);
  53.         // 该用户不存在
  54.         if(user==null){
  55.             return null;
  56.         }
  57.         // 获取盐
  58.         ByteSource salt = ByteSource.Util.bytes(userName);
  59.         // 返回认证信息由父类AuthenticatingRealm进行认证
  60.         // getName() :父类的一个方法，获取当前数据源的名称（MyRealm）
  61.         SimpleAuthenticationInfo simpleAuthenticationInfo = new SimpleAuthenticationInfo(userName,user.getUserPwd(),salt,getName());
  62.         return simpleAuthenticationInfo;
  63.     }
  64. }

工具类：Util中

 

MD5Util
  1. package com.hqyj.poison.utils;
  2.  
  3. import org.apache.shiro.crypto.hash.SimpleHash;
  4.  
  5. public class MD5Util {
  6.     private String userPassword;
  7.     private String userName;
  8.  
  9.     public static String getPasswordByMD5(String password,String salt){
  10.         String simpleHash =  new SimpleHash("MD5",password,salt,1024).toString();
  11.         return simpleHash;
  12.     }
  13. }

 13.关于分页部分：

这个部分相对而言比较难，因此，我个人觉得可以不实现，直接使用表单返回查询和显示的数据也是可以的。（此处运用了gridmanaer:GridManager - Demo (lovejavascript.com)）

 

 

QueryOrderBean:

  1. package com.hqyj.poison.query;
  2.  
  3.  
  4. import lombok.Data;
  5.  
  6. @Data
  7. public class QueryOrderBean {
  8.     private Integer currentPage;
  9.     private Integer pageSize;
  10.     private String orderName;
  11.     private String orderTel;
  12.  
  13.  
  14.     private Integer startIndex;
  15.  
  16.  
  17.     public Integer getStartIndex() {
  18.         return this.startIndex = (this.currentPage-1)*this.pageSize;   }
  19.  
  20. }

QueryUserBean: 

  1. package com.hqyj.poison.query;
  2.  
  3.  
  4. import lombok.Data;
  5.  
  6. @Data
  7. public class QueryUserBean {
  8. //    当前页码
  9.     private Integer currentPage;
  10. //    每页展示的条数
  11.     private Integer pageSize;
  12. //    搜索条件
  13.     private String userName;
  14.     private String userTel;
  15.  
  16.  
  17.     private Integer startIndex;
  18.  
  19.  
  20.     public Integer getStartIndex() {
  21.         return this.startIndex = (this.currentPage-1)*this.pageSize;   }
  22.  
  23. }

 Resultlnfo:

  1. package com.hqyj.poison.result;
  2.  
  3. import com.hqyj.poison.entity.User;
  4. import lombok.Data;
  5.  
  6. import java.util.List;
  7.  
  8. @Data
  9. public class ResultInfo {
  10.     private String status;
  11.     private Integer totals;
  12.     private String message;
  13.     private Object data;
  14.  
  15.     //返回出错
  16.     public ResultInfo(String status, String message) {
  17.         this.status = status;
  18.         this.message = message;
  19.     }
  20. //返回grid渲染表格的数据
  21.     public ResultInfo(String status, Integer totals, Object data) {
  22.         this.status = status;
  23.         this.totals = totals;
  24.         this.data = data;
  25.     }
  26. //返回不需要分页的数据
  27.     public ResultInfo(String status, String message, Object data) {
  28.         this.status = status;
  29.         this.message = message;
  30.         this.data = data;
  31.     }
  32.  
  33.  
  34. }

结果：

 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/article/detail/48929
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号