SSM前端登录成功后跳转到查询页面

﹏ヽ暗。殇╰゛Y 2024-03-26 12:43 58阅读 0赞

#### SSM实现登录和查询功能 ####

*  写在前面
 *  整个项目目录
 *  运行效果
 *  SSM整合配置文件
 *  源码获取

> 需求：前端到后端查询出一个sql显示，用spring、springmvc、mybatis

## 写在前面 ##

前提:熟悉Spring官网，下载Spring需要的pom坐标依赖。

> https://spring.io/

![在这里插入图片描述][88ee87aed8fa44599ae6a60aac0212d0.png]  
![在这里插入图片描述][80b52617f7c84225809dc96299e673ad.png]  
![在这里插入图片描述][20de29a9dff94d40a6382715a300db13.png]  
![在这里插入图片描述][5785192c230345ad99640ef40633eaff.png]  
![在这里插入图片描述][8550cd5e973a4d97898ea0e7db11f4f9.png]  
![在这里插入图片描述][967ac460570842e0bd20db0529ecfa8a.png]  
![在这里插入图片描述][3ea6d17e19514bb6aded3fd567acca20.png]  
![在这里插入图片描述][3b6d0ace5e1544518b52e050bf4aa3bb.png]

## 整个项目目录 ##

![在这里插入图片描述][c28b6f3643dc48d2a20dcf6fea3bf4d0.png]

## 运行效果 ##

![在这里插入图片描述][c037fb2ad2f64a2fbeed6c407773e4a7.png]

## SSM整合配置文件 ##

> applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xmlns:aop="http://www.springframework.org/schema/aop"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
            https://www.springframework.org/schema/beans/spring-beans.xsd
            http://www.springframework.org/schema/context
            https://www.springframework.org/schema/context/spring-context.xsd
            http://www.springframework.org/schema/tx
            https://www.springframework.org/schema/tx/spring-tx.xsd
            http://www.springframework.org/schema/aop
            https://www.springframework.org/schema/aop/spring-aop.xsd">
    
        
        <context:component-scan base-package="com.yxm"/>
    
        
        <context:property-placeholder file-encoding="utf-8" location="classpath:dbconfig.properties"/>
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
            <property name="driverClassName" value="${jdbc.driver}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    
            <property name="dataSource" ref="dataSource"/>
            <property name="typeAliasesPackage" value="cn.yxm.pojo"/>
        </bean>
    
        
        <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg index="0" ref="sqlSessionFactory" />
        </bean>
    
        
        <bean id="mapperConfig" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.yxm.dao"/>
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        </bean>
    
        
        <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
        
        
    
        
        <tx:advice id="txAdvice" transaction-manager="txManager">
            <tx:attributes>
                <tx:method name="select*" propagation="NOT_SUPPORTED"/>
                <tx:method name="query*" propagation="NOT_SUPPORTED"/>
                <tx:method name="find*" propagation="NOT_SUPPORTED"/>
                <tx:method name="insert*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
                <tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
                <tx:method name="save*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
                <tx:method name="update*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
                <tx:method name="upd*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
                <tx:method name="delete*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
                <tx:method name="del*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
            </tx:attributes>
        </tx:advice>
        <aop:config proxy-target-class="true" expose-proxy="true">
            <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.yxm.services.*.* (..))"/>
        </aop:config>
    
    </beans>

> dbconfig.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.username=root
    jdbc.password=123456
    jdbc.url=jdbc:mysql://localhost:3306/test

> spring-mvc.xml

> web.xml

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
                          http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
             version="4.0">
      
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
      </context-param>
    
      
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
    
      
      <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
      </servlet>
      <servlet-mapping>
        <servlet-name>springmvc</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-mapping>
    
      
      <filter>
        <filter-name>encodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
          <param-name>encoding</param-name>
          <param-value>utf-8</param-value>
        </init-param>
      </filter>
      <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
    
    </web-app>

/*
     Navicat Premium Data Transfer
    
     Source Server         : mysql
     Source Server Type    : MySQL
     Source Server Version : 50718
     Source Host           : localhost:3306
     Source Schema         : test
    
     Target Server Type    : MySQL
     Target Server Version : 50718
     File Encoding         : 65001
    
     Date: 24/02/2023 14:08:12
    */
    
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for person
    -- ----------------------------
    DROP TABLE IF EXISTS `person`;
    CREATE TABLE `person`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `age` int(11) NULL DEFAULT NULL,
      `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of person
    -- ----------------------------
    INSERT INTO `person` VALUES (1, '王昭君', 1, '杭州');
    INSERT INTO `person` VALUES (2, '白起', 2, '上海');
    
    -- ----------------------------
    -- Table structure for user
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of user
    -- ----------------------------
    INSERT INTO `user` VALUES (1, 'admin', '123456');
    
    SET FOREIGN_KEY_CHECKS = 1;

## 源码获取 ##

Gitee：https://gitee.com/yangxumin/ssm

[88ee87aed8fa44599ae6a60aac0212d0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/244a5b2f4d0d414888fcbc7426208b26.png
[80b52617f7c84225809dc96299e673ad.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/b5ae3d3c57b94d0ea0c039b4e2632bd9.png
[20de29a9dff94d40a6382715a300db13.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/af4b90a7ea0042578e1dfb09c6886588.png
[5785192c230345ad99640ef40633eaff.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/03c2ab62ec614576af0eb188883d04c7.png
[8550cd5e973a4d97898ea0e7db11f4f9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/6eb16344c13b4752b1c3f475834e4fe9.png
[967ac460570842e0bd20db0529ecfa8a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/7b03c87102d8464997f56f8439d59126.png
[3ea6d17e19514bb6aded3fd567acca20.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/4b6f7c6767444b4884239089e8de956c.png
[3b6d0ace5e1544518b52e050bf4aa3bb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/8f1847d073bd4aa3abe78031fd6764b6.png
[c28b6f3643dc48d2a20dcf6fea3bf4d0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/0a1be7d14df74d99b7badae347e5bf4d.png
[c037fb2ad2f64a2fbeed6c407773e4a7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/6edafeee54c2466bb19f540bc17dd296.png