Resultset的返回值判断

因为Resultset的返回值是一个对象，可以通过这个对象 的一个方法来进行判断

我就用了.next()这哥方法，用来读这一行有没有值，有值就会返回一个true

System.out.println("查询");
                System.out.println("id shangpin price geshua");
                //Class.forName("com.mysql.cj.jdbc.Driver");//里面又一个建泰代码块是drivermanager
                String url="jdbc:mysql://localhost:3306/db1";
                String username="root";
                String password="123456";
                Connection conn = DriverManager.getConnection(url,username,password);//Drivermanager得一个getconnection
                String sql ="select * from shangpin";
                Statement stmt = conn.createStatement();
                ResultSet count=stmt.executeQuery(sql);
                while(count.next()){
                    System.out.println(count.getInt(1)+"    "+count.getString(2)+"    "+count.getInt(3)+"   "+count.getInt(4));
                }
                stmt.close();
                conn.close();
                break;