mysql JDBC 驱动类

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


public class DBManager_crm {


private static final String DRIVATE = "com.mysql.jdbc.Driver";
private static final String DB_URL = "jdbc:mysql:///crm?characterEncoding=utf-8";
private static final String USER_NAME = "root";
private static final String USER_PASS = "123456";


public static Connection getConnection() {
try {
Class.forName(DRIVATE);
Connection con = DriverManager.getConnection(DB_URL, USER_NAME,
USER_PASS);
return con;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}


public static void closeConnection(Connection con) {
try {
if (con != null && !con.isClosed()) {
con.close();
}
} catch (Exception e) {
e.printStackTrace();
con = null;
}
}


public static void closeResultSet(ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
} catch (Exception e) {
e.printStackTrace();
rs = null;
}
}


public static void closePreparedStatement(PreparedStatement pst) {
try {
if (pst != null) {
pst.close();
}
} catch (Exception e) {
e.printStackTrace();
pst = null;
}
}


public static void close(Connection con, PreparedStatement pst) {
closeConnection(con);
closePreparedStatement(pst);
}


public static void close(Connection con, PreparedStatement pst, ResultSet rs) {
close(con, pst);
closeResultSet(rs);
}