DB2+MyBatis+spring整合例子

IUserOperation.java

package com.yihaomen.mybatis.inter;

import java.util.List;

import com.yihaomen.mybatis.model.*;

public interface IUserOperation {

	public User selectUserByID(int id);

	public List<User> selectUsers(String userName);

	public void addUser(User user);

	public void updateUser(User user);

	public void deleteUser(int id);

	public List<Article> getUserArticles(int id);

}

Article.java

package com.yihaomen.mybatis.model;

public class Article {

	private int id;
	private User user;
	private String title;
	private String content;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public User getUser() {
		return user;
	}

	public void setUser(User user) {
		this.user = user;
	}

	public String getTitle() {
		return title;
	}

	public void setTitle(String title) {
		this.title = title;
	}

	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}

}

User.java

package com.yihaomen.mybatis.model;

public class User {

	private int id;
	private String userName;
	private int userAge;
	private String userAddress;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	public int getUserAge() {
		return userAge;
	}

	public void setUserAge(int userAge) {
		this.userAge = userAge;
	}

	public String getUserAddress() {
		return userAddress;
	}

	public void setUserAddress(String userAddress) {
		this.userAddress = userAddress;
	}

}

User.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">

<mapper namespace="com.yihaomen.mybatis.inter.IUserOperation">
	<select id="selectUserByID" parameterType="int" resultType="User">
		select * from user where id = #{id}
    </select>

	<!-- 返回list 的select 语句，注意 resultMap 的值是指向前面定义好的 -->
	<select id="selectUsers" parameterType="string" resultMap="resultListUser">
		select * from user where userName like #{userName}
    </select>

	<!--
		执行增加操作的SQL语句。id和parameterType 分别与IUserOperation接口中的addUser方法的名字和 参数类型一致。以#{name}的形式引用Student参数 的name属性，MyBatis将使用反射读取Student参数
		的此属性。#{name}中name大小写敏感。引用其他 的gender等属性与此一致。seGeneratedKeys设置 为"true"表明要MyBatis获取由数据库自动生成的主 键；keyProperty="id"指定把获取到的主键值注入
		到Student的id属性
	-->
	<insert id="addUser" parameterType="User">
		insert into
		user(id,userName,userAge,userAddress)
		values(#{id},#{userName},#{userAge},#{userAddress})  
    </insert>

	<update id="updateUser" parameterType="User">
		update user set userName=#{userName},userAge=#{userAge},userAddress=#{userAddress}
		where id=#{id}
    </update>

	<delete id="deleteUser" parameterType="int">
		delete from user where id=#{id}
    </delete>

	<select id="getUserArticles" parameterType="int" resultMap="resultUserArticleList">
		select user.id,user.userName,user.userAddress,article.id
		aid,article.title,article.content from user,article
		where user.id=article.userid and user.id=#{id}
    </select>

	<!-- User 联合文章进行查询 方法之一的配置 (多对一的方式)  -->
	<resultMap id="resultUserArticleList" type="Article">
		<id property="id" column="aid" />
		<result property="title" column="title" />
		<result property="content" column="content" />

		<association property="user" javaType="User">
			<id property="id" column="id" />
			<result property="userName" column="userName" />
			<result property="userAddress" column="userAddress" />
		</association>
	</resultMap>

	<!-- User 联合文章进行查询 方法之二的配置 (多对一的方式) -->
	<resultMap id="resultUserArticleList-2" type="Article">
		<id property="id" column="aid" />
		<result property="title" column="title" />
		<result property="content" column="content" />
		<association property="user" javaType="User" resultMap="resultListUser" />
	</resultMap>

	<!-- 为了返回list 类型而定义的returnMap -->
	<resultMap id="resultListUser" type="User">
		<id column="id" property="id" />
		<result column="userName" property="userName" />
		<result column="userAge" property="userAge" />
		<result column="userAddress" property="userAddress" />
	</resultMap>
</mapper>

applicationContext.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" xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="  
            http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd  
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd  
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd  
            http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd  
            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd"
	default-autowire="byName" default-lazy-init="false">

	<!--本示例采用DBCP连接池，应预先把DBCP的jar包复制到工程的lib目录下。 -->

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.ibm.db2.jcc.DB2Driver" />
		<property name="url" value="jdbc:db2://localhost:50000/TEST" />
		<property name="username" value="administrator" />
		<property name="password" value="wzs_626750095" />
	</bean>

	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!--dataSource属性指定要用到的连接池-->
		<property name="dataSource" ref="dataSource" />
		<!--configLocation属性指定mybatis的核心配置文件-->
		<property name="configLocation" value="config/Configuration.xml" />
	</bean>

	<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		<!--sqlSessionFactory属性指定要用到的SqlSessionFactory实例-->
		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
		<!--mapperInterface属性指定映射器接口，用于实现此接口并生成映射器对象-->
		<property name="mapperInterface" value="com.yihaomen.mybatis.inter.IUserOperation" />
	</bean>

</beans> 

Configuration.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases> 
        <typeAlias alias="User" type="com.yihaomen.mybatis.model.User"/> 
        <typeAlias alias="Article" type="com.yihaomen.mybatis.model.Article"/> 
    </typeAliases> 
    <!-- 与spring 集成之后,这些可以完全删除,数据库连接的管理交给 spring 去管理 -->
    <!-- 
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="com.ibm.db2.jcc.DB2Driver" />
				<property name="url" value="jdbc:db2://localhost:50000/TEST" />
				<property name="username" value="administrator" />
				<property name="password" value="wzs_626750095" />
			</dataSource>
		</environment>
	</environments>
	-->
	 
	<mappers>
	    <mapper resource="com/yihaomen/mybatis/model/User.xml"/>
	</mappers>
</configuration>

MybatisSprintTest.java

package com.yihaomen.test;

import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.yihaomen.mybatis.inter.IUserOperation;
import com.yihaomen.mybatis.model.Article;
import com.yihaomen.mybatis.model.User;

public class MybatisSprintTest {

	private static ApplicationContext ctx;

	static {
		ctx = new ClassPathXmlApplicationContext("config/applicationContext.xml");
	}

	public static void main(String[] args) {
		IUserOperation mapper = (IUserOperation) ctx.getBean("userMapper");
		// 测试id=1的用户查询，根据数据库中的情况，可以改成你自己的.
		System.out.println("得到用户id=1的用户信息");
		User user = mapper.selectUserByID(1);
		System.out.println(user.getUserAddress());

		// 得到文章列表测试
		System.out.println("得到用户id为1的所有文章列表");
		List<Article> articles = mapper.getUserArticles(1);

		for (Article article : articles) {
			System.out.println(article.getContent() + "--" + article.getTitle());
		}

	}

}

jar包下载地址： http://download.csdn.net/detail/adam_zs/6516255

例子参考：http://www.yihaomen.com/article/java/302.htm