【JAVAEE框架】Mybatis常用操作（CRUD）

"1.0" encoding="UTF-8" ?>
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
"com.itxzw.dao.IBrandDao">
 
    "getUserList" resultType="Brand">
        select * from tb_brand
    
 

public interface IBrandDao {
 
    public List getUserList() throws Exception;
 
}

public class MyBatisUtil {
 
    private static SqlSessionFactory factory;
 
    static {
 
        try {
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
 
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
 
            factory = builder.build(is);
        } catch (IOException e) {
            e.printStackTrace();
        }
 
    }
 
    public static SqlSession openSession(){
        return factory.openSession();
    }
 
    public static SqlSession openSession(boolean autoCommit){
        return factory.openSession(autoCommit);
    }
 
}

public class Brand {
    // id 主键
    private Integer id;
    // 品牌名称
    private String brand_name;
    // 企业名称
    private String company_name;
    // 排序字段
    private Integer ordered;
    // 描述信息
    private String description;
    // 状态：0：禁用  1：启用
    private Integer status;
 
    public Brand() {
    }
 
    public Brand(Integer id, String brand_name, String company_name, Integer ordered, String description, Integer status) {
        this.id = id;
        this.brand_name = brand_name;
        this.company_name = company_name;
        this.ordered = ordered;
        this.description = description;
        this.status = status;
    }
 
    public Integer getId() {
        return id;
    }
 
    public void setId(Integer id) {
        this.id = id;
    }
 
    public String getBrand_name() {
        return brand_name;
    }
 
    public void setBrand_name(String brand_name) {
        this.brand_name = brand_name;
    }
 
    public String getCompany_name() {
        return company_name;
    }
 
    public void setCompany_name(String company_name) {
        this.company_name = company_name;
    }
 
    public Integer getOrdered() {
        return ordered;
    }
 
    public void setOrdered(Integer ordered) {
        this.ordered = ordered;
    }
 
    public String getDescription() {
        return description;
    }
 
    public void setDescription(String description) {
        this.description = description;
    }
 
    public Integer getStatus() {
        return status;
    }
 
    public void setStatus(Integer status) {
        this.status = status;
    }
 
    @Override
    public String toString() {
        return "Brand{" +
                "id=" + id +
                ", brand_name='" + brand_name + '\'' +
                ", company_name='" + company_name + '\'' +
                ", ordered=" + ordered +
                ", description='" + description + '\'' +
                ", status=" + status +
                '}';
    }
}

public class TestMyBatis {
 
    @Test
    public void test01() throws Exception {
 
        IBrandDao userDao = new BrandDao();
 
        List userList = userDao.getUserList();
 
        for (Brand brand : userList) {
            System.out.println(brand);
        }
 
 
    }
 
}

    "getBrandById" resultType="Brand" parameterType="java.lang.String">
        select * from tb_brand where id = #{id}
    

public interface IBrandDao {
 
    public List getBrandList();
 
    public Brand getBrandById(String id);
 
    public List getBrandListByCondition(Brand conn);
 
    public List getBrandListByCondition(Map conn);
 
    public Integer addBrand(Brand brand);
 
    public Integer updateBrand(Brand brand);
 
    public Integer deleteBrand(Brand brand);
 
    public Integer getBrandByCondition(Brand brand);
 
}

    @Test
    public void test02(){
        IBrandDao dao = new BrandDao();
 
        Brand brandList = dao.getBrandById("142");
 
        System.out.println(brandList);
 
    }

    "getBrandListByCondition" resultType="Brand" parameterType="Brand">
        
            select t.id,
                   t.brand_name,
                   t.company_name,
                   t.description,
                   t.status,
                   t.ordered
            from tb_brand t where
        ]]>
 
        <if test="id != null and id != '' ">
            
                id = #{id}
                    ]]>
        if>
 
        <if test="brand_name != null and brand_name != '' ">
            
                 brand_name like '%${brand_name}%'
                     ]]>
        if>
 
        <if test="company_name != null and company_name != '' ">
            
               and company_name like '%${company_name}%'
                    ]]>
        if>
 
 
 
 
    

    @Test
    public void test03(){
        SqlSession sqlSession = MyBatisUtil.openSession();
 
        IBrandDao mapper = sqlSession.getMapper(IBrandDao.class);
 
        Brand brand = new Brand();
        brand.setBrand_name("8");
//        brand.setCompany_name("小米");
 
        List brandList = mapper.getBrandListByCondition(brand);
 
        for (int i = 0; i < brandList.size(); i++) {
            System.out.println(brandList.get(i));
        }
 
    }

    "addBrand" parameterType="Brand">
        
            insert into tb_brand values (#{id}, #{brand_name}, #{company_name}, #{ordered}, #{description}, #{status});
        ]]>
    
 
    "updateBrand" parameterType="Brand">
        
            update tb_brand set company_name = #{company_name} where id = #{id}
        ]]>
    
 
    "deleteBrand" parameterType="Brand">
        
            delete from tb_brand where id = #{id}
        ]]>
    

    @Test
    public void test04(){
        SqlSession sqlSession = MyBatisUtil.openSession();
 
        IBrandDao mapper = sqlSession.getMapper(IBrandDao.class);
 
        Brand brand = new Brand(null, "菠萝手机","菠萝",100,"美国有苹果,中国有菠萝",0);
 
        Integer integer = mapper.addBrand(brand);
        sqlSession.commit();
 
        System.out.println(integer);
 
    }
 
 
    @Test
    public void test05(){
        SqlSession sqlSession = MyBatisUtil.openSession();
 
        IBrandDao mapper = sqlSession.getMapper(IBrandDao.class);
 
        Brand brand = new Brand();
        brand.setId(191);
        brand.setCompany_name("大菠萝手机");
 
        Integer integer = mapper.updateBrand(brand);
        sqlSession.commit();
 
        System.out.println(integer);
 
    }
 
    @Test
    public void test06(){
        SqlSession sqlSession = MyBatisUtil.openSession();
 
        IBrandDao mapper = sqlSession.getMapper(IBrandDao.class);
 
        Brand brand = new Brand();
        brand.setId(195);
 
        Integer integer = mapper.deleteBrand(brand);
        sqlSession.commit();
 
        System.out.println(integer);
 
    }

  "smbmsUser" type="smbmsUser">
        "id" column="id">
        "role" column="userrole" resultMap="smbmsRole">
        "addresses" column="id" ofType="smbmsAddress" resultMap="smbmsAddress">
    
 
    "smbmsRole" type="smbmsRole">
        "id" column="rid">
        "createdby" column="rcb">
        "creationdate" column="rcd">
        "modifyby" column="rmb">
        "modifydate" column="rmd">
    
 
    "smbmsAddress" type="smbmsAddress">
        "id" column="aid">
        "createdby" column="acb">
        "creationdate" column="acd">
        "modifyby" column="amb">
        "modifydate" column="amd">
    
 
    "getUserListByCondition" parameterType="userCondition" resultMap="smbmsUser">
 
        
            select
                   u.ID,
                   u.USERCODE,
                   u.USERNAME,
                   u.USERPASSWORD,
                   u.GENDER,
                   u.BIRTHDAY,
                   u.PHONE,
                   u.ADDRESS,
                   u.userrole,
                   r.id rid,
                   r.rolecode,
                   r.rolename,
                   r.createdby rcb,
                   r.creationdate rcd,
                   r.modifyby rmb,
                   r.modifydate rmd,
                   a.id aid,
                   a.contact,
                   a.addressdesc,
                   a.postcode,
                   a.tel,
                   a.createdby acb,
                   a.creationdate acd,
                   a.modifyby amb,
                   a.modifydate amd,
                   a.userid,
                   u.CREATEDBY,
                   u.CREATIONDATE,
                   u.MODIFYBY,
                   u.MODIFYDATE
            from SMBMS_USER u
                     left join smbms_role r
                               on u.userrole = r.id
                     left join smbms_address a
                               on u.id = a.userid
            where 1=1
        ]]>
 
 
 
    

    public List getUserListByCondition(UserCondition conn);

    @Test
    public void test01(){
 
        SqlSession sqlSession = MyBatisUtil.openSession();
 
        IUserDao mapper = sqlSession.getMapper(IUserDao.class);
 
 
        UserCondition conn = new UserCondition();
 
        List userList = mapper.getUserListByCondition(conn);
        for (SmbmsUser smbmsUser : userList) {
            System.out.println(smbmsUser);
        }
 
 
        sqlSession.close();
    }

    "selectByPage" parameterType="Brand" resultType="Brand">
        select * from tb_brand limit #{begin}, #{size}
    

public List selectByPage(@Param("begin") int begin, @Param("size") int size);

    @Test
    public void test01() {
 
        SqlSession sqlSession = MyBatisUtil.openSession();
 
        IUserDao mapper = sqlSession.getMapper(IUserDao.class);
 
        List pageBean = mapper.selectByPage(1, 10);
 
        for (Brand brand : pageBean) {
            System.out.println(brand);
        }
 
        sqlSession.close();
    }