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>
<!-- like #{custName} 或者 like contact(contact('%', #{custName}), '%')-->
<select id="selectUsersByName" parameterType="User" resultType="User">
SELECT CUST_ID as "custId", CUST_NAME "custName" FROM CUST WHERE
CUST_NAME like '%${custName}%'
</sele