package auskey.manager.data;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class CallStoredProcedure {
public ArrayList geLilstRelationship(){
	Connection con = null;
	ArrayList relationships = new ArrayList();
	try {
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //com.microsoft.sqlserver.jdbc.SQLServerDrive
		try {
			//con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;" + "databaseName=AusKRegDB;UserName=AuthAppUser;password=myexreallySux2");
			con = DriverManager.getConnection("jdbc:sqlserver://10.244.53.67:1433;" + "databaseName=AuthAppData;UserName=AuthAppUser;password=myexreallySux2");
			CallableStatement relationshipList_stmt = con.prepareCall("{call dbo.spnTestUserCredentialsList(22550793903)}");
			ResultSet rs = relationshipList_stmt.executeQuery();
			while(rs.next()){
				System.out.println(rs.getInt(1));
				relationships.add(rs.getInt(1));

			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return relationships;

}
}