Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static String url = "jdbc:mysql://localhost:3306/tbabdl?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
- public static String usr = "root";
- public static String mdp = "";
- public static Connection connection = null;
- public static Statement statement = null;
- public static ResultSet resultSet = null;
- public static ResultSet Robots(String Mod_W_R, String Query, boolean CloseConnection, boolean Debug) {
- /* === MYSQL MOD WRITE === */
- if (Mod_W_R.equalsIgnoreCase("W")) {
- System.out.println("[DatabaseManager:Robots] => Mod:Write");
- System.out.println("[DatabaseManager:Robots] => Mod:Write (INFO) => Query to Execute => " + Query);
- System.out.println("[DatabaseManager:Robots] => Mod:Write (INFO) => Connection");
- try {
- connection = DriverManager.getConnection(url, usr, mdp);
- System.out.println("[DatabaseManager:Robots] => Mod:Write (INFO) => Connection SUCCESS");
- statement = connection.createStatement();
- int status = statement.executeUpdate(Query);
- } catch (SQLException e) {
- System.out.println("[DatabaseManager:Robots] => Mod:Write (INFO) => Connection FAIL");
- e.printStackTrace();
- } finally {
- if (CloseConnection) { //if true
- if (connection != null) {
- System.out.println("[DatabaseManager:Robots] => Mod:Write (INFO) => Closing Connection...");
- DatabaseCloseConnection();
- } else {
- System.out.println("[DatabaseManager:Robots] => Mod:Write (INFO) => Connection return void !");
- }
- }
- }
- /* === MYSQL MOD READ === */
- } else if (Mod_W_R.equalsIgnoreCase("R")) {
- System.out.println("[DatabaseManager:Robots] => Mod:Read");
- System.out.println("[DatabaseManager:Robots] => Mod:Read (INFO) => Connection");
- try {
- connection = DriverManager.getConnection(url, usr, mdp);
- System.out.println("[DatabaseManager:Robots] => Mod:Read (INFO) => Connection SUCCESS");
- statement = connection.createStatement();
- resultSet = statement.executeQuery(Query);
- } catch (SQLException e) {
- System.out.println("[DatabaseManager:Robots] => Mod:Read (INFO) => Connection FAIL");
- e.printStackTrace();
- } finally {
- if (CloseConnection) { //if true
- if (connection != null) {
- System.out.println("[DatabaseManager:Robots] => Mod:Read (INFO) => Closing Connection...");
- DatabaseCloseConnection();
- } else {
- System.out.println("[DatabaseManager:Robots] => Mod:Read (INFO) => Connection return void !");
- }
- }
- }
- } else {
- System.out.println("[DatabaseManager:Robots] ERROR Unknown MOD : '" + Mod_W_R + "' PLEASE USE 'W' OR 'R'");
- return null;
- }
- return resultSet;
- }
- public static void DatabaseCloseConnection() {
- try {
- connection.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement