jdbcutil.java

shoppingCar 购物车

package com.tarena.shoppingcar.util;

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

public class JdbcUtil {
	public static void close(Connection con) {
		if (con != null) {
			try {
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	public static void close(Statement pstmt) {
		if (pstmt != null) {
			try {
				pstmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	public static void close(ResultSet rs) {
		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	public static void close(Connection con, Statement pstmt) {
		close(pstmt);
		close(con);
	}

	public static void close(Statement pstmt, ResultSet rs) {
		close(rs);
		close(pstmt);
	}

	public static void close(Connection con, Statement pstmt, ResultSet rs) {
		close(rs);
		close(pstmt);
		close(con);
	}
}