// Sample application for JDBC connection to MySql import 

import java.sql.*;
 
public class JdbcTest
{
	public static void main(String[] args)
	{
		try
		{
			// Loading driver class
			Class.forName("org.gjt.mm.mysql.Driver"); // MySQL
 			
 			// Connect to the database
 			Connection con = 
 
			// only for MySQL
			DriverManager.getConnection("jdbc:mysql://localhost/person", "username", "password");
 
 			// Create a statement object
 			Statement stmt = con.createStatement();
 			String sql = "SELECT * FROM employee";
 
 			// Execute the query and get a result
 			ResultSet rs = stmt.executeQuery(sql);
 
 			// Loop with the number of found data
 			while(rs.next())
 			{
 				// Id
 				int id = rs.getInt("id");
 				// name
 				String name = rs.getString("name");
 				// birthday
				String birthday = rs.getString("birthday");
				// memo
				String memo = rs.getString("memo");
				// Desplay data
				System.out.println(id + " " + name + " " + birthday + " " + memo);
			}
			// Disconnect from the database
			stmt.close();
			con.close();
		} catch (Exception e) {
		  e.printStackTrace();
		}
	}
}