具体怎么写 还有怎么建hbm.xml文件 能说一下吗 小弟感激不尽
我orcale的函数是
f_dm_getteam(?,f_dm_getshift(?)) 取出来的只有一个team 是String类型的 数据库里面是varchar2类型的
最好能有个实例 谢谢
我orcale的函数是
f_dm_getteam(?,f_dm_getshift(?)) 取出来的只有一个team 是String类型的 数据库里面是varchar2类型的
最好能有个实例 谢谢
解决方案 »
- Spring过滤器
- 小公司里前台也要自己做吗?
- 有关于做购物网站的jsp书吗?推荐几本
- 欠套在jsf标签的a4j event事件和他本身的事件同时需要用时怎么办?
- 关于ASP+AJAX显示乱码的问题,请教一下大家
- 如何在运行时找到JAR包中特定目录下的一些文件
- webservice cxf
- 配置SQLSERVER200数据源错误:Name jdbc is not bound in this Context,请帮忙?
- 在weblogic8中配置for sqlserver2000连接池的问题
- Struts中的form有个属性per,怎么限制它只能输入数字
- hibernate配置c3po连接池后:无法使用jdbc查询?报错Operation not allowed after ResultSet closed
- poi3.7 读取excel2007 问题
if (session == null) {
// 未连接数据库
}String SQL = "select * from table where f_dm_getteam(?,f_dm_getshift(?))"; Query query = session.createSQLQuery(SQL);
query.setString(0, strLoginID);
query.setString(1, strPassword);
List list = query.list();if (!list.isEmpty()) {
Object obj=list.get(0);
}
木有传说中的HibernateSessionFactory类啊
你的dao打开看,里面有什么方法?怎么操作数据库的?如果是hibernateTemplate.get() ,hibernateTemplate.load()...那么使用这个方法 hibernateTemplate.execute(new HibernateCallback(){}) hibernateTemplate.execute(new HibernateCallback(){})会自动让你添加实现,用里面的doInibernate实现调用JDBC或者纯Hibernate代码
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution. Follows the Thread Local Session
* pattern, see {@link http://hibernate.org/42.html }.
*/
public class HibernateSessionFactory { /**
* Location of hibernate.cfg.xml file.
* Location should be on the classpath as Hibernate uses
* #resourceAsStream style lookup for its configuration file.
* The default classpath location of the hibernate config file is
* in the default package. Use #setConfigFile() to update
* the location of the configuration file for the current session.
*/
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static Configuration configuration = new Configuration();
private static org.hibernate.SessionFactory sessionFactory;
private static String configFile = CONFIG_FILE_LOCATION; static {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
private HibernateSessionFactory() {
}
/**
* Returns the ThreadLocal Session instance. Lazy initialize
* the <code>SessionFactory</code> if needed.
*
* @return Session
* @throws HibernateException
*/
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get(); if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
} return session;
} /**
* Rebuild hibernate session factory
*
*/
public static void rebuildSessionFactory() {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
} /**
* Close the single hibernate session instance.
*
* @throws HibernateException
*/
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null); if (session != null) {
session.close();
}
} /**
* return session factory
*
*/
public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
} /**
* return session factory
*
* session factory will be rebuilded in the next call
*/
public static void setConfigFile(String configFile) {
HibernateSessionFactory.configFile = configFile;
sessionFactory = null;
} /**
* return hibernate configuration
*
*/
public static Configuration getConfiguration() {
return configuration;
}
}