81,095
社区成员
发帖
与我相关
我的任务
分享
public boolean insetInfo(final UserBean userBean,final int[] depIds) throws Exception {
// TODO Auto-generated method stub
List list= (List)getHibernateTemplate().executeFind(new HibernateCallback(){
public Object doInHibernate(Session session)
throws HibernateException, SQLException{
for (int i = 0 ; i < depIds.length ; i++)
{
String sql ="insert into tbl_user_dep (userId,depId) values(?,?)";
Query query= session.createSQLQuery(sql);
query.setParameter( 0, userBean.getUserId());
query.setParameter( 1, depIds[i]);
query.executeUpdate();
session.flush();
session.clear();
}
Object o = null;
return o;
}
});
return true;
}
sql="";
session.createSQLQuery(sql).list();