query = conn.prepareStatement("select PC_PARTS_PK, PC_PARTS_TITLE, PC_PARTS_CODE, PC_PARTS_MAKER, PC_PARTS_AVAIL, PC_PARTS_DESC " +
"from PC_PARTS");
ResultSet rs = query.executeQuery();
json = converter.toJSONArray(rs);
query.close(); //close connection
}
catch(SQLException sqlError) {
sqlError.printStackTrace();
return json;