How to put a query into scriptlet?

[federico.cattozzi]

 Hi,

I want to put a SQL query into a scriptlet to set a default value for a parameter.

What is the correct way?

Thanks.

[federico.cattozzi]

I answer to myself.

An example:

Code:

public class MyJRDefaultScriptlet extends net.sf.jasperreports.engine.JRDefaultScriptlet {}	public int getMaxValue(String s) throws JRScriptletException, SQLException{		Connection con = ((Connection)this.getParameterValue(JRParameter.REPORT_CONNECTION));		Statement stmt = null;		String query = "SELECT max(foo.value) FROM foo WHERE foo.s = '" + s + "'";		int max = 0;		try {			stmt = con.createStatement();			ResultSet rs = stmt.executeQuery(query);			while (rs.next()) {				max = rs.getInt("value");			}		} catch (SQLException e ) {					} finally {			if (stmt != null) { stmt.close(); }		}		return max;	}}