问题描述: 我有一张表,分别有三个字段: 工单编号、工单内容、工单时间现在想做一个需求,根据工单编号来查询,工单编号是16位,输入工单编号,查询出对应工单的相应信息
public abstract Dispatchchild queryById(Long id); //根据工单编号查询
@Override
public Dispatchchild queryById(Long id){
Dispatchchild dispatchchild=new Dispatchchild();
Session s=HibernateUtil.getSessionFactory().getCurrentSession();
s.beginTransaction(); hql="from Dispatchchild d where d.disp_id=?";
Query q=s.createQuery(hql);
// q.setString(0,id);
q.setLong(0, id);
List<Dispatchchild> list=q.list();
Iterator it=list.iterator();
if(it.hasNext()){
dispatchchild=(Dispatchchild)it.next();
}
s.getTransaction().commit();
return dispatchchild;
}
public abstract Dispatchchild queryById(Long id); //根据工单编号查询
@Override
public Dispatchchild queryById(Long id){
Dispatchchild dispatchchild=new Dispatchchild();
Session s=HibernateUtil.getSessionFactory().getCurrentSession();
s.beginTransaction(); hql="from Dispatchchild d where d.disp_id=?";
Query q=s.createQuery(hql);
// q.setString(0,id);
q.setLong(0, id);
List<Dispatchchild> list=q.list();
Iterator it=list.iterator();
if(it.hasNext()){
dispatchchild=(Dispatchchild)it.next();
}
s.getTransaction().commit();
return dispatchchild;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货