Mybatis练习之查询、增加、

1、创建功能接口

public interface ProviderMapper {

    /**
     * 查询供货商的所有信息
     * @return
     */
    public List<Provider> getProviderList();

    /**
     * 增加供货商信息
     * @param provider 供货商实体类
     * @return
     */
    public int addProvide(Provider provider);

    /**
     * 根据供货商联系人模糊查询供应商信息
     * @param proContact 模糊查询的供货商姓名
     * @return
     */
    public List<Provider>  findProvideByproName(String proContact);
}

2、将接口在Mapper.xml中配置，Mapper.xml文件直接映射到对应的接口，调用接口方法会自动去Mapper.xml文件中找到对应的标签

<mapper namespace="cn.kgc.Dao.ProviderMapper">
    <select id="proList" resultType="Provider">
        select * from smbms_provider
    </select>
    <select id="proCount" resultType="int">
        select count(1) from smbms_provider
    </select>
    <select id="getProviderList" resultType="cn.kgc.entity.Provider">
         select * from smbms_provider
    </select>
    <insert id="addProvide" parameterType="Provider">
        INSERT INTO smbms_provider (id,proCode,proName,proDesc,proContact,
        proPhone,proAddress,proFax,createdBy,creationDate,modifyDate,modifyBy)  
              VALUES   (#{id},#{proCode},#{proName},#{proDesc},  
                          #{proContact},#{proPhone},#{proAddress},
                          #{proFax},#{createdBy},#{creationDate},#{modifyDate},
                          #{modifyBy})  
    </insert>
    <select id="findProvideByproName" resultType="Provider" parameterType="String">
        select * from smbms_provider where proContact like CONCAT('%',#{proName},'%')
    </select>
</mapper>

3、将Mapper.xml配置在mybatis-config.xml中

<mappers>
        <mapper resource="cn/kgc/Dao/FinancingProductMapper.xml"></mapper>
        <mapper resource="cn/kgc/Dao/ProviderMapper.xml"></mapper>
    </mappers>

4、编写工具类

public class myBatisUntil {
    private static SqlSession sqlSession;
    static {
        String path = "mybatis-config.xml";
        try {
            InputStream is= Resources.getResourceAsStream(path);
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
            sqlSession = sqlSessionFactory.openSession();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    public static SqlSession getSqlSession(){
        return sqlSession;
    }
}

5、测试类

/**
     * 查询供货商的所有信息
     */
    @Test
    public void test02(){
        SqlSession sqlSession = myBatisUntil.getSqlSession();
        List<Provider> providerList = sqlSession.getMapper(ProviderMapper.class).getProviderList();
        //List<Provider> providerList = sqlSession.selectList("cn.kgc.Dao.ProviderMapper.proList");
        for (Provider provider : providerList) {
            System.out.println(provider.getId()+"---"+provider.getProCode()+"---"
                    +provider.getProName()+"---"+provider.getProDesc()+"---"
                    +provider.getProContact()+"---"+provider.getProPhone()+"---"
                    +provider.getProAddress()+"---"+provider.getProFax()+"---"
                    +provider.getModifyBy()+"---"+provider.getCreationDate()
                    +"---"+provider.getModifyDate()+"---"+provider.getCreatedBy());
        }
    }


/**
     * 增加供货商信息
     */
    @Test
    public void test04(){
        SqlSession sqlSession = myBatisUntil.getSqlSession();
        
        Provider provider = new Provider();
        provider.setId(16);
        provider.setProCode("ZJ_GYS002");
        provider.setProName("乐摆日用品厂");
        provider.setProDesc("长期合作伙伴，主营产品：各种中、高档塑料杯，塑料乐扣水杯（密封杯）、保鲜杯（保鲜盒）、广告杯、礼品杯");
        provider.setProContact("王佳欣");
        provider.setProPhone("18060975170");
        provider.setProAddress("湖里区");
        provider.setProFax("0579-34452321");
        provider.setCreatedBy(1);
        provider.setCreationDate("2019-10-21 10:01:30");
        int count = sqlSession.getMapper(ProviderMapper.class).addProvide(provider);
        System.out.println("添加："+count);
    }


/**
     * 根据供货商联系人模糊查询供应商信息
     */
    @Test
    public void test05() {
        SqlSession sqlSession = myBatisUntil.getSqlSession();
        String proContact = "王";
        List<Provider> providerList = sqlSession.getMapper(ProviderMapper.class).findProvideByproName(proContact);
        //List<Provider> providerList = sqlSession.selectList("cn.kgc.Dao.ProviderMapper.proList");
        for (Provider provider : providerList) {
            System.out.println(provider.getId() + "---" + provider.getProCode() + "---"
                    + provider.getProName() + "---" + provider.getProDesc() + "---"
                    + provider.getProContact() + "---" + provider.getProPhone() + "---"
                    + provider.getProAddress() + "---" + provider.getProFax() + "---"
                    + provider.getModifyBy() + "---" + provider.getCreationDate()
                    + "---" + provider.getModifyDate() + "---" + provider.getCreatedBy());
        }
    }

测试结果：

查询供应商信息：