pom文件中如何添加JDBC驱动

在pom文件中如何添加JDBC驱动

To start with, the jar that I need to connect to MySQL 5.5 should have been mysql-connector-java-5.1.15-bin.jar but not mysql-connector-java-5.1.15.jar. Secondly, this jar is not available in maven repository so I needed to manually add it to my local maven repository and then added it as a dependency in my pom.xml.

Adding mysql-connector-java-5.1.15.jar to the local maven repository by mvn install:install-file -Dfile=C:Librariesmysql-connector-java-5.1.15-binmysql-connector-java-5.1.15-bin.jar -DgroupId=mysql -DartifactId=mysql-connector-java -Dversion=5.1.15-bin -Dpackaging=jar and then adding the following dependency to pom.xml of the project.

<!-- MySql 5.5 Connector -->   
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.15-bin</version>
    </dependency>

这样还没有完成,还需要添加<scope>标签才可以使用

<!-- MySql 5.5 Connector -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.15-bin</version>
            <scope>runtime</scope>
        </dependency>

经验分享 程序员 微信小程序 职场和发展