数据库连接类
时间：2021-07-01 10:21:17
帮助过：6人阅读
util;
import java.sql.*
;
public class DBconn {
static String url = "jdbc:mysql://localhost:3306/student?serverTimezone=UTC"
;
static String username = "root"
;
static String password = "123"
;
static Connection conn =
null;
static ResultSet rs =
null;
static PreparedStatement ps =
null;
public static void init(){
try {
Class.forName("com.mysql.cj.jdbc.Driver"
);
conn =
DriverManager.getConnection(url,username,password);
} catch (Exception e) {
System.out.println("init [SQL驱动程序初始化失败！]"
);
e.printStackTrace();
}
}
public static int addUpdDel(String sql){
int i = 0
;
try {
ps =
conn.prepareStatement(sql);
i =
ps.executeUpdate();
} catch (SQLException e) {
System.out.println("sql数据库增删改异常"
);
e.printStackTrace();
}
return i;
}
public static ResultSet selectSql(String sql){
try {
ps =
conn.prepareStatement(sql);
rs =
ps.executeQuery();
} catch (SQLException e) {
System.out.println("sql数据库查询异常"
);
e.printStackTrace();
}
return rs;
}
public static void closeConn(){
try {
conn.close();
} catch (SQLException e) {
System.out.println("sql数据库关闭异常"
);
e.printStackTrace();
}
}
}
数据库连接类
标签：use zone style try time col prepare rman dup
