mysql驱动设置

1,下载JDBC驱动程序mysql-connector-java-3.1.13.zip，解压在合适的目录下面！

我的是D:\mysql-jdbc

2，设置环境变量，即在classpath的值里加上：D:\mysql-jdbc\mysql-connector-java-3.1.13-bin.jar

现在java程序已经可以访问数据库了！测试代码如下：

import java.sql.*

public class sqlConn

{

public static void main(String[] args)

{

System.out.println("MySQL connection test")

Connection con = null

Statement stat = null

String urlstr = "jdbc:mysql://localhost:3306/try"

String user = "root"

String password = "413026"

Class.forName("com.mysql.jdbc.Driver")

con = DriverManager.getConnection(urlstr, user, password)

stat = con.createStatement()

stat.executeUpdate("insert into new_table(id) values(1)

ResultSet rs = stat.executeQuery("select * from new_table")

while (rs.next())

System.out.println("id:"+rs.getString("id"))

rs.close()

System.out.println("Test ends")

}

}

为了让数据库可以让JSP程序使用做第三步。

3,将解压后的文件夹中的mysql-connector-java-3.1.13-bin.jar复制到

D:\Tomcat\common\lib

D:\Tomcat\shared\lib

即Tomcat的安装目录下面。

<dependency>

<groupId>org.wisdom-framework</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.34_1</version>

</dependency>

首先需要jar包 mysql-connector-java-3.1.13-bin.jar

代码：

Connection conn=null

String url = "jdbc:mysql://localhost:3306/本地数据库名字"

try {

Class.forName("com.mysql.jdbc.Driver")

} catch (ClassNotFoundException ex) {

System.out.println("数据库驱动加载失败")

}

try {

conn = DriverManager.getConnection(url, "用户名", "密码")

} catch (SQLException e) {

e.printStackTrace()

}

return conn

---