1.Pet.jaa
package com.annotation.entity;
import java.util.Date;
/**
* 创建实体类Pet
* @author Steven
*
*/
public class Pet {
private int id;//宠物id
private String name;//名称
private String owner;//主人
private String species;//品种
private char sex;//性别
private Date birth;//出生日期
private Date death;//死亡日期
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getOwner() {
return owner;
}
public void setOwner(String owner) {
this.owner = owner;
}
public String getSpecies() {
return species;
}
public void setSpecies(String species) {
this.species = species;
}
public char getSex() {
return sex;
}
public void setSex(char sex) {
this.sex = sex;
}
public Date getBirth() {
return birth;
}
public void setBirth(Date birth) {
this.birth = birth;
}
public Date getDeath() {
return death;
}
public void setDeath(Date death) {
this.death = death;
}
@Override
public String toString() {
return "Pet [id=" + id + ", name=" + name + ", owner=" + owner + ", species=" + species + ", sex=" + sex
+ ", birth=" + birth + ", death=" + death + "]";
}
}
2.PetDao.java
public interface PetDao {
//Pet实体类对应数据库中的表
@Select("select * from pet")
public List<Pet> selectAll();
}
3.mybatos-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="sql.properties"></properties>
<typeAliases>
<!-- <typeAlias type="com.mybatis.entity.Pet" alias="Pet"/> -->
<!-- 默认别名是对应的类名 -->
<package name="com.mybatis.entity"/>
</typeAliases>
<!--environments 指mybatis可以配置多个环境默认,default只想默认的环境
每个sqlSessionFactory对应一个environment
-->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<!-- UNPOOLED访问数据库时每次都会打开关闭连接
POOLED数据库池减少了每次初始化、创建连接、和请求验证的时间
-->
<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>
<!-- 定义SQL语句的映射文件 -->
<mapper resource="com/mybatis/entity/PetMapper.xml" />
<!-- 对应接口类-->
<mapper class="com.annotation.dao.PetDao"/>
</mappers>
</configuration>
4.测试类
public class Test {
public static void main(String[] args) throws IOException {
SqlSession session=MyBatisUtil.getSqlSession();
//Mapper映射相关接口
PetDao petDao=session.getMapper(PetDao.class);
List<Pet>pets=petDao.selectAll();
for(Pet pet:pets) {
System.out.println(pet);
}
}
}