怎么安装MYSQL5.0的JDBC驱动

最新推荐文章于 2024-09-06 16:37:12 发布

原创最新推荐文章于 2024-09-06 16:37:12 发布 · 205 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#JDBC #MySQL #Java #EXT #Tomcat

Database 专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何下载并安装 MySQL 的 JDBC 驱动 mysql-connector-java-3.1.10-bin.jar，提供了两种安装方式：一种是将 com 和 org 目录下的文件放置在指定位置；另一种是直接将 jar 包放入特定目录，并设置相应的 classpath 环境变量。

1、下载mysql for jdbc driver.
http://dev.mysql.com/downloads/connector/j/3.1.html
MySQL Connector/J is distributed as a .zip or .tar.gz archive containing
the sources and class files as well as a class-file only "binary" .jar
archive named "mysql-connector-java-3.1.10-bin.jar".

2、解压缩下载的文件，如：mysql-connector-java-3.1.10.zip

You will need to use the appropriate gui or command-line utility to un-archive
the distribution (for example, WinZip for the .zip archive, and "tar" for
the .tar.gz archive).

3、mysql for jdbc driver有两种安装发式：

Once you have un-archived the distribution archive,
you can install the driver in one of two ways:

第一种方法：将com和org两个目录下所有文件和目录拷贝到任何地方，比如将com和org两个目录下所有文件和目录拷贝到任何地方，比如d:\mysqlforjdbc下
设置classpath=.;d:\mysqlforjdbc;%classpath%

Either copy the "com" and "org" subdirectories and all of their contents
to anywhere you like, and put the directory holding the "com" and "org"
subdirectories in your classpath, or...

第二种方法：将mysql-connector-java-3.1.10-bin.jar拷贝到一个地方，如：D:\Program Files\Apache Software Foundation\Tomcat 5.0\common\lib下
设置classpath=.;D:\Program Files\Apache Software Foundation\Tomcat 5.0\common\lib\mysql-connector-java-3.1.10-bin.jar;%classpath%

或直接把mysql-connector-java-3.1.10-bin.jar拷贝到%JAVA_HOME%\jre\lib\ext下
%JAVA_HOME%就是J2SDK的安装目录，如我的为D:\j2sdk1.4.2_06就拷贝到D:\j2sdk1.4.2_06\jre\lib\ext下

(调试java程序使用)

Put mysql-connector-java-3.1.10-bin.jar in your classpath, either by adding the
FULL path to it to your CLASSPATH enviornment variable, or putting it
in $JAVA_HOME/jre/lib/ext.