0

I am trying to create a set of restful webservice in java using netbeans and mysql database. Netbeans allows creation of webservice on top of tables and views. I want to create a webservice based on joins on multiple tables along with where clause with conditions based on web service parameters.

My questions are:

  1. is this possible?
  2. what are different alternatives and the best possible way to achieve this?
  3. are there any samples available?
Abhishek Kumar
  • 41
  • 7

1 Answers1

0

Yes, it is possible. And since this is already answered in detail, i will give you link for same.

Need to write a RESTful JSON service in Java

Community
  • 1
  • 1
Maulik Shah
  • 402
  • 1
  • 4
  • 18
  • If one adds a comment on the reason to down-vote the answer, it would help avoiding mistakes – Maulik Shah Jul 24 '15 at 07:10
  • Thanks Maulik, your links talks about single table but not web service based on join multiple tables. Can you point me to the sample with multiple tables? – Abhishek Dhote Jul 24 '15 at 11:23
  • [This link](http://www.oracle.com/webfolder/technetwork/tutorials/obe/java/RESTfulWebServices/RESTfulWebservices.htm) will help you to create web service via Net Beans on multiple tables. It uses a different database though – Maulik Shah Jul 24 '15 at 11:33
  • Hi Maulik, the post here talks about two tables but not about the join of two tables... – Abhishek Dhote Jul 24 '15 at 17:33