Mybatis

Mybatis 使用 Class、xml实现操作数据库（基础的javaProject）

jar包：mybatis-3.5.2.jar / mysql-connector-java-5.1.47.jar

目录：src/mybatis/dao

创建mybatis-config.xml/NewsMapper.xml

创建类MybatisDrill

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>


    
        
            
            
                
                
                
                
            
        
    
    
        
    

NewsMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>



    
    
    
        select * from user where id = #{id}
    

    
        insert into user values(#{id},#{password})
    

MybatisDrill

package mybatisClass;
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.InputStream;
import java.util.HashMap;

public class MybatisDrill {
    private static SqlSessionFactory sqlSessionFactory;

    public static void main(String[] args) throws Exception{
        String resource = "mybatisClass/dao/mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        selectUser(sqlSession);
    }

    public static void selectUser(SqlSession sqlSession){
        HashMap news = new HashMap();
        news.put("id","news");
        news.put("password","520520");
        int n = sqlSession.insert("mybatisClass.dao.NewsMapper.insertUser",news);
        sqlSession.commit();
        sqlSession.close();
    }
}

实现的效果就是在数据库的User表中插入了一行数据