各数据库连接配置与maven依赖安装
maven用的比较多,所以自己去捣鼓了一下:以下是关于数据库配置的一块,把相关的内容张贴出来,以备不时之需
//MySql
配置文件(maven):pom.xml
1 2 3 4 5 6 7 8 9 | <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.0.5</version> </dependency> |
配置文件:(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&o;useUnicode=ture&characterEncoding=utf-8
hibernate.connection.username=root
hibernate.connection.password=****
hibernate.connection.hbm2ddl.auto=update
//Oracle
配置文件(maven)
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc14</artifactId>
<version>10.2.0.2.1</version>
</dependency>
配置文件:(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)
<dependency>
<groupId>net.sourceforge.jtds</groupId>
<artifactId>jtds</artifactId>
<version>1.2</version>
</dependency>
配置文件:(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&o;useUnicode=ture&characterEncoding=utf-8
hibernate.connection.username=sa
hibernate.connection.password=****
hibernate.connection.hbm2ddl.auto=update
//手动安装maven依赖包
1:将此依赖添加到项目的pom.xml
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>3.0</version>
</dependency>
2:在命令行中执行install命令 (有用)
1 | 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中即可
来源网络。
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步