sql的jar包下载:mysql-connector-java.jar
打开以下网址免费下载:
www.codingutil.com/searchJar.html?jarName=mysql-connector-java
打开eclipse,创建工程,工程名称用鼠标右键点击,选择Build Path–>Add External Archives–>选择刚才下载的驱动即可,接下来要验证是否连接成功
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class MySqlTest {
static String exec = "select * from table01";
public static void main(String[] args) {
link();//连接测试
}
public static void link() {
try {
conn();
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static void conn() throws SQLException ,ClassNotFoundException {