mybatis配置文件编写

mybatis配置文件configuration编写 ，见网址

http://mybatis.github.io/mybatis-3/configuration.html

最简单的配置

<?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>
	<mappers>
		<mapper resource="com/icreate/dao/UserDao.xml"/>
	</mappers>
</configuration>

mybatis映射文件mapper.xml编写，见网址

http://mybatis.github.io/mybatis-3/sqlmap-xml.html

自己写的配置，各个意思，查上面的网址，一目了然

<mapper namespace="com.icreate.dao.UserDao">

	<resultMap type="com.icreate.entity.User" id="resultList">
		<id column="id" property="id"/>
		<result column="username" property="username"/>
		<result column="password" property="password"/>
	</resultMap>
<!-- 查询表中记录总数 -->
	<select id="countAll" resultType="int">
		select count(*) c from tb_user
	</select>
	
	<select id="selectAll" resultMap="resultList">
		select * from tb_user order by username asc
	</select>
	
	<insert id="insert" parameterType="com.icreate.entity.User">
		insert into tb_user(username,password) values(#{username},#{password})
	</insert>
	
	<update id="update" parameterType="com.icreate.entity.User">
		update tb_user set username=#{username},password=#{password}
			where username=#{username}
	</update>
	
	<delete id="delete" parameterType="String">
		delete form tb_user where username=#{username}
	</delete>
	
	<select id="findByUserName" parameterType="String" resultType="com.icreate.entity.User">
		select * from tb_user where username=#{username}
	</select>

</mapper>