学步园

package com.connection;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DB {
	
	public static final String driver = "com.mysql.jdbc.Driver";
	public static final String url = "jdbc:mysql://localhost:3306/eshopA";
	public static final String username = "root";
	public static final String passwrod = "123";
	
	public static Connection getConection(){
		
		Connection connection = null;	
		try {
			Class.forName(driver);
			connection = DriverManager.getConnection(url,username,passwrod);			
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();//捕获驱动类无法找到的异常
		}
		return connection;
	}
	public static void closeConnection(Connection connection) {
		
		if(null !=connection){
			try {
				connection.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	public static void closePreparedStatement(PreparedStatement preparedStatement){
		if(null != preparedStatement){
			try {
				preparedStatement.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	public static void closeResultSet(ResultSet resultSet){
		if(null != resultSet){
			try {
				resultSet.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}