mybatis 详解

If：判断添加传值是否为空

ResultMap：配置返回映射对象
column:SQL语句中输入的名字，
type/property：实体类中的名字
最后显示的是type/property

resultMap：配置返回映射
parameterType:传入类型数组
forech：遍历输入或集合元素
collection:遍历的对象
open:连接的开始
separator:分隔
item:返回的名称

Close:结束

Set:判断是否最后一个条件

返回添加的id

Property:实体类的属性集合
JavaType：java的参数类型
ofType：实体类
select：引用方法
column：传入参数
1.mybatis-jar包 mysql-jar包

2.实体类 domin

3.持久层实体类 dao

4.mybatis-config.xml

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

UserDao.xml

<?xml version="1.0" encoding="UTF-8" ?> select * from nameandpass select * from nameandpass where username=${name} insert into nameandpass(username,password) value (${username},${password})

5.测试类text

package com.itheima.text;

import com.itheima.dao.UserDao;

import com.itheima.domain.User;
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 java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class UserText {
private SqlSession sqlSession;
private InputStream in;
private UserDao userDao;

/**
 * 获取连接
 * @throws IOException
 */
@Before
public void init() throws IOException {
    //连接配置文件config
    in = Resources.getResourceAsStream("config/mybatis-config.xml");
    //创建构建者对象
    SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    //创建工厂
    SqlSessionFactory build = builder.build(in);
    //根据工程创建session对象
    sqlSession=build.openSession();
    //class解析获取接口方法
    userDao=sqlSession.getMapper(UserDao.class);
}

/**
 * 提交及关闭流
 * @throws IOException
 */
@After
public void destroy() throws IOException {
    sqlSession.commit();
    sqlSession.close();
    in.close();
}
@Test
public void fingAll(){
    List<User> all = userDao.findAll();
    for (User user : all) {
        System.out.println(user);
    }
}

}