使用IDEA与MySQL建立连接

最新推荐文章于 2024-12-08 00:21:47 发布

luckeryu

最新推荐文章于 2024-12-08 00:21:47 发布

阅读量296

点赞数 1

分类专栏： MySQL 文章标签： mysql jdbc java sql

本文链接：https://blog.youkuaiyun.com/luckeryu/article/details/117766673

版权

MySQL 专栏收录该内容

2 篇文章

订阅专栏

Java中使用JDBC连接数据库

加载驱动

 Class.forName("com.mysql.jdbc.Driver");

创建数据库连接

String url = "jdbc:mysql://localhost:3306/jdbcstudy?useUnicode=true&characterEncoding=utf8&useSSL=true";
String username = "root";
 String password = "123456";
//3.连接成功，数据库对象
Connection connection = DriverManager.getConnection(url, username, password);

创建执行sql的语句

 String sql = "SELECT *FROM users";

执行语句

  Statement statement = connection.createStatement();

处理执行结果

//此处为遍历查询表中的数据
ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()) {
            System.out.println("id=" + resultSet.getObject("id"));
            System.out.println("name=" + resultSet.getObject("name"));
            System.out.println("password=" + resultSet.getObject("password"));
            System.out.println("email=" + resultSet.getObject("email"));
            System.out.println("birth=" + resultSet.getObject("birthday"));
            System.out.println("============================");
        }

释放资源

resultSet.close();
statement.close();
connection.close();

完整源码：

package MySQLTest;

import java.sql.*;

public class Test01 {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        //1.加载驱动 固定写法    Driver：驱动程序
        Class.forName("com.mysql.jdbc.Driver");
        //2．用户信息和url
        String url = "jdbc:mysql://localhost:3306/jdbcstudy?useUnicode=true&characterEncoding=utf8&useSSL=true";
        String username = "root";
        String password = "123456";
        //3.连接成功，数据库对象
        Connection connection = DriverManager.getConnection(url, username, password);
        //4．执行SQL的对象
        Statement statement = connection.createStatement();
        //5．执行sQL的对象去执行sQL，可能存在结果，查看返回结果
        String sql = "SELECT *FROM users";
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()) {
            System.out.println("id=" + resultSet.getObject("id"));
            System.out.println("name=" + resultSet.getObject("name"));
            System.out.println("password=" + resultSet.getObject("password"));
            System.out.println("email=" + resultSet.getObject("email"));
            System.out.println("birth=" + resultSet.getObject("birthday"));
            System.out.println("============================");
        }
        //6、释放连接
        resultSet.close();
        statement.close();
        connection.close();
    }

}

希望能帮到你哦！
插入删除也很简单，只要改一点点就好了

 String sql = " DELETE FROM  users WHERE id=3";
        //插入成功
      //  String sql = "INSERT INTO  users(id ,name, password ,email,birthday) VALUES (5,'kan','123456','2473674','2020-01-01')";
        int i = statement.executeUpdate(sql);
        if (i > 0) {
            System.out.println("删除成功");
        }

！！！驱动下载地址！！！