java : iBatis 2.3 resultMap

最新推荐文章于 2021-02-24 08:31:27 发布

转载最新推荐文章于 2021-02-24 08:31:27 发布 · 833 阅读

文章标签：

#java #iBatis #resultMap

java 专栏收录该内容

41 篇文章

订阅专栏

sqlMapConfig.xml 请参考: iBATIS in Action 2007

sqlMap2.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap
 PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
 "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="area">
<resultMap id="result" class="ibatis.test.Area">
 <result property="code" column="code" />
 <result property="cname" column="cname" />
</resultMap> 

<select id="get_cname" parameterClass="hashmap" resultMap="result">
<![CDATA[
SELECT code,cname FROM table1 WHERE code in (#code1#,#code2#,#code3#)
]]>
</select>
</sqlMap>

POJO : Area.java

package ibatis.test;
import java.io.Serializable;
// POJO
public class Area implements Serializable {
	private String code;
	private String cname;

	public Area(){}

	public String getCode() { return this.code; }
	public void setCode(String code) { this.code = code; }

	public String getCname() { return this.cname; }
	public void setCname(String cname) { this.cname = cname; }

}

测试程序: Test2.java

package ibatis.test;
/*
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.log4j.Logger;
import org.apache.log4j.PropertyConfigurator;
*/
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

import ibatis.test.Area;

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

public class Test2 {
//	public static Log log = LogFactory.getLog(Test2.class);

	public static void main(String[] args) throws Exception {
	//	PropertyConfigurator.configure("./log4j.properties");
	
		String code;
		if (args.length ==1){
			code = args[0];
		} else {
			System.out.println(" usage: java Test2 ?????? ");
			return;
		}
		try{
			String resource = "ibatis/test/sqlMapConfig.xml";
			Reader reader = Resources.getResourceAsReader (resource);
			SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
		
			HashMap<String,String> codes = new HashMap<String,String>();
			codes.put("code1",code.substring(0,2)+"0000");
			codes.put("code2",code.substring(0,4)+"00");
			codes.put("code3",code);

			List alist = sqlMap.queryForList("get_cname", codes);
			int rows = alist.size();
			System.out.println(" selected " + rows + " records.");
			Area area ;
			for(int i = 0; i < rows; i++) {
				area = (Area)alist.get(i);
				System.out.println(area.getCode() +"  "+ area.getCname());
			}
		} catch(Exception e){
			System.out.println(e);
		}
	}
}

编译 compile2.bat

@echo off
set JarPATH=/iBatis/lib/ibatis-common-2.jar
set JarPATH=%JarPATH%;/iBatis/lib/ibatis-2.3.4.726.jar
javac -Xlint:unchecked -cp %JarPATH%;. Test2.java  Area.java

运行 run2.bat

@echo off
set JarPATH=/iBatis/mysql-connector-java-5.1.24-bin.jar
set JarPATH=%JarPATH%;/iBatis/lib/ibatis-common-2.jar
set JarPATH=%JarPATH%;/iBatis/lib/ibatis-2.3.4.726.jar
java -cp %JarPATH%;/ ibatis.test.Test2 %1