package innerClass;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnectionDriver {

	public static void main(String[] args) {
		// get connection to database
		try {
			Connection conn = ConnectionManager.getMySQLConnection();
			String query = "select word from popular_words where word regexp 'z'";
			Statement statement = conn.createStatement();
			ResultSet rs = statement.executeQuery(query);	
	        while (rs.next())  {
            	System.out.println(rs.getString("word"));
	        }
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
		
	}

}