Solution to problems in Java transfer process
* Test Conn Shutdown condition
*/
Package com.hb.test;
Import java.sql.connection;
/**
*
* @author Icecold
*/
public class Testconn {
STATIC connection conn = null;
public static void Main (string[] args) throws exception {
conn = Db.getconnection ();
Db.closeconnection (conn);
Db.setconnection (conn);
if (conn = = null) {
System.out.println ("AAA");
}else {
System.out.println ("BBB");
}
}
}
Data class
*
* Database Tutorial Operation class
*/
Package com.hb.test;
Import java.sql.connection;
Import Java.sql.drivermanager;
/**
*
* @author Icecold
*/
public class DB {
public static void CloseConnection (Connection conn) {
try{
IF (conn!= null) {
Conn.close ();
conn = null;
IF (Conn. isclosed ()) {
System.out.println ("null");
}else {
System.out.println ("not null");
// }
}
conn = null;
}catch (Exception e) {
E.printstacktrace ();
}
}
public static Connection getconnection () throws exception {
Connection conn = null;
Class.forName ("Com.mysql tutorial. Jdbc.driver");
conn = Drivermanager.getconnection ("Jdbc:mysql://localhost:3306/test?user", "root", "123456");
Return conn;
}
public static void SetConnection (Connection conn) {
conn = null;
}
}