package edu.unca.cs.csci343;

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

/**
 *
 * @author J Dean Brock <brock@unca.edu>
 */
public class ListFriends {

    private static String jdbcDriver = "com.mysql.jdbc.Driver" ;

    private static String connectionName = 
	"jdbc:mysql://joe.cs.unca.edu/socialDB" ;
    private static String connectionUser = "csci343" ;
    private static String connectionPassword = "" ;

    private static final String sqlDBquery =
            "SELECT A.name, B.name " +
            "FROM Highschooler A, Highschooler B, Friend F " +
            "WHERE A.ID = F.ID1 AND B.ID = F.ID2 AND A.name < B.name ;" ;

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws ClassNotFoundException {
        Class.forName(jdbcDriver) ;
        try {
            Connection sqlDBconn = 
		DriverManager.getConnection(connectionName,
                        connectionUser, connectionPassword) ;
            Statement sqlDBstmt = sqlDBconn.createStatement() ;
            ResultSet sqlDBresults = sqlDBstmt.executeQuery(sqlDBquery) ;
            while(sqlDBresults.next()) {
                System.out.format("Friends:   %-10s & %-10s\n",
                        sqlDBresults.getString(1), sqlDBresults.getString(2)) ;
            }
        } catch (SQLException sqlx) {
            System.err.println(sqlx);
        }
    }
}