mybatic

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>
<!--加载java配置文件或者是声明属性信息-->
<properties resource="dataSource.properties"></properties>


<!--自定义别名-->
<typeAliases>
<!-- package：指定包名称来为该包下的po类声明别名，默认的别名就是类名（首字母大小写都可）-->
<package name="com.wode.bean"></package>
</typeAliases>


<!--配置mybatis的环境信息，与spring整合，该信息又spring来管理-->
<environments default="development">
<environment id="development">
<!-- 配置JDBC事务控制，由mybatis进行管理 -->  
<transactionManager type="JDBC" />
<!-- 配置数据源，采用mybatis连接池 -->  
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</dataSource>
</environment>
</environments>


<!--加载映射文件-->
<mappers>
<mapper resource="com/wode/mapper/UserMapper.xml"></mapper>
</mappers>
</configuration>

UserMapper.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.wode.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 user values(null,#{user.userName},#{user.userPwd},#{user.userType});
</insert>


<!--删除-->
<delete id="delUserById">
delecte from user where user_id=#{id};
</delete>

<!--修改-->
<update id="upateUser" parameterType="User">
update user set user_name=#{user.userName},user_pwd=#{user.userPwd},user_type=#{user.userType} where user_id=#{user.userId}          
</update>


<!--通过id查询-->
<select id="findUserById" resultMap="userMap">
select * from user where user_id=#{id};
</select>


<!--查询所有用户-->
<select id="findAllUser" resultMap="userMap">
select * from user
</select>


<!--通过name和pwd查询-->
<select id="findUserByNameAndPwd" resultMap="userMap">
select * from user where user_name=#{name} and user_pwd=#{pwd};
</select>
</select>


<!--通过用户名模糊查询-->
<select id="findUserByLikeName" resultMap="userMap">
select * from user where user_name like concat('%',#{name},'%');
</select>
</mapper>

总结：

1.配置要从大往小配

a.数据库配置文件

b.sqlMapConfig的配置

c.userMapper.java(相当于以前的dao层)

d.userMapper。xml(相当于以前的daoimpl层)

e.service层进行调用