JDBC--API--Statement

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class jdbcdemo_Statement {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        String url="jdbc:mysql://127.0.0.1:3306/homework?useSSL=false";
        String user="root";
        String password="1234";
        Connection conn = DriverManager.getConnection(url, user, password);
        String sql="update lyj set credit=888 where id=3";
        Statement statement = conn.createStatement();
        conn.setAutoCommit(false);
        try {

            int i = statement.executeUpdate(sql);
            if (i>0){
                System.out.println("执行成功");
            }else {
                System.out.println("执行失败");

            }        } catch (SQLException throwables) {
            conn.rollback();
            throwables.printStackTrace();
        }
        conn.commit();

conn.close();
statement.close();


    }
}