各种数据库的jdbc.properties写法

mysql数据库

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost/simplejee?useUnicode=true&characterEncoding=GBK
jdbc.username=root
jdbc.password=root

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
driverClassName=com.mysql.jdbc.Driver
validationQuery=SELECT 1
jdbc_url=jdbc:mysql://localhost:3306/sshe?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
jdbc_username=sshe
jdbc_password=sshe

hibernate.dialect=org.hibernate.dialect.MySQLDialect
driverClassName=com.mysql.jdbc.Driver
validationQuery=SELECT 1
jdbc_url=jdbc:mysql://localhost:3306/sy?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
jdbc_username=sypro
jdbc_password=sypro

postgres数据库

hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
jdbc.driverClassName.postgressql=org.postgresql.Driver
validationQuery.sqlserver=SELECT 1
jdbc.url.jeecg=jdbc:postgresql://localhost:5432/jeecg
jdbc.username.jeecg=postgres
jdbc.password.jeecg=postgres
jdbc.dbType=postgres

sqlserver数据库

jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.url=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=orcl
jdbc.username=sa
jdbc.password=
hibernate.dialect=org.hibernate.dialect.SQLServerDialect

hibernate.dialect=org.hibernate.dialect.SQLServer2008Dialect
driverClassName=net.sourceforge.jtds.jdbc.Driver
validationQuery=SELECT 1
jdbc_url=jdbc:jtds:sqlserver://127.0.0.1:1433/dbName
jdbc_username=sa
jdbc_password=123456

hibernate.dialect=org.hibernate.dialect.SQLServerDialect
driverClassName=net.sourceforge.jtds.jdbc.Driver
validationQuery=SELECT 1
jdbc_url=jdbc:jtds:sqlserver://127.0.0.1:1433/sy
jdbc_username=sa
jdbc_password=123456

sqlserver2005
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
jdbc.driverClassName.sqlserver=com.microsoft.sqlserver.jdbc.SQLServerDriver
validationQuery.sqlserver=SELECT 1
jdbc.url.jeecg=jdbc:jtds:sqlserver://localhost:1433/jeecg
jdbc.username.jeecg=sa
jdbc.password.jeecg=taosent

oracle数据库

jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:orcle
jdbc.username=simplejee
jdbc.password=simplejee
hibernate.dialect=org.hibernate.dialect.OracleDialect

hibernate.dialect=sy.util.base.Oracle10gDialect
driverClassName=oracle.jdbc.driver.OracleDriver
validationQuery=SELECT 1 FROM DUAL
jdbc_url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))
jdbc_username=sshe
jdbc_password=123456

hibernate.dialect=org.hibernate.dialect.OracleDialect
driverClassName=oracle.jdbc.driver.OracleDriver
validationQuery=SELECT 1 FROM DUAL
jdbc_url=jdbc:oracle:thin:@localhost:1521:orcl
jdbc_username=sypro
jdbc_password=sypro

Derby数据库

hibernate.dialect=org.hibernate.dialect.DerbyDialect
driverClassName=org.apache.derby.jdbc.EmbeddedDriver
validationQuery=SELECT 1
jdbc_url=jdbc:derby:sy;create=true
jdbc_username=sypro
jdbc_password=sypro

jdbcJPA方式

jdbcJPA.url=jdbc:mysql://localhost/simplejee?useUnicode=true&characterEncoding=GBK

jndi方式

jndiName=java:comp/env/dataSourceName

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName" value="${jndiName}"></property> </bean>

hibernate.dialect=org.hibernate.dialect.OracleDialect
jdbc.driverClassName.oracle=oracle.jdbc.driver.OracleDriver
hibernate.dialect=org.hibernate.dialect.MySQLDialect
jdbc.driverClassName.mysql=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
jdbc.driverClassName.sqlserver=com.microsoft.sqlserver.jdbc.SQLServerDriver