IDEA_连接——Mysql

Java 和 Scala连接Mysql的驱动（Python则需要安装库pymysql）

<dependencies>
        <!-- MySQL驱动包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.16</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.29</version>
        </dependency>
</dependencies>

Python

import pymysql
mysqlqd = pymysql.connect(
                host="localhost",
                # host="zj1",
                port=3306,
                user="root",
                password="666666",
                db="test")
cur = mysqlqd.cursor()
sql = "select * from clicks"
cur.execute(sql)
data = cur.fetchall()
print(data)
cur.close()
mysqlqd.close()

Java（可来连接）

import java.sql.*;

public class jdbc_test {
//    初始化Mysql驱动内容和Mysql用户和密码
//    Msyql驱动
    public static String driver = "com.mysql.cj.jdbc.Driver";
//    public static String driver = "com.mysql.jdbc.Driver";
//                                           Mysql地址，端口 数据库
    public static String url = "jdbc:mysql://localhost:3306/test";
//    Mysql的用户
    public static String usr = "root";
//    Mysql的密码
    public static String pwd = "666666";

    public static void main (String [] args) {
        Connection con;
        Statement sql;
        ResultSet rs;
        try {
            Class.forName (driver);
        } catch (ClassNotFoundException e) {
            System.out.println ("error!Class not found");
            return;
        }
        try {
            con = DriverManager.getConnection (url, usr, pwd);
            sql = con.createStatement ();
            rs = sql.executeQuery ("SELECT * FROM clicks");
            while (rs.next ()) {
                System.out.println (rs.getString (1));
                System.out.println (rs.getString (2));
            }
            con.close();
        } catch (SQLException e) {
            System.out.println ("error!SQL Exception");
        }

    }
}

SCALA

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

object MysqlDemo {
//  private val driver="com.mysql.jdbc.Driver"
  private val driver="com.mysql.cj.jdbc.Driver"
  private val url="jdbc:mysql://localhost:3306/test"
  //  private val url="jdbc:mysql://zj1:3306/test?useSSL=false&serverTimezone=Hongkong&characterEncoding=utf-8&autoReconnect=true"
  private val username="root"
  private val password="666666"

  private var connection:Connection =null

  def getConnection():Unit={
    Class.forName(driver)
    connection= DriverManager.getConnection(url,username,password)
  }



  def select():Unit={
    val selectStrSql="select * from clicks"
    val rs: ResultSet = connection.createStatement().executeQuery(selectStrSql)
    while (rs.next()){
//      val id: Int = rs.getInt("id")
      val user: String = rs.getString("user")
      val age: String = rs.getString("url")
      println("\t"+user+"\t"+url)
    }
  }
  def main(args: Array[String]): Unit = {
    getConnection()
    /*println(connection)
    val num: Int = insert("kb09",6)
    println("结果为："+num)*/
    select()
  }
}