package com.mine
import java.sql.{Connection, DriverManager}
object TestDemo {
def getConnection: Connection = {
Class.forName("com.mysql.jdbc.Driver")
val url = "jdbc:mysql://localhost:3306/dm_cf?characterEncoding=utf8&useSSL=false"
val user = "root"
val pass = "password"
DriverManager.getConnection(url, user, pass)
}
def main(args: Array[String]): Unit = {
val conn = getConnection
val sql = "select * from client_info"
val preparedStatement = conn.prepareStatement(sql)
val rs = preparedStatement.executeQuery(sql)
val metaData = rs.getMetaData
println("获得所有列的数目及实际列数" + metaData.getColumnCount + "\n")
for (i <- 1 to metaData.getColumnCount) {
// 获得所有列的数目及实际列数
val columnCount = metaData.getCo
Scala 获取数据库的表中各字段的相关信息
最新推荐文章于 2023-02-03 14:33:09 发布
本文介绍了如何利用Scala编程语言连接到数据库并获取表的字段信息,包括字段名称、数据类型、约束等,详细阐述了相关步骤和示例代码。
摘要由CSDN通过智能技术生成