Posts
 
Reputation
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
~2K People Reached
Favorite Tags
Member Avatar for tapas.chand

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 …

Member Avatar for javaAddict
0
1K
Member Avatar for tapas.chand

i am saving some records in an excel file on click of a button currently i am hardcoding the path like [CODE]FileOutputStream fileOut = new FileOutputStream("c:\\test.xls"); [/CODE] but i want to take the path from user,i.e.,something like 'save as' option how can i do it? please help. Thanks in advance.

Member Avatar for tapas.chand
0
96
Member Avatar for tapas.chand

[CODE] hi there, i am using a sliding bar on my homepage.i want to set focus on a textbox but [COLOR="Green"]document.getElementById("userid").focus() is giving[/COLOR]error,because textbox is invisible on page load. is there any way to do this? Thanks in advance. [/CODE]

Member Avatar for tapas.chand
0
137
Member Avatar for tapas.chand

[CODE] [B]Hi there I am using several insert statements in a method in Java. If the connection fails in between I want to roll back the inserted rows. I cant use [COLOR="Green"]con.rollback()[/COLOR], because there is no connection. How to handle such situation? Thanks in advance.[/B][/CODE]

Member Avatar for tapas.chand
0
72