连接数据库的配置语句

我常用的数据库，记录下它们的连接语句，因为有时候会忘了！

 

MySql：

<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/databaseName</property>
<property name="connection.username">root</property>
<property name="connection.password">123</property>

 

Oracle：

<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:databaseName</property>
<property name="connection.username">scott</property>
<property name="connection.password">tiger</property>

 

评论

1 楼 nannansun 2014-02-11  

增加一个  SQLServer

<property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="connection.url">jdbc:sqlserver://192.168.1.101:1433;databaseName=demos</property>
<property name="connection.username">sa</property>
<property name="connection.password">12345</property>