这个例子是我在
http://www.developersbook.com/ibatis/iBatis-tutorials/iBatis-tutorials-2.php看的一个很好例子。
DROP TABLE IF EXISTS `test`.`trade`;
CREATE TABLE `trade` (
`trade_id` decimal(5,0) NOT NULL,
`side` varchar(10) NOT NULL,
`symbol` varchar(6) NOT NULL,
`shares` decimal(4,0) NOT NULL,
`price` decimal(4,0) NOT NULL,
`state` varchar(20) NOT NULL,
PRIMARY KEY (`trade_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
Trade.java
package com.developerbook.iBatis.domain;
public class Trade {
private long tradeId;
private String action;
private String symbol;
private long shares;
private double price;
private String state;
public long getTradeId() {
return tradeId;
}
public void setTradeId(long tradeId) {
this.tradeId = tradeId;
}
public String getAction() {
return action;
}
public void setAction(String action) {
this.action = action;
}
public String getSymbol() {
return symbol;
}
public void setSymbol(String symbol) {
this.symbol = symbol;
}
public long getShares() {
return shares;
}
public void setShares(long shares) {
this.shares = shares;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
public String toString() {
return ("TRADE " + tradeId + ": " + action + ", " + symbol + ", "
+ shares + " shares, $" + price + "/share (" + state + ")");
}
}
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName"
value="com.mysql.jdbc.Driver"/>
<property name="url"
value="jdbc:mysql://localhost:3306/test"/>
<property name="username"
value="root"/>
<property name="password"
value="billsxm"/>
</bean>
<bean id="sqlMap"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation">
<value>classpath:config/SqlMapConfig.xml</value>
</property>
<property name="dataSource" ref="dataSource"/>
</bean>
<bean id="tradingService"
class="com.developerbook.iBatis.service.TradeServiceImpl">
<property name="sqlMapClient" ref="sqlMap"/>
</bean>
</beans>
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 useStatementNamespaces="true"/>
<sqlMap resource="config/TradingSQLMap.xml"/>
</sqlMapConfig>
TradingSQLMap.xml
<?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="trading">
<typeAlias alias="trade" type="com.developerbook.iBatis.domain.Trade"/>
<cacheModel id="tradeCache" type="LRU" readOnly="true">
<flushInterval hours="24"/>
<flushOnExecute statement="trading.executeTrade"/>
<property name="cache-size" value="1000"/>
</cacheModel>
<resultMap id="tradeResult" class="trade">
<result property="tradeId" column="TRADE_ID"/>
<result property="action" column="SIDE"/>
<result property="symbol" column="SYMBOL"/>
<result property="shares" column="SHARES"/>
<result property="price" column="PRICE"/>
<result property="state" column="STATE"/>
</resultMap>
<select id="getTrade" parameterClass="long" resultMap="tradeResult" cacheModel="tradeCache">
SELECT
TRADE_ID,
SIDE,
SYMBOL,
SHARES,
PRICE,
STATE
FROM
TRADE
WHERE
TRADE_ID = #id#
</select>
<update id="executeTrade" parameterClass="long">
UPDATE
TRADE
SET
STATE = 'EXECUTED'
WHERE
TRADE_ID = #id#
</update>
<insert id="insertTrade" parameterClass="trade">
INSERT INTO
TRADE
(TRADE_ID,
SIDE,
SYMBOL,
SHARES,
PRICE,
STATE)
VALUES
(#tradeId#,
#action#,
#symbol#,
#shares#,
#price#,
#state#)
</insert>
</sqlMap>
ITrade.java
package com.developerbook.iBatis.service;
import java.sql.SQLException;
import com.developerbook.iBatis.domain.Trade;
public interface ITradeService {
public Trade getTrade(long tradeId)throws SQLException;
public void executeTrade(long tradeId)throws SQLException;
public void insertTrade(Trade trade)throws SQLException;
}
TradeServiceImpl.java
package com.developerbook.iBatis.service;
import java.sql.SQLException;
import com.developerbook.iBatis.domain.Trade;
import com.ibatis.sqlmap.client.SqlMapClient;
public class TradeServiceImpl implements ITradeService {
protected SqlMapClient sqlMap = null;
public void setSqlMapClient(SqlMapClient sqlMap){
this.sqlMap = sqlMap;
}
public void executeTrade(long tradeId) throws SQLException {
sqlMap.update("trading.executeTrade", tradeId);
}
public Trade getTrade(long tradeId) throws SQLException {
return (Trade)sqlMap.queryForObject("trading.getTrade", tradeId);
}
public void insertTrade(Trade trade) throws SQLException {
sqlMap.insert("trading.insertTrade", trade);
}
}
IBatisClient.java
package com.developerbook.iBatis.client;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.developerbook.iBatis.service.ITradeService;
public class IBatisClient {
/**
* @param args
*/
public static void main(String[] args) {
try{
System.out.println("Start IBatisClient...");
System.out.println("=====================");
//load spring beans
ApplicationContext ctx = new ClassPathXmlApplicationContext(
"config/applicationContext.xml");
System.out.println("Classpath loaded...");
System.out.println("====================");
ITradeService service = (ITradeService) ctx.getBean("tradingService");
//get Trade
int tradeId=1;
System.out.println("BEFORE: "+service.getTrade(tradeId));
//update Trade
service.executeTrade(tradeId);
System.out.println("AFTER: "+service.getTrade(tradeId));
System.out.println("=====================");
System.out.println("Hurry , It is done.!");
}catch(Exception ex){
ex.printStackTrace();
}
}
}
分享到:
相关推荐
NULL 博文链接:https://yunshen0909.iteye.com/blog/833865
NULL 博文链接:https://yunshen0909.iteye.com/blog/839770
ibatis与spring 框架整合
简单易入手,使用mysql数据库进行数据管理
iBatis和Spring整合 iBatis和Spring整合
内容包里面是源代码,运行该例子的方式就是,使用里面的sql...使用cmd进入该解压包,运行 java -jar *.jar ibatis2spring.jar 就可以了。欲了解代码的详细,请访问作者博客,搜索《ibatis + Spring 多表查询》文章。
是将struts2+spring3+iBATIS进行整合。
整合了ibatis和spring 采用了数据源的配置 ibatis有详细的解释
ibatis与spring的整合,文档doc格式,学习可用
最近想在最新的Spring5.0中集成ibatis(不是mybatis),发现已经不在支持SqlmapClientTemplate和SqlmapClientFactoryBean,于是搞了这个工具jar来进行支持如下配置 <bean id="sqlMapClient" class="org.spring...
使用ibatis+spring+struts2 做的开发例子 帮助大家一起学习ibatis的整合
backbone+bootstrap+ibatis+spring例子
简单整合了struts1+ibatis+Spring demo
ibatis与spring整合,内附文档
NULL 博文链接:https://wcp88888888.iteye.com/blog/1328481
ibatis+Spring+struts2整合实例
spring ibatis 配置spring ibatis 配置spring ibatis 配置spring ibatis 配置
Struts2-Ibatis+spring.rar Struts2-Ibatis+spring.rar Struts2-Ibatis+spring.rar Struts2-Ibatis+spring.rar Struts2-Ibatis+spring.rar
Spring与iBATIS的集成 iBATIS似乎已远离众说纷纭的OR框架之列,通常人们对非常流行的Hibernate情有独钟。但正如Spring A Developer's Notebook作者Bruce Tate 和Justin Gehtland所说的那样,与其他的OR框架相比...
一个iBatis与Spring整合的例子一个iBatis与Spring整合的例子一个iBatis与Spring整合的例子