iabtis 测试通过的例子
修改了一个网上的示例,测试通过!
所需jar包:mysql-connector-java-5.0.4-bin.jar ;ibatis-2.3.0.677.jar
SqlMapConfig.xml文件
<?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 cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" errorTracingEnabled="true" maxRequests="32"
maxSessions="10" maxTransactions="5" useStatementNamespaces="false" />
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="com.mysql.jdbc.Driver" />
<property name="JDBC.ConnectionURL"
value="jdbc:mysql://localhost/sample" />
<property name="JDBC.Username" value="root" />
<property name="JDBC.Password" value="root" />
<property name="Pool.MaximumActiveConnections" value="10" />
<property name="Pool.MaximumIdleConnections" value="5" />
<property name="Pool.MaximumCheckoutTime" value="120000" />
<property name="Pool.TimeToWait" value="500" />
<property name="Pool.PingQuery"
value="select 1 from sample" />
<property name="Pool.PingEnabled" value="false" />
<property name="Pool.PingConnectionsOlderThan" value="1" />
<property name="Pool.PingConnectionsNotUsedFor" value="1" />
</dataSource>
</transactionManager>
<sqlMap resource="com/ctgusec/zhupan/model/User.xml" />
</sqlMapConfig>
==============================================
我用的是mysql数据库
建表语句:
DROP TABLE IF EXISTS `sample`.`t_user`;
CREATE TABLE `sample`.`t_user` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`sex` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
==============================================
实体
package com.model;
import java.io.Serializable;
@SuppressWarnings("serial")
public class User implements Serializable {
private Integer id;
private String name;
private String sex;
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 getSex() {
return this.sex;
}
public void setSex(String sex) {
this.sex = sex;
}
}
==============================================
实体对应的mxl文件
<?xml version = "1.0" encoding = "UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
<typeAlias alias="user" type="com.ctgusec.zhupan.model.User" />
<select id="getUser" parameterresultparameterparameterparameter+ tem);
user.setSex("女");
try {
sqlMap.startTransaction();
sqlMap.insert("insertUser", user);
sqlMap.commitTransaction();
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
try {
sqlMap.endTransaction();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
update();
// deleteUser();
// insertUser();
List user = getAllUser();
for (int i = 0; i < user.size(); i++)
{
System.out.println(i + " :: " + ((User) user.get(i)).getName()
+ "=======" + ((User) user.get(i)).getSex());
}
}
}
==============================================