mybatis常用基础

UserDao.xml中<mapper namespace="com.javaserver.user.UserDao"> 和 UserDao.java 位置相同

<?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">  
<!--这块等于dao接口的实现 namespace必须和接口的类路径一样 -->  
<mapper namespace="com.javaserver.user.UserDao">  
    <!--type是在configuration.xml里定义过的typeAlias -->  
<!-- User -->      
<sql id="userColomns">
	u_id, u_name, u_password, u_time
</sql>
<sql id="userDynamicWhere">
	<where>
		<if test="u_id != null">and u_id like '%${u_id}%' </if>
		<if test="u_name != null">and u_name like '%${u_name}%' </if>
		<if test="u_password != null">and u_password like '%${u_password}%' </if>
		<if test="u_time != null">and u_time = #{u_time} </if>
	</where>
</sql>
<insert  id="addUser" parameterType="UserObj">
	insert into sys_user
	   (u_id,
		u_name,
		u_password,
		u_email) 
	values
	   (#{u_id},
		#{u_name},
		#{u_password},
		#{u_email})
</insert>

<delete id="deleteUser" parameterType="UserObj">
	delete from sys_user 
	<include refid="userDynamicWhere"></include>
</delete>

<update id="updateUser" parameterType="UserObj">
	update sys_user 
	<set>
		<if test="u_name != null"> u_name = #{u_name},</if>
		<if test="u_password != null"> u_password = #{u_password},</if>
		<if test="u_email != null"> u_email = #{u_email} </if>
	</set>
	where u_id = #{u_id}
</update>

<select id="getUser" parameterType="UserObj" resultType="Map">
	select 
	<include refid="userColomns"></include> 
	from sys_user
	<include refid="userDynamicWhere"></include>
</select>
<select id="getUserByName" parameterType="String" resultType="UserObj">
	select * from sys_user where u_name =#{u_name}
</select>
<select id="getUserByid" parameterType="String" resultType="UserObj" >
	select * from sys_user where u_id =#{u_id}
</select>
		
</mapper>    

package com.javaserver.user;

import java.util.List;
import java.util.Map;

import com.jlib.obj.UserObj;

public interface UserDao {

	int deleteUser(UserObj user);

	int updateUser(UserObj user);

	int addUser(UserObj user);
	
	List<Map<String,String>> getUser(UserObj userObj);
	
	UserObj getUserByid(String user_id);

	UserObj getUserByName(String u_name);

	
}