Hibernate返回一个实体

最新推荐文章于 2022-10-12 21:24:37 发布

ouou009

最新推荐文章于 2022-10-12 21:24:37 发布

阅读量248

点赞数

文章标签： java 运维

本文链接：https://blog.csdn.net/ouou009/article/details/84175736

版权

@Override
public ExistedSystem getExistedSystemByName(String existedSystemName)
{
String hql = "select * from tbl_existed_system where name = {0}";
final String formathql = MessageFormat.format(hql, "'" + existedSystemName + "'");
ExistedSystem ret = (ExistedSystem)getHibernateTemplate().executeWithNewSession(new HibernateCallback()
{

@Override
public Object doInHibernate(Session session)
throws SQLException
{
ExistedSystem existedSystem = new ExistedSystem();
Object[] next = (Object[])session.createSQLQuery(formathql).uniqueResult();
Project project = new Project();
project.setProjectId((Integer)next[0]);
existedSystem.setProject(project);
existedSystem.setServerId((Integer)next[1]);

existedSystem.setName(next[Constants.TWO].toString());
existedSystem.setDescription(next[Constants.THREE].toString());
existedSystem.setModel(next[Constants.FOUR].toString());
existedSystem.setProcessorFamily(next[Constants.FIVE].toString());
existedSystem.setCpuCores((Short)next[Constants.SIX]);
existedSystem.setCpuCoreSpeed((Short)next[Constants.SEVEN]);
existedSystem.setMemoryCapacity((Float)next[Constants.EIGHT]);
existedSystem.setDiskIoCapacity((Float)next[Constants.NINE]);
existedSystem.setNetworkIoCapacity((Float)next[Constants.TEN]);
existedSystem.setOs(next[Constants.ELEVEN].toString());
existedSystem.setType((Short)next[Constants.TWELVE]);
return existedSystem;
}
});

return ret;
}

/** {@inheritDoc} */