方式一:通过try-catch-finally进行关闭,利用finally必须执行的特性
例如:
import java.sql.*;
public class WriteData {
public static void main(String[] args) {
Connection connection= null;
Statement statement=null;
ResultSet effect=null;
//1.
try {
Class.forName ( " com.mysql.jdbc.Driver" );
//2.JDBC url 协议
String url="jdbc:mysql://127.0.0.1:3306/memo?user=root&password=wzp961208";
connection = DriverManager.getConnection ( url );
//3.创建命令
statement=connection.createStatement ();
//4.写入
String sql="insert into memo_group(name,created_time) values ('今天是个好日子','2019-06-24 19:42:00');";
//5执行
effect=statement.exe