示例
接口
public List <Provider > selectProviderList(Map <String , Object > map)throws Exception ;
xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace ="com.rzk.mapper.provider.ProviderMapper" >
<select id ="selectProviderList" resultType ="provider" parameterType ="map" >
select * from smbms_provider where 1=1
<if test ="proCode != null" >
and proCode LIKE concat('%',#{proCode},'%')
</if >
<if test ="proName != null" >
and proName LIKE concat('%',#{proName},'%')
</if >
order by creationDate DESC limit #{startIndex},#{pageSize}
</select >
</mapper >
mybatis.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 ="db.properties" />
<settings >
<setting name ="logImpl" value ="LOG4J" />
<setting name ="mapUnderscoreToCamelCase" value ="true" />
</settings >
<typeAliases >
<package name ="com.rzk.pojo" />
</typeAliases >
<environments default ="development" >
<environment id ="development" >
<transactionManager type ="JDBC" />
<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/rzk/mapper/user/UserMapper.xml" />
<mapper resource ="com/rzk/mapper/role/RoleMapper.xml" />
<mapper resource ="com/rzk/mapper/provider/ProviderMapper.xml" />
</mappers >
</configuration >
db.properties
driver =com.mysql.jdbc.Driver
url =jdbc:mysql://localhost:3306 /?useUnicode=true &characterEncoding=UTF-8
username =root
password =123456
SQL
CREATE TABLE `smbms_provider` (
`id` bigint (20 ) NOT NULL AUTO_INCREMENT COMMENT '主键ID' ,
`proCode` varchar (20 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '供应商编码' ,
`proName` varchar (20 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '供应商名称' ,
`proDesc` varchar (50 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '供应商详细描述' ,
`proContact` varchar (20 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '供应商联系人' ,
`proPhone` varchar (20 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系电话' ,
`proAddress` varchar (50 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '地址' ,
`proFax` varchar (20 ) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '传真' ,
`createdBy` bigint (20 ) DEFAULT NULL COMMENT '创建者(userId)' ,
`creationDate` datetime DEFAULT NULL COMMENT '创建时间' ,
`modifyDate` datetime DEFAULT NULL COMMENT '更新时间' ,
`modifyBy` bigint (20 ) DEFAULT NULL COMMENT '更新者(userId)' ,
PRIMARY KEY (`id`) USING BTREE
) ENGINE= InnoDB AUTO_INCREMENT= 19 DEFAULT CHARSET= utf8 COLLATE = utf8_unicode_ci ROW_FORMAT= COMPACT;
INSERT INTO `smbms_provider` VALUES ('1' , 'BJ_GYS001' , '北京三木堂商贸有限公司' , '长期合作伙伴,主营产品:茅台、五粮液、郎酒、酒鬼酒、泸州老窖、赖茅酒、法国红酒等' , '张国强' , '135666677' , '北京市丰台区育芳园北路' , '010-58858787' , '1' , '2013-03-21 16:52:07' , null , null );
INSERT INTO `smbms_provider` VALUES ('4' , 'GZ_GYS002' , '深圳市喜来客商贸有限公司' , '长期合作伙伴,主营产品:坚果炒货.果脯蜜饯.天然花茶.营养豆豆.特色美食.进口食品.海味零食.肉脯肉' , '林妮1' , '185998975' , '广东省深圳市福龙工业区B2栋3楼西' , '0755-677341' , '1' , '2013-03-22 16:52:07' , '2018-09-24 21:28:07' , '1' );
INSERT INTO `smbms_provider` VALUES ('8' , 'ZJ_GYS001' , '慈溪市广和绿色食品厂' , '长期合作伙伴,主营产品:豆瓣酱、黄豆酱、甜面酱,辣椒,大蒜等农产品' , '薛圣丹1' , '180999532' , '浙江省宁波市慈溪周巷小安村' , '0574-34449090' , '1' , '2013-11-21 06:02:07' , '2018-09-28 19:54:31' , '1' );
INSERT INTO `smbms_provider` VALUES ('9' , 'GX_GYS001' , '优百商贸有限公司' , '长期合作伙伴,主营产品:日化产品' , '李立国' , '133266543' , '广西南宁市秀厢大道42-1号' , '0771-988614' , '1' , '2013-03-21 19:52:07' , null , null );
INSERT INTO `smbms_provider` VALUES ('18' , '12' , '234' , '123' , '234' , '15815891967' , '213' , '123' , '1' , '2018-09-26 12:55:42' , null , null );
测试
@Test
public void selectProviderList () throws Exception {
SqlSession session = MybatisUtils.getSqlSessionFactory();
ProviderMapper mapper = session.getMapper(ProviderMapper.class);
Map<String, Object> map = new HashMap <>();
map.put("proCode" ,"Z" );
map.put("startIndex" ,0 );
map.put("pageSize" ,3 );
List<Provider> list = mapper.selectProviderList(map);
for (Provider provider : list) {
System.out.println(provider);
}
}
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· .NET Core内存结构体系(Windows环境)底层原理浅谈
· C# 深度学习:对抗生成网络(GAN)训练头像生成模型
· .NET 适配 HarmonyOS 进展
· .NET 进程 stackoverflow异常后,还可以接收 TCP 连接请求吗?
· SQL Server统计信息更新会被阻塞或引起会话阻塞吗?
· 传国玉玺易主,ai.com竟然跳转到国产AI
· 本地部署 DeepSeek:小白也能轻松搞定!
· 自己如何在本地电脑从零搭建DeepSeek!手把手教学,快来看看! (建议收藏)
· 我们是如何解决abp身上的几个痛点
· 普通人也能轻松掌握的20个DeepSeek高频提示词(2025版)