提交作业

package com.imooc.jdbc.goodsapp;

import java.sql.*;

public class GoodsApp {
    public static void main(String[] args) {
        //加载并注册mysql驱动类
        Connection conn = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            //创建数据库连接
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/imooc?useSSL" +
                            "=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true",
                    "root", "root");
            //创建statement对象
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("select * from goods where price<3500");
            //遍历查询
            while (rs.next()) {
                Integer id = rs.getInt(1);
                String name = rs.getString(2);
                float price = rs.getFloat(3);
                String desp = rs.getString("desp");
                System.out.println(id + "  " + name + "  " + price + "  " + desp);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            //关闭资源
            try {
                if (conn != null && !conn.isClosed()) {
                    conn.close();
                }
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }

        }
    }
}