summaryrefslogtreecommitdiff
path: root/src/main/java/com/redstoner/misc/mysql/MysqlQueryHandler.java
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/java/com/redstoner/misc/mysql/MysqlQueryHandler.java')
-rw-r--r--src/main/java/com/redstoner/misc/mysql/MysqlQueryHandler.java33
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;
+ }
+ }
+}