val reader = Resources.getResourceAsReader("mybatis-priceratio.xml")
val ds:DataSource = new SingleConnectionDataSource(GlobalConfig.priceratioJdbcUrl,GlobalConfig.priceratioJdbcUser,GlobalConfig.priceratioJdbcPwd,true);
val transactionFactory:TransactionFactory = new JdbcTransactionFactory()
val environment:Environment = new Environment("development", transactionFactory, ds)
val configuration = new XMLConfigBuilder(reader).parse()
configuration.setEnvironment(environment)
val fac:SqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration)
val session = fac.openSession();
try{
val mp:HotelChannelMappingMapper = session.getMapper(classOf[HotelChannelMappingMapper])
val list = tp2._2.toSeq
mp.insertWithBatch(seqAsJavaList(list));
//不提交事务 ,数据不会保存
session.commit();
}finally{
session.close();
}
2) mybatis-priceratio.xml 配置
<?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>
<!-- 指定映射文件 -->
<mappers>
<mapper resource="mapper/ChannelScenicProductPackageMapper.xml"/>
<mapper resource="mapper/ScenicChannelMappingMapper.xml"/>
</mappers>
</configuration>
3)依赖包 spring