CREATE TABLE GROUPSERVER
(
GID NUMBER NOT NULL,
SVRID NUMBER NOT NULL
)public List find(String svrid){
List list = new ArrayList();
String sql = "select gid from groupserver where svrid=:svrid";
Session session = this.getHibernateTemplate().getSessionFactory().openSession();
Transaction tx = null;
try{
tx = session.beginTransaction();
Query qry = session.createSQLQuery(sql);
qry.setString(svrid, svrid);
qry.executeUpdate();
tx.commit();
Iterator it = qry.list().iterator(); while(it.hasNext()){
Object obj[] = (Object[])it.next();
GroupserverBean gb=new GroupserverBean();
gb.setGid(obj[0].toString());
list.add(gb);
}
tx = null;
}catch(Exception e){
log.error("查询错误!");
}finally{
if(tx != null){
tx = null;
}
session.close();
}
return list;
}
报查询错误????????怎么回事
(
GID NUMBER NOT NULL,
SVRID NUMBER NOT NULL
)public List find(String svrid){
List list = new ArrayList();
String sql = "select gid from groupserver where svrid=:svrid";
Session session = this.getHibernateTemplate().getSessionFactory().openSession();
Transaction tx = null;
try{
tx = session.beginTransaction();
Query qry = session.createSQLQuery(sql);
qry.setString(svrid, svrid);
qry.executeUpdate();
tx.commit();
Iterator it = qry.list().iterator(); while(it.hasNext()){
Object obj[] = (Object[])it.next();
GroupserverBean gb=new GroupserverBean();
gb.setGid(obj[0].toString());
list.add(gb);
}
tx = null;
}catch(Exception e){
log.error("查询错误!");
}finally{
if(tx != null){
tx = null;
}
session.close();
}
return list;
}
报查询错误????????怎么回事
qry.setString(svrid, svrid);
这里应该
setInt