java连接输出,java jdbc连接 - 结果集输出问题

我目前正试图实现一个jdbc连接，当我搜索与'%input%'输入相匹配的任何内容时，它将返回表中的所有数据。

例如ResultSet rs4 = stm4.executeQuery("select imageTime from image_data where imageName like '%" + value3 + "%' or imageTime like '%" + value3 + "%' or imageLocation like '" + value3 + "'" );

我试图将结果集中的所有行作为搜索结果返回。

但如果我有没有更多的行要去Resultset.next命令

导致以下结果集全为空，....

如果任何id喜欢输出整个结果集的方法，谢谢。

编辑

编辑问题：更直接;我需要一种方法来获取每个包含结果集列的每一行数据。所以我可以输出它。

这是我在下面的尝试。

rs4 =下面声明的结果集。

这是我的代码;

if(name_time_location == 1)

{

String value3=searchInput.getText();//Sets the search Input as value3

// selecting the cominbation from table, that match input options

try{

con = DriverManager.getConnection("jdbc:mysql:blah blah");

// Query the database for the correct username and passord

Statement stm3 = con.createStatement();

Statement stm4 = con.createStatement();

Statement stm5 = con.createStatement();

//queries database for password from input username

ResultSet rs3 = stm3.executeQuery("select imageName from image_data where imageName like '%" + value3 + "%' or imageTime like '%" + value3 + "%' or imageLocation like '" + value3 + "'" );

//ResultSetMetaData rsmd = rs3.getMetaData();

//stm3.setFetchSize(5);

//rs3.last();

//int numberOfRows = rs3.getRow();

//String[] resultList;

//resultList = new String[numberOfRows];

// Fetch each row from the result set

rs3.beforeFirst();

while(rs3.next())

{

imageSearchResult1 = rs3.getString(1);

rs3.next();

imageSearchResult11 = rs4.getString(1);

rs3.next();

imageSearchResult12 = rs4.getString(1);

rs3.next();

imageSearchResult13 = rs4.getString(1);

rs3.next();

imageSearchResult14 = rs4.getString(1);

}rs3.close();

}catch (Exception e)

{

//System.out.println("Exception: " + e + "");

}

System.out.println("Search Results: \nName: " + imageSearchResult1 + " Time stamp: " + imageSearchResult2 + " Location: " + imageSearchResult3 + "\n" +

"Name: " + imageSearchResult11 + " Time stamp: " + imageSearchResult21 + " Location: " + imageSearchResult31 + "\n" +

"Name: " + imageSearchResult12 + " Time stamp: " + imageSearchResult22 + " Location: " + imageSearchResult32 + "\n" +

"Name: " + imageSearchResult13 + " Time stamp: " + imageSearchResult23 + " Location: " + imageSearchResult33 + "\n" +

"Name: " + imageSearchResult14 + " Time stamp: " + imageSearchResult24 + " Location: " + imageSearchResult34 + "\n" );