搭建完整的SSM框架(增、删、该、查)
1. 如果没有创建好项目,请点击连接:创建ssm maven项目
- 在根目录的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.nf</groupId> <artifactId>myweb07</artifactId> <packaging>pom</packaging> <version>1.0-SNAPSHOT</version> <modules> <module>entity</module> <module>dao</module> <module>service</module> <module>action</module> <module>web-view</module> </modules> <properties> <spring-version>5.1.0.RELEASE</spring-version> <jackson-version>2.9.7</jackson-version> <jstl-version>1.2</jstl-version> <mybatis-version>3.4.6</mybatis-version> <mybatis-spring-version>1.3.2</mybatis-spring-version> <c3p0-version>0.9.5.2</c3p0-version> <mysql-version>8.0.12</mysql-version> </properties> <dependencies> <!--1.Spring包--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-beans</artifactId> <version>${spring-version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring-version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>${spring-version}</version> </dependency> <!--1.Spring项目跟mybatic中融合需要的2个东西--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring-version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring-version}</version> </dependency> <!--2.SpringMVC的包--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>${spring-version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring-version}</version> </dependency> <!--2.SpringMVC中,ResponseBody时要用到的默认的JSON解析引擎--> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>${jackson-version}</version> </dependency> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-core</artifactId> <version>${jackson-version}</version> </dependency> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-annotations</artifactId> <version>${jackson-version}</version> </dependency> <!--4.JSP的JSTL依赖,如果不用,可以不写--> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>${jstl-version}</version> </dependency> <!--5.MyBatis的依赖包--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>${mybatis-version}</version> </dependency> <!-- 5. 1.MyBatis的SqlSession提供指定的方法来处理编程式的事务(手动写commit或rollback等代码) 2.但当使用mybatis-spring这个组件时,bean会使用Spring管理的SqlSession。 Spring通常都是处理事务(不用程序员来写commit) --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>${mybatis-spring-version}</version> </dependency> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>${c3p0-version}</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>${mysql-version}</version> </dependency> </dependencies> </project>
2.可以看一下表格中的是基本配置,具体的需要用到什么再去添加
maven仓库网址:https://mvnrepository.com/
3. 在web层中的webapp目录下的resources(没有自行创建)文件夹中创建配置文
1. springmvc.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:mvc="http://www.springframework.org/schema/mvc"
xmlns:aop="http://www.springframework.org/schema/aop"
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 http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<context:component-scan base-package="com.nf">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Service" />
</context:component-scan>
<!--mvc:annotation-driven 是告诉springmvc需要解析:@ResponseBody-->
<!--如果使用jackson,可以不写里面的bean,因为是默认-->
<mvc:annotation-driven></mvc:annotation-driven>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!--加载静态文件-->
<mvc:resources mapping="/css/**" location="/css/"></mvc:resources>
<mvc:resources mapping="/js/**" location="/js/"></mvc:resources>
<mvc:resources mapping="/img/**" location="/img/"></mvc:resources>
</beans>
2. jdbc.properties.xml,我注射了,需要那个数据库自己添加获取解开
# mysql
#jdbc.driverClassName=com.mysql.cj.jdbc.Driver
#jdbc.url=jdbc:mysql://localhost:3306/batis?serverTimezone=GMT%2B8&useSSL=false&allowPublicKeyRetrieval=true
#jdbc.username=root
#jdbc.password=123456
#oracle
#jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
#jdbc.url=jdbc:oracle:thin:@192.168.88.88:1521:orcl
#jdbc.username=oa
#jdbc.password=123456
4. 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"
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/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 自动扫描 -->
<context:component-scan base-package="com.nf" />
<!-- 引入配置文件,spring2.5以后的写法,之前的是bean class=org.springframework.beans.factory.config.PropertyPlaceholderConfigurer -->
<context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>
<!--配置C3P0 dataSource-->
<bean id="myDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driverClassName}"></property>
<property name="jdbcUrl" value="${jdbc.url}"></property>
<property name="user" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
<!-- 连接池中保留的最小连接数,默认为:3 -->
<property name="minPoolSize" value="3" />
<!-- 连接池中保留的最大连接数。默认值: 15 -->
<property name="maxPoolSize" value="15" />
<!-- 初始化连接池中的连接数,取值应在minPoolSize与maxPoolSize之间,默认为3 -->
<property name="initialPoolSize" value="3"/>
</bean>
<!--
此处,SqlSessionFactory以及MapperScannerConfigurer就是书本12.4章的内容
作用:实现书本第3章代码,一行都不用写,直接生成dao的实现类,不用任何编码
也不需要写一行mybatis的代码。
ps.这就是依赖于spring神的帮助
-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="myDataSource"></property>
<property name="mapperLocations" value="classpath*:mapper/*.xml"></property>
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--扫描dao层的接口interface-->
<property name="basePackage" value="com.nf.dao" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<!--mapper xml文件就像实现类,它是怎么知道对应哪个dao层的接口的?-->
<!--声明式事务管理-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="myDataSource"></property>
</bean>
<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"></tx:annotation-driven>
</beans>
5.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">
<!--这是springmvc的配置-->
<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:springmvc.xml</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!--这是spring的配置-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!-- Spring监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
</web-app>
4. 配置好sping、springMVC、web.xml和mybatis的文件完了之后就可以写代码了
-
自行创建数据库
-
编写实体类
-
编写dao层,一般ssm在dao层的项目命名是xxxMapper
-
在dao层中resources文件夹下创建一个Mapper文件,用于进行数据操作
BookMapper.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.nf.dao.BookMapper"> <resultMap id="bookMap" type="com.nf.entity.Book"> <id property="id" column="id"></id> <result property="name" column="name"></result> </resultMap> <select id="getAllBooks" resultMap="bookMap" > select * from book </select> <insert id="addBook" keyProperty="id" useGeneratedKeys="true"> insert into book(name) values(#{name}) </insert> <update id="editBook"> update book set name= #{name} where id = #{id} </update> <delete id="delBookById"> delete from book where id=#{id} </delete> </mapper>
-
编写service层
编写service接口
编写service实现类
-
编写action层(api接口)
BookAction.java代码块package com.nf.action; import com.nf.entity.Book; import com.nf.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import java.util.HashMap; import java.util.List; @Controller public class BookAction { @Autowired private BookService bookService; //查询方法 @RequestMapping("/getAllBooks") public String getAllBooks(Model model){ List<Book> bookList = bookService.getAllBooks(); model.addAttribute("bookList",bookList); return "books"; //跳到books页面 } //下面是前后端分离的,需要添加@ResponseBody注解 // 查询方法 @ResponseBody @RequestMapping("/selectAllBook") public HashMap<String,Object> seleAllBook(){ List<Book> list = bookService.getAllBooks(); HashMap<String,Object> map = new HashMap<String, Object>(); map.put("list",list); return map; } //添加方法 @ResponseBody @RequestMapping("/addBook") public HashMap<String,Object> addBook(@RequestBody(required = true) Book book){ bookService.addBook(book); return new HashMap<String, Object>(); } // 修改方法 @ResponseBody @RequestMapping("/editBook") public HashMap<String,Object> editBook(@RequestBody Book book){ bookService.editBook(book); return new HashMap<String, Object>(); } //删除方法 @ResponseBody @RequestMapping("/delBookById") public HashMap<String,Object> delBookById(Integer id){ System.out.println(id); bookService.delBookById(id); return new HashMap<String, Object>(); } }
jsp:book.jsp代码块
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <html> <head> <title>Title</title> </head> <body> 这是书本列表 <c:forEach items="${bookList}" var="book"> ${book.name}<br> </c:forEach> </body> </html>
-
最后测试一下,推荐一款测试接口的软件:postman官网 ;没用过的可以自己下载,测试接口很方便,也很容易使用
a.首先测试jsp页面,成功。
b.测试接口,添加,使用postman测试,成功。
c.测试修改
d.最后根据id删除
最后上面图片中我放spring等配置文件resources的目录,放错了,因为已经排版好了,懒得改过来,下图是正确的目录。
如果按照图片来的话,增、删、改、查基本就可以实现了,希望能帮到有需要的人