Spring: Conquer Database (iii)

Source: Internet
Author: User

In the previous article we briefly explained the integration of spring and mybatis, but it is not difficult to find that it is cumbersome to configure. The most obvious point is that we need to write a long SQL Note on our custom mapper interface and register it manually with the spring container. This paper mainly explains the simplified method.

First, the interface is defined, but you don't see any traces of the frame,

Package Org.chen.mybatis.mapper;import Org.chen.domain.spitter;public interface Spittermapper {spitter GetSpitter ( String email);}

If you are using MAVEN, in the Resource folder Resouces, build and org.chen.mybatis.mapper the same directory structure,

The name of the file Spittermapper must be the same as the interface above. The contents of Spittermapper are as follows:

<?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= "Org.chen.mybatis.mapper.SpitterMapper" >  <select id= "Getspitter" resulttype= " Org.chen.domain.Spitter ">    select * from  spitter where email = #{email}  </select></mapper>

The ID and interface correspond to the same name of the method name, Resulttype is the return class name. (You might think it's a hassle to write such a long name, it's really, it's a simplified method)

Next in the spring configuration file,

    <bean class= "Org.mybatis.spring.mapper.MapperScannerConfigurer" >        <property name= "Basepackage" value= "Org.chen.mybatis.mapper"/>     </bean>

The function of this bean is the same as automatic detection, which is to automatically register the mapper under the basepackage specified in the package as MyBatis.

To simplify the writing of the Resulttype above,

  <bean id= "Sqlsessionfactory" class= "Org.mybatis.spring.SqlSessionFactoryBean" >        <property name= " DataSource "ref=" DataSource "/>         <property name=" typealiasespackage "value=" Org.chen.domain "/>  </bean>

Add a typealiasespackage, that is, the name of the package alias, so directly write resulttype= "Spitter" is OK.

Finally we inject mapper into the service,

@Servicepublic class Testservice {@Autowiredprivate spittermapper spittermapper;public void Setspittermapper ( Spittermapper spittermapper) {this.spittermapper = Spittermapper;}

Spring: Conquer Database (iii)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.