import java.sql.*;

public class MysqlConnect{
	public static void main(String[] args) {
		System.out.println("MySQL Connect Example.");
		Connection conn = null;
		String url = "jdbc:mysql://localhost:3306/";
		String dbName = "stock1";
		String driver = "com.mysql.jdbc.Driver";
		String userName = "root";
		String password = "alaaelamin";
		ResultSet r ;
		Statement s = null;
		try {
			Class.forName(driver).newInstance();
			conn = DriverManager.getConnection(url+dbName,userName,password);

			System.out.println("Connected to the database");

			r = s.executeQuery("alaaelamin");

			while (r.next()) {
			String y = r.getString("name");
			String x = r.getString("age");
			String z = r.getString("car");
			Statement stmt = conn.createStatement(
			ResultSet.TYPE_SCROLL_INSENSITIVE,
			ResultSet.CONCUR_READ_ONLY);
			ResultSet rs;
			System.out.println(y);
			System.out.println(x);
			}

			conn.close();
			System.out.println("Disconnected from database");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}