Hi everyone, I want to retrieve data from database in jsp page .I am finding it very difficult so please can you all help me out with the problem. Here is the structure of my database and i am using ms.access
now i want to display the m_bal for pl,sl,cl in the jsp page for the respective userid who has logged in. Please help me its very urgent. thanks in advance.
Thanks for the help you provided me .the code that you have provided me is joining two tables and retreiving data onto the jsp page with respect to particular primary key,isn't it.if i am wrong please rectify me . I have to retreive the m_bal with respect to the emp no for each sl,pl,cl onto the jsp page as given above .suppose you have to show the user his leave balance which are pl,sl,cl by retrieving data from the given above table and m_bal is the leave balance of the particular user .there is no primary key defined so there are three rows of 1004,1009 etc for each pl,sl,cl please find the remedy . thanks.
I have got the rows from the database but if i want to display values of pl=30 ,sl=7 ,cl=7 onto the jsp page, is this the way i should write it as stated in "bold" or else what i am doing is wrong .please correct me if i am making a mistake . thanks in advance.
hi sreesnath, Actually i am totally confused with this problem,so not able to think anything.can you please provide me with an example which will guide me to the solution.please help me thanks in advance