![](https://csdnimg.cn/release/download_crawler_static/9728515/bg1.jpg)
SSM 框 架 下 基 本 的
mapper,dao,service,controller 等相关文件
的整理
(新手整理,有不详细和不正确的地方还望指正以便即使改进)
Mapper 文 件
Tate
Model 里面多
对应的字段
Dao 层的路径
参数
所对应的 map
的 id,
方法名称
<?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.ts.ssm.dao.UserDao">
<resultMap id="UserBaseMap" type="com.ts.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>
数据类型
数据库字段名称
这个是对应的
1