MySqlManager.java

package org.pokenet.chat.server;

/*
 * Simple MySQL Java Class
 * Makes it similair to PHP
 */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 * Handles MySql connections
 * @author Daniel Morante
 */
public class MySqlManager {
    private Connection mysql_connection;
    private ResultSet mysql_result;    
    private String mysql_connectionURL;
    
    /**
     * Connects to the server. Returns true on success.
     * @param server
     * @param username
     * @param password
     * @return
     */
    public boolean connect(String server, String username, String password) {
        try {
            //Open Connection
            mysql_connectionURL = "jdbc:mysql://" + server+"?autoReconnect=true";
            mysql_connection = DriverManager.getConnection(mysql_connectionURL, username, password);
            if(!mysql_connection.isClosed())
            	return true;
            else
            	return false;
        } catch( Exception x ) {
          x.printStackTrace();
          return false;
        }
    }
    
    /**
     * Selects the current database. Returns true on success
     * @param database
     * @return
     */
    public boolean selectDatabase(String database) {
    	try {
        	Statement stm = mysql_connection.createStatement();
        	stm.executeQuery("USE " + database);
        	return true;
    	} catch (Exception e) {
    		e.printStackTrace();
    		return false;
    	}
    }
    
    /**
     * Closes the connection to the mysql server. Returns true on success.
     * @return
     */
    public boolean close(){
        try{
            mysql_connection.close();
            mysql_connection = null;
            return true;
        }
        catch (Exception x) {
             x.printStackTrace();
             return false;
        }
    }
    
    /**
     * Returns a result set for a query
     * @param query
     * @return
     */
    public ResultSet query(String query){
        //Create Statement object
        Statement stmt;
        
        /*
         * We want to keep things simple, so...
         *
         * Detect whether this is an INSERT, DELETE, or UPDATE statement      
         * And use the executeUpdate() function
         *
         * Or...
         * 
         * Detect whether this is a SELECT statement and use the executeQuery()
         * Function. 
         * 
        */  
        
        if (query.startsWith("SELECT")) {
            //Use the "executeQuery" function because we have to retrieve data
            //Return the data as a resultset
            try{
                //Execute Query
                stmt = mysql_connection.createStatement();
                mysql_result = stmt.executeQuery(query);
            }
            catch(Exception x) {
            	mysql_result = null;
                x.printStackTrace();
            }
            
            //Return Result
            return mysql_result;
        }
        else {
            //It's an UPDATE, INSERT, or DELETE statement
            //Use the"executeUpdaye" function and return a null result
            try{
                //Execute Query
                stmt = mysql_connection.createStatement();
                stmt.executeUpdate(query);
            }
            catch(Exception x) {
                x.printStackTrace();
            }
            
            //Return nothing
            return null;
        }
    }    
    
    /**
     * Returns a sql-safe string
     * @param text
     * @return
     */
    public static String parseSQL(String text)
	{
		try {
			if(text == null) text = "";
			text = text.replace("'", "''");
			text = text.replace("\\", "\\\\");
		} catch (Exception e) {}
		return  text;
	}
}