Merged pull request #8.v5.2.0

1 files changed, 33 insertions, 0 deletions

diff --git a/src/main/java/com/redstoner/misc/mysql/MysqlQueryHandler.java b/src/main/java/com/redstoner/misc/mysql/MysqlQueryHandler.java
new file mode 100644
index 0000000..f89a08a
--- /dev/null
+++ b/src/main/java/com/redstoner/misc/mysql/MysqlQueryHandler.java
@@ -0,0 +1,33 @@
+package com.redstoner.misc.mysql;
+
+import java.sql.CallableStatement;
+import java.sql.Connection;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+public class MysqlQueryHandler {
+	public static ResultSet queryResult(Connection connection, String query) {
+		try {
+			Statement statement = connection.createStatement();
+			ResultSet results = statement.executeQuery(query);
+			
+			return results;
+		} catch (SQLException e) {
+			e.printStackTrace();
+			return null;
+		}
+	}
+	
+	public static boolean queryNoResult(Connection connection, String query) {
+		try {
+			CallableStatement statement = connection.prepareCall(query);
+			statement.execute();
+			
+			return true;
+		} catch (SQLException e) {
+			e.printStackTrace();
+			return false;
+		}
+	}
+}