1.Mybatis配置文件:mybatis_config.xml
<?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">
<configuration>
<properties resource="jdbc.properties">
<!-- <property name="driver" value="com.mysql.jdbc.Driver"/>-->
<!-- <property name="url" value="jdbc:mysql://127.0.0.1:3306/day01"/>-->
<!-- <property name="username" value="root"/>-->
<!-- <property name="password" value="123456"/>-->
</properties>
<!--配置别名-->
<typeAliases>
<package name="com.leisong.domain"/>
</typeAliases>
<environments default="mysql">
<environment id="mysql">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/leisong/dao/ProviderMapper.xml"/>
<!--<mapper class="com.leisong.dao.AccountDao"/>-->
<!-- <package name="com.leisong.dao"/>-->
<mapper resource="com/leisong/dao/BillMapper.xml"/>
</mappers>
</configuration>
2.实体类:Provider
package com.leisong.domain;
import java.util.Date;
public class Provider {
private int id;
private String proCode;
private String proName;
private String proDesc;
private String proContact;
private String proPhone;
private String proFax;
private int createdBy;
private Date creationDate;
private int modifyBy;
private Date modifyDate;
private String companyLicPicPath;
private String orgCodePicPath;
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 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 int getModifyBy() {
return modifyBy;
}
public void setModifyBy(int modifyBy) {
this.modifyBy = modifyBy;
}
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;
}
@Override
public String toString() {
return "Provider{" +
"id=" + id +
", proCode='" + proCode + '\'' +
", proName='" + proName + '\'' +
", proDesc='" + proDesc + '\'' +
", proContact='" + proContact + '\'' +
", proPhone='" + proPhone + '\'' +
", proFax='" + proFax + '\'' +
", createdBy=" + createdBy +
", creationDate=" + creationDate +
", modifyBy=" + modifyBy +
", modifyDate=" + modifyDate +
", companyLicPicPath='" + companyLicPicPath + '\'' +
", orgCodePicPath='" + orgCodePicPath + '\'' +
'}';
}
}
3.数据访问层接口ProviderMapper
package com.leisong.dao;
import java.util.List;
public interface ProviderMapper {
public int count();
public List<?> getProviderAll();
}
4.ProviderMapper映射文件: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.leisong.dao.ProviderMapper">
<select id="count" resultType="Integer">
select count(1) from smbms_provider
</select>
<select id="getProviderAll" resultType="com.leisong.domain.Provider">
select * from smbms_provider;
</select>
</mapper>
5.自定义Mybatis工具类:MybatisUtil
package com.leisong.util;
import com.leisong.domain.Provider;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class MybatisUtil {
public static SqlSession getSqlSession(){
String str = "mybatis_config.xml";
SqlSession sqlSession = null;
try {
InputStream is = Resources.getResourceAsStream(str);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
sqlSession = sqlSessionFactory.openSession();
List<Provider> list = sqlSession.selectList("com.leisong.dao.ProviderMapper.getProviderAll");
for(Provider p : list){
System.out.println(p.toString());
}
} catch (IOException e) {
e.printStackTrace();
}
return sqlSession;
}
public static void closeSqlsession(SqlSession sqlSession){
if(sqlSession != null){
sqlSession.close();
}
}
}
6.测试
package com.leisong.test;
import com.leisong.domain.Provider;
import com.leisong.util.MybatisUtil;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class TestProvider {
@Test
public void test(){
String str = "mybatis_config.xml";
SqlSession sqlSession = null;
try {
InputStream is = Resources.getResourceAsStream(str);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
sqlSession = sqlSessionFactory.openSession();
int count = sqlSession.selectOne("com.leisong.dao.ProviderMapper.count");
System.out.println("用户个数:"+count);
} catch (IOException e) {
e.printStackTrace();
} finally {
if(sqlSession != null ){
sqlSession.close();
}
}
}
@Test
public void test2(){
SqlSession sqlSession = MybatisUtil.getSqlSession();
List<Provider> list = sqlSession.selectList("com.leisong.dao.ProviderMapper.getProviderAll");
for(Provider p : list){
System.out.println(p.toString());
}
MybatisUtil.closeSqlsession(sqlSession);
}
}