作业二

Provider.java

package com.oupeng.pojo;

import java.util.Date;

public class Provider {
    private int id;
    private int modifyBy;
    private String proCode;
    private String proName;
    private String proDesc;
    private String proContact;
    private String proPhone;
    private String proAddress;
    private String proFax;
    private int createdBy;
    private Date creationDate;
    private Date modifyDate;
    private String companyLicPicPath;
    private String orgCodePicPath;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getModifyBy() {
        return modifyBy;
    }

    public void setModifyBy(int modifyBy) {
        this.modifyBy = modifyBy;
    }

    public String getProCode() {
        return proCode;
    }

    public void setProCode(String proCode) {
        this.proCode = proCode;
    }

    public String getProName() {
        return proName;
    }

    public void setProName(String proName) {
        this.proName = proName;
    }

    public String getProDesc() {
        return proDesc;
    }

    public void setProDesc(String proDesc) {
        this.proDesc = proDesc;
    }

    public String getProContact() {
        return proContact;
    }

    public void setProContact(String proContact) {
        this.proContact = proContact;
    }

    public String getProPhone() {
        return proPhone;
    }

    public void setProPhone(String proPhone) {
        this.proPhone = proPhone;
    }

    public String getProAddress() {
        return proAddress;
    }

    public void setProAddress(String proAddress) {
        this.proAddress = proAddress;
    }

    public String getProFax() {
        return proFax;
    }

    public void setProFax(String proFax) {
        this.proFax = proFax;
    }

    public int getCreatedBy() {
        return createdBy;
    }

    public void setCreatedBy(int createdBy) {
        this.createdBy = createdBy;
    }

    public Date getCreationDate() {
        return creationDate;
    }

    public void setCreationDate(Date creationDate) {
        this.creationDate = creationDate;
    }

    public Date getModifyDate() {
        return modifyDate;
    }

    public void setModifyDate(Date modifyDate) {
        this.modifyDate = modifyDate;
    }

    public String getCompanyLicPicPath() {
        return companyLicPicPath;
    }

    public void setCompanyLicPicPath(String companyLicPicPath) {
        this.companyLicPicPath = companyLicPicPath;
    }

    public String getOrgCodePicPath() {
        return orgCodePicPath;
    }

    public void setOrgCodePicPath(String orgCodePicPath) {
        this.orgCodePicPath = orgCodePicPath;
    }
}

ProviderMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.oupeng.mapper.ProviderMapper">
    <select id="getProviderAll" resultType="Provider">
        select * from smbms_provider
    </select>

</mapper>

TestProviderMapper

  @Test
    public void test1() {
        SqlSession sqlSession = null;
        try {
            sqlSession = getSqlSessionFactory().openSession();
            List<Provider> list = sqlSession.getMapper(ProviderMapper.class).getProviderAll();
            for(Provider p:list){
                System.out.println(p.getProName()+"\t"+p.getProPhone()+"\t"+p.getCreationDate());
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
        sqlSession.close();
    }
    @Test
    public void test２() {
        SqlSession sqlSession = null;
        try {
            sqlSession = getSqlSessionFactory().openSession();
            /*//statement:对sql映射配置文件当中的sql语句的唯一符(全限定名 +　方法名)*/
            List<Provider> list = sqlSession.selectList("com.oupeng.mapper.ProviderMapper.getProviderAll");
            for(Provider p:list){
                System.out.println(p.getProName()+"\t"+p.getProPhone()+"\t"+p.getCreationDate());
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
        sqlSession.close();
    }

MybatisUtil.java

public class MybatisUtil {
    public static SqlSessionFactory sqlSessionFactory;

    static{
        String resource="mybatis-config.xml";

        try {
            InputStream is = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);


        } catch (IOException e) {
            e.printStackTrace();
        }
    }
//    创建SQLSession
    public static SqlSession createSqlSession(){
        SqlSession sqlSession=sqlSessionFactory.openSession();
        return sqlSession;
    }
//    关闭sqlSession
    public static void closeSqlSession(SqlSession sqlSession){
        if(sqlSession!=null){
            sqlSession.close();
        }
    }