Streaming-kafka-mysql (scalikejdbc)

package kafka

import java.sql.DriverManager

import com.typesafe.config.ConfigFactory
import org.apache.kafka.common.TopicPartition
import org.apache.spark.streaming.kafka010.OffsetRange
import scalikejdbc.{DB, SQL}

import scala.collection.mutable.Map

object OffsetManager {

  val config = ConfigFactory.load()

  def getConn ={
    DriverManager.getConnection(config.getString("db.url"),
      config.getString("db.user"),
      config.getString("db.password"))
  }

  /**
    * 获取指定用户的偏移量信息
    */
  def apply(groupid :String,topic :String)={
/*    val conn = getConn
    val pstmt = conn.prepareStatement("SELECT * FROM streaming_offset WHERE groupid=? AND topic=?")
    pstmt.setString(1,groupid)
    pstmt.setString(2,topic)
    val rs = pstmt.executeQuery()

    val offsetRange = Map[TopicPartition,Long]()
    while (rs.next()){
      offsetRange += new TopicPartition(rs.getString("to