dcsimg
preparedstatementy
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   pavan_sharma
Posted On:   Tuesday, January 9, 2007 02:34 AM

I have this code for example.......... sqlstmt = "UPDATE CATEGORIES SET SUB=? , HAS_SUB=? WHERE ID=?"; pstmt = conn.prepareStatement(sqlstmt); pstmt.setString(1,subcatids); pstmt.setString(2,"Y"); pstmt.setString(3,selsubcat); pstmt.executeUpdate(); There is no problem in code...and query updated successfully... but here i want to print the 'sqlstmt' statement....to know what exactly query contain in place of palce holder (?)... how can print it with preparedstatement.... Reply me ASAP Thanks    More>>

I have this code for example..........


sqlstmt = "UPDATE CATEGORIES SET SUB=? , HAS_SUB=? WHERE ID=?";
pstmt = conn.prepareStatement(sqlstmt);
pstmt.setString(1,subcatids);
pstmt.setString(2,"Y");
pstmt.setString(3,selsubcat);

pstmt.executeUpdate();


There is no problem in code...and query updated successfully...

but here i want to print the 'sqlstmt' statement....to know what exactly
query contain in place of palce holder (?)...

how can print it with preparedstatement....

Reply me ASAP

Thanks

   <<Less
About | Sitemap | Contact