@@ -0,0 +1,2604 @@
+package com.leftindust.SimpleJava.sql;%0A%0Aimport java.sql.Connection;%0Aimport java.sql.DriverManager;%0Aimport java.sql.PreparedStatement;%0Aimport java.sql.ResultSet;%0Aimport java.sql.Statement;%0A%0A/**%0A * %0A * Copyright (c) 2015 Daniel Shirvani%0A * %0A * Permission is hereby granted, free of charge, to any person obtaining a copy%0A * of this software and associated documentation files (the %22Software%22), to deal%0A * in the Software without restriction, including without limitation the rights%0A * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell%0A * copies of the Software, and to permit persons to whom the Software is%0A * furnished to do so, subject to the following conditions:%0A * %0A * The above copyright notice and this permission notice shall be included in all%0A * copies or substantial portions of the Software.%0A * %0A * THE SOFTWARE IS PROVIDED %22AS IS%22, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR%0A * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,%0A * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE%0A * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER%0A * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,%0A * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE%0A * SOFTWARE.%0A * %0A * @author Daniel Shirvani%0A * @version 1.0%0A * %0A */%0Apublic class RunSQL %7B%0A%09%0A%09@SuppressWarnings(%22unused%22)%0A%09private Statement st;%0A%09private Connection connection;%0A%09%0A%09/**%0A%09 * Please know that this requires the MySQL JDBC Driver.%5Cn%0A%09 * From here you can run SQL commands to your database from Java%0A%09 * %0A%09 * @param ip The IP Address to the SQL Database%0A%09 * @param username The Username to the SQL Database%0A%09 * @param password The Password of the SQL Database%0A%09 * @param databaseName The Name of The Database%0A%09 */%0A%09public RunSQL(String ip, String username, String password, String databaseName)%7B%0A%09%09try %7B%0A%09%09%09Class.forName(%22com.mysql.jdbc.Driver%22);%0A%09%09%09connection = DriverManager.getConnection(%22jdbc:mysql://%22+ip+%22/%22+databaseName+%22?user=%22+username+%22&password=%22+password);%0A%09%09%09%0A%09%09%09st = connection.createStatement();%0A%09%09%7D catch (Exception e) %7B%0A%09%09%09e.printStackTrace();%0A%09%09%09%0A%09%09%09System.err.println(%22%5Cn%5CnPlease note that this requires the MySQL JDBC Driver!%22);%0A%09%09%7D%0A%09%7D%0A%09%0A%09public ResultSet runSQL(String command)%7B%0A%09%09try %7B%0A%09%09%09PreparedStatement statement = connection.prepareStatement(command);%0A%09%09%09ResultSet result = statement.executeQuery();%0A%09%09%09%0A%09%09%09if(!result.next())%7B%0A%09%09%09%09System.err.println(%22No Result!%22);%0A%09%09%09%7D%0A%09%09%09%0A%09%09%09return result;%0A%09%09%7D catch (Exception e) %7B%0A%09%09%09e.printStackTrace();%0A%09%09%7D%0A%09%09return null;%0A%09%7D%0A%7D%0A%0A%0A

Create RunSQL.java