好几年没用ssh框架了,最近忽然想回味一下,搞了个IBATIS环境。
希望对初学者配置方面有所帮助。
1 系统环境 java5 ,myeclipse6.5 mysql5
2 类包:ibatis-2.3.4.726.jar,mysql-connector-java-5.1.6-bin.jar
当然,首先是在mysql中建立数据库表,我这里数据库是test
用户名是root ,没有设置密码,建立数据库表t_user(id,name,pass)
我建立一个简单的web project
src下建立文件sqlMapConfig.xml
内容如下:
<?xml version="1.0" encoding="UTF-8" ?>
/font>
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="32"
maxSessions="10" maxTransactions="5" useStatementNamespaces="false" />
value="jdbc:mysql://localhost/test" />
com/ibatis/sample/User.xml 如下:
<?xml version="1.0" encoding="UTF-8"?>
/font>
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
resultMap="get-user-result">
select
id,name,
pass
from t_user
]]>
resultClass="user">
select
name,
pass
from t_user
where name = #name#
]]>
UPDATE t_user
SET
name=#name#,
pass=#pass#
WHERE id = #id#
]]>
INSERT INTO t_user ( name, pass) VALUES ( #name#, #pass# )
delete from t_user where id = #value#
创建类文件:
package com.ibatis.sample;
import java.io.Serializable;
import java.util.HashSet;
import java.util.Set;
public class User implements Serializable{
private Integer id;
private String name;
private String pass;
public User() {
}
public Integer getId() {
return this.id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return this.name;
}
public void setName(String name) {
this.name = name;
}
public String getPass() {
return this.pass;
}
public void setSex(String pass) {
this.pass = pass;
}
}
随便写个测试方法:
String resource = "SqlMapConfig.xml";//路径指的是src下的
Reader reader;
reader = Resources.getResourceAsReader(resource);
SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
List userList = sqlMap.queryForList("getUsers", "");
for (int i = 0; i < userList.size(); i++) {
User user = (User) userList.get(i);
System.out.println("==>" + user.getName());
}
希望对初学者配置ibatis有所帮助
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15116811/viewspace-717831/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15116811/viewspace-717831/