Constants类:
package com.util;
public class Constants {
public static final String URL = "jdbc:mysql://localhost:3306/lover";
public static final String USERNAME = "root";
public static final String PASSWORD = "root";
public static final String DRIVER = "com.mysql.jdbc.Driver";
}
DBUtil类:
package com.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBUtil {
private static Connection conn;
public static Connection getConn() {
if(conn != null) {
return conn;
} else {
try {
Class.forName(Constants.DRIVER);
conn = DriverManager.getConnection(Constants.URL, Constants.USERNAME, Constants.PASSWORD);
return conn;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return null;
}
}