需求:传入多个 id 查询用户信息,用下边两个 sql 实现:
SELECT * FROM USERS WHERE username LIKE '%张%' AND (id =10 OR id =89 OR id=16)
SELECT * FROM USERS WHERE username LIKE '%张%' AND id IN (10,89,...
需求:查出给定id的记录:
<select id="getEmpsByConditionForeach" resultType="comtestbeansEmployee">
SELECT * FROM tb1_emplyee WHERE id IN
<foreach collection="list" item="item_id" ...
drop PROCEDURE if exists my_procedure;
create PROCEDURE my_procedure()
BEGIN
declare my_sqll varchar(500);
set my_sqll='select * from aa_list';
set @ms=my_sqll;
PREPARE s1 from @ms;
...