失眠网 > idea 使用 maven 整合 ssm 框架实现简单的增删改和分页查询功能

idea 使用 maven 整合 ssm 框架实现简单的增删改和分页查询功能

时间：2023-12-11 07:24:47

详细请参考: idea 使用 maven 整合 ssm 框架

文章目录

==效果图==

==准备数据库==

==创建maven项目==

==配置文件==

pom.xml

jdbc.properties

Teacher.xml

applicationContext.xml

dispatcher-servlet.xml

web.xml

==java 文件==

Teacher 实体类

TeacherMappepr 接口

TeacherService 接口

TeacherServiceImpl 实现类

Page 辅助类

CrudController 控制类

==jsp 文件==

getAll.jsp

edit.jsp

getById.jsp

==源码下载==

效果图

浏览器输入:http://localhost:8080

准备数据库

创建 mybatis 数据库，在 mybatis 数据库中创建 teacher 数据库表，然后在表中插入几行数据

/*SQLyog Ultimate v12.09 (64 bit)MySQL - 5.5.53 **********************************************************************//*!40101 SET NAMES utf8 */;create table `teacher` (`id` int (11),`name` varchar (75),`age` int (15),`major` varchar (165)); insert into `teacher` (`id`, `name`, `age`, `major`) values('17070101','张学年','45','移动互联');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070102','刘佳明','34','法律学');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070103','吴美姨','28','软件测试');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070104','方逸雅','29','商务英语');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070105','唐雨嫣','31','工商管理');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070106','程婉盈','37','护理学');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070107','霍思燕','27','新闻学');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070108','杨丽玲','39','中医学');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070109','张晋峰','42','软件工程');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070110','夏雷','33','机器视觉');insert into `teacher` (`id`, `name`, `age`, `major`) values('17070111','黎思琪','35','金融工程');

创建maven项目

idea 使用 maven 整合 ssm 框架都的项目结构如下:

配置文件

pom.xml

在 idea 使用 maven 整合 ssm 框架的基础上添加了 PageHelper 分页插件依赖，用于分页查询操作

<?xml version="1.0" encoding="UTF-8"?><project xmlns="/POM/4.0.0" xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/POM/4.0.0 /xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.CD4356</groupId><artifactId>SSM_CRUD</artifactId><version>1.0-SNAPSHOT</version><packaging>war</packaging><name>SSM_CRUD Maven Webapp</name><url></url><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><piler.source>1.7</piler.source><piler.target>1.7</piler.target></properties><dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-beans</artifactId><version>4.3.23.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-core</artifactId><version>4.3.23.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>4.3.23.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>4.3.23.RELEASE</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.3.2</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.1.1</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.29</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>4.3.23.RELEASE</version></dependency><dependency><groupId>jstl</groupId><artifactId>jstl</artifactId><version>1.2</version></dependency><dependency><groupId>com.github.jsqlparser</groupId><artifactId>jsqlparser</artifactId><version>1.4</version></dependency><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper</artifactId><version>5.1.8</version></dependency></dependencies></project>

jdbc.properties

注意: jdbc.properties文件中，用户名和密码后面不能有空格，否则会报错

# mysql数据库配置文件jdbc.driver = com.mysql.jdbc.Driverjdbc.url = jdbc:mysql://localhost:3306/mybatis?characterEncoding=UTF-8jdbc.username = rootjdbc.password = root

Teacher.xml

注意: namespace属性的值要与Mapper 接口的全类名一致

1、标签的 id 值对应 Mapper 接口中的方法名

2、sql语句中，#{Mapper接口传入的参数}

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-////DTD Mapper 3.0//EN" "/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.CD4356.mapper.TeacherMappepr"><insert id="add" parameterType="Teacher" >insert into teacher (id,name,age,major) values (#{id},#{name},#{age},#{major})</insert><update id="update" parameterType="Teacher" >update teacher set id=#{id},name=#{name},age=#{age},major=#{major} where id=#{id}</update><delete id="delete" parameterType="int" >delete from teacher where id= #{id}</delete><select id="findById" parameterType="int" resultType="Teacher">select * from teacher where id=#{id}</select><select id="findAll" resultType="Teacher">select *from teacher order by age</select><select id="findByIdAndName" parameterType="Object" resultType="Teacher">select * from teacher where id=#{id} and name=#{name}</select></mapper>

applicationContext.xml

1、扫描service包下@Service注解的类

2、加载jdbc.properties配置文件

3、配置 dataSource 数据源

4、扫描 Mapper 接口

5、配置 SqlSessionFactory 对象

6、配置事务管理器

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:context="/schema/context" xmlns:tx="/schema/tx"xsi:schemaLocation="/schema/beans /schema/beans/spring-beans.xsd /schema/context /schema/context/spring-context.xsd /schema/tx /schema/tx/spring-tx.xsd"><context:annotation-config/><context:component-scan base-package="com.CD4356.service"/><context:property-placeholder location="classpath:jdbc.properties"/><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 class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.CD4356.mapper"/></bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"/><property name="typeAliasesPackage" value="com.CD4356.pojo"/><property name="mapperLocations" value="classpath:mapper/Teacher.xml"/><property name="plugins"><array><bean class="com.github.pagehelper.PageInterceptor"><property name="properties"><value></value></property></bean></array></property></bean><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"/></bean><tx:advice id="txAdvice" transaction-manager="transactionManager"><tx:attributes><tx:method name="find*" read-only="true"/><tx:method name="*"/></tx:attributes></tx:advice></beans>

dispatcher-servlet.xml

1、扫描controller包下@Controller注解的类

2、定义 viewResolver 视图解析器,定位视图

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:context="/schema/context"xmlns:mvc="/schema/mvc"xsi:schemaLocation="/schema/beans /schema/beans/spring-beans.xsd /schema/context /schema/context/spring-context.xsd /schema/cache /schema/cache/spring-cache.xsd /schema/mvc /schema/mvc/spring-mvc.xsd"><context:component-scan base-package="com.CD4356.controller"/><mvc:annotation-driven/><mvc:default-servlet-handler/><bean id="viewResolver"class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/><property name="prefix" value="/WEB-INF/page/"/><property name="suffix" value=".jsp"/></bean></beans>

web.xml

1、加载 spring 的配置文件

2、配置 ContextLoaderListener 监听器

3、配置 Spring MVC 的入口 DispatcherServlet，处理提交的请求

4、加载spring mvc的配置文件，在<servlet>标签内配置

5、配置spring mvc的前端控制器

<!DOCTYPE web-app PUBLIC"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN""/dtd/web-app_2_3.dtd" ><web-app><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:spring/applicationContext.xml</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><servlet><servlet-name>dispatcher</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:spring/dispatcher-servlet.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>dispatcher</servlet-name><url-pattern>/</url-pattern></servlet-mapping></web-app>

java 文件

Teacher 实体类

Teacher 实体类是 teacher 数据库表的映射类

package com.CD4356.pojo;public class Teacher {private int id;private String name;private int age;private String major;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public int getAge() {return age;}public void setAge(int age) {this.age = age;}public String getMajor() {return major;}public void setMajor(String major) {this.major = major;}@Overridepublic String toString() {return "Teacher [id="+id+", name="+name+",age="+age+",major="+major+"]";}}

TeacherMappepr 接口

Mappepr 接口在这里等同于 dao

注意：

Mapper 接口的方法中，如果含有多个参数时，定要在每个参数前加上@Param来与xml配置文件中sql语句的参数进行匹配

否则会报:Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2]参数不匹配错误

package com.CD4356.mapper;import com.CD4356.pojo.Teacher;import org.apache.ibatis.annotations.Param;import java.util.List;public interface TeacherMappepr {int add(Teacher teacher);int delete(int id);// 返回值为int,表示修改的行数int update(Teacher teacher);Teacher findById(int id);/* 多参数时,注意一定要在参数前加上@Param来匹配相同参数名的参数,否则会报: Parameter 'XXX' not found. Available parameters are [1, 0, param1, param2] 参数不匹配错误*/Teacher findByIdAndName(@Param("id")int id, @Param("name")String name);List<Teacher> findAll();}

TeacherService 接口

package com.CD4356.service;import com.CD4356.pojo.Teacher;import java.util.List;public interface TeacherService {void add(Teacher teacher);void delete(int id);void update(Teacher teacher);Teacher findById(int id);Teacher findByIdAndName(int id,String name);List<Teacher> findAll();}

TeacherServiceImpl 实现类

package com.CD4356.service.impl;import com.CD4356.mapper.TeacherMappepr;import com.CD4356.pojo.Teacher;import com.CD4356.service.TeacherService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.List;@Service("teacherService")public class TeacherServiceImpl implements TeacherService {@AutowiredTeacherMappepr teacherMappepr;@Overridepublic void add(Teacher teacher) {teacherMappepr.add(teacher);}@Overridepublic void delete(int id) {teacherMappepr.delete(id);}@Overridepublic void update(Teacher teacher) {teacherMappepr.update(teacher);}@Overridepublic Teacher findById(int id) {return teacherMappepr.findById(id);}@Overridepublic Teacher findByIdAndName(int id,String name){return teacherMappepr.findByIdAndName(id,name);}@Overridepublic List<Teacher> findAll() {return teacherMappepr.findAll();}}

Page 辅助类

Page类用于存放分页信息：

start: 开始位置

count: 每页的个数

last: 最后一页的位置

caculateLast()方法: 通过总数total和每页的个数计算出最后一页的位置

package com.CD4356.pojo;public class Page {int start=0;int count=4;int last=0;public int getStart() {return start;}public void setStart(int start) {this.start = start;}public int getCount() {return count;}public void setCount(int count) {this.count = count;}public int getLast() {return last;}public void setLast(int last) {this.last = last;}public void caculateLast(int total){if(0==total%count){// 假设总数是50，是能够被5整除的，那么最后一页的开始就是45last=total-count;}else {// 假设总数是51，不能够被5整除的，那么最后一页的开始就是50last=total-total%count;}}}

CrudController 控制类

package com.CD4356.controller;import com.CD4356.pojo.Page;import com.CD4356.pojo.Teacher;import com.CD4356.service.TeacherService;import com.github.pagehelper.PageHelper;import com.github.pagehelper.PageInfo;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.Model;import org.springframework.ui.ModelMap;import org.springframework.web.bind.annotation.RequestMapping;import java.util.List;// 告诉spring mvc这是一个控制器类@Controllerpublic class CrudController {@AutowiredTeacherService teacherService;@RequestMapping(value = "/")public String toLogin(){return "login";}@RequestMapping(value = "/login")public String login(int id,String name, Model model){Teacher list=teacherService.findByIdAndName(id,name);if(list!=null){return "redirect:/getAll";}model.addAttribute("error","工号或姓名错误！");return "login";}@RequestMapping("/getAll")// 修改findAllTeacher,接受分页信息的注入public String findAllTeacher(ModelMap map,Page page){// 在调用teacherService.findAll();之前执行,实现分页PageHelper.offsetPage(page.getStart(),4);List<Teacher> ts=teacherService.findAll();int total = (int) new PageInfo<>(ts).getTotal();page.caculateLast(total);map.addAttribute("ts",ts);map.addAttribute("total",total);return "getAll";}@RequestMapping(value = "/getById")public String findById(int id, ModelMap map){Teacher ls=teacherService.findById(id);if(ls!=null){map.addAttribute("ls",ls);return "getById";}return "redirect:/getAll";}@RequestMapping(value = "/add")public String add(Teacher teacher){teacherService.add(teacher);return "redirect:/getAll";}@RequestMapping(value = "/delete")public String delete(int id){teacherService.delete(id);return "redirect:/getAll";}@RequestMapping(value = "/edit")public String edit(int id,ModelMap map){Teacher t=teacherService.findById(id);map.addAttribute("t",t);return "edit";}@RequestMapping(value = "/update")public String update(Teacher teacher){teacherService.update(teacher);return "redirect:/getAll";}}

jsp 文件

login.jsp

<%@page pageEncoding="UTF-8" %><%@page isELIgnored="false" %><html><head><meta charset="UTF-8"><meta name="viewport"content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"><meta http-equiv="X-UA-Compatible" content="ie=edge"><title>Document</title></head><body><div align="center" style="background: wheat;width: 35%;margin-left: 30px"><div align="center"><font face="华文新魏" size="4">使用工号和姓名登录</font></div><br><form action="/login">工号：<input type="text" name="id"><br><br>姓名：<input type="text" name="name"><br><br><div align="center"><input type="submit" value="登录"></div></form><br><div align="center"><font face="华文新魏" size="4" color="red">${error}</font></div></div></body></html>

getAll.jsp

<%@ taglib prefix="c" uri="/jsp/jstl/core" %><%@page pageEncoding="UTF-8" %><%@ page isELIgnored="false" %><%--Created by IntelliJ IDEA.User: CD4356Date: /4/20Time: 16:46To change this template use File | Settings | File Templates.--%><%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head><title>SSM 项目入门</title></head><body><div style=" width: 50%;margin-top: 20px;float: left;background: gray"><div style="background: wheat;margin: 15px"><div align="center" style="padding-top: 10px"><font face="华文行楷" size="4">教师人数: ${total}</font></div><br><table width="80%" align="center" border='1' cellspacing="0"><tr><td width="20%"><font face="华文中宋" size="4">工号</font></td><td width="20%"><font face="华文中宋" size="4">姓名</font></td><td width="20%"><font face="华文中宋" size="4">年龄</font></td><td width="20%"><font face="华文中宋" size="4">专业</font></td><td width="10%"><font face="华文中宋" size="4">编辑</font></td><td width="10%"><font face="华文中宋" size="4">删除</font></td></tr><c:forEach items="${ts}" var="t" varStatus="st"><tr><td><font face="华文新魏" size="4">${t.id}</font></td><td><font face="华文新魏" size="4">${t.name}</font></td><td><font face="华文新魏" size="4">${t.age}</font></td><td><font face="华文新魏" size="4">${t.major}</font></td><td><font face="华文新魏" size="4"><a href="/edit?id=${t.id}">编辑</a></font></td><td><font face="华文新魏" size="4"><a href="/delete?id=${t.id}">删除</a></font></td></tr></c:forEach></table><div style="padding-bottom: 15px;text-align: center"><font face="华文新魏" size="4"><a href="?start=0">首页</a><a href="?start=${page.start-page.count}">上一页</a><a href="?start=${page.start+page.count}">下一页</a><a href="?start=${page.last}">末页</a></font></div></div><div style="width: 40%;margin: 15px;float: left"><div align="center" style="padding-top: 15px"><font face="华文行楷" size="4">添加教师信息</font></div><br><form action="/add" style="text-align: center"><font face="华文新魏" size="4">教师工号: <input type="text" name="id" placeholder="id"><br><br>教师姓名: <input type="text" name="name" placeholder="name"><br><br>教师年龄: <input type="text" name="age" placeholder="age"><br><br>所教专业: <input type="text" name="major" placeholder="major"><br><br><div align="center"><input type="submit" value="添加"></div></font></form></div><div align="center" style="width: 35%;height: 20%;margin: 15px;float: right"><div align="center" style="padding-top: 15px"><font face="华文行楷" size="4">根据工号查询</font></div><br><form action="/getById" method="post"><input type="text" name="id" placeholder="输入工号:"><input type="submit" value="查"></form></div></div></body></html>

edit.jsp

getById.jsp

<%@ taglib prefix="c" uri="/jsp/jstl/core" %><%@page pageEncoding="UTF-8" %><%@ page isELIgnored="false" %><html><head><meta charset="UTF-8"><meta name="viewport"content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0"><meta http-equiv="X-UA-Compatible" content="ie=edge"><title>Document</title></head><body><div style="width: 45%;padding-top: 15px;padding-bottom: 15px;background: wheat"><table width="80%" align="center" border='1'><tr><td width="20%"><font face="华文中宋" size="4">学号</font></td><td width="20%"><font face="华文中宋" size="4">姓名</font></td><td width="20%"><font face="华文中宋" size="4">年龄</font></td><td width="20%"><font face="华文中宋" size="4">专业</font></td><td width="10%"><font face="华文中宋" size="4">编辑</font></td><td width="10%"><font face="华文中宋" size="4">删除</font></td></tr><%--只有一条数据时,forEach标签不使用var属性--%><c:forEach items="ls" var="l"><tr><td><font face="华文新魏" size="4">${ls.id}</font></td><td><font face="华文新魏" size="4">${ls.name}</font></td><td><font face="华文新魏" size="4">${ls.age}</font></td><td><font face="华文新魏" size="4">${ls.major}</font></td><td><font face="华文新魏" size="4"><a href="/edit?id=${ls.id}">编辑</a></font></td><td><font face="华文新魏" size="4"><a href="/delete?id=${ls.id}">删除</a></font></td></tr></c:forEach></table></div></body></html>

如果文章对你有用，请点个赞，谢谢