下面这个代码可以正常执行,没有问题
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类型,因此最好就是用哪个导入哪个