Ad:

JSP Discussion Thread
Unsolved
Views: 1235

Aug 22nd, 2009

Multiple Prepared Statements in JSP

Expand Post »

Hello all, I've been working on a project where I wish to retrieve two sets of information from a MySQL database using two prepared statements. When I try to do this I get a blank screen, but the first query is successfull executed. Any suggestion would be greatly appreciated.

Thanks.

Similar Threads

how to upload multiple files using jsp in JSP
inserting multiple selection from checkbox in to one column in JSP
Using Prepared Statements in JAVA in Java
Retriving multiple values from Database using JSp in JSP

CodeBoy101

Reputation Points: 8

Solved Threads: 0

Junior Poster in Training

Offline

71 posts
since Dec 2007

Permalink

Aug 22nd, 2009

Re: Multiple Prepared Statements in JSP

jsp Syntax (Toggle Plain Text)
      ....
      String query = "insert into table(stringcol, numcol) values(?, ?)";
      pstmt = conn.prepareStatement(query);
      pstmt.setString(1, "A");
      pstmt.setInt(2, 10);
      pstmt.addBatch();
 
      pstmt.setString(1, "B");
      pstmt.setInt(2, 2);
      pstmt.addBatch();
 
      int[] updateCounts = pstmt.executeBatch();
      checkUpdateCounts(updateCounts);
      conn.commit();
      ....
      ....
      String query = "insert into table(stringcol, numcol) values(?, ?)";
      pstmt = conn.prepareStatement(query);
      pstmt.setString(1, "A");
      pstmt.setInt(2, 10);
      pstmt.addBatch();

      pstmt.setString(1, "B");
      pstmt.setInt(2, 2);
      pstmt.addBatch();

      int[] updateCounts = pstmt.executeBatch();
      checkUpdateCounts(updateCounts);
      conn.commit();
      ....

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Aug 23rd, 2009

-1

Re: Multiple Prepared Statements in JSP

Click to Expand / Collapse Quote originally posted by CodeBoy101 ...

Hello all, I've been working on a project where I wish to retrieve two sets of information from a MySQL database using two prepared statements. When I try to do this I get a blank screen, but the first query is successfull executed. Any suggestion would be greatly appreciated.

Thanks.

Not normal behaviour. If adatapost will not solve it please provide code sample of you using.

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 873

Code tags enforcer

Offline

6,656 posts
since Dec 2004

Permalink

Aug 24th, 2009

-1

Re: Multiple Prepared Statements in JSP

I have a question, what if I was trying to work with more than one table?

CodeBoy101

Reputation Points: 8

Solved Threads: 0

Junior Poster in Training

Offline

71 posts
since Dec 2007

Permalink

Aug 25th, 2009

-1

Re: Multiple Prepared Statements in JSP

Click to Expand / Collapse Quote originally posted by CodeBoy101 ...

I have a question, what if I was trying to work with more than one table?

It makes no difference to us...

Now, are you gone answer previous question about code you using?

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 873

Code tags enforcer

Offline

6,656 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JSP Forum Timeline: How to create web proxy through jsp

Next Thread in JSP Forum Timeline: Please help

DaniWeb Message

Cancel Changes

User Name
Password