Java连接JDBC并在控制台输出

 public static void main(String[] args) {

        try {
            //加载mysql8.0驱动
            Class.forName("com.mysql.cj.jdbc.Driver");
            //建立数据库连接
            String url="jdbc:mysql://localhost:3306/myjob?serverTimezone=Asia/Shanghai";
            String username="root";
            String password="123456";
            //获取DriverManager对象连接数据库
            Connection conn = DriverManager.getConnection(url, username, password);
            //预编译处理
            String sql = "select * from emp";
            PreparedStatement ps = conn.prepareStatement(sql);
            //执行查询executeQuery();返回ResultSet对象
            ResultSet set = ps.executeQuery();
            //获取列名(字段名)
            ResultSetMetaData data = ps.getMetaData();
            for (int i = 1; i <= data.getColumnCount(); i++) {
                //data.getColumnName().toUpperCase获取列名并全部大写
                System.out.print(data.getColumnName(i).toUpperCase()+" \t");
            }
            System.out.println();
            while(set.next()) {
                System.out.print(set.getInt(1)+" \t");
                System.out.print(set.getString(2)+" \t");
                System.out.print(set.getInt(3)+" \t");
                System.out.print(set.getInt(4)+" \t");
                System.out.print(set.getDate(5)+" \t");
                System.out.print(set.getBigDecimal(6)+" \t");
                System.out.print(set.getBigDecimal(7)+" \t");
                System.out.print(set.getInt(8)+" \n");
            }
            //关闭连接释放资源
            set.close();
            ps.close();
            conn.close();
        } catch (ClassNotFoundException | SQLException e) {
            throw new RuntimeException(e);
        }
    }

PS：在运行代码之前你需要用到mysql8.0的jar包

 创建lib文件包 下载  mysql-connector-java-8.0.13.jar

下载地址:链接：https://pan.baidu.com/s/1NE8uESyPJJdrrA11x5h9nQ 
提取码：stiy 

输出结果：