Java Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingJava Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old March 4th, 2005, 02:52 AM
abhit_kumar abhit_kumar is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Posts: 22 abhit_kumar User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 m 3 sec
Reputation Power: 0
automatic insertion of new record.....help......

i have done insertion of 6 field in the database..which is working good(code is below)...Now i want to do stuff that when i insert 6 field in database, then a new record also has to be insert into the database, in that new record the following changes should be done.

1)if i insert field code no ex.. 20 is inserted into the database then the a new code no 120 should be generated and inserted into database (the new code no should be started with 1, then the orginal code no will come) ex.. 10=101, 11=111, 256=1256,257=1257. The bold part is orginal record entered by the user, and the new record isnot bold.

2)Percentage field is there,ex 12%, 13% etc values will come , it calculates the percentage of credit amount field values and insert that values into the debit amount field of new record.

In my following code the code no is displayed as code, debit amount is shown as DrAmount, credit amount is shown as CrAmount, percentage field is shown as pct.

conn.setAutoCommit(false); PreparedStatement pstmt = conn.prepareStatement("INSERT INTO gl_mast VALUES (?, ?, ?, ?, ?, ?)"); for (int i=1; request.getParameter((i==1)?"code""code_" +i)) != null; i++){ String Code1=request.getParameter((i==1)?"code""code_" +i)); int Code=Integer.parseInt(request.getParameter((i==1)? "code""code_" +i)));pstmt.setInt(1,Code); String Description=request.getParameter((i==1)?"Description""Description_" +i));pstmt.setString(2,Description); float Dr_Amt =Float.parseFloat(request.getParameter((i==1)?"DrAmount""DrAmount_" +i)));pstmt.setFloat(3,Dr_Amt ); float Cr_Amt =Float.parseFloat(request.getParameter((i==1)?"CrAmount""CrAmount_" +i)));pstmt.setFloat(4,Cr_Amt); String Type =request.getParameter((i==1)?"type""type_" +i));pstmt.setString(5,Type ); float Pct =Float.parseFloat(request.getParameter((i==1)?"pct""pct_" +i)));pstmt.setFloat(6,Pct); pstmt.addBatch();conn.commit();conn.setAutoCommit( true); pstmt.executeBatch();

plz...look at my code and solved my prob....

thanx

Reply With Quote
  #2  
Old March 4th, 2005, 07:23 AM
MadCowDzz's Avatar
MadCowDzz MadCowDzz is offline
I'm Internet Famous
Dev Articles Frequenter (2500 - 2999 posts)
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 2,886 MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Week 16 h 19 m 35 sec
Reputation Power: 18
Any chance you could repost your code?

wrap it in [code][/code] tags to preserve your formatting.

And your example: "ex.. 10=101"
I assume you mean 10=110

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingJava Development > automatic insertion of new record.....help......


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap