JDBC连接数据库的工具类的编写

首先要添加mysql的驱动
下载网站https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.46.zip
下载后编写代码

import java.sql.*;

public class JdbcUtils {
	static {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
}
private static Connection conn;
public static Connection getConnection() throws SQLException{
		String url="jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=false";
		String user="root";
		String password="root";
		if (conn==null||conn.isClosed()) {
			conn = DriverManager.getConnection(url, user, password);
		}
		return conn;
}

public static void colse(Connection conn,Statement stmt,ResultSet rs) throws SQLException {

		if(conn!=null&&!conn.isClosed()) {
			conn.close();
		}
		if(stmt!=null&&!stmt.isClosed()) {
			stmt.close();
		}
		if(rs!=null&&!rs.isClosed()) {
			rs.close();
		}
}
}

编写完毕就可以使用这个工具类进行连接数据库了