scala JDBC连接Mysql数据库

一、在mysql创建表结构

create table student(
id int primary key auto_increment,
name varchar(255),
age int
)

插入一组测试数据

insert into student(name,age) values("张三",21),("李四",25)

二、导入依赖包

可以直接传入jar包，maven项目可以导入依赖

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

三、代码部分

object mysqlConnect{
	//定义驱动,数据库地址,名称,密码
	private val driver="com:mysql.jdbc.Driver"
	private val url="jdbc:mysql://192.168.184.40:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false"
	private val userName="root"
	private val password="ok"

	//获取连接
	private var connection:Connection=null
	def getConnection():Unit={
		Class.forName(driver)
		connection =DriverManager.getConnection(url,userName,password)
	}
	
	//定义查询
	def select():Unit={
		println("查询数据")
	    val selectSql="select * from student"
		val rs:ResultSet=connection.createStatement().executeQuery(selectSql)
		while(rs.next()){
			var id=rs.getInt("id")
			var name=rs.getString("name")
			var age=rs.getInt("age")
			println(id+"\t"+name+","+age)
		}
	}
	
	//定义插入语句
	def insert(uname,uage):Unit={
		println("插入数据")
		val insertSql="insert into student(name,age) values(?,?)"
		val stat:PreparedStatement=connection.prepareStatement(insertSql)
		stat.setString(1,uname)
		stat.setInt(2,uage)
		//定义执行查询后返回值
		var i=stat.executeUpdate()
		println(i)   
	}
	
	//测试
	def main(args:Array[String]):Unit={
		getConnection()
		println(connection)
		select()
		insert("王五",23)
	}
}

执行结果：