Myibatis3与ibatis3应该没有较大的改动吧,之前听说Myibatis3不再需要实现DAO接口中的方法,Service层直接调用接口中的方法就OK了,今天整一Demo.
Demo的组织结构图如下:
sql映射文件(BlogMapper.xml):
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN" "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd"> <!-- 这里的命名空间,应该为BlogMapper的全限定名,不然会找不到的 --> <mapper namespace="cn.enjoylife.persistence.BlogMapper"> <select id="selectBlog" parameterType="int" resultType="Blog" > select id,title,content from Blog where id = #{id} </select> <insert id="insertBlog" parameterType="Blog" > insert into Blog(id,title,content) values(#{id},#{title},#{content}) </insert> <update id="updateBlog" parameterType="Blog"> update Blog set title=#{title},content=#{content} where id=#{id} </update> <delete id="deleteBlog" parameterType="int"> delete from Blog where id=#{id} </delete> </mapper>
DAO接口(BlogMapper.java):
/** * * Blog DAO接口,猜想方法名称对应到BlogMapper.xml中sql id; * @author Evan * */ public interface BlogMapper { public Blog selectBlog(Integer id); public void insertBlog(Blog blog); public void updateBlog(Blog blog); public void deleteBlog(Integer id); }
Service实现(BlogService.java):
/** * Blog的service实现类 * @author Evan */ @Service @Transactional public class BlogService { @Autowired private BlogMapper blogMapper; public Blog selectBlog(Integer id) { Blog blog=blogMapper.selectBlog(id); return blog; } public void insertBlog(Blog blog){ blogMapper.insertBlog(blog); } public void updateBlog(Blog blog){ blogMapper.updateBlog(blog); } public void deleteBlog(Integer id){ blogMapper.deleteBlog(id); } }
总的配置文件(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:jdbc="http://www.springframework.org/schema/jdbc" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation=" http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-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/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd"> <!-- 使用最简单的jdbc数据源 --> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName"> <value>oracle.jdbc.driver.OracleDriver</value> </property> <property name="url"> <value>jdbc:oracle:thin:@localhost:1521:orcl</value> </property> <property name="username"> <value>scott</value> </property> <property name="password"> <value>tiger</value> </property> </bean> <!-- 声明事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <!-- 扫描service实现 --> <context:component-scan base-package="cn.enjoylife.service" /> <!-- 启用自动装配 --> <context:annotation-config /> <!-- 启用基于注解的事务 --> <tx:annotation-driven /> <!-- 创建 SqlSessionFactory --> <!-- 数据源--> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="typeAliasesPackage" value="cn.enjoylife.domain" /> </bean> <!-- 扫描mappers并让他们自动装配 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="cn.enjoylife.persistence" /> </bean> </beans>
测试代码:
public class BlogServiceTest { private static BlogService blogService; @BeforeClass public static void setUpBeforeClass() throws Exception { ClassPathXmlApplicationContext ctx=new ClassPathXmlApplicationContext("applicationContext.xml"); blogService=(BlogService)ctx.getBean("blogService"); System.out.println(blogService); } @Test public void testInsertBlog() { Blog blog=new Blog(); blog.setId(100); blog.setTitle("today"); blog.setContent("今天雨下的好大!"); blogService.insertBlog(blog); } @Test public void testSelectBlog() { Blog blog=blogService.selectBlog(100); System.out.println(blog); } @Test public void testUpdateBlog() { Blog blog=new Blog(); blog.setId(100); blog.setTitle("tomorrow"); blog.setContent("是否还要接着下呢?!"); blogService.updateBlog(blog); System.out.println(blogService.selectBlog(100)); } @Test public void testDeleteBlog() { blogService.deleteBlog(100); } }