spring-mybatis SqlSessionTemplate使用 （数据库持久化二）

SqlSessionTemplate有点类似于mybatis中的SqlSession操作

配置文件

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-4.3.xsd">

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.mysql.cj.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://127.0.0.1:3306/test" />
		<property name="username" value="root" />
		<property name="password" value="root" />
	</bean>
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="configLocation" value="classpath:mybaties.xml" />
	</bean>

	<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg index="0" ref="sqlSessionFactory" />
	</bean>
</beans>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<!-- 配置信息 -->
	<typeAliases>
		<typeAlias type="priv.dengjl.springmybatis.bean.Role" alias="role"/>
	</typeAliases>
	<mappers>
		<mapper resource="priv/dengjl/springmybatis/mapper/RoleMapper.xml" />
	</mappers>
</configuration>

基本操作

public class TestSqlSesstionTemplate {
	
	private static final Logger logger = LoggerFactory.getLogger(TestSqlSesstionTemplate.class);
	
	public static void main(String[] args) {
		ApplicationContext context = new ClassPathXmlApplicationContext("spring-mybaties.xml");
		SqlSessionTemplate sqlSessionTemplate = (SqlSessionTemplate) context.getBean("sqlSessionTemplate");
		
		Role role = new Role();
		role.setId(10086);
		role.setName("湖南工业");
		role.setDesc("王八犊子");
		sqlSessionTemplate.insert("priv.dengjl.springmybatis.dao.RoleMapper.insertRole", role);
		
		logger.debug(role.getId().toString());
	}

}