Mybatis的简单应用

Mybatis和ibatis差别这么大我也是醉了。。。。。

主要参考

Mybatis配置文件（MybatisConfig.xml）

<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Sun Jan 04 13:38:35 CST 2015-->
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD SQL Map Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
		<setting name="cacheEnabled" value="true"/>
		<setting name="lazyLoadingEnabled" value="true"/>
	</settings>
	<typeAliases>
	    <typeAlias alias="tikabean" type="database.TikaBean" />  
	</typeAliases>
	
	<typeHandlers>
	</typeHandlers>
	
	<environments default="default">
		<environment id="default">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver"/>
				<property name="url" value="jdbc:mysql://localhost:3306/tika?characterEncoding=utf-8"/>
				<property name="username" value="root"/>
				<property name="password" value="123"/>
			</dataSource>
		</environment>
	</environments>
	
	<mappers>
		<mapper resource="database/TikaTest.xml"/>
	</mappers>
	</configuration>

<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Sun Jan 04 11:15:13 CST 2015-->
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="TikaTest">

	<insert id="insert" parameterType="tikabean">
		
		INSERT INTO fileparse (
			filename, filecontent
		) VALUES (
			#{filename}, #{filecontent}
		)
		
	</insert>
	
	<insert id="insertBatch" parameterType="java.util.List">
	    		
		INSERT INTO fileparse (
			 filename, filecontent
		) VALUES 
		
		 <foreach collection="list" item="item" index="index" separator=",">
					
				(
					#{item.filename}, #{item.filecontent}
				)
			
		</foreach>
	</insert>
	
	<select id="getAll" parameterType="java.util.Map" resultType="tikabean">
	
		SELECT
		id, filename, filecontent
		FROM fileparse
	
	</select>
	
	<select id="countAll" parameterType="java.util.Map" resultType="java.lang.Integer">
	
		SELECT
		COUNT(*) 
		FROM fileparse
		WHERE
		1
	
	</select>
	
	<select id="getByKey" parameterType="java.util.Map" resultType="tikabean">
	
		SELECT
		id, filename, filecontent
		FROM fileparse
		WHERE
		id=#{id}
	
	</select>		
	
	<update id="update" parameterType="tikabean">
		
		UPDATE fileparse 
		SET
		id=#{id}, filename=#{filename}, filecontent=#{filecontent}
		WHERE
		id=#{id}
		
	</update>		
	
	<delete id="delete" parameterType="tikabean">
		
		DELETE fileparse 
		WHERE
		id=#{id}
		
	</delete>		
</mapper>

Reader reader = Resources.getResourceAsReader("database/mybatisConfig.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sqlSessionFactory.openSession();
session.insert("TikaTest.insert",tikaBean);
session.commit();
session.clearCache();		
TikaBean tikaBean2 = (TikaBean) session.selectOne("TikaTest.getByKey", "");