java : iBatis 2.3 起点

来源：互联网发布：js新手可以做的小游戏编辑：程序博客网时间：2024/05/16 10:10

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 offset JarPATH=/iBatis/mysql-connector-java-5.1.24-bin.jarset JarPATH=%JarPATH%;/iBatis/lib/commons-logging-1.1.1.jarset JarPATH=%JarPATH%;/iBatis/lib/ibatis-2.3.0.677.jarjava -cp %JarPATH%;/ ibatis.test.Test1 %1

执行 run.bat 440101

0 0