Java 连接 mysql数据库

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

 

public class ConnectionManager{

private static final String DRIVER_CLASS = "org.gjt.mm.mysql.Driver";

private static final String DATABASE_URL = "jdbc:mysql://localhost:3306/databaseName";

private static final String DATABASE_USER = "root";

private static final String DATABASE_PASSWORD = "password";

public static Connection getConnection(){

Connection conn = null;

try{

Class.forName(DRIVER_CLASS);

conn = DriverManager.getConnection(DATABASE_URL, DATABASE_USER, DATABASE_PASSWORD);

}catch(Exception e){

e.printStackTrace();

}

return conn;

}

public static void closeConnection(Connection conn){

try{

if(conn!=null && (!conn.isClosed())){

conn.close();

}

}catch(Exception e){

e.printStackTrace();

}

}

public static void closeResultSet(ResultSet rs){

try{

if(rs!=null){

rs.close();

rs = null;

}

}catch(Exception e){

e.printStackTrace();

}

}

public static void closeStatement(PreparedStatement pStatement){

try{

if(pStatement!=null){

pStatement.close();

pStatement=null;

}

}catch(Exception e){

e.printStackTrace();

}

}

////////////////////////////////////////////////////

}