数据库
db.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/javatest?useUnicode=true&characterEncoding=utf8&useSSL=false
username=root
password=xxxxxx
连接数据库工具类
package com.hongkai.jdbc.utils;
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
public class JdbcUtils {
private static String driver = null;
private static String url = null;
private static String username = null;
private static String password = null;
static {
try {
InputStream in = JdbcUtils.class.getClassLoader().getResourceAsStream("db.properties");
Properties properties = new Properties();
properties.load(in);
driver = properties.getProperty("driver");
url = properties.getProperty("url");
username = properties.getProperty("username");
password = properties.getProperty("password");
//驱动只需要加载一次
Class.forName(driver);
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//获取连接
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, username, password);
}
//释放资源
public static void release(Connection con, Statement st, ResultSet rs) throws SQLException {
if (rs != null) {
rs.close();
}
if (st!=null){
st.close();
}
if (con!=null){
con.close();
}
}
}
Gui
package com.hongkai.jdbc.utils;
import javax.swing.*;
import