Java链接MySQL数据库

最新推荐文章于 2025-08-19 17:57:57 发布

此人太懒

最新推荐文章于 2025-08-19 17:57:57 发布

阅读量137

点赞数

分类专栏： Java MySQL 文章标签： mysql java database 数据库

Java 同时被 2 个专栏收录

9 篇文章

订阅专栏

MySQL

2 篇文章

订阅专栏

本文提供了一个使用Java连接MySQL数据库的示例代码。介绍了如何通过指定IP地址、端口、数据库名称、用户名及密码来建立数据库连接，并实现了自动重连功能。此外还提供了关闭资源的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[b]Java链接MySQL数据库创建方式[/b]


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

public class MySQLDAO {
	private String ip = null;
	private String port = null;
	private String database = null;
	private String user = null;
	private String password = null;
	private Connection con = null;

	/**
	 * 
	 * @param ip
	 * @param port
	 * @param database
	 * @param user
	 * @param password
	 */
	public MySQLDAO(String ip, String port, String database, String user, String password) {
		this.ip = ip;
		this.port = port;
		this.database = database;
		this.user = user;
		this.password = password;
	}

	/**
	 * 
	 * @return Connection
	 */
	public Connection getMySQLConnection() {
		int time = 0;
		String url = "jdbc:mysql://" + ip + ":" + port + "/" + database + "?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull";
		try {
			for (; (++time < 3) && (con == null || con.isClosed());) {
				Class.forName("com.mysql.jdbc.Driver");
				con = DriverManager.getConnection(url, user, password);
			}
		} catch (Exception e) {
			System.err.println("Cannot get MySQL database connection.");
			e.printStackTrace();
		}
		return con;
	}

	/**
	 * 
	 * @param con
	 *            Connection
	 * @return
	 */
	public boolean closeMySQLResource(Connection con) {
		return closeMySQLResource(con, null, null);
	}

	/**
	 * 
	 * @param ps
	 *            Statement
	 * @return
	 */
	public boolean closeMySQLResource(Statement ps) {
		return closeMySQLResource(null, ps, null);
	}

	/**
	 * 
	 * @param rs
	 *            ResultSet
	 * @return
	 */
	public boolean closeMySQLResource(ResultSet rs) {
		return closeMySQLResource(null, null, rs);
	}

	/**
	 * 
	 * @param con
	 *            Connection
	 * @param ps
	 *            Statement
	 * @return
	 */
	public boolean closeMySQLResource(Connection con, Statement ps) {
		return closeMySQLResource(con, ps, null);
	}

	/**
	 * 
	 * @param ps
	 *            Statement
	 * @param rs
	 *            ResultSet
	 * @return
	 */
	public boolean closeMySQLResource(Statement ps, ResultSet rs) {
		return closeMySQLResource(null, ps, rs);
	}

	/**
	 * 
	 * @param con
	 *            Connection
	 * @param rs
	 *            ResultSet
	 * @return
	 */
	public boolean closeMySQLResource(Connection con, ResultSet rs) {
		return closeMySQLResource(con, null, rs);
	}

	/**
	 * 
	 * @param con
	 *            Connection
	 * @param ps
	 *            Statement
	 * @param rs
	 *            ResultSet
	 * @return
	 */
	public boolean closeMySQLResource(Connection con, Statement ps, ResultSet rs) {
		try {
			if (con != null)
				con.close();
			if (ps != null)
				ps.close();
			if (rs != null)
				rs.close();
			return true;
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}
}