导入Java . SQL . connection;
导入Java . SQL . driver manager;
导入Java . SQL . resultset;
导入Java . SQL . SQL exception;
导入Java . SQL . statement;
public class Conn {
private static final String driver = " com . MySQL . JDBC . driver ";
私有静态最终字符串URL = " JDBC:MySQL://localhost:3316/blog?用户= root & amp密码= root ";
//获得数据库连接公共静态连接getConnection(){
连接连接= null请尝试{
Class.forName(driver );
conn = driver manager . getconnection(URL);
如果(连接!= null){
System.out.print("成功");} } catch(SQLException e){
e . printstacktrace();} catch(ClassNotFoundException e){;返回连接;}
//关闭公共静态void close ResultSet(ResultSet RS)
{
try
{
if(RS!= null)
{
RS . close();}
} catch(SQLException ex)
{
ex . printstacktrace();}
}
//关闭Statement public static void close Statement(Statement ST)
{
try
{
if(ST!= null)
{
ST . close();}
} catch(SQLException ex)
{
ex . printstacktrace();}
}
//关闭Connection
public static void close Connection(Connection conn)
{
try
{
if(conn!= null)
{
conn . close();}
} catch(SQLException ex)
{
ex . printstacktrace();}
}
//测试数据库连接是否成功public static void main(String[]args){
conn . getconnection();
}
}