Custom SQL for create, update and delete

sameeulla · **Joined:** Tue Nov 16, 2010 9:43 am **Posts:** 19

<class name="Person">
<id name="id">
<generator class="increment"/>
</id>
<property name="name" not-null="true"/>
<sql-insert>INSERT INTO PERSON (NAME, ID) VALUES ( UPPER(?), ? )</sql-insert>
<sql-update>UPDATE PERSON SET NAME=UPPER(?) WHERE ID=?</sql-update>
<sql-delete>DELETE FROM PERSON WHERE ID=?</sql-delete>
</class>

[b] how to call above queries in client application

r · **Joined:** Fri Oct 08, 2010 8:44 am **Posts:** 130

Call "save", "update" or "delete" on your Session object. Sounds like obvious thing to me :O

chirag.naikec · **Posted:** Thu Nov 18, 2010 2:02 am

session.save(Person) - For save
session.update(Person) - For update
session.delete(Person) - For delete

sameeulla · **Joined:** Tue Nov 16, 2010 9:43 am **Posts:** 19

ok, but how to pass values in the placeholders ie (?) from client application

r · **Joined:** Fri Oct 08, 2010 8:44 am **Posts:** 130

Set them in your Person object using field setters.

Code:

person.setName("sameeulla")
session.save(person)

But better read the manual first. Your questions are extremely trivial. You won't be able to program successfully without at least some basic understanding how Java and database mappings work.