今天我实践了下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>
数据库链接文件
好了大家开始吧