JDBC常见问题
中文乱码
url增加参数:characterEncoding=utf8防止中文乱码
serverTimezone=Asia/Shanghai"增加时区
String url ="jdbc:mysql://localhost:3306/cgb2107?characterEncoding=utf8&serverTimezone=Asia/Shanghai";
工具类
封装:注册驱动和获取数据库的连接
public static Connection getConnection()throws Exception{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection c = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/cgb2107","root","root");
return c;
}
封装:释放资源
public static void getClose(Connection c,PreparedStatement p,ResultSet r) {
if (r != null) {
try {
r.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (p != null) {
try {
p.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (c != null) {
try {
c.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}