首页 > 技术文章 > 基于Spring MVC + Spring + MyBatis的【学生信息管理系统】

vmuu 2021-11-29 10:00 原文

资源下载:https://download.csdn.net/download/weixin_44893902/45603211

练习点设计: 模糊查询、删除、新增

一、语言和环境

  1. 实现语言:JAVA语言。
  2. 环境要求:MyEclipse/Eclipse + Tomcat + MySql。
  3. 使用技术:Jsp+Servlet+JavaBeanSpringMVC + Spring + Mybatis

二、实现功能

随着数字化信息的发展,现需要制作学生信息管理系统,主要功能如下:
1.首页默认显示所有学生信息,如图1所示。
图1 首页显示所有信息
2.鼠标悬停某行数据时,以线性过渡动画显示光棒效果,如图2所示。
图2 鼠标悬停效果
3.用户输入学生名称,点击查询,则完成模糊查询,显示查询结果,如图3所示。
图3 模糊查询结果
4.用户点击删除,则弹出提示框,用户点击确定后,删除选中数据并显示最新数据,如图4和图5所示。
图4 确认删除提示窗口
图5 数据删除后显示最新数据

5.用户点击“新增”按钮,则打开新增页面,填写完相关信息后点击新增按钮,增加学生信息数据到数据库,且页面跳转到列表页面展示最新数据,如图6和图7所示。
图6 增加数据
图7 展示最新数据

三、 数据库设计

1.创建数据库(stu_db)。
2.创建数据表(student),结构如下。

字段名说明字段类型长度备注
id编号int主键,自增
name学生姓名varchar50不能为空
age年龄int不能为空
classes班级名称varchar50不能为空
birth出生日期date不能为空

四、推荐实现步骤

1.SSM版本的实现步骤如下:

(1)创建数据库和数据表,添加测试数据(至少添加4条测试数据)。
(2)创建Web工程并创建各个包,导入工程所需的jar文件。
(3)添加相关SSM框架支持。
(4)配置项目所需要的各种配置文件(mybatis配置文件、spring配置文件、springMVC配置文件)。
(5)创建实体类。
(6)创建MyBatis操作数据库所需的Mapper接口及其Xml映射数据库操作语句文件。
(7)创建业务逻辑相应的接口及其实现类,实现相应的业务,并在类中加入对DAO/Mapper的引用和注入。
(8)创建Controller控制器类,在Controller中添加对业务逻辑类的引用和注入,并配置springMVC配置文件。
(9)创建相关的操作页面,并使用CSS对页面进行美化。
(10)实现页面的各项操作功能,并在相关地方进行验证,操作要人性化。
(11)调试运行成功后导出相关的数据库文件并提交。

五、实现代码

1、MySQL数据库

stu_db.sql
在这里插入图片描述

2、项目Java代码

目录结构

student
在这里插入图片描述

JAR包:

在这里插入图片描述在这里插入图片描述

src

com.controller

StudentController.java

package com.controller;

import java.util.List;

import javax.annotation.Resource;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import com.dao.StudentMapper;
import com.entity.Student;
import com.service.StudentService;

@Controller
public class StudentController {
	@Resource
	StudentService service;
	@RequestMapping("/selectStudent")
	public ModelAndView selectStudent(String keyword) {
		List<Student> studentList=service.selectAll(keyword);
		if (keyword==null||keyword.trim().equals("")) {
			keyword="";
		}
		System.out.println("123456");
		ModelAndView modelAndView = new ModelAndView();
		modelAndView.addObject("studentList", studentList);
		modelAndView.setViewName("student");
		return modelAndView;
	}
	
	@RequestMapping("/delStudent")
	public String delStudent(int id) {
		int del=service.delStudent(id);
		return "redirect:/selectStudent.do";
	}
	
	@RequestMapping("/jumpInsert")
	public String jumpInsert() {
		return "addStudent";
	}
	@RequestMapping("/insertStudent")
	public String insertStudent(Student student) {
		int add=service.insertStudent(student);
		return "redirect:/selectStudent.do";
	}
}

com.dao

StudentMapper.java

package com.dao;

import com.entity.Student;
import java.util.List;

public interface StudentMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Student record);

    Student selectByPrimaryKey(Integer id);

    List<Student> selectAll();

    int updateByPrimaryKey(Student record);

	List<Student> likeSelect(String keyword);
}

StudentMapper.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.dao.StudentMapper" >
  <resultMap id="BaseResultMap" type="com.entity.Student" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="age" property="age" jdbcType="INTEGER" />
    <result column="classes" property="classes" jdbcType="VARCHAR" />
    <result column="birth" property="birth" jdbcType="VARCHAR" />
  </resultMap>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    delete from student
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.entity.Student" >
    insert into student (id, name, age, 
      classes, birth)
    values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER}, 
      #{classes,jdbcType=VARCHAR}, #{birth,jdbcType=VARCHAR})
  </insert>
  <update id="updateByPrimaryKey" parameterType="com.entity.Student" >
    update student
    set name = #{name,jdbcType=VARCHAR},
      age = #{age,jdbcType=INTEGER},
      classes = #{classes,jdbcType=VARCHAR},
      birth = #{birth,jdbcType=VARCHAR}
    where id = #{id,jdbcType=INTEGER}
  </update>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select id, name, age, classes, birth
    from student
    where id = #{id,jdbcType=INTEGER}
  </select>
  <select id="selectAll" resultMap="BaseResultMap" >
    select id, name, age, classes, birth
    from student
  </select>
  <select id="likeSelect" resultMap="BaseResultMap" >
    select id, name, age, classes, birth
    from student where `name` LIKE "%"#{name}"%"
  </select>
</mapper>

com.entity

Student.java

package com.entity;

public class Student {
    private Integer id;

    private String name;

    private Integer age;

    private String classes;

    private String birth;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name == null ? null : name.trim();
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getClasses() {
        return classes;
    }

    public void setClasses(String classes) {
        this.classes = classes == null ? null : classes.trim();
    }

    public String getBirth() {
        return birth;
    }

    public void setBirth(String birth) {
        this.birth = birth == null ? null : birth.trim();
    }
}

com.generator

Generator.java

package com.generator;

import java.io.IOException;
import java.io.InputStream;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.exception.InvalidConfigurationException;
import org.mybatis.generator.exception.XMLParserException;
import org.mybatis.generator.internal.DefaultShellCallback;

public class Generator {
	/*
	 * targetRuntime="MyBatis3Simple", 不生成Example
	 */
	public void generateMyBatis() {
		//MBG执行过程中的警告信息
		List<String> warnings = new ArrayList<String>();
		//当生成的代码重复时,覆盖原代码
		boolean overwrite = true ;
		//String generatorFile = "/generator/generatorConfig.xml";
		String generatorFile = "/generatorConfig.xml";
		//读取MBG配置文件
		InputStream is = Generator.class.getResourceAsStream(generatorFile);
		ConfigurationParser cp = new ConfigurationParser(warnings);
		Configuration config;
		try {
			config = cp.parseConfiguration(is);
			DefaultShellCallback callback = new DefaultShellCallback(overwrite);
			//创建MBG
			MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
			//执行生成代码
			myBatisGenerator.generate(null);
		} catch (IOException e) {
			e.printStackTrace();
		} catch (XMLParserException e) {
			e.printStackTrace();
		} catch (InvalidConfigurationException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (InterruptedException e) {
			e.printStackTrace();
		}
		for (String warning : warnings) {
			System.out.println(warning);
		}
	}
	
	public static void main(String[] args) {
		Generator generator = new Generator();
		generator.generateMyBatis();
	}
}

com.service

StudentService.java

package com.service;

import java.util.List;

import com.entity.Student;

public interface StudentService {
	//查询
	List<Student> selectAll(String keyword);
	//删除
	int delStudent(int id);
	//添加
	int insertStudent(Student student);
}

com.service.imp

StudentServiceImpl.java

package com.serviceImpl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.dao.StudentMapper;
import com.entity.Student;
import com.service.StudentService;

@Service
public class StudentServiceImpl implements StudentService {
	@Resource
	StudentMapper mapper;

	@Override
	// 查询
	public List<Student> selectAll(String keyword) {
		if (keyword == null || keyword.trim().equals("")) {
			List<Student> selectAll = mapper.selectAll();
			return selectAll;
		} else {
			List<Student> likeSelect = mapper.likeSelect(keyword);
			return likeSelect;
		}
	}

	// 删除
	@Override
	public int delStudent(int id) {
		int del = mapper.deleteByPrimaryKey(id);
		return del;
	}

	// 添加
	@Override
	public int insertStudent(Student student) {
		int insert = mapper.insert(student);
		return insert;
	}
}

mybatis

sqlMapConfig.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.entity" />
	</typeAliases>
</configuration>

spring

applicationContext-dao.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xmlns="http://www.springframework.org/schema/beans" 
	xmlns:p="http://www.springframework.org/schema/p" 
	xmlns:context="http://www.springframework.org/schema/context" 
	xmlns:aop="http://www.springframework.org/schema/aop" 
	xmlns:tx="http://www.springframework.org/schema/tx" 
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans-4.2.xsd 
	http://www.springframework.org/schema/context 
	http://www.springframework.org/schema/context/spring-context-4.2.xsd 
	http://www.springframework.org/schema/aop 
	http://www.springframework.org/schema/aop/spring-aop-4.2.xsd 
	http://www.springframework.org/schema/tx
	http://www.springframework.org/schema/tx/spring-tx.xsd
	http://www.springframework.org/schema/mvc 
		http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd ">
	
	<!-- 指定spring容器读取db.properties文件 -->
	<context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
	<!-- 将连接池注册到bean容器中 -->
	<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
		<property name="driverClassName" value="${jdbc.driver}"></property>
		<property name="Url" value="${jdbc.url}"></property>
		<property name="username" value="${jdbc.username}"></property>
		<property name="password" value="${jdbc.password}"></property>
	</bean>
	<!-- 配置SqlSessionFactory -->
	<bean class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 设置MyBatis核心配置文件 -->
		<property name="configLocation" value="classpath:mybatis/sqlMapConfig.xml" />
		<!-- 设置数据源 -->
		<property name="dataSource" ref="dataSource" />
	</bean>
	<!-- 配置Mapper扫描 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<!-- 设置Mapper扫描包 -->
		<property name="basePackage"  value="com.dao" />
	</bean>
	<!-- 配置事务管理器 -->
		<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
			<property name="dataSource" ref="dataSource"></property>
		</bean>
		<!-- 开启注解方式管理AOP事务 -->
		<tx:annotation-driven transaction-manager="transactionManager" />
</beans>

applicationContext-service.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
		xmlns="http://www.springframework.org/schema/beans" 
		xmlns:context="http://www.springframework.org/schema/context" 
		xmlns:aop="http://www.springframework.org/schema/aop" 
		xmlns:tx="http://www.springframework.org/schema/tx" 
		xmlns:mvc="http://www.springframework.org/schema/mvc" 
		xsi:schemaLocation="http://www.springframework.org/schema/beans 
		http://www.springframework.org/schema/beans/spring-beans-4.2.xsd 
		http://www.springframework.org/schema/context 
		http://www.springframework.org/schema/context/spring-context-4.2.xsd 
		http://www.springframework.org/schema/aop 
		http://www.springframework.org/schema/aop/spring-aop-4.2.xsd 
		http://www.springframework.org/schema/tx 
		http://www.springframework.org/schema/tx/spring-tx-4.2.xsd 
		http://www.springframework.org/schema/mvc 
		http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd ">
		<!-- 配置Service扫描 -->
		<context:component-scan base-package="com" />
		
</beans>

spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
		xmlns="http://www.springframework.org/schema/beans" 
		xmlns:context="http://www.springframework.org/schema/context" 
		xmlns:aop="http://www.springframework.org/schema/aop" 
		xmlns:tx="http://www.springframework.org/schema/tx" 
		xmlns:mvc="http://www.springframework.org/schema/mvc" 
		xsi:schemaLocation="http://www.springframework.org/schema/beans 
		http://www.springframework.org/schema/beans/spring-beans-4.2.xsd 
		http://www.springframework.org/schema/context 
		http://www.springframework.org/schema/context/spring-context-4.2.xsd 
		http://www.springframework.org/schema/aop 
		http://www.springframework.org/schema/aop/spring-aop-4.2.xsd 
		http://www.springframework.org/schema/tx 
		http://www.springframework.org/schema/tx/spring-tx-4.2.xsd 
		http://www.springframework.org/schema/mvc 
		http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd ">
		
		<!-- 配置Controller扫描 -->
		<context:component-scan base-package="com.controller" />
		<!-- 配置注解驱动 -->
		<mvc:annotation-driven />
		<!-- 配置视图解析器 -->
		<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
			<!-- 前缀 -->
			<property name="prefix" value="/WEB-INF/jsp/" />
			<!-- 后缀 -->
			<property name="suffix" value=".jsp" />
		</bean>
</beans>

generatorConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
  PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<!-- 配置生成器 -->
<generatorConfiguration>
	<context id="MySQLContext" targetRuntime="MyBatis3Simple"
		defaultModelType="flat">
		<!-- 配置前置分隔符和后置分隔符 -->
		<property name="beginningDelimiter" value="`" />
		<property name="endingDelimiter" value="`" />
		<!-- 配置注释信息 -->
		<commentGenerator>
			<!-- 不生成注释 -->
			<property name="suppressAllComments" value="true" />
			<property name="suppressDate" value="true" />
			<property name="addRemarkComments" value="true" />
		</commentGenerator>
		<!-- 数据库连接配置 -->
		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
			connectionURL="jdbc:mysql://localhost:3306/stu_db" userId="root"
			password="root">
		</jdbcConnection>

		<!-- targetPackage:生成实体类存放的包名, targetProject:指定目标项目路径,可以使用相对路径或绝对路径 -->
		<javaModelGenerator targetPackage="com.entity"
			targetProject="src">
			<property name="trimStrings" value="true" />
		</javaModelGenerator>

		<!-- 配置SQL映射器Mapper.xml文件的属性 -->
		<sqlMapGenerator targetPackage="com.dao"
			targetProject="src" />

		<!-- type="XMLMAPPER":所有的方法都在XML中,接口调用依赖XML文件 -->
		<javaClientGenerator targetPackage="com.dao" type="XMLMAPPER"
			targetProject="src" />

		<!-- 生成所有表的映射 -->
		<table tableName="%"></table>
	</context>
</generatorConfiguration>

jdbc.properties

jdbc.url=jdbc:mysql://localhost:3306/stu_db?useUnicode=true&characterEncoding=UTF-8&useSSL=false
jdbc.username=root
jdbc.password=123456
jdbc.driver=com.mysql.jdbc.Driver

WebContent

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  <display-name>library.two</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  <!--spring容器  -->
  <context-param>
  	<param-name>contextConfigLocation</param-name>
  	<param-value>classpath:spring/applicationContext-*.xml</param-value>
  </context-param>
  <!-- 监听器,加载spring配置 -->
  <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/spring-mvc.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>springmvc</servlet-name>
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>
	<!-- 设置post请求的字符编码过滤器 -->
  <filter>
        <filter-name>CharacterEncodingFilter</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>CharacterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
</web-app>

JSP

Home.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<!DOCTYPE html>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme()+"://"+request.getServerName()+":"
		+request.getServerPort()+path;
%>
<html>
<head>
<meta charset="utf-8">
<title>学生信息管理系统</title>
</head>
<body>
	<script type="text/javascript">
	window.location.href="<%=basePath%>/selectStudent.do";
</script>
</body>
</html>

addStudent.jsp

<?xml version="1.0" encoding="UTF-8" ?>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title></title>
</head>
<body>
	<div class="addMoot">
		<form action="insertStudent.do" method="post">
			<input type="hidden" name="id" value="${studentList.id}" />
			<p class="add_title">录入新同学</p>
			<table border="0" cellspacing="0" cellpadding="0">
				<tr>
					<td>学生姓名:</td>
					<td><input type="text" name="name" value="${student.name}"></td>
				</tr>
				<tr>
					<td>年龄:</td>
					<td><input type="text" name="age" value="${student.age}"></td>
				</tr>
				<tr>
					<td>班级名称:</td>
					<td><input type="text" name="classes"
						value="${student.classes}"></td>
				</tr>
				<tr>
					<td>生日:</td>
					<td><input type="date" name="birth" value="${student.birth}"></td>
				</tr>
				<tr>
					<td class="btn" colspan="2"><input class="button"
						type="submit" value="新增" />&nbsp;&nbsp;&nbsp; <input class="reset"
						type="button" onclick="history.go(-1);" value="取消" /></td>
				</tr>
			</table>
		</form>
	</div>
</body>
</html>

student.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<head>
<meta charset="utf-8">
<title>学生信息管理系统</title>
</head>
<style type="text/css">
tr:hover {
	background: orange;
}
</style>
<body>

	<form action="">
		<fieldset style="height: 60px">
			<legend>&nbsp;&nbsp;&nbsp;搜索</legend>
			姓名:<input type="text" placeholder="请输入姓名搜索" name="keyword"
				style="height: 25px;" />
			<button type="submit">查询</button>
			<button>
				<a href="jumpInsert.do">新增</a>
			</button>
		</fieldset>

	</form>
	<table border="1px">
		<tr>
			<th>编号</th>
			<th>学生姓名</th>
			<th>年龄</th>
			<th>班级名称</th>
			<th>生日</th>
			<th>操作</th>
		</tr>
		<c:forEach var="student" items="${studentList }" varStatus="item">
			<tr>
				<td>${student.id}</td>
				<td>${student.name}</td>
				<td>${student.age}</td>
				<td>${student.classes}</td>
				<td>${student.birth}</td>
				<td><a onclick="del(${student.id})">删除</a></td>
			</tr>
		</c:forEach>
	</table>
	<div>

		<span>共${studentList.size()}条数据</span>
	</div>
	<script type="text/javascript">
	function del(id){
		
	    if(confirm("确认要删除吗?")){
	        return window.location.href="delStudent.do?id="+id;
	    }else {
	        return false;
	    }
	 }
	</script>

</body>
</html>

推荐阅读