Query Operation on Repository in ATG:
Four Operations:

• Insert
• View
• Update
• Delete

Consider the four variables am using for repository operation
String employeeName;
String employeeAge;
Repository connection;- am using profileAdaptorRepository

UserProfile.xml
<item-descriptor name="employees"
<table name="employee" type="primary" id-column-name="ids">
<property name="Names column-name="name" data-type="string" xml-combine="remove" />
<property name="ages" column-name="age" data-type="string" />
</table>




Insert:

MutableRepository obj=(MutableRepository) getConnection();
MutableRepositoryItem repobj=obj.createItem("employees");   employees - itemdescriptorName
repobj.setPropertyValue("Names", getEmployeeName());
repobj.setPropertyValue("ages", getEmployeeAge());
obj.addItem(repobj);

Update:

MutableRepository obj=(MutableRepository)getConnection();
MutableRepositoryItem repobj=obj.getItemforUpdate(repositoryid,"employees");
repobj.setPropertyValue("Names",  getEmployeeName());
obj.updateItem(repobj);

View:

MutableRepository obj=(MutableRepository)getConnection();
RepositoryView robj=obj.getView("employees");
RqlStatement st=RqlStatement.parseRqlStatement("id=?0");
Object params[]={"10001"}; or get this values from jsp using getters()
RepositoryItem [] items =st.executeQuery(robj,params);

//gettting the name for the corresponding property
String Emp_name=(String) items[0].getPropertyValue("Names");

Delete:

MutableRepository obj=(MutableRepository) getConnection();
obj.removeItem(repositoryid,"employees");