pom.xml增加以下依赖：pom.xml 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 <properties > ...... <jdbc.driver.groupId > postgresql</jdbc.driver.groupId > <jdbc.driver.artifactId > postgresql</jdbc.driver.artifactId > <jdbc.driver.version > 9.1-901.jdbc4</jdbc.driver.version > </properties > <dependencies > ...... <dependency > <groupId > org.springframework</groupId > <artifactId > spring-jdbc</artifactId > </dependency > <dependency > <groupId > org.apache.tomcat</groupId > <artifactId > tomcat-jdbc</artifactId > <version > ${tomcat-jdbc.version}</version > <scope > runtime</scope > </dependency > <dependency > <groupId > ${jdbc.driver.groupId}</groupId > <artifactId > ${jdbc.driver.artifactId}</artifactId > <version > ${jdbc.driver.version}</version > <scope > runtime</scope > </dependency > <dependency > <groupId > org.mybatis</groupId > <artifactId > mybatis</artifactId > <version > 3.3.0</version > </dependency > <dependency > <groupId > org.mybatis</groupId > <artifactId > mybatis-spring</artifactId > <version > 1.2.2</version > </dependency > </dependencies >
在applicationContext.xml中增加以下配置，其中${jdbc…}配置在application.properties中applicationContext.xml 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 ...... <context:property-placeholder ignore-unresolvable ="true" location ="classpath*:/application.properties" /> <bean id ="transactionManager" class ="org.springframework.jdbc.datasource.DataSourceTransactionManager" > <property name ="dataSource" ref ="dataSource" /> </bean > <bean id ="sqlSessionFactory" class ="org.mybatis.spring.SqlSessionFactoryBean" > <property name ="dataSource" ref ="dataSource" /> <property name ="typeAliasesPackage" value ="com.climbran.spring.entity" /> <property name ="mapperLocations" value ="classpath:/mybatis/*Mapper.xml" /> </bean > <bean class ="org.mybatis.spring.mapper.MapperScannerConfigurer" > <property name ="basePackage" value ="com.climbran.spring.repository" /> <property name ="annotationClass" value ="com.climbran.spring.repository.MyBatisRepository" /> </bean > <bean id ="dataSource" class ="org.apache.tomcat.jdbc.pool.DataSource" destroy-method ="close" > <property name ="driverClassName" value ="${jdbc.driver}" /> <property name ="url" value ="${jdbc.url}" /> <property name ="username" value ="${jdbc.username}" /> <property name ="password" value ="${jdbc.password}" /> <property name ="maxActive" value ="${jdbc.pool.maxActive}" /> <property name ="maxIdle" value ="${jdbc.pool.maxIdle}" /> <property name ="minIdle" value ="0" /> <property name ="defaultAutoCommit" value ="false" /> </bean >
在src/main/resources下新建application.properties文件：application.properties 1 2 3 4 5 6 jdbc.driver=org.postgresql .Driver jdbc.url=jdbc:postgresql: jdbc.username=数据库用户名 jdbc.password=数据库密码 jdbc.pool .maxIdle =10 jdbc.pool .maxActive =50
applicationContext.xml文件中，SqlSessionFactory的typeAliasesPackage配置entity的扫描目录，mapperLocations配置mybatis映射文件，示例如下：User.java 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 package com.climbran.spring.entity; * @author climbran */ public class User private Integer id; private String username; private String schoolName; public Integer getId () return id; } public void setId (Integer id) this .id = id; } public String getUsername () return username; } public void setUsername (String username) this .username = username; } public String getSchoolName () return schoolName; } public void setSchoolNamer (String schoolName) this .schoolName = schoolName; } }
在src/main/resources下新建文件夹mybatis,再在mybatis下新建文件UserMapper.xmlUserMapper.xml 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 <?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.climbran.spring.repository.UserDao" > 获取用户: 输出直接映射到对象, school_name列要"as schoolName"以方便映射 --> <select id ="get" parameterType ="integer" resultType ="User" > select id, username, school_name as schoolName from public.user where id=#{id} </select > </mapper >
applicationContext.xml中org.mybatis.spring.mapper.MapperScannerConfigurer配置了dao层文件所在位置，所以根据UserMapper.xml中的配置，对应的java文件为：UserDao.java 1 2 3 4 5 6 7 8 9 10 11 package com .climbran .spring .repository ;import com .climbran .spring .entity .User ; * @author climbran */ @MyBatisRepository public interface UserDao { User get (Integer id ); }
org.mybatis.spring.mapper.MapperScannerConfigurer的annotationClass配置是表示已注解方式扫描dao，自动注册有value值对应注解的bean，例如上面UserDao的@MyBatisRepository注解，其是实现如下：UserDao.xml 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 package com .climbran .spring .repository ;import java .lang .annotation .Documented ;import java .lang .annotation .ElementType ;import java .lang .annotation .Retention ;import java .lang .annotation .RetentionPolicy ;import java .lang .annotation .Target ;import org .springframework .stereotype .Component ; * 标识MyBatis的DAO,方便{@link org.mybatis.spring.mapper.MapperScannerConfigurer}的扫描。 * * @author climbran * */ @Retention(RetentionPolicy.RUNTIME) @Target (ElementType.TYPE) @Documented @Component public @interface MyBatisRepository { String value () default ""; }
使用时在Service中通过@Autowired注入UserDao即可访问数据库。1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 CREATE TABLE "user" ( id serial NOT NULL , username character varying , school_name character varying , CONSTRAINT user_pkey PRIMARY KEY (id ) ) WITH ( OIDS=FALSE ); ALTER TABLE "user" OWNER TO postgres;
