package com.java; import java.sql.*; class JDBC { public static void main(String[] args) { Connection conn =null; try { Statement stat =null; //加载驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //获得连接 String userName="root"; String passWorld="123456"; String url="jdbc:mysql://localhost:3306/huiy?serverTimezone=UTC"; conn = DriverManager.getConnection(url, userName, passWorld); stat = conn.createStatement(); //数据查询 ResultSet res =stat.executeQuery("select * from salary"); //取出结果集 while (res.next()){ System.out.println("员工编号:"+res.getInt("empid")+"\t\t"+"员工基本工资:"+res.getDouble("basesalary") +"\t\t"+"职位补贴工资:"+res.getDouble("titlesalary")+"\t\t"+"扣除工资:"+res.getDouble("deduction")); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException throwables) { throwables.printStackTrace(); } } }
在加载驱动时 Class.forName("com.mysql.cj.jdbc.Driver");如果你不知道驱动地址,可以执行一下,报错后会提示
mysql5.7架包:
https://cdn.mysql.com//Downloads/Connector-J/mysql-connector-java-8.0.26.tar.gz