hibernate.cfg.xml 配置SQL server,MySQL,Oracle
1、连接SQL server
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.url">jdbc:sqlserver://192.168.63.117:1433;databaseName=test</property>
<property name="connection.username">sa</property>
<property name="connection.password">123456</property>
<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="show_sql">true</property>
</session-factory>
</hibernate-configuration>
2、连接MySQL
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.url"> jdbc:mysql://localhost:3306/test </property>
<property name="connection.username">sa</property>
<property name="connection.password">123456</property>
<property name="connection.driver_class"> com.mysql.jdbc.Driver </property>
<property name="dialect"> org.hibernate.dialect.MySQLDialect </property>
<property name="show_sql">true</property>
</session-factory>
</hibernate-configuration>
3、连接Oracle
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.url">jdbc:oracle:thin:@192.168.63.117:1433:orcl</property>
<property name="connection.username">sa</property>
<property name="connection.password">123456</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="show_sql">true</property>
</session-factory>
</hibernate-configuration>
最新文章
- python 高级之面向对象初级
- [js开源组件开发]query组件,获取url参数和form表单json格式
- 【BZOJ-1497】最大获利 最大流
- Android横竖屏切换小结
- <;Araxis Merge>;保存文件
- 深入分析 Java 中的中文编码问题(转)
- Linux下查看所有用户(shell脚本获取)
- [Codeforces Round #237 (Div. 2)] A. Valera and X
- JSTL 格式化输出 Calendar
- HDU 4416 Good Article Good sentence(后缀自动机)
- Nyoj 吝啬的国度(图论&;&;双DFS)
- spark RDD编程,scala版本
- wpf的一些总结
- Go基础之--操作Mysql(一)
- php opcode缓存
- centos7 部署安装gitlab服务器
- 逆元知识普及(扫盲篇) —— from Judge
- DeepLearning.ai学习笔记(四)卷积神经网络 -- week4 特殊应用:人力脸识别和神经风格转换
- Linux之cat的使用
- Pytorch半精度浮点型网络训练问题