package net.xtraordinayr.mysqldemo;

import java.sql.*;

public class DemoDriver {

	public static void main(String[] args) {
		try{
			// Load the driver
			Class.forName("com.mysql.jdbc.Driver");
			
			// 1. Get a connection to the database
			Connection mySqlConn = 
					DriverManager.getConnection("jdbc:mysql://localhost:3306/starfleetacademydb", "root", "ncc_1701-f");
			
			// 2. Create a statement
			Statement demoQuery = mySqlConn.createStatement();
			
			// 3. Execute SQL query
			ResultSet mySqlRs = demoQuery.executeQuery("SELECT * FROM student_table");
			
			// 4. Process the result set
			System.out.println(mySqlRs.getString("rankID") + " " +
					mySqlRs.getString("lastName") + " " +
					mySqlRs.getString("firstName"));
		}
		catch(Exception ex){
			ex.printStackTrace();
		}

	}

}