Mybatis:映射解决列名不匹配的方法

来源：互联网发布：淘宝7年老店有权重吗编辑：程序博客网时间：2024/06/03 19:59

表格

CREATE TABLE `user` (  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,  `namee` varchar(64) NOT NULL DEFAULT '',  `phone` varchar(16) NOT NULL DEFAULT '',  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

模型

//User.javapublic class User {    private int id;    private String name;    private String dept;    private String phonee;    private String website;    //省略getter和setter方法}

方法一：使用别名

映射文件

<!--User.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.model.UserMapper">    <select id="GetUserByID" parameterType="int"  resultType="User" >        select id,namee as "name",phone as "phonee" from `user` where id=#{id}    </select></mapper>

方法二：使用resultMap

映射文件

<!-- User.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.model.UserMapper">    <select id="GetUserByID" parameterType="int"  resultMap="UserResultMap" >          select * from `user` where id=#{id}     </select>    <resultMap type="User" id="UserResultMap">        <result property="id" column="id"/>        <result property="name" column="namee"/>        <result property="phonee" column="phone"/>    </resultMap></mapper>

阅读全文

0 0