private void constructDissertation(JSONObject object, Connection conn) {
		PreparedStatement prep = null;	
        JSONArray dissertArr = null;
        try {
            dissertArr = object.getJSONArray("Dissertation Info");
        } catch(Exception ex) {
            ex.printStackTrace();
        }
        
        if(dissertArr != null && dissertArr.length() > 0) {
            try {
                for(int i = 0; i < dissertArr.length(); i++) {                	
                	JSONObject each = dissertArr.getJSONObject(i);
                    String title = each.getString("dissertation");
                    int author = object.getInt("id");            
                    String university = each.getString("institution");
                    String year = each.getString("year");
                    
                    prep = conn.prepareStatement("insert into dissertation (author, title, university, year) values(?,?,?,?) ;", Statement.RETURN_GENERATED_KEYS);
        			prep.setInt(1, author);
        			prep.setString(2, title);
        			prep.setString(3, university);
        			prep.setString(4, year);
        			prep.execute();
        			prep.close();
        			
        			int student = 0;
        			ResultSet rs = conn.prepareStatement("SELECT currval('dissertation_did_seq');").executeQuery();
        			if (rs.next()) {
        				student = rs.getInt(1);
        			}
        			
        			String advisors = each.getString("advisors");
        			if (!advisors.equals("")) {
        			    String[] tmp = advisors.split(","); 
        			    int len = tmp.length;
        			
        				int advOrder = 1;
                        for(int j = 0; j < len; j++) {
                            int advId = Integer.valueOf(tmp[j]);
                            prep = conn.prepareStatement("insert into advised values(?,?,?);");
                            prep.setInt(1, student);
                			prep.setInt(2, advOrder);
                			prep.setInt(3, advId);
                			prep.execute();
                			prep.close();
                            advOrder += 1;
                        }
                 
        			}
                }
            }catch(Exception ex) {
                ex.printStackTrace();
            }
        }
    }