当然可以啊
给你个例子看看吧:
public List getDateBegin(ConditionCommand conditionCommand) {
List list = null;
Session session = null;
try {
session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction(); StringBuffer SqlStr = new StringBuffer(
"SELECT to_char(datebegin,'yyyy-mm-dd') FROM (select distinct datebegin from TimePeriodDisplay where areaNo=");
SqlStr.append(conditionCommand.getAreaNo());
SqlStr.append(" AND audienceno='");
SqlStr.append(conditionCommand.getAudienceNo());
SqlStr.append("' AND timepreiod='");
SqlStr.append(conditionCommand.getTimePeriodNo());
SqlStr.append("' AND dateperiod='");
SqlStr.append(conditionCommand.getDatePeriodNo());
SqlStr.append("' AND modelno='");
SqlStr.append(conditionCommand.getModelNo());
SqlStr.append("' order by datebegin) where rownum=1");
list = session.createSQLQuery(SqlStr.toString()).list();
} catch (HibernateException he) {
session.getTransaction().rollback();
System.err.println(he.getMessage());
System.err.println("错误发生在TPResultManager.java(getWeekOrder())");
}
return list;
}
HibernateUtil如下写成了一返回sessionFactory的公共类
public class HibernateUtil
{
private static final SessionFactory sessionFactory; static
{
try
{
// Create the SessionFactory from hibernate.cfg.xml
sessionFactory = new Configuration().configure()
.buildSessionFactory();
}
catch (Throwable ex)
{
// Make sure you log the exception, as it might be swallowed
System.err
.println("Initial SessionFactory creation failed." + ex);
throw new ExceptionInInitializerError(ex);
}
} public static SessionFactory getSessionFactory()
{
return sessionFactory;
}
}
给你个例子看看吧:
public List getDateBegin(ConditionCommand conditionCommand) {
List list = null;
Session session = null;
try {
session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction(); StringBuffer SqlStr = new StringBuffer(
"SELECT to_char(datebegin,'yyyy-mm-dd') FROM (select distinct datebegin from TimePeriodDisplay where areaNo=");
SqlStr.append(conditionCommand.getAreaNo());
SqlStr.append(" AND audienceno='");
SqlStr.append(conditionCommand.getAudienceNo());
SqlStr.append("' AND timepreiod='");
SqlStr.append(conditionCommand.getTimePeriodNo());
SqlStr.append("' AND dateperiod='");
SqlStr.append(conditionCommand.getDatePeriodNo());
SqlStr.append("' AND modelno='");
SqlStr.append(conditionCommand.getModelNo());
SqlStr.append("' order by datebegin) where rownum=1");
list = session.createSQLQuery(SqlStr.toString()).list();
} catch (HibernateException he) {
session.getTransaction().rollback();
System.err.println(he.getMessage());
System.err.println("错误发生在TPResultManager.java(getWeekOrder())");
}
return list;
}
HibernateUtil如下写成了一返回sessionFactory的公共类
public class HibernateUtil
{
private static final SessionFactory sessionFactory; static
{
try
{
// Create the SessionFactory from hibernate.cfg.xml
sessionFactory = new Configuration().configure()
.buildSessionFactory();
}
catch (Throwable ex)
{
// Make sure you log the exception, as it might be swallowed
System.err
.println("Initial SessionFactory creation failed." + ex);
throw new ExceptionInInitializerError(ex);
}
} public static SessionFactory getSessionFactory()
{
return sessionFactory;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货