ibatis2+spring入门

lihaibingqq789

浏览: 19892 次
性别:
来自: 深圳

最近访客更多访客>>

liveand

smail-luo

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

框架

Spring iBATIS Bean MySQL AOP

第一步：新建一个web项目

第二步：引入主要jar包

spring.jar,ibatis-2.3.4.jar,mysql-connector-java-5.1.5-bin.jar,c3p0-0.9.1.1.jar,ant.jar,commons-logging.jar等。

第三步：在web.xml文件中添加

<listener>
  <listener-class>
   org.springframework.web.context.ContextLoaderListener
  </listener-class>
</listener>

第四步：新建data-source.xml，内容如下：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans classpath:spring-beans-2.5.xsd">

第五步：新增applicationContext.xml 内容如下

<bean id="sqlMapClient"
  class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="configLocation"
   value="classpath:sqlMapConfig.xml" />
  <property name="dataSource" ref="dataSource" />
</bean>

第六步：新增帮助类 springService.java

package com.common;

import javax.servlet.ServletContext;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.springframework.web.context.WebApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;

/**
* spring 帮助类
* @author barsk.li
*
*/
public class SpringService {

private static ServletContext servletContext;
private static WebApplicationContext webApplictionContext;

public static Object getBean(String name){
return webApplictionContext.getBean(name);
}

public static ServletContext getServletContext() {
return servletContext;
}

public static void setServletContext(ServletContext servletContext) {
SpringService.servletContext = servletContext;
SpringService.webApplictionContext = WebApplicationContextUtils.getWebApplicationContext(servletContext);
}

public static ApplicationContext getApplicationContext() {
ApplicationContext ctx = new FileSystemXmlApplicationContext("/WebRoot/WEB-INF/applicationContext.xml");
return ctx;
}

}

第七步：其他类

1. GuildPlayer.java

/** 公会玩家编号 */
private Integer guildPlayerID;
/** 玩家编号 */
private Integer playerID;
/** 公会编号 */
private Integer guildID;
/** 公会职务 */
private Integer position;
/** 创建时间 */
private Date createTime;

2.IGuildPlayerDAO

package com.ibatis.two;

public interface IGuildPlayerDAO {

public void createGuildPlayer(GuildPlayer guildPlayer);
}

3.GuildPlayerDAO.java

package com.ibatis.two;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

public class GuildPlayerDAO extends SqlMapClientDaoSupport implements IGuildPlayerDAO{

public void createGuildPlayer(GuildPlayer guildPlayer) {

getSqlMapClientTemplate().insert("GuildPlayer.createGuildPlayer",guildPlayer);
}

}
4. GuildPlayer.xml

<?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">

<insert id="createGuildPlayer" parameterClass="GuildPlayer">
  insert into
  t_guild_player(guild_id,player_id,position,create_time)
  values(#guildID#,#playerID#,#position#,sysdate())
</insert>

</sqlMap>

好了，基本上差不多了。写个测试类测试下

GuildPlayerDAOTest.java

package com.ibatis.two;

import org.junit.BeforeClass;
import org.junit.Test;

import com.common.SpringService;

public class GuildPlayerDAOTest {

private static IGuildPlayerDAO guildPlayerDAO ;

@BeforeClass
public static void setUpBeforClass() {
  guildPlayerDAO = (IGuildPlayerDAO) SpringService.getApplicationContext().getBean("guildPlayerDAO");
}

@Test
public void test() {

  GuildPlayer guildPlayer = new GuildPlayer();

  guildPlayer.setGuildID(44);
  guildPlayer.setPlayerID(33);
  guildPlayer.setPosition(2);

  guildPlayerDAO.createGuildPlayer(guildPlayer);
}
}

好了，如果配置没什么问题的话，应该是OK的。下面我们来看下mybaits-3.0的使用。

需要mybatis-3.0.1.jar

sql文件配置区别

GuildPlayer.xml 如下：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<insert id="createGuildPlayer" parameterType="GuildPlayer">
  insert into
  t_guild_player(guild_id,player_id,position,create_time)
  values(#{guildID},#{playerID},#{position},sysdate())
</insert>
</mapper>

分享到：