maven怎么连接mysql数据库配置_各数据库连接配置与maven依赖安装

maven用的比较多，所以自己去捣鼓了一下：以下是关于数据库配置的一块，把相关的内容张贴出来，以备不时之需

//MySql

配置文件(maven)：pom.xml

mysql

mysql-connector-java

5.0.5

配置文件：(hibernat.properties)

hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

hibernate.connection.driver_calss=mysql.jdbc.Driver

hibernate.connection.url=jdbc:mysql://localhost:3306/trails?createDatabaseIfNotExist=true&ampo;useUnicode=ture&characterEncoding=utf-8

hibernate.connection.username=root

hibernate.connection.password=****

hibernate.connection.hbm2ddl.auto=update

//Oracle

配置文件(maven)

com.oracle

ojdbc14

10.2.0.2.1

配置文件：(hibernat.properties)

hibernate.dialect=org.hibernate.dialect.Oracle9Dialect

hibernate.connection.driver_calss=oracle.jdbc.OracleDriver

hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:XE

hibernate.connection.username=system

hibernate.connection.password=****

hibernate.connection.hbm2ddl.auto=update

//SQL Server

配置文件(maven)

net.sourceforge.jtds

jtds

1.2

配置文件：(hibernat.properties)

hibernate.dialect=org.hibernate.dialect.SQLServerDialect

hibernate.connection.driver_calss=net.sourceforge.jtds.jdbc.Driver

hibernate.connection.url=jdbc:jtds:sqlserver://localhost:1433/trails?createDatabaseIfNotExist=true&ampo;useUnicode=ture&characterEncoding=utf-8

hibernate.connection.username=sa

hibernate.connection.password=****

hibernate.connection.hbm2ddl.auto=update

//手动安装maven依赖包

1:将此依赖添加到项目的pom.xml

com.microsoft.sqlserver

sqljdbc4

3.0

2:在命令行中执行install命令 (有用)

mvn install:install-file -Dfile=mysql-connection-java-4.1.45-bin.jar -DgroupId=mysql-connection-java -DartifactId=mysql -Dversion=4.1.45 -Dpackaging=jar

3:将sqljdbc4-3.0.jar拷贝到此依赖安装目录

将sqljdbc4-3.0.jar拷贝到\Documents and Settings\%USER%\.m2\repository\com\microsoft\sqlserver\sqljdbc\4\3.0中即可

来源网络。