package utils;

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

public class JDBCUtil {

 private static String driverName = "com.mysql.jdbc.Driver";
 private static String url = "jdbc:mysql://localhost:3306/stu";
 private static String userName = "root";
 private static String password = "000012";

 public static void registerDriver() {
 try {
 Class.forName(driverName);
 } catch (ClassNotFoundException e) {
 e.printStackTrace();
 }
 }

 public static Connection getConnection() throws SQLException {
 Connection conn = null;
 conn = DriverManager.getConnection(url, userName, password);
 return conn;

 }

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

 }

 /*
 * 释放所有资源
 */
 public static void realeaseAll(ResultSet rs, Statement st, Connection conn) {
 if (rs != null) {
 try {
 rs.close();
 rs = null;
 } catch (SQLException e) {
 e.printStackTrace();
 }
 }
 if (st != null) {
 try {
 st.close();
 st = null;
 } catch (SQLException e) {
 e.printStackTrace();
 }
 }
 closeConnection(conn);
 }

}