- 浏览: 175918 次
- 性别:
- 来自: 沈阳
文章分类
最新评论
-
Cash:
今日测试微信服务器,搭建tomcat8.0.9时,发布的ser ...
Tomcat 主机部署 -
Cash:
追加网通ip段:在网上没有公布出来222.128.0.0 25 ...
双ISP出口用到的ip地址表
package springWebwork2;
import net.sf.hibernate.*;
import org.apache.commons.logging.*;
import java.util.*;
import java.io.*;
import net.sf.hibernate.cfg.Configuration;
import showHelper.block.*;
public class HibernateUtil {
private static Log log = LogFactory.getLog(HibernateUtil.class);
private static final SessionFactory sessionFactory;
static {
try {
// Create the SessionFactory
Configuration conf= new Configuration().configure(new File("hibernate.cfg.xml"));
sessionFactory = conf.buildSessionFactory();
} catch (Throwable ex) {
log.error("创建SessionFactory失败:", ex);
throw new ExceptionInInitializerError(ex);
}
}
//使用ThreadLocal实现线程安全
public static final ThreadLocal LocalSession = new ThreadLocal();
public static Session currentSession() throws HibernateException {
Session s = (Session) LocalSession.get();
// Open a new Session, if this Thread has none yet
if (s == null) {
s = sessionFactory.openSession();
LocalSession.set(s);
}
return s;
}
public static void closeSession() throws HibernateException {
Session s = (Session) LocalSession.get();
LocalSession.set(null);
if (s != null)
s.close();
}
//测试代码
public static void main(String[] args) throws Exception {
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
//创建数据对象并插入表
Block B = new Block();
//B.setBlockname("浑南新区");
//B.setShoworder(0);
//相当于insert
//session.save(B);
//用list方法查询数据
String Sql="from Block as block1 order by block1.Showorder";
Query q = session.createQuery(Sql); //用对象类名,而非表名
List l = q.list();//返回一个List接口,用来遍历结果集
for (int i = 0; i < l.size(); i++) {
B = (Block) l.get(i);
System.out.println(B.getId()+" "+B.getBlockname()); }
//更新数据
//Query qq = session.createQuery("from SimpleUser");
//B = (Block) session.load(Block.class, new Integer(1));
//B.setBlockname("其它");
//tx.commit();
//关闭
HibernateUtil.closeSession();
}
}
----------------------------------------------------------------------------------
配置文件 hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- local connection properties -->
<property name="hibernate.connection.url">
jdbc:postgresql://192.168.1.3/datebasename </property>
<property name="hibernate.connection.driver_class">
org.postgresql.Driver
</property>
<property name="hibernate.connection.username">postgres</property>
<property name="hibernate.connection.password">123456</property>
<!-- property name="hibernate.connection.pool_size"></property -->
<!-- dialect for PostgreSQL -->
<property name="dialect">
net.sf.hibernate.dialect.PostgreSQLDialect
</property>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.transaction.factory_class">
net.sf.hibernate.transaction.JDBCTransactionFactory
</property>
<mapping resource="showHelper/Block.hbm" />
</session-factory>
</hibernate-configuration>
import net.sf.hibernate.*;
import org.apache.commons.logging.*;
import java.util.*;
import java.io.*;
import net.sf.hibernate.cfg.Configuration;
import showHelper.block.*;
public class HibernateUtil {
private static Log log = LogFactory.getLog(HibernateUtil.class);
private static final SessionFactory sessionFactory;
static {
try {
// Create the SessionFactory
Configuration conf= new Configuration().configure(new File("hibernate.cfg.xml"));
sessionFactory = conf.buildSessionFactory();
} catch (Throwable ex) {
log.error("创建SessionFactory失败:", ex);
throw new ExceptionInInitializerError(ex);
}
}
//使用ThreadLocal实现线程安全
public static final ThreadLocal LocalSession = new ThreadLocal();
public static Session currentSession() throws HibernateException {
Session s = (Session) LocalSession.get();
// Open a new Session, if this Thread has none yet
if (s == null) {
s = sessionFactory.openSession();
LocalSession.set(s);
}
return s;
}
public static void closeSession() throws HibernateException {
Session s = (Session) LocalSession.get();
LocalSession.set(null);
if (s != null)
s.close();
}
//测试代码
public static void main(String[] args) throws Exception {
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
//创建数据对象并插入表
Block B = new Block();
//B.setBlockname("浑南新区");
//B.setShoworder(0);
//相当于insert
//session.save(B);
//用list方法查询数据
String Sql="from Block as block1 order by block1.Showorder";
Query q = session.createQuery(Sql); //用对象类名,而非表名
List l = q.list();//返回一个List接口,用来遍历结果集
for (int i = 0; i < l.size(); i++) {
B = (Block) l.get(i);
System.out.println(B.getId()+" "+B.getBlockname()); }
//更新数据
//Query qq = session.createQuery("from SimpleUser");
//B = (Block) session.load(Block.class, new Integer(1));
//B.setBlockname("其它");
//tx.commit();
//关闭
HibernateUtil.closeSession();
}
}
----------------------------------------------------------------------------------
配置文件 hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- local connection properties -->
<property name="hibernate.connection.url">
jdbc:postgresql://192.168.1.3/datebasename </property>
<property name="hibernate.connection.driver_class">
org.postgresql.Driver
</property>
<property name="hibernate.connection.username">postgres</property>
<property name="hibernate.connection.password">123456</property>
<!-- property name="hibernate.connection.pool_size"></property -->
<!-- dialect for PostgreSQL -->
<property name="dialect">
net.sf.hibernate.dialect.PostgreSQLDialect
</property>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.transaction.factory_class">
net.sf.hibernate.transaction.JDBCTransactionFactory
</property>
<mapping resource="showHelper/Block.hbm" />
</session-factory>
</hibernate-configuration>
发表评论
-
MYSQL外联结查询解决注册数据统计
2016-10-10 10:32 344需要从房间配置表、房 ... -
Tomcat 主机部署
2014-12-01 11:55 994tomcat安装完成后,修改以下文件: 安装目录下(以C盘为 ... -
javascript 操作Excel
2013-07-24 08:34 5911创建 var XLObj = new ActiveXObj ... -
tomcat7部署应用
2013-04-28 17:09 3403今日需要部署web应用测试wifi portal页面,使用to ... -
Java数据 Json 封装测试
2010-03-04 16:46 2194借鉴了一下网上一位开发者写大打包类,这个类实用了1.5的泛行特 ... -
JQuery使我想起了当年写asp的岁月!
2010-03-04 13:42 630最近没事看了看现在的框架技术,随着struts、webwork ... -
《Java敏捷开发——使用Spring、Hibernate和Eclipse》选择最适合的去做!
2007-05-12 12:33 1588好久没 ... -
Tomcat6下的应用部署
2007-02-13 16:21 6606Cont ... -
spring + hibernate3.0.5 的批量删除解决方案
2006-07-17 16:13 3146public class HibernateDaoSuppor ... -
spring+hibernate3.0.5 的HQL中文搜索解决方法
2006-07-17 16:10 1536/** 获取某人在某时间段内的访问记录 */ publ ... -
Eclipse3.1 + Hibernate3.0.5 + HibernateSynchronizer3.1.9...
2006-06-12 09:06 1175启动Eclipse时加入参数: -clean 例如: ... -
配置Eclipse的Hibernate3.0开发环境
2005-06-29 00:13 3534使用一下工具: 1)eclip ... -
WebWork2 的 Validation
2005-05-24 11:21 1167在WebWork2包的文档中有一段关于验证器的内容,并举出了一 ... -
applicationContext.xml 一个代理注入多个?
2005-05-23 11:28 2166<?xml version="1.0" ... -
Eclipse3M7+Hibernate2+Spring1.2 环境测试
2005-05-23 10:06 971package springWebwork2; impor ... -
Eclipse3M7+Hibernate2+Spring1.2+Postgre8.0 工程引入文件
2005-05-23 09:54 1221postgresql-8.0.309.jdbc3.jar co ... -
测试SessionFactory失败(解决方案)
2005-05-21 09:08 1110引用 http://www.javaworld.com ... -
测试SessionFactory失败!
2005-05-20 16:33 1621package springWebwork2; import ...
相关推荐
Eclipse+Struts+Spring+Hibernate+Mysql环境搭建及访问数据库实例
精通J2EE——Eclipse+Struts+Hibernate+Spring整合应用案例 pdf电子书, 包含所有18个章节的完整版, 美中不足的是扫描质量不是很高,且是第一版的,不是目前最新的第二版! 请看清楚了再下,免得后悔! 共有两个部分-这...
Eclipse+Struts+Spring+Hibernate+Mysql环境搭建及访问数据库实例.doc
Eclipse下Spring+SpringMVC+Hibernate框架环境搭建demo,适合新手入门参考。
eclipse(springmvc+spring+hibernate)案例附带mysql数据库
flex+eclipse+spring+hibernate整合
J2EE Eclipse Struts Hibernate Spring 环境搭配详细步骤
精通J2EE-Eclipse+Struts+Hibernate+Spring整和应用案例
精通J2EE-Eclipse+Struts+Hibernate+Spring整和应用案例
java开发Eclipse+struts+Hibernate制作图形验证码及登录视频
eclipse(struts2+spring3+hibernate3)案例附带mysql数据库
Eclipse+Struts+Hibernate集成开发shoppingcart,有源码,详细过程,对那些想学好java的人来说值得看一看
java开发Eclipse+struts+Hibernate制作图形验证码
整合Eclipse struts+hibernate+spring2
精通J2EE——Eclipse+Struts+Hibernate+Spring整合应用案例 pdf电子书, 包含所有18个章节的完整版, 美中不足的是扫描质量不是很高,且是第一版的,不是目前最新的第二版! 请看清楚了再下,免得后悔! 共有两个部分-这...
这是一个struts 1.2 + spring 2.5 + hibernate 3.2框架demo, 运行环境为eclipse 3.2 + tomcat 5.5 + oracle 11g
eclipse工具,用Maven搭建的Spring+Spring MVC+Hibernate框架源码
eclipse中整合spring+struts+hibernate,能直接运行