Ibatis入门

第一步，在数据库中建一张表：

create table USERS
(
  ID   NUMBER,
  NAME VARCHAR2(20),
  PASS VARCHAR2(20)
)

第二步，根据表建一个javabean类 如下：

package com.yj.ibatis.pojo;

public class Users {

	private int id;
	private String name;
	private String pass;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPass() {
		return pass;
	}

	public void setPass(String pass) {
		this.pass = pass;
	}

}

第三步：配置映射文件 如Users.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" 
"http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap>
	<select id="selectUsers" parameterClass="int" resultClass="com.yj.ibatis.pojo.Users">
		select 
		id as id,
		name as name,
		pass as pass
		from users
		where id=#value#

	</select>

</sqlMap>

这里只配置了一个查询方法 名字叫selectUsers 返回值类型为com.yj.ibatis.pojo.Users


第四步：Sql Map 配置文件

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


<sqlMapConfig>

	<settings cacheModelsEnabled="true" enhancementEnabled="true"
		lazyLoadingEnabled="true" maxRequests="32" maxSessions="10"
		maxTransactions="5" useStatementNamespaces="false" />

	<transactionManager type="JDBC">

		<dataSource type="SIMPLE">
			<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver" />
			<property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@127.0.0.1:1521:orcl" />
			<property name="JDBC.Username" value="scott" />
			<property name="JDBC.Password" value="jian3356945" />
		</dataSource>
	</transactionManager>

	<sqlMap resource="com/yj/ibatis/pojo/Users.xml"/>

</sqlMapConfig>

第五步：测试,

package text;


import java.io.Reader;

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


public class Text {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		try {
			String resource = "SqlMapConfig.xml";
			Reader reader=Resources.getResourceAsReader(resource);
			SqlMapClient sqlMapClient= SqlMapClientBuilder.buildSqlMapClient(reader);

			Users users = (Users) sqlMapClient.queryForObject("selectUsers",1);
			System.out.println("姓名=====》"+users.getName());
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}