关于hibernate的hql

来源:互联网 发布:easybcd引导ubuntu 编辑:程序博客网 时间:2024/06/05 21:17

1 关于Query的查询,当查询的条件在javabean中的字段值是object的时候,举例:

public boolean find(Song song, Songsform songsform) {

Session session=null;
session=this.getSessionFactory().getCurrentSession();
Songsformxq songsformxq=new Songsformxq();
/*songsformxq.setSong(song);
songsformxq.setSongsform(songsform);*/
String sql="from Songsformxq sfxq where sfxq.song.id=? and sfxq.songsform.id=?";
Query q=session.createQuery(sql);
q.setInteger(0, song.getId());
q.setInteger(1, songsform.getId());
int a=q.list().size();
if(a>0)
{
return false;
}
return true;

}

2 关于Query插入,利用sql语句实现而并非hql, 举例:

public boolean add(User user,int songId,String shareDate) throws Exception{
boolean b=false;
Session session = this.getSessionFactory().getCurrentSession();
String sql="insert into share (userId,shareDate,songId) values ("+user.getId()+",'"+shareDate+"',"+songId+")";
int a=session.createSQLQuery(sql).executeUpdate();
if(a>0){
b=true;
}
return b;
}

0 0
原创粉丝点击