欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

JDBC工具类

程序员文章站 2022-05-19 12:05:04
...

JDBC工具类

public class JDBCUtil {
	private static String className = "com.mysql.jdbc.Driver";
	private static String url = "jdbc:mysql://localhost:3306/mydb2";
	private static String user = "root";
	private static String password = "root";

	static {
		try {
			Class.forName(className);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}

	public static Connection getConnection() throws SQLException {
		Connection connection = DriverManager.getConnection(url, user, password);
		return connection;
	}

	public static void getCloseConnection(Connection connection) throws SQLException {
		connection.close();
	}

	public static int executeUpdate(String sql, Object[] params) throws SQLException {
		Connection connection = getConnection();
		PreparedStatement statement = connection.prepareStatement(sql);
		if (params != null) {
			for (int i = 0; i < params.length; i++) {
				statement.setObject(i + 1, params[i]);
			}
		}
		int n = statement.executeUpdate();
		return n;
	}

	public static ResultSet executeQuery(Connection connection, String sql, Object[] params) throws SQLException {
		PreparedStatement statement = connection.prepareStatement(sql);
		if (params != null) {
			for (int i = 0; i < params.length; i++) {
				statement.setObject(i + 1, params[i]);
			}
		}
		ResultSet rs = statement.executeQuery();
		return rs;
	}

}