/**
使用lobmok插件
*/
@Getter
@Setter
@NoArgsConstructor
@ToString
@EqualsAndHashCode
public class Vendor {
? ? private String vend_id;
? ? private String vend_name;
? ? private String vend_address;
? ? private String vend_city;
? ? private String vend_state;
? ? private String vend_zip;
? ? private String vend_country;
}

<?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.mybatis.mapper.VendorMapper"> ?
? <select id="findByVendorEntity" parameterType="vendor" resultType="vendor">
? ?? ?select * from Vendors where vend_id = #{vend_id} and vend_name = #{vend_name}
? </select>
</mapper>

public interface VendorMapper {
?? ?//通過Vendor對象查詢
?? ?Vendors findByVendorEntity(Vendor vendor);
}

try {
?? ??? ??? ?String resource = "mybatis-config.xml";
?? ??? ??? ?InputStream resourceAsStream = Resources.getResourceAsStream(resource);
?? ??? ??? ?SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream,"development2");
?? ??? ??? ?//獲取SQLSession
?? ??? ??? ?SqlSession openSession = build.openSession();
?? ??? ??? ?
?? ??? ??? ?VendorMapper mapper = openSession.getMapper(VendorMapper.class);
?? ??? ??? ?Vendor vendor = new Vendor();
?? ??? ??? ?vendor.setId("BRE02");
?? ??? ??? ?vendor.setName("Bear Emporium");
?? ??? ??? ?
?? ??? ??? ?Vendor findByVendorEntity = mapper.findByVendorEntity(vendor);
?? ??? ??? ?System.out.println(findByVendorEntity);
?? ??? ?} catch (IOException e) {
?? ??? ??? ?System.out.println("加載配置文件失敗");
?? ??? ??? ?e.printStackTrace();
?? ??? ?}