public boolean addFriendConnection(String user1, String user2) {
String insert_into_table =
"INSERT INTO " + Constant.FRIENDS_TABLE + " (userid, friendid) " + "VALUES (?, ?)";
// insert_into_table = "insert into friends (userid,friendid) values (2,3)";
try {
Connection con = cp.getConnectionFromPool();
System.out.println("here1");
// get userid's from usernames
int user_id = getUserId(con, user1); // get id from user1
System.out.println("here2");
int friend_id = getUserId(con, user2); // get id from user2
PreparedStatement ps = con.prepareStatement(insert_into_table);
ps.setInt(1, user_id);
ps.setInt(2, friend_id);
System.out.println("here3");
// PreparedStatement ps = con.prepareStatement(insert_into_table);
if (user_id != 0 && friend_id != 0) ps.executeUpdate();
cp.returnConnectionToPool(con);
} catch (SQLException e) {
System.out.println("Friend SQL Exception");
} catch (Exception e) {
System.out.println("Friend Other Exception");
}
return true;
}
