Spring Mybatis

天地因心 2016-12-27

展开全文

基于之前的spring项目，引入mybatis作为数据层基本框架

1. 引入mybatis依赖

3.3.0

1.2.3

org.mybatis mybatis-spring ${mybatis-spring.version} org.mybatis mybatis ${mybatis.version}

>
>3.3.0
>1.2.3
>
>org.mybatis
>mybatis-spring
>${mybatis-spring.version}
>
>org.mybatis
>mybatis
>${mybatis.version}

3.3.0

1.2.3

org.mybatis mybatis-spring ${mybatis-spring.version} org.mybatis mybatis ${mybatis.version}

2. 创建Domain类

2.1 表结构

CREATE TABLE `stock` ( `code` varchar(10) NOT NULL, `name` varchar(10) NOT NULL, `count` int(11) DEFAULT NULL, `main_business` varchar(256) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `price` decimal(10,2) DEFAULT NULL, PRIMARY KEY (`code`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

CREATE TABLE `stock` (
`code` varchar(10) NOT NULL,
`name` varchar(10) NOT NULL,
`count` int(11) DEFAULT NULL,
`main_business` varchar(256) DEFAULT NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`price` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

2.2 Stock.java

package com.zmannotes.spring.mybatis.domain;public class Stock { private String code; private String name; private Integer count; private String mainBusiness; private Date createTime; private BigDecimal price;//setter and getter//...}

package com.zmannotes.spring.mybatis.domain;
public class Stock {
private String code;
private String name;
private Integer count;
private String mainBusiness;
private Date createTime;
private BigDecimal price;
//setter and getter
//...
}

3. 创建Dao(Mapper)

package com.zmannotes.spring.mybatis.dao;import com.zmannotes.spring.mybatis.domain.Stock;public interface StockMapper { //根据PK删除 int deleteByPrimaryKey(String code); //插入新纪录 int insert(Stock record); //根据PK查询 Stock selectByPrimaryKey(String code);}

package com.zmannotes.spring.mybatis.dao;
import com.zmannotes.spring.mybatis.domain.Stock;
public interface StockMapper {
//根据PK删除
int deleteByPrimaryKey(String code);
//插入新纪录
int insert(Stock record);
//根据PK查询
Stock selectByPrimaryKey(String code);
}

4. 配置映射文件

//通过配置文件将数据库表与对象、Dao关联起来 code, name, count, main_business, create_time, price delete from stock where code = #{code,jdbcType=VARCHAR} insert into stock (code, name, count, main_business, create_time, price ) values (#{code,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{count,jdbcType=INTEGER}, #{mainBusiness,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{price,jdbcType=DECIMAL} )

//通过配置文件将数据库表与对象、Dao关联起来
namespace='com.zmannotes.spring.mybatis.dao.StockMapper' >
id='BaseResultMap' type='com.zmannotes.spring.mybatis.domain.Stock' >
column='code' property='code' jdbcType='VARCHAR' />
column='name' property='name' jdbcType='VARCHAR' />
column='count' property='count' jdbcType='INTEGER' />
column='main_business' property='mainBusiness' jdbcType='VARCHAR' />
column='create_time' property='createTime' jdbcType='TIMESTAMP' />
column='price' property='price' jdbcType='DECIMAL' />
id='Base_Column_List' >
code, name, count, main_business, create_time, price
id='selectByPrimaryKey' resultMap='BaseResultMap' parameterType='java.lang.String' >
select
refid='Base_Column_List' />
from stock
where code = #{code,jdbcType=VARCHAR}
id='deleteByPrimaryKey' parameterType='java.lang.String' >
delete from stock
where code = #{code,jdbcType=VARCHAR}
id='insert' parameterType='com.zmannotes.spring.mybatis.domain.Stock' >
insert into stock (code, name, count,
main_business, create_time, price
)
values (#{code,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{count,jdbcType=INTEGER},
#{mainBusiness,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{price,jdbcType=DECIMAL}
)

5. 配置数据源及SessionFactory

set names utf8mb4;

classpath:mybatis/stock/*.xml com.zmannotes.spring.mybatis.dao

xmlns='http://www./schema/beans'
xmlns:xsi='http://www./2001/XMLSchema-instance' xmlns:tx='http://www./schema/tx'
xsi:schemaLocation='
http://www./schema/beans
http://www./schema/beans/spring-beans.xsd
http://www./schema/tx
http://www./schema/tx/spring-tx.xsd'>
id='stock_dataSource' class='org.apache.commons.dbcp2.BasicDataSource'
destroy-method='close'>
name='driverClassName' value='com.mysql.jdbc.Driver' />
name='url' value='jdbc:mysql://123.57.144.1:3306/stock' />
name='username' value='stock' />
name='password' value='stock' />
name='connectionInitSqls'>
>
>set names utf8mb4;
id='stock_txManager'
class='org.springframework.jdbc.datasource.DataSourceTransactionManager'>
name='dataSource' ref='stock_dataSource' />
transaction-manager='stock_txManager'
mode='proxy' proxy-target-class='true' />
id='stock_sqlSessionFactory' class='org.mybatis.spring.SqlSessionFactoryBean'>
name='dataSource' ref='stock_dataSource' />
name='typeAliasesPackage'
value='com.zmannotes.spring.mybatis.domain' />
name='mapperLocations'>
>
>classpath:mybatis/stock/*.xml
class='org.mybatis.spring.mapper.MapperScannerConfigurer'>
name='basePackage'>
>
com.zmannotes.spring.mybatis.dao
name='sqlSessionFactoryBeanName' value='stock_sqlSessionFactory' />

set names utf8mb4;

classpath:mybatis/stock/*.xml com.zmannotes.spring.mybatis.dao

6. 完成单测

@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration(locations = '/spring/stock-session-factory.xml')public class StockTest { @Autowired private StockMapper stockMapper; /**插入一条数据并自动回滚*/ @Transactional @Test public void test(){ Stock stock = new Stock(); stock.setCode('900001'); stock.setName('tcl'); stockMapper.insert(stock); }}