import java.sql.*;
import java.util.*;

public class Driver {
	public static void main(String args[]){
		Scanner sc = new Scanner(System.in);
		System.out.print("Enter a students ID: ");
		int SID = sc.nextInt();
		System.out.println("You entered " + SID);


		ConnTime(SID);
	}

	private static void ConnTime(int _SID) {
		// TODO Auto-generated method stub
		try{
			Class.forName("com.mysql.jdbc.Driver");
			Connection con=DriverManager.getConnection(
			"jdbc:mysql://localhost:3306/fuented2","fuented2","`}410aD*KB4");
			//here sonoo is database name, root is username and password
			String query = ("select * from transcript");
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery(query);
			//print student

			System.out.println("************TRANSCRIPT************");
			while(rs.next())
			if(rs.getInt(1) == _SID)
			{
				System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getString(5)+"\t"+rs.getString(6));
			}

			//run second query
			float output = 0;
			CallableStatement stmt2 = con.prepareCall(("{CALL calculateGPA(?, ?)}"));
			stmt2.setInt(1,_SID);
			stmt2.registerOutParameter(2, Types.FLOAT);
			stmt2.execute();
			output = stmt2.getFloat(2);
			//ResultSet rs2 = stmt2.executeQuery(query2);

			System.out.println("STUDENT GPA: " + output);
			con.close();
			}catch(Exception e){ System.out.println(e);}
	}

}