MyBatis（一）

实现代码：

package com.openlab.dao;

public interface ProviderMapper {
	
	//查询统计供应商的数量
	public int count();
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">

<mapper namespace="com.openlab.dao.ProviderMapper">
	<!-- 查询供应商数量 -->
	<select id="count" resultType="Integer">
		select count(1) as count from smbms_provider
	</select>









</mapper>

package com.openlab.pojo;

import java.sql.Date;

public class Provider {
	private int id;
	private String proCode;
	private String proName;
	private String proDesc;
	private String proContact;
	private String proPhone;
	private String proAddress;
	private String proFax;
	private int createBy;
	private Date creationDate;
	private Date modifyDate;
	private int modifyBy;
	private String companyLicPicPath;
	
	public int getId() {
		return id;
	}
	
	public void setId(int id) {
		this.id = id;
	}
	
	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 getCreateBy() {
		return createBy;
	}
	
	public void setCreateBy(int createBy) {
		this.createBy = createBy;
	}
	
	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 int getModifyBy() {
		return modifyBy;
	}
	
	public void setModifyBy(int modifyBy) {
		this.modifyBy = modifyBy;
	}
	
	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;
	}
	
	private String orgCodePicPath;
	
}

package com.openlab.test;

import java.io.IOException;
import java.io.InputStream;

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 Test01 {
	
	public static void main(String[] args){
		//读取配置文件
		String str = "mybatis-config.xml";
		SqlSession sqlSession = null;
		Integer count = 0;
		InputStream is;
		
		try {
			is = Resources.getResourceAsStream(str);
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
			//创建SqlSession
			sqlSession = sqlSessionFactory.openSession();
			
			//执行查询供应商的数量的方法
			count = sqlSession.selectOne("com.openlab.dao.Pro");
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}