配置文件db.properties
url =jdbc:mysql://localhost:3306/sys
username =root
password =5201314
className =com.mysql.jdbc.Driver
JdbcUtil.java
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;import com.mysql.jdbc.Statement;
public class JdbcUtil {
private static String url;
private static String username;
private static String password;
private static String classname;
static {
InputStream in = JdbcUtil.class.getResourceAsStream("db.properties");
Properties p = new Properties();
try {
p.load(in);
url = p.getProperty("url");
username = p.getProperty("username");
password = p.getProperty("password");
classname = p.getProperty("className");
Class.forName(classname);
} catch (Exception e) {
e.printStackTrace();
}
}public static Connection getConnection() {
Connection con = null;
try {
con = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}public static void close(ResultSet rt, Statement st, Connection con) {
if (rt != null) {
try {
rt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (st != null) {
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (con != null) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}