Springmvc和mybatis整合

向右看齐 2024-02-18 14:39 37阅读 0赞

## Springmvc和mybatis整合 ##

### 1. 整合思路 ###

### 2. 准备环境 ###

#### 1) 框架版本 ####

Spring3.1.1

Mybatis 3.1.0

#### 2) 开发工具版本 ####

Tomcat: apache-tomcat-8.0.30

Eclipse: OxygenRelease (4.7.0)

Jdk: 1.8.0\_101

Mysql: mysql-5.7.17

#### 3) 数据库文件 ####

SET FOREIGN\_KEY\_CHECKS=0;  
  
  
\-- ----------------------------  
\-- Table structure for \`items\`  
\-- ----------------------------  
DROP TABLE IF EXISTS \`items\`;  
CREATE TABLE \`items\` (  
\`id\` int(11) NOT NULL AUTO\_INCREMENT,  
\`name\` varchar(255) DEFAULT NULL,  
\`price\` int(11) DEFAULT NULL,  
\`detail\` varchar(500) DEFAULT NULL,  
\`pic\` text,  
\`creattime\` datetime DEFAULT NULL,  
PRIMARY KEY (\`id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=4 DEFAULT CHARSET=utf8mb4;  
  
  
\-- ----------------------------  
\-- Records of items  
\-- ----------------------------  
INSERT INTO \`items\` VALUES ('1', 'apple1', '9000', '质量不错', 'ddd.jpg', '2017-08-24 20:49:21');  
INSERT INTO \`items\` VALUES ('2', 'apple2', '7000', 'good', 'nice.png', '2017-08-15 20:50:38');  
INSERT INTO \`items\` VALUES ('3', 'pro1', '8000', 'nice', 'fuck.jgp', '2017-08-07 20:51:16');

### 3. 整合dao ###

#### 1) SqlMapConfig.xml ####

<?xml  version=*"1.0"*  encoding=*"UTF-8"*?>

<!DOCTYPE  configuration

PUBLIC "-//mybatis.org//DTDConfig 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

</typeAliases>

</configuration>

#### 2) applicationContext-dao.xml ####

<?xml  version=*"1.0"*  encoding=*"UTF-8"*?>

<beans  xmlns=*"http://www.springframework.org/schema/beans"*

xmlns:mvc=*"http://www.springframework.org/schema/mvc"*

xmlns:xsi=*"http://www.w3.org/2001/XMLSchema-instance"*

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.xsd*

*http://www.springframework.org/schema/mvc*

*http://www.springframework.org/schema/mvc/spring-mvc.xsd*

*http://www.springframework.org/schema/context*

*http://www.springframework.org/schema/context/spring-context.xsd*

*http://www.springframework.org/schema/aop*

*http://www.springframework.org/schema/aop/spring-aop.xsd*

*http://www.springframework.org/schema/tx*

*http://www.springframework.org/schema/tx/spring-tx.xsd"*>

<context:property-placeholder location=*"classpath:db.properties"*/>

</bean>

</bean>

</bean>

</beans>

#### 3) 逆向工程生成po类和mapper ####

#### 4) 手动定义商品查询mapper ####

##### a) ItemsMapperCustom.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">

WHERE name like'%\{itemsCustom.name\}%'

</if>

</sql>

<select  id=*"findItemList"*

parameterType=*"cn.hr.ssm.po.ItemsQueryVo"*

resultType=*"cn.hr.ssm.po.ItemsCustom"*>

SELECT \* FROM items

<where>

</where>

</select>

</mapper>

##### b) ItemsMapperCustom.java #####

package cn.hr.ssm.mapper;

import java.util.List;

import cn.hr.ssm.po.ItemsCustom;

import cn.hr.ssm.po.ItemsQueryVo;

public interface ItemsMapperCustom \{

public List<ItemsCustom> findItemList(ItemsQueryVo itemsQueryVo)throws Exception;

### 4. 整合service ###

#### 1) 定义service接口 ####

package cn.hr.ssm.service;

import java.util.List;

import cn.hr.ssm.po.ItemsCustom;

import cn.hr.ssm.po.ItemsQueryVo;

public interface ItemsService \{

publicList<ItemsCustom> findItemList(ItemsQueryVo itemsQueryVo) throwsException;

#### 2) 在spring容器中配置service（applicationContext-service.xml） ####

<?xml  version=*"1.0"*  encoding=*"UTF-8"*?>

<beans xmlns=*"http://www.springframework.org/schema/beans"*

xmlns:mvc=*"http://www.springframework.org/schema/mvc"*

xmlns:xsi=*"http://www.w3.org/2001/XMLSchema-instance"*

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.xsd*

*http://www.springframework.org/schema/mvc*

*http://www.springframework.org/schema/mvc/spring-mvc.xsd*

*http://www.springframework.org/schema/context*

*http://www.springframework.org/schema/context/spring-context.xsd*

*http://www.springframework.org/schema/aop*

*http://www.springframework.org/schema/aop/spring-aop.xsd*

*http://www.springframework.org/schema/tx*

*http://www.springframework.org/schema/tx/spring-tx.xsd"*>

</beans>

#### 3) 事务控制（applicationContext-trasaction.xml） ####

<?xml  version=*"1.0"*  encoding=*"UTF-8"*?>

<beans  xmlns=*"http://www.springframework.org/schema/beans"*

xmlns:mvc=*"http://www.springframework.org/schema/mvc"*

xmlns:xsi=*"http://www.w3.org/2001/XMLSchema-instance"*

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.xsd*

*http://www.springframework.org/schema/mvc*

*http://www.springframework.org/schema/mvc/spring-mvc.xsd*

*http://www.springframework.org/schema/context*

*http://www.springframework.org/schema/context/spring-context.xsd*

*http://www.springframework.org/schema/aop*

*http://www.springframework.org/schema/aop/spring-aop.xsd*

*http://www.springframework.org/schema/tx*

*http://www.springframework.org/schema/tx/spring-tx.xsd"*>

<!-- 事务管理

spring使用jdbc的事务控制类

\-->

</bean>

<tx:advice id=*"txAdvice"* transaction-manager=*"transactionManager"*>

<tx:attributes>

<tx:method name=*"save\*"* propagation=*"REQUIRED"*/>

<tx:method name=*"delete\*"* propagation=*"REQUIRED"*/>

<tx:method name=*"insert\*"* propagation=*"REQUIRED"*/>

<tx:method name=*"udpate\*"* propagation=*"REQUIRED"*/>

<tx:method name=*"find\*"* propagation=*"REQUIRED"*read-only=*"true"*/>

<tx:method name=*"get\*"* propagation=*"REQUIRED"*read-only=*"true"*/>

<tx:method name=*"select\*"* propagation=*"REQUIRED"*read-only=*"true"*/>

</tx:attributes>

</tx:advice>

<aop:config>

<aop:advisor advice-ref=*"txAdvice"* pointcut=*"execution(\*cn.hr.ssm.service.impl.\*.\*(..))"*/>

</aop:config>

</beans>

### 5. 整合springmvc ###

#### 1) springmvc.xml ####

<?xml  version=*"1.0"*  encoding=*"UTF-8"*?>

<beans  xmlns=*"http://www.springframework.org/schema/beans"*

xmlns:mvc=*"http://www.springframework.org/schema/mvc"*

xmlns:xsi=*"http://www.w3.org/2001/XMLSchema-instance"*

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.xsd*

*http://www.springframework.org/schema/mvc*

*http://www.springframework.org/schema/mvc/spring-mvc.xsd*

*http://www.springframework.org/schema/context*

*http://www.springframework.org/schema/context/spring-context.xsd*

*http://www.springframework.org/schema/aop*

*http://www.springframework.org/schema/aop/spring-aop.xsd*

*http://www.springframework.org/schema/tx*

*http://www.springframework.org/schema/tx/spring-tx.xsd"*>

<context:component-scan base-package=*"cn.hr.ssm.controller"*></context:component-scan>

<mvc:annotation-driven></mvc:annotation-driven>

</bean>

</beans>

#### 2) 配置前端控制器 ####

<?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>spring\_mybatis0823</display-name>

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>/WEB-INF/classes/spring/applicationContext-\*.xml</param-value>

</context-param>

<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>

<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/springmvc.xml</param-value>

</init-param>

</servlet>

<servlet-mapping>

<servlet-name>springmvc</servlet-name>

<url-pattern>\*.action</url-pattern>

</servlet-mapping>

<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>

</web-app>

#### 3) 编写controller（就是handler） ####

package cn.hr.ssm.controller;

import java.util.List;

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.stereotype.Controller;

importorg.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.servlet.ModelAndView;

import cn.hr.ssm.po.ItemsCustom;

import cn.hr.ssm.service.ItemsService;

@Controller

public class ItemsController \{

@Autowired

privateItemsService itemsService;

@RequestMapping("/queryItems")

publicModelAndView queryItems() throws Exception\{

List<ItemsCustom>itemsList = itemsService.findItemList(null);

ModelAndViewmodelAndView = new ModelAndView();

modelAndView.addObject("itemsList",itemsList);

modelAndView.setViewName("items/itemsList");

returnmodelAndView;

#### 4) 编写jsp ####

<%@ page language=*"java"*contentType=*"text/html; charset=utf-8"*

pageEncoding=*"utf-8"*%>

<%@ taglib uri=*"http://java.sun.com/jsp/jstl/core"*prefix=*"c"* %>

<%@ taglib uri=*"http://java.sun.com/jsp/jstl/fmt"*prefix=*"fmt"* %>

<!DOCTYPE  html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>商品查询列表</title>

</head>

<body>

查询条件:

<tr>

</tr>

</table>

商品列表：

<tr>

</tr>

<c:forEach items=*"*$\{itemsList \}*"* var=*"item"*>

<tr>

<td>$\{item.price\}</td>

<td>$\{item.detail\}</td>

</tr>

</c:forEach>

</table>

</form>

</body>

</html>

### 6. 加载spring容器 ###

在web.xml中配置

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>/WEB-INF/classes/spring/applicationContext-\*.xml</param-value>

</context-param>

<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>

Springmvc和mybatis整合

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Springmvc和mybatis整合

相关 SpringMVC学习(四)——Spring、MyBatis和SpringMVC的整合

相关【SpringMVC学习04】Spring、MyBatis和SpringMVC的整合

相关 springmvc整合mybatis

相关 Spring、springMVC、Mybatis整合

相关 springmvc整合mybatis

相关 Spring + SpringMVC整合MyBatis

相关（六）springMvc 和 mybatis 整合

相关 mybatis(五) --springmvc和mybatis整合

相关 SpringMVC整合MyBatis