public String getRidBySubjectID(String subject_ID)
{
String R_id=null;
List list=getSessionFactory().getCurrentSession().createSQLQuery("SELECT r_ID FROM syysjlsubjectlink where subject_ID='"+subject_ID+"' ").addScalar("r_ID",StandardBasicTypes.STRING).list();
for(Iterator iterator = list.iterator();iterator.hasNext();){
Object tempBean=(Object) iterator.next();
R_id=(String) tempBean;
}
return R_id;
}