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 sqlMapPUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN""http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap><select id="getPerson" resultname="code"><?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>

?数据库链接文件

?

?

?

好了大家开始吧

?