mybatis注解开发

pojo

package com.zking.pojo;

public class city {
    private  String cid;
    private String cname;
    private String pid ;


    public city() {
    }

    public city(String cid, String cname, String pid) {
        this.cid = cid;
        this.cname = cname;
        this.pid = pid;
    }

    public String getCid() {
        return cid;
    }

    public void setCid(String cid) {
        this.cid = cid;
    }

    public String getCname() {
        return cname;
    }

    public void setCname(String cname) {
        this.cname = cname;
    }

    public String getPid() {
        return pid;
    }

    public void setPid(String pid) {
        this.pid = pid;
    }
}







package com.zking.pojo;

import java.util.Set;

public class province {

    private String pid;
    private String pname;
    private city city;
    private Set<city> citySet;


    public province() {
    }

    public province(String pid, String pname) {
        this.pid = pid;
        this.pname = pname;
    }

    public Set<com.zking.pojo.city> getCitySet() {
        return citySet;
    }

    public void setCitySet(Set<com.zking.pojo.city> citySet) {
        this.citySet = citySet;
    }

    public com.zking.pojo.city getCity() {
        return city;
    }

    public void setCity(com.zking.pojo.city city) {
        this.city = city;
    }

    public String getPid() {
        return pid;
    }

    public void setPid(String pid) {
        this.pid = pid;
    }

    public String getPname() {
        return pname;
    }

    public void setPname(String pname) {
        this.pname = pname;
    }
}

mapper：

package com.zking.mapper;

import com.zking.pojo.city;
import org.apache.ibatis.annotations.*;

import java.util.Set;

public interface Icity {

    @Insert("insert into city() value(uuid(),#{cname},#{pid})")
    public int Addcity(city c);
   @Update("update city set cname=#{cname},pid=#{pid} where cid=#{cid}")
    public int Editcity(city c);
    @Delete("delete from  city where cid=#{cid}")
    public int Deletecity(city c);

    @Select("select * from city where pid=#{pid}")
    @Results({
            @Result(id = true,property = "cid",column = "cid"),
            @Result(property = "cname",column = "cname"),
            @Result(property = "pid",column = "pid")
    })
    public city FindAll(String pid);

    @Select("select * from city where pid=#{pid}")
    @Results({
            @Result(id = true,property = "cid",column = "cid"),
            @Result(property = "cname",column = "cname"),
            @Result(property = "pid",column = "pid")
    })
    public Set<city> FindAlls(String pid);
}





package com.zking.mapper;

import com.zking.pojo.province;
import org.apache.ibatis.annotations.*;

import javax.annotation.Resources;
import java.util.List;

public interface Iprovince {
    @Insert("insert into province() value(uuid(),#{pname}) ")
    public int AddProvince(province province);

    @Update("update province set pname=#{pname} where pid=#{pid}")
    public int EditProvince(province province);


    @Select("select * from province")
    @Results({
            @Result(id = true, property = "pid", column = "pid"),
            @Result(property = "pname", column = "pname"),
            @Result(property = "city", column = "pid", one = @One(select = "com.zking.mapper.Icity.FindAll"))
    })
    public List<province> FindAll();
    @Select("select * from province")
    @Results({
            @Result(id = true, property = "pid", column = "pid"),
            @Result(property = "pname", column = "pname"),
            @Result(property = "citySet", column = "pid", many = @Many(select = "com.zking.mapper.Icity.FindAlls"))
    })
    public List<province> FindAlls();
}

Test：

import com.zking.mapper.Icity;
import com.zking.mapper.Iprovince;
import com.zking.pojo.city;
import com.zking.pojo.province;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class Test {


    @org.junit.Test
    public void dome01() throws Exception {

        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        Iprovince iprovince = sqlSession.getMapper(Iprovince.class);
        province p = new province();
        p.setPname("湖北");
        iprovince.AddProvince(p);
        sqlSession.commit();
        sqlSession.close();

    }
    @org.junit.Test
    public void dome02() throws Exception {

        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        Iprovince iprovince = sqlSession.getMapper(Iprovince.class);
        province p = new province();
        p.setPid("96dbb233-0c4b-11ea-a8ef-fc459698e2bd");
        p.setPname("湖北");
        iprovince.EditProvince(p);
        sqlSession.commit();
        sqlSession.close();

    }


    @org.junit.Test
    public void dome03() throws Exception {

        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        Icity mapper = sqlSession.getMapper(Icity.class);
        city c=new city();
        c.setCname("长沙");
        c.setPid("96dbb233-0c4b-11ea-a8ef-fc459698e2bd");
        mapper.Addcity(c);
        sqlSession.commit();
        sqlSession.close();

    }

    @org.junit.Test
    public void dome04() throws Exception {
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        Icity mapper = sqlSession.getMapper(Icity.class);
        city c=new city();
        c.setCid("9495f3f5-0c55-11ea-ab6e-fc459698e2bd");
        c.setCname("长沙");
        c.setPid("96dbb233-0c4b-11ea-a8ef-fc459698e2bd");
        mapper.Editcity(c);
        sqlSession.commit();
        sqlSession.close();

    }

    @org.junit.Test
    public void dome05() throws Exception {
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        Icity mapper = sqlSession.getMapper(Icity.class);
        city c=new city();
        c.setCid("9495f3f5-0c55-11ea-ab6e-fc459698e2bd");
        mapper.Deletecity(c);
        sqlSession.commit();
        sqlSession.close();

    }

    @org.junit.Test
    public void dome06() throws Exception {
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        Iprovince mapper = sqlSession.getMapper(Iprovince.class);
        mapper.FindAll();
        sqlSession.close();

    }
    @org.junit.Test
    public void dome07() throws Exception {
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        Iprovince mapper = sqlSession.getMapper(Iprovince.class);
        mapper.FindAlls();
        sqlSession.close();

    }
}