spring ibatis一个简单sample_springboot ibatis sample-优快云博客

本文介绍了一个使用Spring框架整合iBatis的示例应用，包括配置文件、数据访问对象及测试代码。通过示例展示了如何配置数据源、设置iBatis映射文件，并实现基本的数据查询操作。

spring配置文件

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

	<context:component-scan base-package="com"/>
	<!-- 数据 -->
	<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
		<property name="url" value="jdbc:mysql://localhost:3306/lpWeb"/>
		<property name="username" value="root"/>
		<property name="password" value="root123"/>
	</bean>
	
	<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
		<property name="configLocation" value="classpath:/sql-map-config.xml"/>
		<property name="dataSource" ref="dataSource"/>
	</bean>
	
	 <bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate">    
        <property name="sqlMapClient" ref="sqlMapClient"/>   
    </bean>
  
	 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"/>
	</bean> 
</beans>

映射文件sql-map-config.xml

连接java和数据库代码的纽带

<?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="320" maxSessions="100"
		maxTransactions="100" useStatementNamespaces="true" />
	<sqlMap resource="file.xml"/>
</sqlMapConfig>

file.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">
<sqlMap namespace="com.entity">
	 <resultMap id="file" class="com.entity.File">
		<result property="fileId" column="fileID" />
		<result property="title" column="title" />
		<result property="brief" column="brief" />
		<result property="content" column="content" />
		<result property="url" column="url" />
	</resultMap>
	
	<select id="selectfile" resultMap="file">
			select * from files
	</select>
	
	<select id="selectfilebyid" resultMap="file" parameterClass="java.lang.String">
	  <![CDATA[
		select * from files where fileID = #fileId#
			]]>
	</select>
	
	<select id="selectfilebytitle" resultMap="file" parameterClass="java.lang.String">
	  <![CDATA[
		select * from files where title like  #title#		
			]]>
	</select>
	
	<select id="selectbymap" resultMap="file" parameterClass="java.util.HashMap">
		select * from files where 1=1
		<isNotEmpty prepend="and" property="fileId">
			fileID = #fileId#
		</isNotEmpty>
		<isNotEmpty prepend="and" property="title">
			fileID like '%' || #title# || '%'
		</isNotEmpty>
	</select>
	
	<select id="selectCount" parameterClass="com.entity.File" resultClass="int">
		select count(*) from files where 1=1
		<isNotEmpty prepend="and" property="fileId">
			fileID = #fileId#
		</isNotEmpty>
	</select>
	
</sqlMap>

Dao

package com.file.dao;

import java.util.List;
import java.util.Map;

import com.entity.File;

public interface FileDao {

	List queryFiles();
	
	File queryFileById(String fileId);

	File queryFileByMap(Map map);

	File queryFileByTitle(String title);

	int queryFilesCount(File files);
}

package com.file.dao;

import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.ibatis.SqlMapClientTemplate;
import org.springframework.stereotype.Repository;

import com.entity.File;

@Repository
public class FileDaoImpl implements FileDao {

	@Autowired
	SqlMapClientTemplate sqlMapClient;
	
	@Override
	public List<File> queryFiles() {
		// TODO Auto-generated method stub
		return 	sqlMapClient.queryForList("com.entity.selectfiles");
	}

	@Override
	public File queryFileById(String fileId) {
		// TODO Auto-generated method stub
		return (File) sqlMapClient.queryForObject("com.entity.selectfilebyid", fileId);
	}

	@Override
	public File queryFileByTitle(String title) {
		// TODO Auto-generated method stub
		return (File) sqlMapClient.queryForObject("com.entity.selectfilebytitle", title);
	}

	
	@Override
	public File queryFileByMap(Map  map) {
		// TODO Auto-generated method stub
		return (File) sqlMapClient.queryForObject("com.entity.selectbymap", map);
	}

	@Override
	public int queryFilesCount(File files) {
		// TODO Auto-generated method stub
		return (Integer) sqlMapClient.queryForObject("com.entity.selectCount", files);
	}

}

Test

package com.file.dao;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.entity.File;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:/spring-ibatis.xml" })
public class TestFileDao {

	@Autowired
	FileDao fileDao;

	//
	// @Test
	// public void testFiles(){
	// try{
	// List<File> files = fileDao.queryFiles();
	//
	// System.out.println(files);
	// }catch(Exception e){
	// e.printStackTrace();
	// }
	// }
	//
//	@Test
//	public void testFile() {
//		try {
//			File file = fileDao.queryFileById("1");
//
//			System.out.println(file);
//		} catch (Exception e) {
//			e.printStackTrace();
//		}
//	}

//	@Test
//	public void testFileTitle() {
//		try {
//			File file = fileDao.queryFileByTitle("罗盘科技电视购物解决方案");
//
//			System.out.println(file);
//		} catch (Exception e) {
//			e.printStackTrace();
//		}
//	}
	
	@Test
	public void testFilesCount() {
		try {
			File files = new File();
			files.setFileId("1");
			int count = fileDao.queryFilesCount(files);

			System.out.println(count);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	
}