java代码连接数据库实例_小吴先生666的博客

写一个加载驱动的公共方法DBUtil

package com.zq.framework.config.properties;

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

import org.springframework.context.annotation.Configuration;

@Configuration
public class DBUtil {
	private static String URL = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8";
	private static String NAME = "root";
	private static String PASSWORD = "root";

	/**
	 * 连接驱动
	 * 
	 * @return
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public static Connection getCon() throws ClassNotFoundException, SQLException {
		// 1.加载驱动程序
		Class.forName("com.mysql.cj.jdbc.Driver");
		// 2.获得数据库的连接
		Connection conn = DriverManager.getConnection(URL, NAME, PASSWORD);
		return conn;
	}

	/**
	 * 关闭连接
	 * 
	 * @param con
	 * @param state
	 * @throws SQLException
	 */
	public static void close(Connection con, Statement state) throws SQLException {
		if (con != null) {
			state.close();
			con.close();
		}
	}

}
package com.zq.framework.c