package com.rain.DB;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBUtil {
private static final String IP="localhost";
private static final String POOL="3306";
private static final String DBNAME="school";
private static final String Encoding="utf8";
private static final String USERNAME="root";
private static final String PASSWORD="root";
public static Connection getConnection() {
Connection conn = null;
//加载驱动
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("加载驱动错误");
e.printStackTrace();
}
//2.数据库连接
try {//IP,端口,数据库名,字符集,用户名,密码
conn = DriverManager.getConnection("jdbc:mysql://"+IP+":"+POOL+"/"+DBNAME+"?autoReconnect=true&useUnicode=true&characterEncoding="+Encoding,USERNAME,PASSWORD);
} catch (SQLException e) {
System.out.println("getConnection错误");
e.printStackTrace();
}
return conn;
}
//释放连接
public static void close(Connection conn,PreparedStatement ps,ResultSet rs){
if (rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (ps!=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}