整合SSM及学生管理系统实验

manster1231

已于 2022-06-28 14:42:51 修改

阅读量343

点赞数 1

分类专栏：项目文章标签： tomcat java maven

于 2021-06-17 12:10:18 首次发布

本文链接：https://blog.csdn.net/qq_45803593/article/details/117988783

版权

项目专栏收录该内容

30 篇文章 37 订阅

订阅专栏

实验源代码地址：https://gitee.com/manster1231/student-management-system

前提

配置好 maven，所有关于 jdk 的版本一定要一致

1.创建一个Maven项目

1、pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.manster</groupId>
    <artifactId>helloworld</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>

        <!-- spring -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.2.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>5.2.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-expression</artifactId>
            <version>5.2.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>5.2.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.2.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>5.2.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.2.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.2.6.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>5.2.6.RELEASE</version>
        </dependency>

        <!-- mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.5</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.21</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.5</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <dependency>
            <groupId>commons-logging</groupId>
            <artifactId>commons-logging</artifactId>
            <version>1.1.1</version>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>

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

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

</project>

2、创建项目 helloworld

创建完成项目后在自项目上点击右键 Add Framework Support
选择 web Application
如果 Java EE 中没有 web Application 选项
- File -> Project Structure -> Facts
- 将项目的 web 删除，点击 Apply
然后选择 web Application

此时就生成了具有 web.xml 的 Maven 项目

3、添加 tomcat

1.点击配置启动项

123

2.选择配置tomcat

tomcat1

3.选择本地所下载的 tomcat，并配置项目访问端口号

tomcat2

4.配置路径

tomcat3

4、将jar包发送至输出路径

File -> Project Structure -> Artifacts
点击 helloworld:war exploded
在 Output Layout 中在 WEB-INF 下创建一个 lib 文件夹
将所有 jar 包导入到这个文件夹中
点击 Apply 完成配置

2.配置xml

1.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">
    <!--  配置加载Spring文件的监听器  -->
    <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>
    <!--  编码过滤器  -->
    <filter>
        <filter-name>encoding</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>encoding</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!--  注册DispatcherServlet  -->
    <servlet>
        <servlet-name>springmvc</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <!--    关联一个springmvc配置文件    -->
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:springmvc-config.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>
</web-app>

2.spring配置

在 resources 下创建 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:tx="http://www.springframework.org/schema/tx"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd">
    <!-- 配置自动扫描IOC注解 -->
    <context:component-scan base-package="com.mhr.service"/>
    <!-- 加载jdbc属性文件 -->
    <context:property-placeholder location="classpath:db.properties" />
    <!-- 配置数据库连接jdbc -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <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="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!--注入数据源-->
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <tx:annotation-driven transaction-manager="transactionManager"/>

    <!-- myBatis配置 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- 配置数据库表对应的java实体类 -->
        <property name="typeAliasesPackage" value="com.mhr.pojo" />
        <property name="mapperLocations" value="classpath:/mapper/*.xml"/>
        <!-- 指定mybatis配置文件位置 -->
        <property name="configLocation" value="classpath:mybatis-config.xml" />
    </bean>
    <!--配置自动扫描mapper文件，包括扫描mapper.java以及同目录下的xml文件-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.mhr.dao" />
    </bean>
</beans>

3.springmvc

在 resources 下创建 springmvc-config.xml

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

    <!-- 自动扫描包，让指定包下的注解生效,由IOC容器统一管理 -->
    <!-- 使用 Annotation 自动注册 Bean,只扫描 @Controller -->
    <context:component-scan base-package="com.mhr.controller" />
    <!-- 让Spring MVC不处理静态资源 -->
    <mvc:default-servlet-handler />
    <!--支持mvc注解驱动-->
    <mvc:annotation-driven />
    
<!--    <mvc:resources mapping="/static/**" location="/static/" />-->

    <!-- 拦截器配置，拦截顺序：先执行后定义的，排在第一位的最后执行。-->
    <mvc:interceptors>
        <mvc:interceptor>
            <mvc:mapping path="/**"/>
            <mvc:exclude-mapping path="/static/**"/>
            <mvc:exclude-mapping path="/login"/>
            <bean class="com.mhr.interceptor.LoginInterceptor"/>
        </mvc:interceptor>
    </mvc:interceptors>

    <!--视图解析器:DispatcherServlet给他的ModelAndView-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" id="InternalResourceViewResolver">
        <!--前缀-->
        <property name="prefix" value="/WEB-INF/view/"/>
        <!--后缀-->
        <property name="suffix" value=".jsp"/>
    </bean>
</beans>

4.配置mybatis

在 resources 下创建 mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases>
        <package name="com.mhr.pojo"/>
    </typeAliases>

</configuration>

5.数据库连接配置

在 resources 下创建 db.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/db_mhr?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
jdbc.username=root
jdbc.password=123456

6.创建 sql 日志打印

log4j.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/xml/doc-files/log4j.dtd">

<log4j:configuration>

    <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
        <param name="Encoding" value="UTF-8"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m  (%F:%L) \n"/>
        </layout>
    </appender>
    <logger name="java.sql">
        <level value="debug"/>
    </logger>
    <logger name="org.apache.ibatis">
        <level value="info"/>
    </logger>
    <root>
        <level value="debug"/>
        <appender-ref ref="STDOUT"/>
    </root>
</log4j:configuration>

3.创建jsp

在 web 下创建 static 目录用来放置静态文件

在 WEB-INF 下创建 view 目录，里面创一个 hello.jsp

<%--
  Created by IntelliJ IDEA.
  User: hp
  Date: 2021/4/21
  Time: 22:06
  To change this template use File | Settings | File Templates.
--%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" isELIgnored="false" language="java" %>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>学生管理登录</title>
</head>
<body>

<div>
    <div>
        <div>
            <div>
                <h2>
                    <div>
                        学生管理登录
                    </div>
                </h2>
                <form method="post" action="${pageContext.request.contextPath}/login">
                    <div>
                        <div>
                            <div >
                                <input type="text" name="username" placeholder="用户名">
                            </div>
                        </div>
                        <div>
                            <div >
                                <input type="password" name="password" placeholder="密码">
                            </div>
                        </div>
                        <button >登   录</button>
                    </div>

                    <c:if test="${msg!=null}">
                        <div>${msg}</div>
                    </c:if>
                </form>
            </div>
        </div>
    </div>
</div>

</body>
</html>

4.登录

package com.mhr.controller;

import com.mhr.pojo.Admin;
import com.mhr.service.LoginService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.util.DigestUtils;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;

import javax.servlet.http.HttpServletRequest;

/**
 * @Author manster
 * @Date 2021/4/21
 **/
@Controller
public class LoginController {

    @Autowired
    private LoginService loginService;

    @GetMapping(value = "login")
    public String toLogin(){
        return "login";
    }

    @PostMapping(value = "login")
    public String login(@RequestParam(name = "username")String name,
                        @RequestParam(name = "password")String password,
                        HttpServletRequest request,
                        Model model){

        Admin admin = loginService.login(name);
        //管理员是否存在
        if(!StringUtils.isEmpty(admin)){
            //判断密码是否正确
            if(DigestUtils.md5DigestAsHex(password.getBytes()).equals(admin.getPassword())){
                request.getSession().setAttribute("admin",admin);
                return "redirect:/list";
            }
            model.addAttribute("msg","密码错误");
            return "login";

        }

        model.addAttribute("msg","用户不存在");
        return "login";

    }

}

1、pojo：实体类

package com.mhr.pojo;

/**
 * @Author manster
 * @Date 2021/5/26
 **/
public class Admin {

    private Integer id;

    private String name;

    private String password;

	//get、set
}

2、dao：持久层

package com.mhr.dao;

import com.mhr.pojo.Admin;
import org.springframework.stereotype.Repository;

/**
 * @Author manster
 * @Date 2021/5/26
 **/
@Repository
public interface AdminMapper {

    Admin getPassword(String name);

}

3、AdminMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mhr.dao.AdminMapper">

    <select id="getPassword" resultType="com.mhr.pojo.Admin">
        select * from admin where name = #{name}
    </select>

</mapper>

4、service：业务层接口

package com.mhr.service;

import com.mhr.pojo.Admin;

/**
 * @Author manster
 * @Date 2021/5/26
 **/
public interface LoginService {

    //登录校验
    Admin login(String name);

}

5、impl：业务实现

package com.mhr.service.impl;

import com.mhr.dao.AdminMapper;
import com.mhr.pojo.Admin;
import com.mhr.service.LoginService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @Author manster
 * @Date 2021/5/26
 **/
@Service
public class LoginServiceImpl implements LoginService {

    @Autowired
    private AdminMapper adminMapper;

    @Override
    public Admin login(String name) {
        return adminMapper.getPassword(name);
    }
}

6、interceptor：拦截器

package com.mhr.interceptor;

import com.mhr.pojo.Admin;
import org.springframework.web.servlet.HandlerInterceptor;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * @Author manster
 * @Date 2021/5/26
 **/
public class LoginInterceptor implements HandlerInterceptor {

    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {

        Admin admin = (Admin) request.getSession().getAttribute("admin");
        if(admin == null){
            response.sendRedirect("/login");
        }

        return true;
    }
}

7、controller：控制器

package com.mhr.controller;

import com.mhr.pojo.Admin;
import com.mhr.service.LoginService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.util.DigestUtils;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;

import javax.servlet.http.HttpServletRequest;

/**
 * @Author manster
 * @Date 2021/4/21
 **/
@Controller
public class LoginController {

    @Autowired
    private LoginService loginService;

    @GetMapping(value = "login")
    public String toLogin(){
        return "login";
    }

    @PostMapping(value = "login")
    public String login(@RequestParam(name = "username")String name,
                        @RequestParam(name = "password")String password,
                        HttpServletRequest request,
                        Model model){

        Admin admin = loginService.login(name);
        //管理员是否存在
        if(!StringUtils.isEmpty(admin)){
            //判断密码是否正确
            if(DigestUtils.md5DigestAsHex(password.getBytes()).equals(admin.getPassword())){
                request.getSession().setAttribute("admin",admin);
                return "redirect:/list";
            }
            model.addAttribute("msg","密码错误");
            return "login";

        }

        model.addAttribute("msg","用户不存在");
        return "login";

    }

}

整体结构目录

ssm

manster1231

关注

1
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
整合SSM及学生管理系统实验

HelloWorld前提配置好 maven，所有关于 jdk 的版本一定要一致1.创建一个Maven项目1、pom.xml<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=
复制链接

扫一扫

专栏目录