复习JDBC连接数据库

最新推荐文章于 2023-01-11 13:44:37 发布

MenBad

最新推荐文章于 2023-01-11 13:44:37 发布

阅读量183

点赞数

分类专栏： mybatis java 文章标签：数据库 mysql sql

本文链接：https://blog.csdn.net/MenBad/article/details/126453656

版权

java 同时被 2 个专栏收录

55 篇文章 0 订阅

订阅专栏

mybatis

4 篇文章 0 订阅

订阅专栏


import java.sql.*;

public class Test {
    static final String driver="com.mysql.cj.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8";
    static final String USER = "root";
    static final String PASS = "root";
    static final String QUERY = "UPDATE sc SET sc.`name` = \"Tom\" WHERE sc.id=2";
    public static void main(String[] args) {
        Connection conn = null;
        try {
            Class.forName(driver);
            conn= DriverManager.getConnection(DB_URL, USER, PASS);

            conn.setAutoCommit(false);
            Statement stmt = conn.createStatement();
            int i = stmt.executeUpdate(QUERY);

            conn.commit();

           if (i>0){
               System.out.println("success");
               conn.rollback();
           }
        } catch (SQLException e) {
            try {
                conn.rollback();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
}