本文共 3181 字，大约阅读时间需要 10 分钟。

1.创建实体类 Blog

package com.wang.pojo;import lombok.Data;import java.util.Date;@Datapublic class Blog {    private String id;    private String title;    private String author;    private Date createTime;    private int view;}

2.创建数据库操作接口与对应的Mapper

package com.wang.dao;import com.wang.pojo.Blog;import java.util.Date;import java.util.List;import java.util.Map;public interface BlogMapper {    //插入数据    public void inSert(Blog blog);    //查找博客    public List
   
     quereBlog(Map map);}
   

BlogMapper.xml

   
   
        
    
     insert into mybatis.blog(id, title, author, create_time, view)values (#{id},#{title},#{author},#{createTime},#{view});    
    
        
            select * from mybatis.blog where 1=1                    and title=#{title}                            and author=#{author}            
   

3.编写mybatis配置文件   mybatis-config.xml

   
       
        
    
     
     
             
         
    <！--        设置别名  -->    
            
         
    
      
            
                 
                  
                      
                       
                       
                       
                   
              
         
    
        
            
         
    
   

4.创建工具类

package com.wang.utils;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 java.io.IOException;import java.io.InputStream;public class MyBatisUtils {//    获得SqlSessionFactory    static  SqlSessionFactory sqlSessionFactory;    static {        try {            String resource = "mybatis-config.xml";            InputStream stream = Resources.getResourceAsStream(resource);            sqlSessionFactory  = new SqlSessionFactoryBuilder().build(stream);        } catch (IOException e) {            e.printStackTrace();        }    }//    获得SqlSession对象    public static SqlSession getSqlSession(){        return sqlSessionFactory.openSession(true);    }}

5.   创建实现类

public class Text {    @Test    public void addBlog(){        SqlSession sqlSession = MyBatisUtils.getSqlSession();        BlogMapper mapper = sqlSession.getMapper(BlogMapper.class);        Blog blog=new Blog();        blog.setId(IDutils.getID());        blog.setTitle("Java快速入门");        blog.setAuthor("少年不知岁月长");        blog.setCreateTime(new Date());        blog.setView(5392);        mapper.inSert(blog);        blog.setId(IDutils.getID());        blog.setTitle("数据库底层原理");        blog.setCreateTime(new Date());        blog.setView(5645);        mapper.inSert(blog);        blog.setId(IDutils.getID());        blog.setTitle("JVM");        blog.setCreateTime(new Date());        blog.setView(4984);        mapper.inSert(blog);        sqlSession.close();    }    @Test    public void QuereIf(){        SqlSession sqlSession = MyBatisUtils.getSqlSession();        BlogMapper mapper = sqlSession.getMapper(BlogMapper.class);        Map
   
     map = new HashMap<>();        map.put("title","数据库底层原理");        List
    
      blogs = mapper.quereBlog(map);        for (Blog blog : blogs) {            System.out.println(blog);        }        map.clear();        sqlSession.close();    }}
    
   

转载地址：http://jfcki.baihongyu.com/