[Java] mybatis映射文件mapper.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.qbd.mapper.StudentMappers">
  <select id="findbyid" parameterType="Integer" resultMap="StudentResult">
    select *from student where id=#{id}
  </select>
  
  <select id="findbygradeid" parameterType="Integer" resultMap="StudentResult">
    select *from student where gid=#{gid}
  </select>
  
  <resultMap type="Student" id="StudentResult">
    <id property="id" column="id"/>
    <result property="name" column="name"/>
    <result property="age" column="age"/>
    <association property="address" column="addid" select="com.qbd.mapper.AddressMappers.findbyid">  
    </association>
    <association property="grade" column="gid" select="com.qbd.mapper.GradeMappers.findbyid">  
    </association>
  </resultMap>
</mapper>

package com.qbd.service;
import org.apache.ibatis.session.SqlSession;
import org.apache.log4j.Logger;
 
import com.qbd.mapper.StudentMappers;
import com.qbd.model.Student;
import com.qbd.util.SqlSessionFactoryUtil;
 
public class StudentService {
  private static Logger logge=Logger.getLogger(StudentService.class);
  public static void main(String[] args) {
    SqlSession sqlSession=SqlSessionFactoryUtil.getSqlSession();
    
    StudentMappers studentMappers=(StudentMappers)sqlSession.getMapper(StudentMappers.class);
    Student student=new Student();
    student.setName("22");
    student.setAge(2);
    int s=studentMappers.add(student);
    sqlSession.commit();
    if(s>0){
      logge.info("success");
      System.out.println("success");
    }
    
  }
}

<?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.qbd.ssm.dao.UserDao">
  <!-- 定义缓存  一般是一级缓存，如果用同一个sqlsession 那么相同查询直接会从缓存中查找 
  <cache size="1024" flushInterval="60000" eviction="LRU" readOnly="false"></cache>
  -->
  <!-- 查找所有 -->
  <select id="find" parameterType="Map" resultMap="StudentResult">
    select * from user
    <where>
      <if test="uname!=null and uname!='' ">
        and uname like #{uname}
      </if>
    </where>
    <if test="start!=null and size!=null">
      limit #{start},#{size}
    </if>
  </select>
  
  <select id="getTotal" parameterType="Map" resultType="Long">
    select count(*) from user
    <where>
      <if test="uname!=null and uname!='' ">
        and uname like #{uname}
      </if>
    </where>
  </select>
  <!-- 按照用户名和密码查找 -->
  <select id="getUser" resultMap="StudentResult" parameterType="Map">
    select *from user where uname=#{uname} and upassword=#{upassword}
  </select>
  <!-- 删除 -->
  <delete id="delete" parameterType="Map">
    delete from user where uid=#{uid}
  </delete>
  <!-- 修改 -->
  <update id="update" parameterType="User">
    update user
    <set>
      <if test="uname!=null">
         uname=#{uname},
      </if>
      <if test="upassword!=null">
        upassword=#{upassword},
      </if>
      <if test="upower!=null">
        upower=#{upower},
      </if>
    </set>
    where uid=#{uid}
  </update>
  <!-- 增加 -->
  <insert id="add" parameterType="User">
    insert into user values(null,#{uname},#{upassword},#{upower})
  </insert>
  <resultMap type="User" id="StudentResult">
    <id property="uid" column="uid"/>
    <result property="uname" column="uname"/>
    <result property="upassword" column="upassword"/>
  </resultMap>
</mapper>

package com.qbd.ssm.dao;
 
import java.util.List;
import java.util.Map;
 
import org.apache.ibatis.annotations.Delete;
 
import com.qbd.ssm.model.User;
 
public interface UserDao {
 
  public List<User> getAll();
  public User getUser(User user);
  public int delete(User user);
  public int update(User user);
  public int add(User user);
  public List<User> find(Map<String,Object> map);
  public Long getTotal(Map<String,Object> map);
}

package com.qbd.ssm.service;
import java.util.List;
import java.util.Map;
import com.qbd.ssm.model.User; 
public interface UserService {
 
  public List<User> getAll();
  public User getUser(User user);
  public int delete(User user);
  public int update(User user);
  public int add(User user);
  public List<User> find(Map<String,Object> map);
  public Long getTotal(Map<String,Object> map);
}

package com.qbd.ssm.serviceimpl;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource; 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.qbd.ssm.dao.UserDao;
import com.qbd.ssm.model.User;
import com.qbd.ssm.service.UserService;
 
@Service("userService")
public class UserServiceImpl implements UserService {
 
  private UserDao userDao;
  
  public UserDao getUserDao() {
    return userDao;
  }
 
  @Resource
  public void setUserDao(UserDao userDao) {
    this.userDao = userDao;
  }
 
  public List<User> getAll() {
    // TODO Auto-generated method stub
    return userDao.getAll();
  }
 
  public User getUser(User user) {
    // TODO Auto-generated method stub
    return userDao.getUser(user);
  }
 
  public int delete(User user) {
    // TODO Auto-generated method stub
    return userDao.delete(user);
  }
 
  public int update(User user) {
    // TODO Auto-generated method stub
    return userDao.update(user);
  }
 
  public int add(User user) {
    // TODO Auto-generated method stub
    return userDao.add(user);
  }
 
  public List<User> find(Map<String, Object> map) {
    // TODO Auto-generated method stub
    return userDao.find(map);
  }
 
  public Long getTotal(Map<String, Object> map) {
    // TODO Auto-generated method stub
    return userDao.getTotal(map);
  }
}