JDBC只能获取一部分结果

Question

package com.chapter08;

import java.sql.*;
import java.util.Scanner;

public class log {

public static void main(String[] args) {


        Scanner sc=new Scanner(System.in);
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        Connection conn =null;
        PreparedStatement pre =null;
        try {
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/shiyan?serveTimezone=GMT","root","123456");
            //验证登录
            String s="select * from bank where id=? and pwd=?";
            pre = conn.prepareStatement(s);
            System.out.println("请输入账号：");
            int i1 = sc.nextInt();
            System.out.println("请输入密码：");
            //int s2 = sc.nextInt();
            int s1 = sc.nextInt();

            pre.setInt(1,i1);
            pre.setInt(2,s1);
            ResultSet rs = pre.executeQuery();
            int id =0;
            int pwd =0;
            String name=" ";
            while(rs.next()) {
                id = rs.getInt("id");
                pwd = rs.getInt("pwd");
            }
            System.out.println(id==i1&&pwd==s1?"登录成功":"登录失败");
            // 获取数据
            System.out.println("编号\t卡号\t密码\t电话号码\t姓名");
            while(rs.next()){
                System.out.println(rs.getInt("id")+" "+rs.getInt("card")+" "+rs.getInt("pwd")+" "
                +rs.getInt("pho")+rs.getString("name"));
            }

        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {
            try {
                pre.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            try {
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }


}

 

Answer 1

因为你在第一个while循环的时候，已经把游标移动第一条数据了，你只有一条数据，第二次while循环后，就没有数据可取了