Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
Re:
hello, i am using preparestatement to insert muliple rows into database. [CODE]String query = "insert into table_temp(col1,col2) values(?,?)"; pstmt = con.prepareStatement(query); pstmt.setString(1,"a"); pstmt.setInt(2,100); pstmt.addBatch(); pstmt.setString(1,"b"); pstmt.setInt(2,null); pstmt.addBatch(); int[] cnt = pstmt.executeBatch(); [/CODE] My problem is that in the 2nd addBatch block i dont want to insert any value into the … |