package com.gaulhor.jdbc;
import java.sql.*;
public final class mysqlConnectionBase
{
private final static String url="jdbc:mysql://localhost:3306/iseeuon";
private final static String user="root";
private final static String password="";
private mysqlConnectionBase(){}
static
{
try
{
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e)
{
throw new ExceptionInInitializerError(e);
}
}
public static Connection getConnection() throws SQLException
{
//建立连接
return DriverManager.getConnection(url,user,password);
}
public static void free(ResultSet rs,Statement st,Connection conn)
{
//6.释放资源
try{
if(rs!=null)
rs.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(st!=null)
st.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(conn!=null)
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
}
}