Displaying Sql query string results in jsp by using Spring Framework

[Raj chiru]

Hi Friends,
we are developing spring based we application,but Basic Requriements

1. A jsp apge to isnert the following into table
2. A jsp page to view the following based on ID or all if no ID is provided
3. based on data source id , get or execute SOL string from table and and display the results query results in view

For this i created spring controller,domain(POJO) object and dao object

I need your help how to get or execute SOL string and and display the results query results in jsp view based on data source id?

DROP TABLE ODB_US_DS_CFG;

CREATE TABLE ODB_US_DS_CFG
(
  ID         INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1, INCREMENT BY 1) PRIMARY KEY,
  NAME       VARCHAR(256),
  REFRESH_RATE   INTEGER,
  DS_DRIVER  VARCHAR(256),
  HOST       VARCHAR(256),
  PORT       INTEGER,
  SID       VARCHAR(256),
  USERNAME   VARCHAR(256),
  PASSWORD   VARCHAR(256),
  [b]SQL_STRING        VARCHAR(512)[/b]
)

Insert into ODB_US_DS_CFG
   (ID, NAME, INTERVAL, DS_DRIVER, HOST, 
    PORT, USERNAME, PASSWORD, SQL, SID)
Values
   (1, 'AR POLL STATUS', 60, 'jdbc: oracle:thin:', '10.14.11.100', 
    '1522', 'cdfdba', 'cdfdba', 'select * From dual', 'emadev');

[Raj chiru]

Any solution for this query?

[Naveen Madarapu]

use JdbcTemplate class...