ibatis例子（四） iterate 2

前提：目录结构参照ibatis例子（二） 下面4个文件不变

SqlMapConfig.xml

log4j.properties

t_user.sql

User.java

1.User.xml 中加入如下信息

<select id="searchProductList" resultClass="user" parameterClass="java.util.ArrayList">
			select * from t_user 
			<dynamic prepend="WHERE">
				<iterate open="(" close=")" conjunction="OR">
					name=#keywordList[]# 
				</iterate>
			 </dynamic>
		</select>

2.UserTest.java

package com.jinzy;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class UserTest {

	/**
	 * @param args
	 * @throws SQLException
	 * @throws IOException
	 */
	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
		Reader reader = Resources
				.getResourceAsReader("com/jinzy/maps/sqlMapConfig.xml");
		SqlMapClient sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
		reader.close();
		
		List keywordList = new ArrayList();
		keywordList.add("jinzy2");
		keywordList.add("jinzy4");
		List users = sqlMapper.queryForList("searchProductList", keywordList);
		
		User user1 = null;
		for (int i = 0; i < users.size(); i++) {
			user1 = (User)users.get(i);
			System.out.print(user1.getId());
			System.out.print("-");
			System.out.println(user1.getName());
		}
		
	}
}

3.最终输出结果

DEBUG - {pstm-100001} Executing Statement:     select * from t_user WHERE ( name=? OR name=?      )