需要工具:
Eclipse;
jdbc:百度云:
mysql-connector-java-8.0.13.zip
提取码:1e1v ;
下载完后再eclipse中新建一个java项目;
比如我新建的就是:
然后new 一个floder名字为lib;
将mysql-connector-java-8.0.13.zip解压后拖拽到lib下面:
右击项目名 -->build path–>configure build path;
接着 add jars;
找到mysql-connector-java-8.0.13.zip:
点击apply and close;
在src–>新建个包–>新建类:
代码如下;
package MysqlConnect;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class MysqlConnect {
public static void main(String[] args) throws SQLException {
Connection con;
String driver="com.mysql.cj.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/test"+"?serverTimezone=UTC";
String user="root";
String pass="123456";
System.out.println(">>");
try {
Class.forName(driver);//加载驱动
con=DriverManager.getConnection(url, user, pass);
if(!con.isClosed())System.out.println("connect success");//测试是否连接成功;
Statement statement = con.createStatement();
String sql = "select * from test";
ResultSet rs = statement.executeQuery(sql);
while(rs.next()){
String name=rs.getString("name");
System.out.println(name);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}
效果如图: