package com.oracle.tools;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class JDBCUtils {

    public static Connection getConn(){

        Connection conn = null;

        try {

            Class.forName("com.mysql.jdbc.Driver");

            String url = "jdbc:mysql://localhost:3306/java0512jie?characterEncoding=utf8";

            String uname = "root";

            String pwd = "123456";

             conn = DriverManager.getConnection(url,uname,pwd);

        } catch (ClassNotFoundException e) {

            e.printStackTrace();

        } catch (SQLException e) {

            e.printStackTrace();

        }

        return conn;

    }

    //增删改释放资源方法

    public static void close(Connection conn,PreparedStatement pst){

        if(pst!=null){

            try {

                pst.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

        if(conn!=null){

            try {

                conn.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

    }

    //增删改查释放资源方法

    public static void close(Connection conn,PreparedStatement pst,ResultSet rs){

        if (rs!=null) {

            try {

                rs.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

        if(pst!=null){

            try {

                pst.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

        if(conn!=null){

            try {

                conn.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

    }

}