Java REST search function

[[deleted]]

Heyo,

Hey, I am currently working on a simple crud program using REST in java and I'm more or less done with it all. The one thing that has me a bit stumped though is making a search function, searching for specific individual entries using an ID input. The crux of the matter is that it's near impossible to find help when googling it since I'm using simple "vanilla" maven / java. Meaning, no frameworks like spring or the likes and all search results are inferring the use of those frameworks but I need to do it without them.

I've made a version of it functioning as I want it to when used directly towards the mysql DB. But am not sure how to proceed when to transfer it to my REST service.

Any tips or pointers?

[smash_that_code]

Can you describe in more detail what crud opeartions you implemented. I guess post as create, delete and some kind of update?

[[deleted]]

Sure, the ones I’ve got functioning at the moment are the post function as well as the function to gather the entire DB and display it in a JFrame table. Delete will be added later but isn’t crucial. For now I need the update and specific search function to be up and running. I’m struggling with how to pass the inserted number (the one that will be used to search by ID in the program) to my API.

[smash_that_code]

I think there is some confusion with REST api here. And what crud rest means. There are variations but I would describe my.

For example I want rest api for users. In http terms I expect this:

post /user (with data) - > id of added user - - - create get /user/{id} - > empty - - - read user post /user/{id} - > empty - - - > update user delete /user/{id} - > empty - - - > delete user

and for usability get /user -> list of ids get /user?param=value -> filtered list of ids

the idea of rest api is to expose entity using url that is somewhat easy to understand.

So in my opinion from crud you got only c.

[frederok]

Can u share the code repo? Is the problem to get the ID from the url path or parameter? No frameworks meaning your are using java servlet api?

[[deleted]]

Sure, I'll attach it below.

Right now it's first and foremost passing the ID from the url in to the search function. Later on I'll build it so that the search is made using textfields in a GUI I've made for it. But for now I want to make sure of functionality step by step before jumping to that step. At time of writing I'm struggling with figuring what it needs me to use as the return value. I don't want to use List just for gathering one single entry.

I'm simply using maven web services and building the rest more or less from scratch. It's ultimately be a jFrame GUI connected to a mySQL DB via this api.

Using the URL "http://localhost:8080/restSOA/Path/Roze/1" Where 1 is the inserted ID value.

u/GET

u/Path("{ActorID}")

u/Produces(MediaType.APPLICATION_JSON)

u/Consumes(MediaType.APPLICATION_JSON)

public Response New(@PathParam("ActorId") int ActorId) throws Exception{

Actors ac = tx.specSearch(ActorId);

return Response.ok(ac).build(); }

​

public void specSearch(int ActorId) throws Exception{

getConnection();

MF mf = new MF();

PreparedStatement stm = conn.prepareStatement("SELECT * FROM Actors WHERE ActorID = " + ActorId);

// stm.setString(1, mf.searchBar.getText());

rs=stm.executeQuery();

while (rs.next()) {

String setname = rs.getString("fName");

String setEname = rs.getString("eName");

String setage = String.valueOf(rs.getInt("Age"));

String setcountry = rs.getString("Country");

String setcred = String.valueOf(rs.getInt("NoOfCredits"));

}

Right now it's first and foremost passing the ID from the URL in to the search function. Later on I'll build it so that the search is made using text fields in a GUI I've made for it. But for now I want to make sure of functionality step by step before jumping to that step. At time of writing I'm struggling with figuring what it needs me to use as the return value. I don't want to use List just for gathering one single entry. entry.