MySQLTest

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;


public class MySQLTest {
    private Connection connect = null;
    private Statement statement = null;
    private static String MYSQL_HOST = "hostname";
    private static String MYSQL_DB = "db";
    private static String MYSQL_TABLE = "table";
    private static String MYSQL_USER = "user";
    private static String MYSQL_PASSWORD = "password";


    public MySQLTest() throws ClassNotFoundException, SQLException
    {
        Class.forName("com.mysql.jdbc.Driver");
        connect = (Connection) DriverManager.getConnection("jdbc:mysql://" + MYSQL_HOST + "/" + MYSQL_DB + "?user=" + MYSQL_USER + "&password=" + MYSQL_PASSWORD);
    }

    public void getResults() throws SQLException
    {
        statement = (Statement) connect.createStatement();
        printMyResults(statement.executeQuery("SELECT * from `" + MYSQL_DB + "`.`" + MYSQL_TABLE + "`"));
        connect.close();
    }

    private void printMyResults(ResultSet result_set) throws SQLException
    {
        long i = 1;
        if(result_set != null)
        {
            while (result_set.next())
            {
                System.out.println(i++ + ".: " + result_set.getString("descr") + "\r\n\r\n");
            }
            result_set.close();
        }
    }
}