[Scala] IDEA + Maven + Scala + scalikejdbc 读写MySQL

迷南。 2022-05-19 00:27 184阅读 0赞

1. 新建一个maven + scala 的 工程

2. 导入依赖

<dependency>
          <groupId>org.scalikejdbc</groupId>
          <artifactId>scalikejdbc_2.11</artifactId>
          <version>${scalikejdbc.version}</version>
        </dependency>
        <dependency>
          <groupId>org.scalikejdbc</groupId>
          <artifactId>scalikejdbc-config_2.11</artifactId>
          <version>${scalikejdbc.version}</version>
        </dependency>
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>${mysql.version}</version>
        </dependency>
        <dependency>
          <groupId>ch.qos.logback</groupId>
          <artifactId>logback-classic</artifactId>
          <version>1.2.3</version>
        </dependency>

<groupId>org.scala-tools</groupId>
            <artifactId>maven-scala-plugin</artifactId>
            <version>2.15.0</version>
    
            <groupId>org.apache.maven.plugins</groupId>
            <artifactId>maven-eclipse-plugin</artifactId>
            <version>2.10</version>

3. resources/application.conf

# JDBC settings
    db.default.driver="com.mysql.jdbc.Driver"
    db.default.url="jdbc:mysql://192.168.1.7:3306/test?characterEncoding=utf-8"
    db.default.user="test"
    db.default.password="123456"

4. 案例

package com.aaa
    
    import scalikejdbc._
    import scalikejdbc.config._
    
    object ScalaLikeJdbc {
    
      def main(args: Array[String]): Unit = {
    
    //    implicit val session = AutoSession
    
        DBs.setupAll()
    
        val memberIds = DB readOnly { implicit session =>
          sql"select id from people".map(_.long(1)).list.apply()
        }
    
        println(memberIds)
    
        DBs.closeAll()
    
      }
    }