201906G110/POI/DBConnection.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBConnection {
private final String Url ="jdbc:mysql://localhost:3306/edu" ;
private final String Driver ="com.mysql.jdbc.Driver" ;
private final String user ="root" ;
private final String password ="1009" ;
private Connection con ;
public DBConnection()
{
try {
Class.forName(Driver) ;
con = DriverManager.getConnection(Url,user,password) ;
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public Connection getDB()
{
return con ;
}
public void closeDb(ResultSet rs,PreparedStatement ps)
{
if(rs!=null)
{
try {
rs.close() ;
} catch (SQLException e) {
// TODO Auto-generated catch block


e.printStackTrace();
}
}
if(ps!=null)
{
try {
ps.close() ;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}