jdbc连接mysql8.0.21_jdbc-MySQL8.0连接

package student;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class main {

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

//声明Connection对象

String dbURL = “jdbc:mysql://localhost:3306/runoob?useSSL=false&&allowPublicKeyRetrieval=true&&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC”;

String userName = “root”;

String passWord = “123456”;

Class.forName(“com.mysql.cj.jdbc.Driver”);

Connection connection = DriverManager.getConnection(dbURL, userName, passWord);

Connection con;

//驱动程序名

String driver = "com.mysql.cj.jdbc.Driver";

//遍历查询结果集

try {

//加载驱动程序

Class.forName(driver);

//1.getConnection()方法，连接MySQL数据库！！

con = DriverManager.getConnection(dbURL,userName,passWord);

if(!con.isClosed())

System.out.println("Succeeded connecting to the Database!");

//2.创建statement类对象，用来执行SQL语句！！

Statement statement = con.createStatement();

//要执行的SQL语句

String sql = "select * from websites";

//3.ResultSet类，用来存放获取的结果集！！

ResultSet rs = statement.executeQuery(sql);

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

System.out.println("执行结果如下所示:");

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

System.out.println("id" + "\t" + "name" + "\t" + "url" + "\t" +"\t"+"country");

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

String id = null;

String name= null;

String url = null;

String country = null;

while(rs.next()){

//获取sno这列数据

id = rs.getString("id");

//获取sname这列数据

name = rs.getString("name");

url = rs.getString("url");

country = rs.getString("country");

//获取sex这列数据

//输出结果

System.out.println(id + "\t" + name+"\t"+url+ "\t" + country);

}

rs.close();

con.close();

} catch(ClassNotFoundException e) {

//数据库驱动类异常处理

System.out.println("Sorry,can`t find the Driver!");

e.printStackTrace();

} catch(SQLException e) {

//数据库连接失败异常处理

e.printStackTrace();

}catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

}

finally{

System.out.println("数据库数据成功获取！！");

}

}

}

weixin_45522607

发布了0 篇原创文章 · 获赞 0 · 访问量 25

私信

关注

标签：jdbc,String,rs,System,MySQL8.0,sql,println,连接,out

来源： https://blog.csdn.net/weixin_45522607/article/details/104075490