• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

servlet queries

 
jagan billa
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to use this query in servlet
*****combine two database******

database1:registration
database2:shopping_cart
online is a common table in both database

SELECT registration.online.price, shopping_cart.online.name FROM registration.online, shopping_cart.online WHERE registration.online.id = 1 AND shopping_cart.online.id = registration.online.id;

how to define two database name in this

c=DriverManager.getConnection("jdbc:mysql://localhost:3306/database name","root","root");


 
Rob Spoor
Sheriff
Pie
Posts: 20610
63
Chrome Eclipse IDE Java Windows
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You just need one of the two databases to connect to. The database prefix inside the query will take care of the rest.
 
Janarthanan Rajendran
Greenhorn
Posts: 7
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do not use Business logic inside Servlets, it should always go through Service classes.

Regards,
Jana
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic