How to store retrieved data from mysql and display as a result for user's search in java

try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/customer";
String uName = "root";
String password = ""; // unsafe sharing password
Connection con = DriverManager.getConnection(url, uName, password);
String query = "select * from mansions";
PreparedStatement ps = con.prepareStatement(query);
//ps.executeUpdate(); it wont accept query with select keyword
ResultSet rs = ps.executeQuery();
String str = "";
while(rs.next())
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getLong(3)+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getString(7)+" "+rs.getInt(8)+" "+rs.getString(9)+" "+rs.getString(10));
str = rs.getString(2);
System.out.println(str);
con.close();
} catch(Exception e){
System.out.println(e);
}


I am able to retrieve 10 columns from mansions table in mysql and this project is to find available mansions in particular area. I am done with creating table data and retrieve but I have to store and display as search results for the user to get available rooms . To achieve this how can I store mysql data and display as a result? I am not sure which one would help to get expected output. though I am beginner this is core java project I am using console to get user input
ex input from user is
gender : male, members : 1 or 2 , airconditioner : yes or no, food : yes or no
output : Rooms available please check below

mansion_names contact_numbers gender food persons_allowed airconditioned rent area available_rooms
Lahir 9003218193 male no 1 or 2 no 3000 Kodampakkam 4 non ac for single or doubles
please suggest me few so that I can try on my own. thanks friends...!!

1 Answer
1

You should annotate your method with @ResponseBody and @PostMapping and return the search results. Then you can do an AJAX post request each time the search is performed and get the return value of the method in your javascript (done by the @ResponseBody annotation).

@ResponseBody

@PostMapping

@ResponseBody

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.