【Scala】基于8.0版本的jdbc进行数据库连接出现

xiaoxiao2021-07-27  101

下面这个代码可以正常执行,没有问题

import java.sql.{Connection, DriverManager, ResultSet, Statement} object Main { def main(args: Array[String]): Unit = { val driver = "com.mysql.cj.jdbc.Driver" val url = "jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=Asia/Shanghai" val user = "root" val password = "xxxx" Class.forName(driver) val conn: Connection = DriverManager.getConnection(url, user, password) val SQL = "select * from tran" val stmt: Statement = conn.createStatement() val rs: ResultSet = stmt.executeQuery(SQL) while (rs.next()) { println(rs.getString("statis_date")) } rs.close() stmt.close() conn.close() } }

但如果导入包的时候,吧

import java.sql.{Connection, DriverManager, ResultSet, Statement}

替换为

import java.sql._

上面的代码就会报错 因为java.sql._下也有一个Array类,与scala.array会冲突,main的参数就会变成了java.sql.Array类型,因此最好就是用哪个导入哪个

转载请注明原文地址: https://www.6miu.com/read-4823392.html

最新回复(0)