ibatis开发入门

初学ibatis，记录一下搭建步骤。。

先在数据库创建Contact表，字段分别是id,firstname,lastname,email。然后添加数据。在myeclipse新建一个java Project，然后导入相应jar包，我使用的是ibatis-2.3.4.726.jar和ojdbc6.jar。导入后build path。然后创建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>
	<settings useStatementNamespaces="true"/>
	<transactionManager type="JDBC">
		<dataSource type="SIMPLE">
			<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
			<property name="JDBC.ConnectionURL" 
				value="jdbc:oracle:thin:@localhost:1521"/>
			<property name="JDBC.Username" value="root"/>
			<property name="JDBC.Password" value="root"/>
		</dataSource>
	</transactionManager>
	<sqlMap resource="Contact.xml"/>
</sqlMapConfig>

然后创建Contact.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="Contact">
<select id="getAll" resultClass="test.action.Contact">
	select * from contact
</select>
</sqlMap> 

接着创建Contact.java。

package test.action;

public class Contact {
	private String firstName;
	private String lastName;
	private String email;
	private int id;
	
	public Contact() {
		
	}
	
	public Contact(String firstName, String lastName, String email) {
		this.firstName = firstName;
		this.lastName = lastName;
		this.email = email;
	}

	public String getFirstName() {
		return firstName;
	}

	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}

	public String getLastName() {
		return lastName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public int getId() {
		return id;
	}

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

然后是测试Demo：

package test.action;

import java.io.*;
import java.sql.SQLException;
import java.util.*;

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

public class IbatisExample {
	public static void main(String[] args) 
			throws IOException,SQLException{
		Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
		SqlMapClient sqlMap = 
		SqlMapClientBuilder.buildSqlMapClient(reader);
		//Output all contacts
		System.out.println("All Contacts");
		List<Contact> contacts = (List<Contact>)
			sqlMap.queryForList("Contact.getAll",null);
			Contact contact = null;
		for(Contact c:contacts) {
			System.out.print(" " + c.getId());
			System.out.print(" " + c.getFirstName());
			System.out.print(" " + c.getLastName());
			System.out.print(" " + c.getEmail());
				contact = c;
			System.out.println(" ");
		}
	}
}

到此一个完整的java项目完成。下面是测试结果：