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

public class DBConnect {
	private Connection con = null;
	public Statement st = null;
	private ResultSet rs = null;

	public DBConnect() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection("jdbc:mysql://localhost/test", "root", "");
			st = con.createStatement();
			System.out.println("Build It");

		} catch (Exception e) {
			// TODO: handle exception
			System.out.println("Error " + e);
		}
	}

	public void getData() {
		try {
			String query = "SELECT * FROM persons";
			rs = st.executeQuery(query);
			System.out.println("Record From Database");
			while (rs.next()) {
				String name = rs.getString("name");
				int age = rs.getInt("age");
				System.out.println(name + " " + age);
			}

		} catch (Exception e) {
			// TODO: handle exception
			System.out.println("Error" + e);
		}
	}

}