Snippets

Ettar Java - JDBC

Created by Ettar
import java.sql.*;

public class ExtensionCheck {
	public static boolean checkLegitimacy() {
		Connection connect = null;
        Statement statement = null;
        ResultSet resultSet = null;
        Boolean returnBool=false;
        String user = "bukkit";
        String password = "";
        String databaseName = "mccrafteriv_plugins_webserver";
        String connectionString;
        String testIP="192.168.0.1";
        
        
        try {
       	    connectionString = "jdbc:mysql://localhost/" + datName + "?" + "user="+user+"";
            connect = DriverManager.getConnection(connectionString);

            statement = connect.createStatement();
            resultSet=statement.executeQuery("SELECT * FROM mccrafteriv_plugins_webserver WHERE server_address='"+testIP+"'");
            if(resultSet.last()) {
                returnBool=true;
            }
            else {
                System.out.println("Datensatz nicht vorhanden");
            }
        }
        catch(Exception e) {
       	    e.printStackTrace();
        }
        finally {
            try {
			    connect.close();
		    } catch (SQLException e) {
			    e.printStackTrace();
		    }
        }
        return returnBool;
	}
}

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.