Mybatis的简单应用

来源：互联网发布：淘宝打包发货招聘编辑：程序博客网时间：2024/06/08 09:44

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">SELECTid, filename, filecontentFROM fileparse</select><select id="countAll" parameterType="java.util.Map" resultType="java.lang.Integer">SELECTCOUNT(*) FROM fileparseWHERE1</select><select id="getByKey" parameterType="java.util.Map" resultType="tikabean">SELECTid, filename, filecontentFROM fileparseWHEREid=#{id}</select><update id="update" parameterType="tikabean">UPDATE fileparse SETid=#{id}, filename=#{filename}, filecontent=#{filecontent}WHEREid=#{id}</update><delete id="delete" parameterType="tikabean">DELETE fileparse WHEREid=#{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", "");

0 0