~~~ package JDBC; /** * @author: hcf * @qq: 46914685 * @email: 46914685@qq.com */ import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; /** * account表 添加一條記錄 insert 語句 */ public class JDBCDemo2 { public static void main(String[] args) { Connection conn = null; Statement stmt = null; try { //1.注冊驅動 Class.forName("com.mysql.cj.jdbc.Driver"); //2.定義sql String sql = "insert into account(name,balance) values('王五',256.58)"; //3.獲取Connection對象 conn = DriverManager.getConnection("jdbc:mysql:///db1?serverTimezone=UTC", "root", "admin123"); //4.獲取執行sql的對象Statement stmt = conn.createStatement(); //5.執行sql int count = stmt.executeUpdate(sql); //6.處理結果 System.out.println(count); if (count > 0) { System.out.println("添加成功!"); } else { System.out.println("添加失敗!"); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException throwables) { throwables.printStackTrace(); } finally { //7.釋放資源 //避免空指針異常 if (stmt != null) { try { stmt.close(); } catch (SQLException throwables) { throwables.printStackTrace(); } } if (conn != null) { try { conn.close(); } catch (SQLException throwables) { throwables.printStackTrace(); } } } } } ~~~