iBatis简单实践

今天我实践了下ibatis框架，感觉也不错，很简单。嘻嘻，大家也尝试一下吧

 

ibatis下载地址：http://code.google.com/p/mybatis/downloads/detail?name=ibatis-2.3.4.726.zip&can=1&q=

数据库MYSQL下载地址 ：http://dev.mysql.com/downloads/

Connector 下载地址：http://dev.mysql.com/downloads/connector/

 

数据库SQL

CREATE TABLE `person` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(20) default NULL,
  `version` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;

 

package com.java.chenhailong;

import java.io.Reader;
import java.util.List;

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

public class Main {
	public static void main(String args[]) throws Exception {
        String resource = "sqlMapsConfig.xml";
        Reader reader = Resources.getResourceAsReader(resource);
        SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);

        // 検索処理
        List<Person> personList = (List<Person>) sqlMap.queryForList("getPerson");
        for(Person people : personList){
        	System.out.println("People Name:"+people.getName());
        }
    }
}

 上面是主函数

 得到PeopleList，然后进行分析。

package com.java.chenhailong;

/**
 * 
 * @author cnchenhai
 * 
 */
public class Person {

	private int id;

	private String name;

	private int version;

	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 int getVersion() {
		return version;
	}

	public void setVersion(int version) {
		this.version = version;
	}

}

 Model对象

<?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="getPerson" resultClass="com.java.chenhailong.Person">
		select * from person
	</select>
</sqlMap>

 ibatis mapping文件

 

<?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 useStatementNamespaces="true" />
    <transactionManager type="JDBC">
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver" value="com.mysql.jdbc.Driver" />
            <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost:3307/employee" />
            <property name="JDBC.Username" value="root" />
            <property name="JDBC.Password" value="24226305" />
        </dataSource>
    </transactionManager>

    <sqlMap resource="com/java/chenhailong/person_SqlMap.xml" />

</sqlMapConfig>

 数据库链接文件

 

 

 

好了大家开始吧