Scala连接Mysql 实现增删改查

创建Maven工程
导入pom依赖

 <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>

    <dependency>
      <groupId>org.scalikejdbc</groupId>
      <artifactId>scalikejdbc_2.12</artifactId>
      <version>3.3.2</version>
    </dependency>
    <dependency>
      <groupId>org.scalikejdbc</groupId>
      <artifactId>scalikejdbc-config_2.12</artifactId>
      <version>3.3.2</version>
    </dependency>
  </dependencies>

main下创建resources文件夹，配置文件datasources.properties

db.school.driver=com.mysql.jdbc.Driver
db.school.url=jdbc:mysql://192.168.6.160(虚拟机ip):3306/school?useSSL=false&characterEncoding=utf-8
db.school.username=root
db.school.password='mysql密码'

Base

<