public?class?DBConnUtil?{
????private?static?final?String?URL="jdbc:mysql://192.168.0.105:3306/imooc";
????private?static?final?String?USER="zabbix";
????private?static?final?String?PASSWORD="zabbix";
????
????//聲明一個靜態變量
????private?static?Connection?conn?=?null;
????
????//放到靜態塊中
????static?{
????????try?{
????????????//加載驅動
????????????Class.forName("com.mysql.jdbc.Driver");
????????????
????????????conn?=?DriverManager.getConnection(URL,USER,PASSWORD);
????????}?catch?(ClassNotFoundException?e)?{
????????????e.printStackTrace();
????????}?catch?(SQLException?e)?{
????????????e.printStackTrace();
????????}
????}
????
????public?static?Connection?getConn(){
????????return?conn;
????}
}我在每次使用完數據庫后會關掉這個連接（按道理應該關閉吧）conn.close();然后第二次操作數據庫就No operations allowed after connection closed.這個問題要怎么解決？總不能真的注銷 conn.close(); 吧
添加回答
舉報
0/150
提交
取消