2021-01-17

必须纪念一下，JAVA操作数据库成功！

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

public class Myjdbc {
private static final String URL = “jdbc:mysql://localhost:3306/user_cmx?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=CONVERT_TO_NULL”;
private static final String USERNAME = “root”;
private static final String PWD = “password”;

public static void updata() {
	Statement stmt = null;
	Connection connection = null;
	try {
		Class.forName("com.mysql.cj.jdbc.Driver");
		System.out.println("Success loading Mysql Driver!");
		
		connection = DriverManager.getConnection(URL, USERNAME, PWD);
		System.out.println("Success connect Mysql server!");
		stmt = connection.createStatement();
		String sql = "insert into user(name,age) values ('eclipse','123');";
		int count = stmt.executeUpdate(sql);
		if (count > 0) {
			System.out.println("操作成功");
		}
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	} catch (SQLException e) {
		e.printStackTrace();
	} catch (Exception e) {
		e.printStackTrace();
	}

	finally {
		try {
			if (stmt != null)
				stmt.close();
			if (connection != null)
				connection.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}
public static void main(String[] args) {
	updata();
}

}

JDK1.8
mysql-connector-java-8.0.12