CREATE TABLE IF NOT EXISTS `testtable` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `age` INT(11) NOT NULL,
  `city` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
 
INSERT INTO `testtable` (`id`, `name`, `age`, `city`) VALUES
(1, 'Mr. John Doe', 31, 'Groningen'),
(2, 'Mrs. Jane Doe', 31, 'Groningen');

/**
 * @author tomkeur
 */
import java.sql.*;
 
public class MySQLDatabase {
	public static void main(String[] args) {
		Connection conn = null;
 
		try {
			// SETTINGS: userName, passWord and dataBase.
			String userName = "root";
			String passWord = "";
			String dataBase = "test";
 
			// Creating class.
			Class.forName("com.mysql.jdbc.Driver").newInstance();
 
			// Let's create a connection.
			conn = DriverManager.getConnection("jdbc:mysql:///"+dataBase, userName, passWord);
 
			// Do we have a connection?
			if (!conn.isClosed())
			{
				// We have a MySQL Connection.
				Statement s = conn.createStatement ( );
				s.executeQuery ("SELECT * FROM testtable");
				ResultSet rs = s.getResultSet ( );
				while (rs.next()) // loop through rows of result set
				{
					int pkey = rs.getInt (1);
					String strName = rs.getString(2);
					int intAge = rs.getInt(3);
					String strCity = rs.getString(4);
					System.out.println ("uID: " + pkey + ", Name: " + strName + ", Age: " + intAge + ", City: " + strCity );
				}
				rs.close(); // close result set
				s.close(); // close statement
			}
		}
		catch (Exception e)
		{
			System.err.println("Exception: " + e.getMessage());
		}
		finally
		{
			// If we don't have a error, close the connection!
			try
			{
				if (conn != null)
				{
					conn.close();
				}
			}
			catch (SQLException e)
			{
 
			}
		}
	}
 
}