Mybatis步骤

public PageInfo<TransInfo> queryTransList(String merNo,int page,int rows) {PageHelper.startPage(page, rows);Example e = new Example(TransInfo.class);e.setOrderByClause("id desc");//orderBy("id");Criteria c = e.createCriteria();c.andEqualTo("merNo", merNo);c.andEqualTo("status", TransStatus.SUCCESS);PageInfo<TransInfo> pages = new PageInfo<TransInfo>(transInfoMapper.selectByExample(e));return pages;}

mybatis-3.1.1.jar,ojdbc14.jar,junit-4.8.2.jar

1.mybatis-config.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><environments default="development"><environment id="development"><transactionManager type="JDBC" /><dataSource type="POOLED"><property name="driver" value="oracle.jdbc.driver.OracleDriver" /><property name="url" value="jdbc:oracle:thin:@192.168.4.120:1521:orcl" /><property name="username" value="scott" /><property name="password" value="tiger" /></dataSource></environment></environments><mappers><mapper resource="com/chinasoft/entity/BlogMapper.xml" /><mapper resource="com/chinasoft/entity/AuthorMapper.xml" /></mappers></configuration>

2.BolgMapper.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.chinasoft.IBlogMapper"><select id="queryAllBlog" resultType="com.chinasoft.entity.Blog">select * from blog</select><delete id="deleteById" parameterType="int">delete from blog where id= #{id}</delete><update id="updateBlog" parameterType="com.chinasoft.entity.Blog">update blog set TITLE =#{title},CONTENT=#{content},CREATE_TIME=#{createTime},TYPE=#{type}where id = #{id}</update><insert id="addBlog" parameterType="com.chinasoft.entity.Blog">insert intoblog(id,TITLE,CONTENT,CREATE_TIME,TYPE)values(BLOG_SEQ.nextval,#{title},#{content},#{createTime},#{type})</insert></mapper>

3.IBlogMapper.java

package com.chinasoft;import java.util.List;import com.chinasoft.entity.Blog;public interface IBlogMapper {/** * 查询所有 *  * @return */public List<Blog> queryAllBlog();/** * 修改 *  * @return */public int updateBlog(Blog blog);/** * 添加 *  * @param blog * @return */public int addBlog(Blog blog);public int addBlog1(Blog blog);/** * 删除 *  * @param id * @return */public int deleteById(int id);public List<Blog> queryBlogAndAuthor();public List<Blog> queryBlogAndAuthor2();}

4.MyBatisInterfaceMain.java

package com.chinasoft.test;import java.io.Reader;import java.util.Date;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.After;import org.junit.Before;import org.junit.Test;import com.chinasoft.IAuthorMapper;import com.chinasoft.IBlogMapper;import com.chinasoft.entity.Author;import com.chinasoft.entity.Blog;public class MyBatisInterfaceMain {private IBlogMapper blogMapper;private IAuthorMapper authorMapper;private SqlSession openSession;@Beforepublic void beforeMethod() throws Exception {Reader resourceAsReader = Resources.getResourceAsReader("mybatis-config.xml");SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();SqlSessionFactory sessionFacotry = builder.build(resourceAsReader);openSession = sessionFacotry.openSession();blogMapper = openSession.getMapper(IBlogMapper.class);authorMapper = openSession.getMapper(IAuthorMapper.class);}/** * 查询所有博客 *  * @throws Exception */// @Testpublic void queryAllBlog() throws Exception {List<Blog> lstBlog = blogMapper.queryAllBlog();for (Blog blog : lstBlog) {System.out.println(blog);}}/** * 查询所有博客和作者 *  * @throws Exception *///@Testpublic void queryBlogAndAuthor() throws Exception {List<Blog> lstBlog = blogMapper.queryBlogAndAuthor();for (Blog blog : lstBlog) {System.out.println(blog);}}/** * 查询所有博客和作者 *  * @throws Exception *///@Testpublic void queryBlogAndAuthor2() throws Exception {List<Blog> lstBlog = blogMapper.queryBlogAndAuthor2();for (Blog blog : lstBlog) {System.out.println(blog);}}// @Testpublic void updateBlog() {Blog blog = new Blog();blog.setId(1);blog.setContent("嘿嘿嘿");blog.setTitle("hahaha");blog.setType("1");blog.setCreateTime(new Date());int updateBlog = blogMapper.updateBlog(blog);System.out.println(updateBlog);}// @Testpublic void addBlog() {// insert into// blog(id,TITLE,CONTENT,CREATE_TIME,TYPE)// values(#{id},#{title},#{content},#{createTime},#{type})Blog blog = new Blog();// blog.setId(3);blog.setContent("嘿嘿嘿");blog.setTitle("hahaha");blog.setType("1");blog.setCreateTime(new Date());int addBlog = blogMapper.addBlog(blog);System.out.println(addBlog);}// @Testpublic void deleteBlog() {blogMapper.deleteById(1);// <delete id="deleteById" paramterType="int">// delete from blog where id = #{id}// </delete>}@Testpublic void addAuthorAndBlog(){Author author = new Author();author.setAuthorName("11张三");author.setAuthorRemark("11呵呵哒");Blog blog = new Blog();blog.setContent("111啦啦啦,我是卖报的小行家！");blog.setTitle("111啦啦啦");blog.setType("1");blog.setCreateTime(new Date());blog.setAuthor(author);int addAuthor = authorMapper.addAuthor(author);int addBlog = blogMapper.addBlog1(blog);System.err.println(addAuthor);System.err.println(addBlog);}@Afterpublic void afterMethod() {openSession.commit();openSession.close();}}