配置文件:
sqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<settings cacheModelsEnabled="true"
enhancementEnabled="true"
lazyLoadingEnabled="true"
maxRequests="32"
maxSessions="10"
maxTransactions="5"
useStatementNamespaces="true"
/>
<!-- Configure a built-in transaction manager. If you're using an
app server, you probably want to use its transaction manager
and a managed datasource -->
<transactionManager type="JDBC" commitRequired="false">
<dataSource type="proxool.ProxoolDataSourceFactory">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="driverUrl" value="jdbc:mysql://localhost:3306/test"/>
<property name="user" value="root"/>
<property name="password" value="root"/>
<property name="alias" value="default"/>
<property name="maximum-connection-count" value="40"/>
<property name="overload-without-refusal-lifetime" value="60"/>
<property name="house-keeping-test-sql" value="select 1"/>
</dataSource>
</transactionManager>
<sqlMap resource="proxool/User.xml"/>
</sqlMapConfig>
User.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="user">
<!-- 返回结果集 -->
<parameterMap id="ParameterMap" class="map">
<parameter property="userNo" jdbcType="INTEGER" javaType="java.lang.Integer" mode="IN"/>
</parameterMap>
<procedure id="call_SearchUser" parameterMap="ParameterMap" resultClass="proxool.User">
{call selectuser(?)}
</procedure>
</sqlMap>
数据库脚本:
create procedure selectuser(in userno int)
begin
select * from user where uid = userno;
end
pojo类:
package proxool;
public class User {
private String uid;
private String usercd;
private String password;
private String addymd;
public String getAddymd() {
return addymd;
}
public void setAddymd(String addymd) {
this.addymd = addymd;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getUid() {
return uid;
}
public void setUid(String uid) {
this.uid = uid;
}
public String getUsercd() {
return usercd;
}
public void setUsercd(String usercd) {
this.usercd = usercd;
}
}
测试代码:
List list = null;
String resource = "proxool/sqlMapConfig.xml";
Reader reader;
SqlMapClient sqlMap = null;
try {
reader = Resources.getResourceAsReader(resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
sqlMap.startTransaction();
HashMap<String, Object> map = new HashMap<String, Object>();
map.put("userNo", 1);
list = sqlMap.queryForList("user.call_SearchUser", map);
for (int i = 0; i < list.size(); i++) {
User user = (User) list.get(i);
System.out.print(user.getUid());
System.out.print('\t');
System.out.print(user.getUsercd());
System.out.print('\t');
System.out.println(user.getPassword());
}
sqlMap.commitTransaction();
} catch (Exception e) {
e.printStackTrace();
} finally {
sqlMap.endTransaction();
}
分享到:
相关推荐
ibatis调用oracle存储过程分页
ibatis调用oracle存储过程
ibatis调用存储过程使用示例,处理带参数及无参数类型的存储过程,是一个不错的例子。
iBatis调用存储过程
用ibatis调用存储过程的介绍,使用java语言进行开发
Ibatis中调用其它的SQL语句很容易,那么如何在Ibatis中调用存储过程呢?
IBATIS调用存储过程
ibatis调用存储过程.txt [removed] var share_info = {}; [removed]
Ibatis调用Oracle存储过程,返回自定义的类型。
NULL 博文链接:https://jun1986.iteye.com/blog/1290064
NULL 博文链接:https://pzh244658240.iteye.com/blog/1423681
C#中iBatis连接mySQL使用的DLL
目前网上罕见的JSF+iBATIS+MySQL示例代码,公司某软件项目所需而做的前期DEMO,只有两个Web页面,用户登录和用户列表,但已经能够说明JSF+iBATIS的典型应用方式。 MyEclipse6.5 项目工程文件,内含SQL建库指令。 ...
ibatis调用oracle的函数,存储过程的方法,从网上收集的,还没有整理。
JSF+iBATIS+MySQL示例代码的运行war包,可部署在Tomcat6上,建库建表指令见JSF+iBATIS+MySQL示例代码包。
Spring + Ibatis 与mysql集群集成
ibatis调存储过程返回游标,资料整理
ibatis +mysql 实例 :是一个web项目 (简单的增删改查)
ibatismysql.jar ibatismysql.jar