|
|
|
|
<%
try{
sttheam = con.createStatement();
sttheam.executeUpdate("update contest_detail set Contest_Hit = Contest_Hit+1 where Contest_Name = 'ADORA' and Pk_Contest_Keyword = 'ADORA'");
}catch(Exception _e){
out.println("Count Not Updated !!" + _e.getMessage());
}
%>
|
|
|
<%Statement stlist = con.createStatement();
ResultSet rslist=stlist.executeQuery("Select MAX(mar_id) maxid from marqueetab");
while(rslist.next())
{
maximum=rslist.getInt("maxid");
}
rslist.close();
stlist.close();
Statement stwin = con.createStatement();
ResultSet rswin=stwin.executeQuery("Select * from marqueetab where mar_id="+maximum);
while(rswin.next())
{
uniquebid=rswin.getString("mar_text");
}
rswin.close();
stwin.close();
con.close();
%>
|
|
|
|
