idea+java连接mysql 增改删查

到过的地方熟悉曾经的模样

已于 2022-09-21 10:11:09 修改

阅读量356

点赞数

文章标签： sql 数据库 mysql

于 2022-09-21 10:08:59 首次发布

本文链接：https://blog.csdn.net/weixin_40557922/article/details/126967035

版权

import java.sql.*;

public class Main {
    static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost:3306/test?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";
    static final String USER = "root";
    static final String PASS = "";

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        cha();
        zeng();
        shan();
        gai();
    }

    //    查
    public static void cha() throws ClassNotFoundException, SQLException {
        Connection conn = null;
        PreparedStatement preStatement = null;
        ResultSet rs = null;
        Class.forName(JDBC_DRIVER);
        System.out.println("成功加载MySql驱动！");
        conn = DriverManager.getConnection(DB_URL, USER, PASS);
        String sql = "select * from ch";
        preStatement = conn.prepareStatement(sql);
        rs = preStatement.executeQuery();
        while (rs.next()) {
            System.out.println(rs.getString(1));
            System.out.println(rs.getString(2));
        }
        conn.close();
    }

    //    增
    public static void zeng() throws ClassNotFoundException, SQLException {
        Connection conn = null;
        PreparedStatement preStatement = null;
        ResultSet rs = null;
        Class.forName(JDBC_DRIVER);
        System.out.println("成功加载MySql驱动！");
        conn = DriverManager.getConnection(DB_URL, USER, PASS);
        String sql = "insert into ch(name) values('cs')";
        conn.prepareStatement(sql).execute();
        System.out.println("成功插入数据");
        conn.close();
    }

    //    删
    public static void shan() throws ClassNotFoundException, SQLException {
        Connection conn = null;
        PreparedStatement preStatement = null;
        ResultSet rs = null;
        Class.forName(JDBC_DRIVER);
        System.out.println("成功加载MySql驱动！");
        conn = DriverManager.getConnection(DB_URL, USER, PASS);
        String sql = "delete from ch where name='cs'";
        conn.prepareStatement(sql).execute();
        System.out.println("成功删除数据");
        conn.close();
    }

    //    改
    public static void gai() throws ClassNotFoundException, SQLException {
        Connection conn = null;
        PreparedStatement preStatement = null;
        ResultSet rs = null;
        Class.forName(JDBC_DRIVER);
        System.out.println("成功加载MySql驱动！");
        conn = DriverManager.getConnection(DB_URL, USER, PASS);
        String sql = "update ch set  name='css' where id=1";
        conn.prepareStatement(sql).execute();
        System.out.println("成功更新数据");
        conn.close();
    }
}

源码下载
https://download.csdn.net/download/weixin_40557922/86608232