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();
		}
	}
}