How to write an java application that takes a sql query and a number as input and fire it those many times as number establishing a database connection using jndi lookup.
How to write an java application that takes a sql query and a number as input and fire it
148 views Asked by Shahid At
2
There are 2 answers
0
On
This the answer/piece of code I was looking for:
public void runUserQuery(final String userString, final int userInput) throws IllegalArgumentException, NamingException { System.out.println("Executing " + userString + " "+ userInput ); class NewDao extends JdbcDaoSupport {
public NewDao() throws IllegalArgumentException, NamingException {
JndiObjectFactoryBean bean = new JndiObjectFactoryBean();
bean.setJndiName("<JNDI Name>");
bean.afterPropertiesSet();
DataSource dataSource = (DataSource) bean.getObject();
setDataSource(dataSource);
}
public void executeQueryMultiple() {
int index = userInput;
while (index > 0) {
this.getJdbcTemplate().execute(userString);
index--;
}
}
}
;
NewDao dao = new NewDao();
dao.executeQueryMultiple();
}
Unfortunately I could not make you guys understand and got negative vote. :D
Depends very much on the DB you are using. But here is an example for Oracle. In general, you will need a
Connection
, aStatement
and aResultSet