jdbc连接mysql数据库需要jia包吗

只需要mysql的驱动包：包名为：mysql-connector-java-5.1.37-bin.jar

源码如下：

import java.sql.Connection

import java.sql.DriverManager

import java.sql.PreparedStatement

import org.junit.Test

public class JdbcMysql {

@Test

public void connection() throws Exception{

String username = "root"

String password = "root"

String url = "jdbc:mysql://localhost:3306/exam?characterEncoding=utf-8"

String sql = "UPDATE s_cust SET cust_name=? WHERE cid = ? "

//加载mysql的驱动类，获得连接，获取SQL的预编译，设置参数，执行SQL语句

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

Connection con = DriverManager.getConnection(url, username, password)

PreparedStatement ps = con.prepareStatement(sql)

ps.setString(1, "北京")

ps.setInt(2, 6)

ps.execute()

ps.close()

con.close()

}

}

java连接mysql数据库jar包导入：

1.将所有的jar包都是放到web工程lib目录下，mysql-connector-java-x.x-bin.jar也是一样，把该JAR包拷贝到lib目录下即可

2用jdbc直接链接mysql代码如下

public static void main(String[] args) throws SQLException {

DriverManager.registerDriver(new com.mysql.jdbc.Driver())

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/day15", "root", "123456")

System.out.println(conn.getClass().getName())

Statement stmt = conn.createStatement()

ResultSet rs = stmt.executeQuery("select id,name,password,email,birthday from users")

while (rs.next()) {

System.out.println("-------------------------")

System.out.println(rs.getObject("id"))

System.out.println(rs.getObject("name"))

System.out.println(rs.getObject("password"))

System.out.println(rs.getObject("email"))

System.out.println(rs.getObject("birthday"))

}

rs.close()

stmt.close()

conn.close()

}

---