MyBatis与Spring框架整合：操作与映射示例

版权申诉

146 浏览量更新于2024-07-07 收藏 695KB PDF 举报

在Java开发中，MyBatis与Spring框架的集成是一项关键任务，因为它们分别提供了数据访问层和应用框架的管理。这份PDF文档详细探讨了如何在项目中将这两个强大的工具结合起来，以实现高效、可维护的数据库操作。首先，让我们关注于`OrderMapper`接口。在这个接口中，我们看到一系列与订单（Order）相关的CRUD（Create, Read, Update, Delete）操作方法。例如： 1. `countByExample(OrderExample example)`：用于统计满足特定条件的订单数量，`OrderExample`是MyBatis提供的动态SQL查询条件对象。 2. `deleteByExample(OrderExample example)`：批量删除符合给定条件的订单记录。 3. `deleteByPrimaryKey(Integer id)`：根据订单ID删除单条记录。 4. `insert(Order record)`：插入一个新的订单。 5. `insertSelective(Order record)`：插入记录时可以选择性地更新字段，提高性能。 6. `selectByExample(OrderExample example)`：根据条件查询多条订单信息。 7. `selectByPrimaryKey(Integer id)`：根据ID获取单个订单详情。 8. `updateByExampleSelective(Order record, OrderExample example)`：选择性地更新满足条件的订单记录。 9. `updateByExample(Order record, OrderExample example)`：更新所有匹配条件的订单记录。 10. `updateByPrimaryKeySelective(Order record)`：更新单个订单记录，仅对部分字段进行更新。 11. `updateByPrimaryKey(Order record)`：全量更新指定ID的订单记录。这些方法展示了MyBatis如何通过注解（如`@Param`）来处理参数传递，以及如何利用动态SQL实现灵活的数据操作。接下来，`UserMapper`接口同样关注用户（User）操作，包括类似的功能，如用户数量统计、批量删除、单条或批量更新、根据条件查询等。这里的接口定义展示了MyBatis如何处理不同实体类的映射和数据库交互。在与Spring框架整合时，这些Mapper接口通常会被注册到Spring的Bean中，通过依赖注入的方式供Spring IoC容器管理。Spring会负责实例化这些Mapper对象，并通过AOP（面向切面编程）或依赖注入的方式，将事务管理、异常处理等Spring特性与MyBatis的DAO操作无缝结合。这份文档提供了深入理解MyBatis与Spring框架集成的关键概念，包括如何创建和使用Mapper接口，如何处理SQL查询和事务管理，以及如何在Spring容器中配置和调用这些接口。这对于任何希望在Java项目中实现高效数据库操作的开发者来说，都是极其重要的实践指南。

return (Criteria) this;

}

public Criteria andSexIsNull() {

addCriterion("sex is null");

return (Criteria) this;

}

public Criteria andSexIsNotNull() {

addCriterion("sex is not null");

return (Criteria) this;

}

public Criteria andSexEqualTo(String value) {

addCriterion("sex =", value, "sex");

return (Criteria) this;

}

public Criteria andSexNotEqualTo(String value) {

addCriterion("sex <>", value, "sex");

return (Criteria) this;

}

public Criteria andSexGreaterThan(String value) {

addCriterion("sex >", value, "sex");

return (Criteria) this;

}

public Criteria andSexGreaterThanOrEqualTo(String value) {

addCriterion("sex >=", value, "sex");

return (Criteria) this;

}

public Criteria andSexLessThan(String value) {

addCriterion("sex <", value, "sex");

return (Criteria) this;

}

public Criteria andSexLessThanOrEqualTo(String value) {

addCriterion("sex <=", value, "sex");

return (Criteria) this;

}

public Criteria andSexLike(String value) {

addCriterion("sex like", value, "sex");

return (Criteria) this;

}

public Criteria andSexNotLike(String value) {

addCriterion("sex not like", value, "sex");

return (Criteria) this;

}

public Criteria andSexIn(List<String> values) {

addCriterion("sex in", values, "sex");

return (Criteria) this;

}

public Criteria andSexNotIn(List<String> values) {

addCriterion("sex not in", values, "sex");

return (Criteria) this;

}

public Criteria andSexBetween(String value1, String value2) {

addCriterion("sex between", value1, value2, "sex");

return (Criteria) this;

}

public Criteria andSexNotBetween(String value1, String value2) {

addCriterion("sex not between", value1, value2, "sex");

return (Criteria) this;

}

public Criteria andAddressIsNull() {

addCriterion("address is null");

return (Criteria) this;

}

public Criteria andAddressIsNotNull() {

addCriterion("address is not null");

return (Criteria) this;

}

public Criteria andAddressEqualTo(String value) {

addCriterion("address =", value, "address");

return (Criteria) this;

}

public Criteria andAddressNotEqualTo(String value) {

addCriterion("address <>", value, "address");

return (Criteria) this;

}

public Criteria andAddressGreaterThan(String value) {

addCriterion("address >", value, "address");

return (Criteria) this;

}

public Criteria andAddressGreaterThanOrEqualTo(String value) {

addCriterion("address >=", value, "address");

return (Criteria) this;

}

public Criteria andAddressLessThan(String value) {

addCriterion("address <", value, "address");

return (Criteria) this;

}

public Criteria andAddressLessThanOrEqualTo(String value) {

addCriterion("address <=", value, "address");

return (Criteria) this;

}

public Criteria andAddressLike(String value) {

addCriterion("address like", value, "address");

return (Criteria) this;

}

public Criteria andAddressNotLike(String value) {

addCriterion("address not like", value, "address");

return (Criteria) this;

}

public Criteria andAddressIn(List<String> values) {

addCriterion("address in", values, "address");

return (Criteria) this;

}

public Criteria andAddressNotIn(List<String> values) {

addCriterion("address not in", values, "address");

return (Criteria) this;

}

public Criteria andAddressBetween(String value1, String value2) {

addCriterion("address between", value1, value2, "address");

return (Criteria) this;

}

public Criteria andAddressNotBetween(String value1, String value2) {

addCriterion("address not between", value1, value2, "address");

return (Criteria) this;

}

public static class Criteria extends GeneratedCriteria {

protected Criteria() {

super();

}

public static class Criterion {

private String condition;

private Object value;

private Object secondValue;

private boolean noValue;

private boolean singleValue;

private boolean betweenValue;

private boolean listValue;

private String typeHandler;

public String getCondition() {

return condition;

}

public Object getValue() {

return value;

}

public Object getSecondValue() {

return secondValue;

}

public boolean isNoValue() {

return noValue;

}

public boolean isSingleValue() {

return singleValue;

}

public boolean isBetweenValue() {

return betweenValue;

}

public boolean isListValue() {

return listValue;

}

public String getTypeHandler() {

return typeHandler;

}

protected Criterion(String condition) {

super();

this.condition = condition;

this.typeHandler = null;

this.noValue = true;

}

protected Criterion(String condition, Object value, String typeHandler) {

super();

this.condition = condition;

this.value = value;

this.typeHandler = typeHandler;

if (value instanceof List<?>) {

this.listValue = true;

} else {

this.singleValue = true;

}

protected Criterion(String condition, Object value) {

this(condition, value, null);

}

protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {

super();

this.condition = condition;

this.value = value;

this.secondValue = secondValue;

this.typeHandler = typeHandler;

this.betweenValue = true;

}

protected Criterion(String condition, Object value, Object secondValue) {

this(condition, value, secondValue, null);

}

config类：

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

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

xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"

xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

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

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd

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

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

http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">

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

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"

destroy-method="close">

</bean>

</bean>

<!-- <bean class="com.mybatis.dao.impl.UserDaoImpl">

</bean> -->

<!-- <bean id="baseMapper" class="org.mybatis.spring.mapper.MapperFactoryBean" abstract="true" lazy-init="true">

</bean> -->

<!-- <bean parent="baseMapper">

</bean> -->

</bean>

</beans>

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8

jdbc.username=root

jdbc.password=root

# Global logging configuration

log4j.rootLogger=DEBUG, stdout

# Console output...

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

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

</mappers>

</configuration>

测试类：

package com.mybatis.test;

import static org.junit.Assert.fail;

import java.util.List;

import org.junit.Before;

import org.junit.Test;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.mybatis.mapper.OrderMapper;

import com.mybatis.mapper.UserMapper;

import com.mybatis.pojo.Order;

import com.mybatis.pojo.User;

import com.mybatis.pojo.UserExample;

import com.mybatis.pojo.UserExample.Criteria;

public class UserMapperGTest {

private ApplicationContext applicationContext;

@Before

public void init() {

applicationContext = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");

}

@Test

public void testInsertSelective() {

UserMapper userMapper = applicationContext.getBean(UserMapper.class);

User user = new User();

user.setUsername("诸葛亮2");

user.setAddress("深圳黑马");

user.setSex("1");

userMapper.insertSelective(user);

}

@Test

public void testInsert() {

UserMapper userMapper = applicationContext.getBean(UserMapper.class);

User user = new User();

user.setUsername("王一");

user.setAddress("深圳");

user.setSex("1");

user.setBirthday(null);

userMapper.insertSelective(user);

}

@Test

public void testSelectByExample() {

UserMapper userMapper = applicationContext.getBean(UserMapper.class);

UserExample example = new UserExample();

//创建Criteria

Criteria criteria = example.createCriteria();

//设置查询条件

criteria.andUsernameLike("%张%");

criteria.andSexEqualTo("1");

List<User> list = userMapper.selectByExample(example);

for (User user : list) {

System.out.println(user); } }

@Test

public void testSelectByPrimaryKey() {

UserMapper userMapper = applicationContext.getBean(UserMapper.class);

User user = userMapper.selectByPrimaryKey(10);

System.out.println(user);

}

@Test

public void testUpdateByPrimaryKeySelective() {

fail("Not yet implemented");

}

@Test

public void testGetUserOrderMap() {

UserMapper userMapper = applicationContext.getBean(UserMapper.class);

List<User> list = userMapper.getUserOrderMap();

for (User user2 : list) {

System.out.println(user2);

for (Order order : user2.getOrders()) {

if(order.getId() != null){

System.out.println(" 此用户下的订单有：" + order);

} } }

}

@Test

public void testGetOrderUserMap() {

OrderMapper orderMapper = applicationContext.getBean(OrderMapper.class);

//获取OrderMapper代理实现

List<Order> list = orderMapper.getOrderUserMap();

for (Order order : list) {

System.out.println(order);

System.out.println(" 此订单的用户为：" + order.getUser()); } }}

实验心得：、

通过今天试验了解到实际的开发中，对数据库的操作常常会涉及到多张表，这在面向对象中就涉及到了对象与对象之间的关联关系。针对多表之间的操作，MyBatis提供了关联映射，通过关联映射就可以

很好的处理对象与对象之间的关联关系。在关系型数据库中，多表之间存在着三种关联关系，分别为一对一、一对多和多对多，掌握MyBatis中一对多关联映射案例代码的编写，掌握 MyBatis 与 Spring 框

架的整合开发。

为我以后学习与工作增加经验，使我有了增加学好这么技术的信心。同时也感谢老师对我帮助。

mapper类：

package com.mybatis.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.mybatis.pojo.Order;

import com.mybatis.pojo.OrderExample;

public interface OrderMapper {

int countByExample(OrderExample example);

int deleteByExample(OrderExample example);

int deleteByPrimaryKey(Integer id);

int insert(Order record);

int insertSelective(Order record);

List<Order> selectByExample(OrderExample example);

Order selectByPrimaryKey(Integer id);

int updateByExampleSelective(@Param("record") Order record, @Param("example") OrderExample example);

int updateByExample(@Param("record") Order record, @Param("example") OrderExample example);

int updateByPrimaryKeySelective(Order record);

int updateByPrimaryKey(Order record);

List<Order> getOrderUserMap();

}

package com.mybatis.mapper;

import com.mybatis.pojo.User;

import com.mybatis.pojo.UserExample;

import java.util.List;

import org.apache.ibatis.annotations.Param;

public interface UserMapper {

int countByExample(UserExample example);

int deleteByExample(UserExample example);

int deleteByPrimaryKey(Integer id);

int insert(User record);

int insertSelective(User record);

List<User> selectByExample(UserExample example);

User selectByPrimaryKey(Integer id);

int updateByExampleSelective(@Param("record") User record, @Param("example") UserExample example);

int updateByExample(@Param("record") User record, @Param("example") UserExample example);

int updateByPrimaryKeySelective(User record);

int updateByPrimaryKey(User record);

List<User> getUserOrderMap();

}

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

剩余77页未读，继续阅读

一诺网络技术

粉丝: 0
资源: 2万+

MyBatis与Spring框架整合：操作与映射示例

Java EE互联网轻量级框架整合开发 SSM框架（Spring MVC+Spring+MyBatis）和Redis实现.rar

Java EE 框架整合开发⼊⻔到实战——Spring+Spring MVC+MyBatis（微课版）课后习题答案.pdf

第17章 SpringBoot+Mybatis+前端框架整合.pdf

Mybatis系列教程Mybatis注解开发共9页.pdf

JavaEE企业级应用开发教程（Spring+SpringMVC+MyBatis）习题（2022）.pdf

Mybatis配置Mapper[参考].pdf

Mybatis最新版-中文手册.pdf

Mybatis系列教程Mybatis架构原理共4页.pdf

Spring SpringMVC Mybatis SSM整合.pdf

MyBatis-Spring.pdf

最新资源