How to reuse the prepared statement ?

[Shuang mu]

hai,
now i face a big problem is can i reuse the prepared statement? each time i try to reuse it but i fail, all the reference refer to the same data make the update statement cannot be execute,
so please help me to solve this problem......
thanks....

[Dave Vick]

Shuang
Something like this should do it for you:

pStmt = conn.prepareStatement( “INSERT INTO names (fname, lname) VALUES (?, ?)”  :wink:  ;
pStmt.clearParameters( );    // clear any pre-exisitng parameters
 
pStmt.setString(1, “Bob”  :wink:  ;
pStmt.setString(2, “Finklestein”  :wink:  ;
pStmt.executeUpdate( );
pStmt.clearParameters( );    // clear any pre-exisitng parameters
 
pStmt.setString(1, “Joe”  :wink:  ;
pStmt.setString(2, “Schmuckatelly”  :wink:  ;
pStmt.executeUpdate( );

[ April 01, 2002: Message edited by: Dave Vick ]