public boolean createPath(Path path, int requestId, int userId, int projectId) throws RemoteException, SQLException { ResultSet result = connection .createStatement() .executeQuery( "select count(*) from logs where requestId = " + requestId + " and userId = " + userId); if (result.getInt(1) == 0 || requestId == 0) { result = connection .createStatement() .executeQuery( "select id from paths where Name = \"" + path.getName() + "\" and projectId = " + projectId); if (result.next()) return false; result = connection .createStatement() .executeQuery( "select * from administrators where userId = " + userId + " and projectId= " + projectId); if (!result.next()) return false; connection .createStatement() .execute( "insert into paths (Name, Description, ProjectId) values (\"" + path.getName() + "\", \"" + path.getDescription() + "\", " + projectId + ")"); connection .createStatement() .execute( "insert into logs (UserId, RequestId, Response) values (" + userId + ", " + requestId + ", 1)"); return true; } else { result = connection .createStatement() .executeQuery( "select response from logs where requestId = " + requestId + " and userId = " + userId); return result.getBoolean(1); } }