Java codepackage csdn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MySQLDB {
public static Connection getConnection() {
Connection conn = null;
try {
String driver = "com.mysql.jdbc.Driver";
String dbURL = "jdbc:mysql://localhost:3306/DB?useUnicode=true&characterEncoding=UTF-8";
String username = "root";
String password = "";
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(dbURL, username, password);
} catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return conn;
}
public static boolean closeConnection(Connection conn) {
try {
conn.close();
return true;
} catch (SQLException e) {
e.printStackTrace();
return false;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}
}