MyBatis数据库层相关配置

一、datasource.properties文件配置

driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/mybook?useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.userpwd=root

二、SqlMapConfig.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<properties resource="datasource.properties"></properties>
<typeAliases>
<package name="com.myBatis.bean"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.userpwd}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/myBatis/mapper/UserMapper.xml"/>
</mappers>
</configuration>

三、Mapper.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.myBatis.mapper.UserMapper">
<resultMap type="User" id="userMap">
<id property="userId"  column="user_id" javaType="int"/>
<result property="userName" column="user_name" javaType="java.lang.String"/>
<result property="userPwd" column="user_pwd" javaType="java.lang.String"/>
<result property="userType" column="user_type" javaType="int"/>
</resultMap> 
<insert id="addUser" parameterType="User"><!-- 添加用户 -->
insert into users values(null,#{user.userName},#{user.userPwd},#{user.userType})
</insert>
<delete id="delUserById"><!-- 删除用户 -->
delete from users where user_id=#{userId}
</delete>
<select id="findUserById" resultMap="userMap"><!-- 根据ID查询用户 -->
select * from users where user_id = #{userId}
</select>
<select id="findAllUser" resultMap="userMap">
select * from users
</select> 
<select id="findUserByNameAndPwd" resultMap="userMap">
select * from users where user_name=#{name} and user_pwd=#{pwd}
</select>
<select id="findUserLikeNameAndPwd" resultMap="userMap">
select * from users where user_name like concat("%",#{name},"%") and user_pwd like concat("%",#{pwd},"%" )
</select>
<update id="updateUser">
update users set user_name =#{name},user_pwd=#{pwd} where user_id=#{userId}
</update>
</mapper>