DaniWeb Forum Index > Web Development > JSP

Multiple Prepared Statements in JSP

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 65

Reputation: CodeBoy101 is an unknown quantity at this point

Solved Threads: 0

CodeBoy101 CodeBoy101 is offline

Offline

Junior Poster in Training

Multiple Prepared Statements in JSP

Aug 22nd, 2009

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.

•

Join Date: Oct 2008

Posts: 2,612

Reputation: adatapost has much to be proud of

Solved Threads: 463

adatapost

Offline

Posting Maven

Re: Multiple Prepared Statements in JSP

Aug 22nd, 2009

 Help with Code Tags 
 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();
      ....

Failure is not fatal, but failure to change might be. - John Wooden

•

Join Date: Dec 2004

Posts: 4,190

Reputation: peter_budo has much to be proud of

Solved Threads: 483

peter_budo peter_budo is offline

Offline

Code tags enforcer

Re: Multiple Prepared Statements in JSP

-1

Aug 23rd, 2009

•

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.

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group