2021.07.03 继续使用IDEA连接Mysql数据库

变化是这回使用的是旗舰版。没激活，先试用30天。

找到database后，IDEA提示“download missing mysql driver files”。

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

/**

• Created by qcl on 2017/11/18.

• 数据库连接

*/

public class song {
public static void main(String[] args) {
Connection con;

    String driver="com.mysql.jdbc.Driver";

//这里我的数据库是qcl

    String url="jdbc:mysql://127.0.0.1:3306/lianxi";

    String user="root";

    String password="song1984";

    try {
        Class.forName(driver);

        con = DriverManager.getConnection(url, user, password);

        if (!con.isClosed()) {
            System.out.println("数据库连接成功");

        }

        Statement statement = con.createStatement();

        String sql = "select Members_Name from members_basic_information;";//我的表格

        ResultSet resultSet = statement.executeQuery(sql);

        String name;

        while (resultSet.next()) {
            name = resultSet.getString("Members_Name");
                System.out.println("姓名：" + name);

            }


        resultSet.close();

        con.close();

    } catch (ClassNotFoundException e) {
        System.out.println("数据库驱动没有安装");

    } catch (SQLException e) {
        System.out.println("数据库连接失败");

    }

}

}