<?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.bjhst.ssm.dao.UserDao"> <resultMap id="UserBaseMap" type="com.bjhst.ssm.model.User"> <id column="id" property="id" jdbcType="BIGINT"/> <result column="user_name" property="userName" jdbcType="VARCHAR"/> <result column="user_phone" property="userPhone" jdbcType="VARCHAR"/> <result column="user_email" property="userEmail" jdbcType="VARCHAR"/> <result column="user_pwd" property="userPwd" jdbcType="VARCHAR"/> <result column="pwd_salt" property="pwdSalt" jdbcType="VARCHAR"/> <result column="create_time" property="createTime" jdbcType="DATE"/> <result column="modify_time" property="modifyTime" jdbcType="DATE"/> <result column="is_delete" property="isDelete" jdbcType="SMALLINT"></result> </resultMap> <select id="selectUserById" parameterType="java.lang.Long" resultMap="UserBaseMap"> SELECT * FROM t_user WHERE id = #{userId} </select> <select id="selectUserByPhoneOrEmail" resultMap="UserBaseMap"> SELECT * FROM t_user WHERE user_email = #{emailOrPhone} OR user_phone = #{emailOrPhone} AND user_state = #{state} </select> <select id="selectAllUser" resultMap="UserBaseMap"> SELECT * FROM t_user </select> </mapper>
UserMapper.xml
最新推荐文章于 2024-06-21 22:36:06 发布