spark (scala)使用mybatis插入数据到mysql

        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 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值