mybatis+spring3实战1-数据映射器 mapper方式

最新推荐文章于 2024-02-02 00:01:08 发布

java爱分享

最新推荐文章于 2024-02-02 00:01:08 发布

阅读量5.6k

点赞数

本文链接：https://blog.csdn.net/ETTTTTSS/article/details/17118039

版权

该博客介绍了如何在Spring3中整合MyBatis，通过User实体类和UserMapper接口展示了数据映射器的使用，包括增删改查操作。详细说明了XML配置文件、Mapper接口和实体类的定义，以及Spring的配置和事务管理。

摘要由CSDN通过智能技术生成

package com.zxh.customer.mapper.entity;

public class User {

private Long custId;

private String custName;

public Long getCustId() {
return custId;
}

public void setCustId(Long custId) {
this.custId = custId;
}

public String getCustName() {
return custName;
}

public void setCustName(String custName) {
this.custName = custName;
}

}

package com.zxh.customer.mapper.model;

import java.util.List;
import java.util.Map;

import com.zxh.customer.mapper.entity.User;

public interface UserMapper {

// 方法名要和SQL映射文件中的id相同包名+接口名与mapper的namespace相同
public User selectUserById(Long custId);

public List<User> selectUsersByName(User user);

public void saveUser(User user);

public void updateUser(User user);

public void deleteUser(Long custId);

/**
* 使用map，失去面向对象的领域模型概念
*/
// public Map selectUserById(Map map);
//
// public List<Map> selectUsersByName(Map map);
//
// public void saveUser(Map map);
//
// public void updateUser(Map map);
//
// public void deleteUser(Map map);
}

<?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.zxh.customer.mapper.model.UserMapper">

<select id="selectUserById" parameterType="long" resultType="User">
  SELECT CUST_ID as "custId", CUST_NAME "custName" FROM CUST WHERE
  CUST_ID = #{id}
</select>


<select id="selectUsersByName" parameterType="User" resultType="User">
  SELECT CUST_ID as "custId", CUST_NAME "custName" FROM CUST WHERE
  CUST_NAME like '%${custName}%'
</sele