如何在java中将MySQL查询结果放入列表

Question

我有SQL查询，结果是多行多列。
我想执行此查询并将结果放入列表

"select LectureDay, LectureStatus from lecturelist where LectureName like "Java%"; 
res = pstmt.executeQuery();

我想在列表中查看查询结果

public static List<String> ResultList;

而语句看起来是这样的


    while(res.next())
            {
                String LectureStatus = res.getString("LectureStatus");
                String LectureDay = res.getString("LectureDay");
            }
            res.close();

代码：


public void GetData(){
String url = "jdbc:mysql://localhost/DB?serverTimezone=UTC";
String sql = "select LectureDay, LectureStatus from lecturelist where LectureName like "Java%";
pstmt = conn.prepareStatement(sql);
res = pstmt.executeQuery();
try 
        {           
            Class.forName(driver_name);
            conn = DriverManager.getConnection(url, user, password);
            pstmt = conn.prepareStatement(sql);
            while(res.next())
            {
                String LectureStatus = res.getString("LectureStatus");
                String LectureDay = res.getString("LectureDay");
            }
            res.close();
        catch (Exception e) 
        {
            System.out.println(e.getMessage());
        }       
        finally {
                try {
                    pstmt.close();
                    conn.close();
                } catch (Exception e) {
                    System.out.println(e.getMessage());
                }
        }
    }
}

谢谢你读到这篇文章




Answer 1

    public void GetData(){
    String url = "jdbc:mysql://localhost/DB?serverTimezone=UTC";
    String sql = "select LectureDay, LectureStatus from lecturelist where LectureName like "Java%";
    pstmt = conn.prepareStatement(sql);
    res = pstmt.executeQuery();
    List<String> list = new ArrayList<>();
    try
    {
        Class.forName(driver_name);
        conn = DriverManager.getConnection(url, user, password);
        pstmt = conn.prepareStatement(sql);
        while(res.next())
        {
            String LectureStatus = res.getString("LectureStatus");
            String LectureDay = res.getString("LectureDay");
            list.add(LectureStatus);
            list.add(LectureDay);
        }
        res.close();
    catch (Exception e)
        {
            System.out.println(e.getMessage());
        }       
    finally {
        try {
            pstmt.close();
            conn.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }
    }
}