iBATIS のバックアップ(No.1)

バックアップ一覧
差分を表示
現在との差分を表示
ソースを表示
iBATIS へ行く。
- 1 (2007-09-11 (火) 18:24:41)

http://ibatis.apache.org/tools/abator

↑

Test1.java

package main;
import dto.Xy003;
public class Test1 {
	public static void main(String args[]) throws Exception {
		SqlMapClient sqlMap = MyAppSqlConfig.getSqlMapInstance();
		/*

		 */
		Xy003 xy003 = (xy003) sqlMap.queryForObject("getXy003",
				"admin001");


		/*

		 */
		List<Xy003> xy003List = (List<Xy003>) sqlMap
				.queryForList("allXy003");
		for (Xy003 d : xy003List) {

		}

		/*

		 */
		List<Map> list = (List<Map>) sqlMap.queryForList("allXy003Map");
		for (Map d : list) {

		}

		/*

		 */
		List<Map> list1 = (List<Map>) sqlMap.queryForList("getXy003Where",
				" AND UNAME='admin001'");
		for (Map d : list1) {

		}
	}
}

MyAppSqlConfig?.java

package main;

/**

 */
public class MyAppSqlConfig {
	private static SqlMapClient sqlMap;
	static {
		try {
			String resource = "SqlMapConfig.xml";
			Reader reader = Resources.getResourceAsReader(resource);
			sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public static SqlMapClient getSqlMapInstance(){

		return sqlMap;
	}
}

Xy003.java

package dto;

public class Xy003 {
   private String uname;
   private String nokokyaku;

   public String getUname() {
       return uname;
   }
   public void setUname(String uname) {
       this.uname = uname;
   }

   public String getNokokyaku() {
       return nokokyaku;
   }
   public void setNokokyaku(String nokokyaku) {
       this.nokokyaku = nokokyaku;
   }
}

SqlMapConfig?.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig      
   PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      
   "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>

	<transactionManager type="JDBC">
		<dataSource type="SIMPLE">
			<property name="JDBC.Driver" value="org.gjt.mm.mysql.Driver"/>
			<property name="JDBC.ConnectionURL" value="jdbc:mysql://192.168.1.1:3306/hoge"/>
			<property name="JDBC.Username" value="hogeuser"/>
			<property name="JDBC.Password" value="hogepass"/>
		</dataSource>
	</transactionManager>
	
	<sqlMap resource="dao/xy003_SqlMap.xml"/>
</sqlMapConfig>

xy003_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>

	<select id="getXy003" resultClass="dto.Xy003">
		SELECT UNAME, NOKOKYAKU FROM xy003
		WHERE UNAME = #value#
	</select>

	<select id="getXy003Where" resultClass="java.util.HashMap">
		SELECT UNAME, NOKOKYAKU FROM xy003
		WHERE 1 = 1 $value$
	</select>	

	<select id="allXy003" resultClass="dto.Xy003">
		SELECT UNAME, NOKOKYAKU FROM xy003
		ORDER BY UNAME
	</select>

	<select id="allXy003Map" resultClass="java.util.HashMap">
		SELECT UNAME, NOKOKYAKU FROM xy003
		ORDER BY UNAME
	</select>	
		
</sqlMap>

↑

PaginatedList?

public java.util.List queryForList(java.lang.String id,
                                  java.lang.Object parameterObject,
                                  int skip,
                                  int max)
skip - The number of results to ignore.
max - The maximum number of results to return.

↑

#comment