Hibernate createSQLQuery usage operation function result

Write down the problems encountered

The createSQLQuery operation in Hibernate.

1. Return a value, which can be a field in the table or a function value through calculation.

$

Public int getmaxReuslt (){

Object score = getSession (). createSQLQuery ("select max (score) as maxresult from result"). addScalar ("maxresult", Hibernate. INTEGER). uniqueResult ();

Return Integer. parseInt (score. toStrnig ());

}

$

Public String getmaxReuslt (){

String name = getSession (). createSQLQuery ("select name from result"). addScalar ("name", Hibernate. STRING). uniqueResult ();

Return name. toString ();

}

2. The operation result is the affected function (Update, insert)

Public boolean changVIP (int yyryid, int dpid ){
Int falgs = getSession (). createSQLQuery ("update zrdpxx set belongs =" + yyryid + "where dpxx_Id =" +dpid).exe cuteUpdate ();
If (falgs> 0 ){
Return true;
}
Return false;
}