mybatis字段取别名

来源:互联网 发布:沥青库存数据 编辑:程序博客网 时间:2024/05/21 22:29
**别名**<?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.mapper.InsUserMapper" >    <resultMap id="user" type="com.po.InsUser">        <result column="userId" property="userId"></result>        <result column="userName" property="userName"></result>        <result column="password" property="passWord"></result>        <result column="CUST_ID" property="CUST_ID"></result>        <result column="state" property="state"></result>    </resultMap><select id="checkLogin" parameterType="com.po.InsUser" resultMap="user">    SELECT userId  ,userName,passWord from ins_user_100 where userName=#{userName} AND passWord=#{passWord}</select></mapper>
0 0
原创粉丝点击