package xueruan.com.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

public class DBUtil {

	public static Connection getConnection() {

		String username = "username";

		String password = "password";

		String url = "jdbc:mysql://localhost:3306/database";

		Connection con = null;

		try {

			con = DriverManager.getConnection(url, username, password);

		} catch (SQLException e) {

			e.printStackTrace();

		}

		return con;

	}

	public static void close(Connection con) {

		try {

			if(con!=null) con.close();

		} catch (SQLException e) {

			e.printStackTrace();

		}

	}

	public static void close(java.sql.PreparedStatement ps) {

		try {

			if(ps!=null) ps.close();

		} catch (SQLException e) {

			e.printStackTrace();

		}

	}

	public static void close(ResultSet rs) {

		try {

			if(rs!=null) rs.close();

		} catch (SQLException e) {

			e.printStackTrace();

		}

	}

}