I would do this in Java or SSJS. 

I'm not much on the SQL side but I would seriously look at creating a say viewScope variable that you load with the returned Quantity, PartNumber etc. With each returned row as am element in the viewScope. ie in Native Notes terms the viewScope is a multi-value array of complex type, ie a Java Class. Then make this viewScope the dataSource for a repeat control on your XPage. 

I would seriously consider doing this all in JAVA, might take a bit more time the first time but think it would pay great dividends in the long run. David Leedy has a video on Notesin9.com on doing the JAVA side (think it is episode 182 but not sure). In his Demo he is getting the values from Notes documents where you would get them from your SQL query.

But  I have already create dthe agent in Lotus script.I don't have any idea of java.My question is can we run the lotus script agent from xpage.Please help
 

But  I have already create dthe agent in Lotus script.I don't have any idea of java.My question is can we run the lotus script agent from xpage.Please help
 

There are ways to run LS as a backend using SSJS

var agent:NotesAgent = database.getAgent("Your Agent Name");
            agent.runOnServer();

Converting LS to JS is not a really difficult issue. The syntax is a bit different but very doable. 

I do a fair bit with LS agents but they are all scheduled agents that run against the back-end with no user interaction. I probably should rewrite them as JAVA, but they are kind of legacy code and it would be a very big job. However, SSJS and Java are the way to interact with the user. 

If you want to use XPages then you had better get on the SSJS and Java track. There are a number of specific XPages on-line courses on SSJS and Java, plus Dave Leedy has several videos at http://notesin9.com 

Take the time now, it will save you a lot of time later.

B Dali,

Yes you can run an Agent from XPages.  It's not a "best practice" but it's possible.  Performance will suck if it's a busy website.

I've never done it so I can't help you how.  

You should try and use Google.com first.  I did a search for "call agent from xpages" and found a lot of good looking links.

Good Luck

May be you should look at the JDBC service of the Extension Library.

https://books.google.nl/books?id=KIeA3cm4THUC&pg=PA378&lpg=PA378&dq=jdbc+extension+library&source=bl&ots=d8_CgqW7Pw&sig=KfuTMeQHurtNLicwCsavH0qWzpA&hl=en&sa=X&ved=0CEcQ6AEwBmoVChMI2pu0gLC3yAIVRbkUCh1DxAPX#v=onepage&q=jdbc%20extension%20library&f=false