动态Hibernate配置类

最新推荐文章于 2024-08-05 14:22:58 发布
转载 最新推荐文章于 2024-08-05 14:22:58 发布 · 632 阅读 · 0

本文介绍了一个动态配置Hibernate连接的Java类实现。该类可以根据不同的数据库类型（如MySQL、SQL Server、Oracle）设置连接属性，并使用C3P0作为连接池。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

import org.hibernate.HibernateException;
import org.hibernate.cfg.Configuration;


public class DynamicHibernateConfiguration extends Configuration {
    public DynamicHibernateConfiguration() {
        super();
    }

    public void reset() {
        super.reset();
    }

    public DynamicHibernateConfiguration(String dialect, String driverClass,
            String ipAddress, String port, String dataBaseName,
            String username, String password) throws HibernateException {
        String connection_url = "";
        if (dialect.indexOf("MySQL") > -1) {
            connection_url = "jdbc:mysql://" + ipAddress + "/" + dataBaseName;
        } else if (dialect.indexOf("SQLServer") > -1) {
            connection_url = "jdbc:sqlserver://" + ipAddress + ":" + port
                    + ";DataBaseName=" + dataBaseName;
        } else if (dialect.indexOf("Oracle") > -1) {
            connection_url = "jdbc:oracle:thin:@//" + ipAddress + ":" + port
                    + "/" + dataBaseName;
        } else {
            throw new HibernateException("The dialect was not allowed.==fd=="
                    + dialect);
        }
        // 连接池提供类，本配置采用bonecp连接池

        /*super.setProperty("hibernate.connection.provider_class","com.jolbox.bonecp.provider.BoneCPConnectionProvider");
        super.setProperty("hibernate.dialect", dialect);
        super.setProperty("hibernate.connection.url", connection_url);
        super.setProperty("hibernate.connection.driver_class", driverClass);
        super.setProperty("hibernate.connection.username", username);
        super.setProperty("hibernate.connection.password", password);
        super.setProperty("bonecp.idleMaxAge", "0");
        super.setProperty("bonecp.idleConnectionTestPeriod", "1");
        super.setProperty("bonecp.partitionCount", "3");
        super.setProperty("bonecp.maxConnectionsPerPartition", "25");
        super.setProperty("bonecp.minConnectionsPerPartition", "5");
        super.setProperty("bonecp.acquireIncrement", "1");
        super.setProperty("bonecp.connectionTimeout", "5000");
        super.setProperty("bonecp.poolAvailabilityThreshold", "30");
        super.setProperty("bonecp.statementsCacheSize", "50");
        super.setProperty("bonecp.preparedStatementCacheSize", "50");
        super.setProperty("bonecp.releaseHelperThreads", "3");
        super.setProperty("bonecp.statementReleaseHelperThreads", "3");
        super.setProperty("bonecp.connectionTestStatement","select 1");
        super.setProperty("hibernate.connection.release_mode","after_statement");*/

        //c3p0
        System.out.println("connection_url==="+connection_url);
        super.setProperty("hibernate.connection.provider_class","org.hibernate.connection.C3P0ConnectionProvider");
        super.setProperty("hibernate.dialect", dialect);
        super.setProperty("hibernate.connection.url", connection_url);
        super.setProperty("hibernate.connection.driver_class", driverClass);
        super.setProperty("hibernate.connection.username", username);
        super.setProperty("hibernate.connection.password", password);
        super.setProperty("hibernate.connection.release_mode","after_statement");
        super.setProperty("hibernate.c3p0.max_size","15");
        super.setProperty("hibernate.c3p0.min_size","10");
        super.setProperty("hibernate.c3p0.timeout","120");
        super.setProperty("hibernate.c3p0.max_statements","100");
        super.setProperty("hibernate.c3p0.idle_test_period","120");
        super.setProperty("hibernate.c3p0.acquire_increment","5");
        super.setProperty("hibernate.c3p0.testConnectionOnCheckin","true");
        super.setProperty("hibernate.c3p0.testConnectionOnCheckout","true");



    }

    public DynamicHibernateConfiguration(String dialect, String driverClass,
            String ipAddress, String port, String dataBaseName,
            String username, String password, String schema, String catalog)
            throws HibernateException {
        String connection_url = "";
        if (dialect.indexOf("MySQL") > -1) {
            connection_url = "jdbc:mysql://" + ipAddress + "/" + dataBaseName;
        } else if (dialect.indexOf("SQLServer") > -1) {
            connection_url = "jdbc:sqlserver://" + ipAddress + ":" + port
                    + ";DataBaseName=" + dataBaseName;
        } else if (dialect.indexOf("Oracle") > -1) {
            connection_url = "jdbc:oracle:thin:@//" + ipAddress + ":" + port
                    + "/" + dataBaseName;
        }else {
            throw new HibernateException("The dialect was not allowed.==fd=="
                    + dialect);
        }
        // 连接池提供类，本配置采用bonecp连接池
        /*super.setProperty("hibernate.connection.provider_class","com.jolbox.bonecp.provider.BoneCPConnectionProvider");
        super.setProperty("hibernate.dialect", dialect);
        super.setProperty("hibernate.connection.url", connection_url);
        super.setProperty("hibernate.connection.driver_class", driverClass);
        super.setProperty("hibernate.connection.username", username);
        super.setProperty("hibernate.connection.password", password);
        super.setProperty("hibernate.default_schema", schema);
        super.setProperty("bonecp.idleMaxAge", "0");
        super.setProperty("bonecp.idleConnectionTestPeriod", "1");
        super.setProperty("bonecp.partitionCount", "3");
        super.setProperty("bonecp.maxConnectionsPerPartition", "25");
        super.setProperty("bonecp.minConnectionsPerPartition", "5");
        super.setProperty("bonecp.acquireIncrement", "1");
        super.setProperty("bonecp.connectionTimeout", "5000");
        super.setProperty("bonecp.poolAvailabilityThreshold", "30");
        super.setProperty("bonecp.statementsCacheSize", "50");
        super.setProperty("bonecp.preparedStatementCacheSize", "50");
        super.setProperty("bonecp.releaseHelperThreads", "3");
        super.setProperty("bonecp.statementReleaseHelperThreads", "3");
        super.setProperty("bonecp.connectionTestStatement","select 1");
        super.setProperty("hibernate.connection.release_mode","after_statement");*/

        super.setProperty("hibernate.connection.provider_class","org.hibernate.connection.C3P0ConnectionProvider");
        super.setProperty("hibernate.dialect", dialect);
        super.setProperty("hibernate.connection.url", connection_url);
        super.setProperty("hibernate.connection.driver_class", driverClass);
        super.setProperty("hibernate.connection.username", username);
        super.setProperty("hibernate.connection.password", password);
        super.setProperty("hibernate.connection.release_mode","after_statement");
        super.setProperty("hibernate.c3p0.max_size","15");
        super.setProperty("hibernate.c3p0.min_size","10");
        super.setProperty("hibernate.c3p0.timeout","120");
        super.setProperty("hibernate.c3p0.max_statements","100");
        super.setProperty("hibernate.c3p0.idle_test_period","120");
        super.setProperty("hibernate.c3p0.acquire_increment","5");
        super.setProperty("hibernate.c3p0.testConnectionOnCheckin","true");
        super.setProperty("hibernate.c3p0.testConnectionOnCheckout","true");

    }



    public DynamicHibernateConfiguration(String dialect, String driverClass,
            String ipAddress, String port, String dataBaseName,
            String username, String password, String cj) throws HibernateException {
        String connection_url = "";
        if (dialect.indexOf("MySQL") > -1) {
            connection_url = "jdbc:mysql://" + ipAddress + "/" + dataBaseName;
        } else if (dialect.indexOf("SQLServer") > -1) {
            connection_url = "jdbc:sqlserver://" + ipAddress + ":" + port
                    + ";DataBaseName=" + dataBaseName;
        }  else if (dialect.indexOf("Oracle") > -1) {
            connection_url = "jdbc:oracle:thin:@//" + ipAddress + ":" + port
                    + "/" + dataBaseName;
        } else {
            throw new HibernateException("The dialect was not allowed.==fd=="
                    + dialect);
        }
        // 连接池提供类，本配置采用bonecp连接池

        /*super.setProperty("hibernate.connection.provider_class","com.jolbox.bonecp.provider.BoneCPConnectionProvider");
        super.setProperty("hibernate.dialect", dialect);
        super.setProperty("hibernate.connection.url", connection_url);
        super.setProperty("hibernate.connection.driver_class", driverClass);
        super.setProperty("hibernate.connection.username", username);
        super.setProperty("hibernate.connection.password", password);
        super.setProperty("bonecp.idleMaxAge", "0");
        super.setProperty("bonecp.idleConnectionTestPeriod", "1");
        super.setProperty("bonecp.partitionCount", "3");
        super.setProperty("bonecp.maxConnectionsPerPartition", "25");
        super.setProperty("bonecp.minConnectionsPerPartition", "5");
        super.setProperty("bonecp.acquireIncrement", "1");
        super.setProperty("bonecp.connectionTimeout", "5000");
        super.setProperty("bonecp.poolAvailabilityThreshold", "30");
        super.setProperty("bonecp.statementsCacheSize", "50");
        super.setProperty("bonecp.preparedStatementCacheSize", "50");
        super.setProperty("bonecp.releaseHelperThreads", "3");
        super.setProperty("bonecp.statementReleaseHelperThreads", "3");
        super.setProperty("bonecp.connectionTestStatement","select 1");
        super.setProperty("hibernate.connection.release_mode","after_statement");*/

        //c3p0

        super.setProperty("hibernate.connection.provider_class","org.hibernate.connection.C3P0ConnectionProvider");
        super.setProperty("hibernate.dialect", dialect);
        super.setProperty("hibernate.connection.url", connection_url);
        super.setProperty("hibernate.connection.driver_class", driverClass);
        super.setProperty("hibernate.connection.username", username);
        super.setProperty("hibernate.connection.password", password);
        super.setProperty("hibernate.connection.release_mode","after_statement");
        super.setProperty("hibernate.c3p0.max_size","15");
        super.setProperty("hibernate.c3p0.min_size","10");
        super.setProperty("hibernate.c3p0.timeout","120");
        super.setProperty("hibernate.c3p0.max_statements","100");
        super.setProperty("hibernate.c3p0.idle_test_period","120");
        super.setProperty("hibernate.c3p0.acquire_increment","5");
        super.setProperty("hibernate.c3p0.testConnectionOnCheckin","true");
        super.setProperty("hibernate.c3p0.testConnectionOnCheckout","true");



    }

    public DynamicHibernateConfiguration(String dialect, String driverClass,
            String ipAddress, String port, String dataBaseName,
            String username, String password, String schema, String catalog, String cj)
            throws HibernateException {
        String connection_url = "";
        if (dialect.indexOf("MySQL") > -1) {
            connection_url = "jdbc:mysql://" + ipAddress + "/" + dataBaseName;
        } else if (dialect.indexOf("SQLServer") > -1) {
            connection_url = "jdbc:sqlserver://" + ipAddress + ":" + port
                    + ";DataBaseName=" + dataBaseName;
        } else if (dialect.indexOf("Oracle") > -1) {
            connection_url = "jdbc:oracle:thin:@//" + ipAddress + ":" + port
                    + "/" + dataBaseName;
        } else {
            throw new HibernateException("The dialect was not allowed.==fd=="
                    + dialect);
        }
        // 连接池提供类，本配置采用bonecp连接池
        /*super.setProperty("hibernate.connection.provider_class","com.jolbox.bonecp.provider.BoneCPConnectionProvider");
        super.setProperty("hibernate.dialect", dialect);
        super.setProperty("hibernate.connection.url", connection_url);
        super.setProperty("hibernate.connection.driver_class", driverClass);
        super.setProperty("hibernate.connection.username", username);
        super.setProperty("hibernate.connection.password", password);
        super.setProperty("hibernate.default_schema", schema);
        super.setProperty("bonecp.idleMaxAge", "0");
        super.setProperty("bonecp.idleConnectionTestPeriod", "1");
        super.setProperty("bonecp.partitionCount", "3");
        super.setProperty("bonecp.maxConnectionsPerPartition", "25");
        super.setProperty("bonecp.minConnectionsPerPartition", "5");
        super.setProperty("bonecp.acquireIncrement", "1");
        super.setProperty("bonecp.connectionTimeout", "5000");
        super.setProperty("bonecp.poolAvailabilityThreshold", "30");
        super.setProperty("bonecp.statementsCacheSize", "50");
        super.setProperty("bonecp.preparedStatementCacheSize", "50");
        super.setProperty("bonecp.releaseHelperThreads", "3");
        super.setProperty("bonecp.statementReleaseHelperThreads", "3");
        super.setProperty("bonecp.connectionTestStatement","select 1");
        super.setProperty("hibernate.connection.release_mode","after_statement");*/

        super.setProperty("hibernate.connection.provider_class","org.hibernate.connection.C3P0ConnectionProvider");
        super.setProperty("hibernate.dialect", dialect);
        super.setProperty("hibernate.connection.url", connection_url);
        super.setProperty("hibernate.connection.driver_class", driverClass);
        super.setProperty("hibernate.connection.username", username);
        super.setProperty("hibernate.connection.password", password);
        super.setProperty("hibernate.connection.release_mode","after_statement");
        super.setProperty("hibernate.c3p0.max_size","15");
        super.setProperty("hibernate.c3p0.min_size","10");
        super.setProperty("hibernate.c3p0.timeout","120");
        super.setProperty("hibernate.c3p0.max_statements","100");
        super.setProperty("hibernate.c3p0.idle_test_period","120");
        super.setProperty("hibernate.c3p0.acquire_increment","5");
        super.setProperty("hibernate.c3p0.testConnectionOnCheckin","true");
        super.setProperty("hibernate.c3p0.testConnectionOnCheckout","true");

    }

}
Hibernate配置
Toxi_c_的博客
06-16 886
1、在IDEA中建立名为ormlab1的Java工程，并导入相关类包(*.jar) 2、在src目录下创建Hibernate的配置文件(hibernate.cfg.xml) <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hib
Hibernate的三种配置方式
03-28
NULL 博文链接：https://dreamzhong.iteye.com/blog/1211451
Hibernate配置相关的类
03-06 1095
Hibernate配置相关的类      Configuration类（负责管理Hibernate的配置信息）      当创建SessionFactory时，Configuration实例可以指定使用哪一个映射文档。应用程序通常只是创建一个Configuration实例，并通过它创建一个SessionFactory实例。      当客户端发送一个请求线程时，SessionFactor
Hibernate 配置
qq_33240556的博客
08-05 1186
使用注解：这是最常见的方式，实体类使用 JPA 注解来定义映射关系。使用 XML 文件：可以在实体类之外定义一个 XML 文件来定义映射关系。混合使用：可以结合使用注解和 XML 文件。
Hibernate配置文件
04-10
**Hibernate配置文件详解** Hibernate，一个强大的Java持久化框架，为开发者提供了对象关系映射（ORM）服务，简化了数据库操作。在Hibernate中，`hibernate.cfg.xml`是核心配置文件，它定义了数据库连接、实体管理...
hibernate配置文件以及类映射文件常用写法1
08-08
《Hibernate配置文件与类映射详解》 Hibernate作为一款强大的对象关系映射（ORM）框架，简化了Java应用与数据库之间的交互。本文将深入探讨Hibernate的配置文件和类映射文件的常用写法，帮助开发者更好地理解和应用...
hibernate配置.ppt
最新发布
07-04
此外，Hibernate还提供了JPA Annotation的功能，允许开发者使用注解的方式来定义持久化类和属性映射关系，这是配置Hibernate的另一种便捷方式。 总结而言，Hibernate框架的配置和理解涉及到多个层面，包括体系架构...
hibernate动态读取配置及创建数据源
人生如逆旅，我亦是行人。。。
09-19 1130
public static Configuration initDBConfig(String dialect, String driver, String url, String user, String pwd){ Configuration cfg = new Configuration().configure("/hibernate.cfg.xml"); cfg.setProper
hibernate实现动态SQL查询
09-25
hibernate实现动态SQL查询,通过XML配置SQL，FREEMARKER 解析，生成要执行的SQL
hibernate动态设置参数
fendou4533的专栏
11-01 1534
转http://www.iteye.com/problems/47739 hibernate动态设置参数 List list = new ArrayList(); StringBuffer sql=new StringBuffer("select * from xxx t where 1=1 "); if(!StringUtils.isEmpty(fil
Hibernate dynamic model 动态模型
alexgaoyihang的专栏
04-08 985
Hibernate的动态模型为我们动态改动表结构带来了方便, 个人认为这一点非常有价值, 现在的企业级应用系统越来越强调用户可定制性, hibernate的这一点使用户自定义字段或自定义表成为可能 .
hibernate的基本配置
会飞行的猪
04-06 608
在介绍Hibernate之前，可以想一下原始的方法访问数据库，我们需要写JDBC代码，然后重复的每个增删改都需要写一大堆的连接数据库，写SQL语句。这样那面显得繁琐，所以Hibernate很好的解决了这类问题，直接操作对象可以映射到数据库。 Hibernate是一个开放源代码的对象关系映射框架，它对JDBC进行了非常轻量级的对象封装，使得Java程序员可以随心所欲的使用对象编程思维来操纵数据库
hibernate动态表名映射--只有想不到，没有做不到
ESOO
09-29 8007
最近的一个项目有一个需求，有N个考核单位，要对每个考核单位生成一张考核情况表，这样做的目的是横切数据库，这这个需求的实现中，我的组员遇到了一个技术问题，我将我的解决办法和整个思考过程与大家分享，
Hibernate配置过程
你的调料包
12-14 201
1、先建立一个Web项目，导入Hibernate必备的jar包 2、在数据库中创建表 CREATE TABLE `cst_customer` ( `cust_id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '客户编号(主键)', `cust_name` varchar(32) NOT NULL COMMENT '客户名称(公司名称)',...
Hibernate框架介绍以及入门 【二】Hibernate的常见配置
2301_79058515的博客
04-03 990
在面试前我整理归纳了一些面试学习资料，文中结合我的朋友同学面试美团滴滴这类大厂的资料及案例由于篇幅限制，文档的详解资料太全面，细节内容太多，所以只把部分知识点截图出来粗略的介绍，每个小节点里面都有更细化的内容！大家看完有什么不懂的可以在下方留言讨论也可以关注。[外链图片转存中…(img-nFWKHbXK-1712075636824)][外链图片转存中…(img-LendfM22-1712075636825)]
Hibernate之配置文件
weixin_30726161的博客
03-04 425
可持久化对象有以下三种状态： 临时状态(Transient)：对象在保存进数据库之前为临时状态，这时数据库中没有该对象的信息，如果没有持久化，程序退出后临时状态的对象信息将会丢失。随时可能被垃圾回收器回收(在数据库中没有于之对应的记录，应为是new初始化)，而执行save()方法后，就变为Persistent对象(持久性对象)，没有纳入session的管理，内存中一个对象，没有ID，缓存...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值