
Hi. Here in my databse.
CREATE TABLE b ( id int(10) unsigned NOT NULL AUTO_INCREMENT, source varchar(45) NOT NULL, destination varchar(45) NOT NULL, distance int(10) unsigned NOT NULL, PRIMARY KEY (id) );
INSERT INTO b (id,source,destination,distance) VALUES (1,'Madurai','Chennai',10), (2,'Chennai','Bangalore',10), (3,'Chennai','Kanchipuram',5), (4,'Kanchipuram','Arani',15), (5,'Arani','Arcot',20), (6,'Madurai','Bangalore',5), (7,'Bangalore','Kanchipuram',20);
Now i want to find the shortest path from the given source to destination based on the databse values. I want to do this in JSP. I have to get the source and destination in text box in one HTML page. and forward that to one JSP page and I have to do this calculation there. How do I do? Please report quickly. Thanks in advance.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.