java : iBatis 2.3 起点

sqlMapConfig.xml 请参考: iBATIS in Action 2007

sqlMap.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="Codes">
<select id="getCname" parameterClass="ibatis.test.Codes" resultClass="hashmap">
<![CDATA[
SELECT code,cname FROM table1 WHERE code in (#code1#,#code2#,#code3#)
]]>
</select>
</sqlMap>

POJO : Codes.java

package ibatis.test;

public class Codes {
	private String code1;
	private String code2;
	private String code3;

	public String getCode1() { return this.code1; }
	public void setCode1(String code) { this.code1 = code.substring(0,2)+"0000"; }

	public String getCode2() { return this.code2; }
	public void setCode2(String code) { this.code2= code.substring(0,4)+"00"; }

	public String getCode3() { return this.code3; }
	public void setCode3(String code) { this.code3= code; }

}

测试程序: Test1.java

package ibatis.test;

import com.ibatis.sqlmap.client.*;
import com.ibatis.common.resources.Resources;
import ibatis.test.Codes;

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

public class Test1 {
	public static void main(String[] args) throws Exception {
		String code;
		if (args.length ==1){
			code = args[0];
		} else {
			System.out.println(" usage: java Test1 ?????? ");
			return;
		}
		try{
			String resource = "ibatis/test/sqlMapConfig.xml";
			Reader reader = Resources.getResourceAsReader (resource);
			SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
		
			Codes codes = new ibatis.test.Codes();
			codes.setCode1(code);
			codes.setCode2(code);
			codes.setCode3(code);
			List list = sqlMap.queryForList("getCname", codes);
			System.out.println("selected " + list.size() + " records.");
			for(int i = 0; i < list.size(); i++) {
				System.out.println(list.get(i));
			}
		} catch(Exception e){
			System.out.println(e);
		}
	}
}

编译 compile.bat

javac -cp /iBatis/lib/ibatis-2.3.0.677.jar;. Test1.java Codes.java

运行 run.bat

@echo off
set JarPATH=/iBatis/mysql-connector-java-5.1.24-bin.jar
set JarPATH=%JarPATH%;/iBatis/lib/commons-logging-1.1.1.jar
set JarPATH=%JarPATH%;/iBatis/lib/ibatis-2.3.0.677.jar
java -cp %JarPATH%;/ ibatis.test.Test1 %1

执行 run.bat 440101