JDBC工具类

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;
	}

}