获取连接工具类:
package com.itest;
import java.sql.*;
public class JdbcUtils {
//获得连接
public static Connection getConnection() throws Exception {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/gjp","root", "123");
return con;
}
//关闭连接
public static void closeResource(Connection con, Statement st, ResultSet rs){
closeResultSet(rs);
closeStatement(st);
closeConnection(con);
}
public static void closeConnection(Connection con){
if (con != null){
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
con = null;
}
}
public static void closeStatement(Statement st){
if (st != null){
try {
st.close();