java
Question
The below code is for one button two action performed one is inserting into a table and updating in other table it is not working it is not updating the data even after using select statement it is giving error "Array Index Out ofBound Exception".please help me
if(e.getSource()==details)
{
try
{
//String fileno=insfile.getText().toString();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:MyDataSource");
Statement stmt=con.createStatement();
PreparedStatement stat=con.prepareStatement("INSERT INTO instalment VALUES(?,?,?,?,?,?,?,?,?,?)");
String fileno=tinsfno.getText();
String stname=tinsname.getText();
String totfee=tinstotfee.getText();
String bal=tinsbalance.getText();
String duedate=tinsduedate.getText();
String noofinstalment=tinsno.getText();
String balpay=tinsbal.getText();
String paydate=tinspaydate.getText();
String baltobepaid=trial.getText();
String receipt=tinsreceipt.getText();
stat.setInt(1,Integer.parseInt(fileno));
stat.setString(2,stname);
stat.setInt(3,Integer.parseInt(totfee));
stat.setInt(4,Integer.parseInt(bal));
stat.setString(5,duedate);
stat.setInt(6,Integer.parseInt(noofinstalment));
stat.setInt(7,Integer.parseInt(balpay));
stat.setString(8,paydate);
stat.setInt(9,Integer.parseInt(baltobepaid));
stat.setInt(10,Integer.parseInt(receipt));
stat.executeUpdate();
con.commit();
JOptionPane.showMessageDialog(null,"instalment details are saved","MESSAGE",JOptionPane.PLAIN_MESSAGE);
fileno=tinsfno.getText().toString();
PreparedStatement stat1=con.prepareStatement("UPDATE fees SET balance=? where fileno=?");
String balance=tinsdue.getText();
stat1.setInt(1,Integer.parseInt(fileno));
stat1.setString(2,stname);
stat1.setInt(3,Integer.parseInt(totfee));
stat1.setInt(4,Integer.parseInt(balance));
stat1.executeUpdate();
con.commit();
Statement read=con.createStatement();
read.execute("select * from fees");
ResultSet set=read.getResultSet();
while(set.next())
{
System.out.println(set.getInt(1));
}
JOptionPane.showMessageDialog(null,"updated","Message",JOptionPane.PLAIN_MESSAGE);
con.close();
}
catch (Exception er)
{
System.out.println(er);
JOptionPane.showMessageDialog(null,"please check","MESSAGE",JOptionPane.PLAIN_MESSAGE);
}
}
View Answers
April 10, 2010 at 5:23 PM
Hi Friend,
Please post your full code.
Thanks
Related Tutorials/Questions & Answers:
javajava diff bt core
java and
java Advertisements
java java why iterator in
java if we for loop
Java Java Whether
Java is pure object oriented Language
JAVAJAVA how the name came for
java language as "
JAVA javajava explain technologies are used in
java now days and structure
java javajava different between
java & core
java javajava is
java open source
javajava what is
java reflection
java java in
java does not pointers concept but what is nullpointers in
java?
nullpointer is a runtime Exception
javawhat is the size of array in
java ? what is the size of array in
java ?
what is the mean of finalize in
java javajava why to set classpath in
java javajava RARP implementation using
java socket
javajava sample code for RARP using
java JavaJava how to do
java in command prompt
javajava how use
java method
javajava is
java purely object oriented language
javajava why multiple inheritance is not possible in
java javajava give a simple example for inheritance in
java javajava give a simple example for inheritance in
java javajava why to set classpath in
java javajava why to set classpath in
java javajava why to set classpath in
java java java What is ?static? keyword
javajava Does
java allows multiline comments
javajava Write a
java code to print "ABABBABCABABBA
javajava write a program in
java to acess the email
javajava send me
java interview questions
javajava what are
JAVA applications development tools
JavaJava Whether
Java is Programming Language or it is SOftware
javajava explain object oriented concept in
java java java difference between class and interface
JavaJava how to draw class diagrams in
java javajava write a
java program using filenotfoundexception
javajava how to edit text document by using
java
then how to edit starting and ending of text document by using
java javajava different between
java & core
java
print("code sample
java java how can use sleep in
java
which book learn of
java language
java java How to set
java Policy for applet using jdk 6
javajava pattern code for a given words
java pattern code for a given words pattern
javajava dear,
i want a field for date picker using
java/
java script
javajava create
java program for delete and update the details,without using database, just a normal
java program
javajava why methods in
java raise exceptions
Have a look at the following link:
Java Exceptions
javajava code to search the nodes how to write the
java code to search the nodes using routers
javajava online telephone directory i need coding for online telephone directory..by using
java....pls help me
javajava different between
java & core
java
print("code sample
javajava how to invoke one chart
java file from another
java file
javajava how to prepare the
java
Hi Friend,
If you want to learn how to install
java, creating and running a
java program then go through the following links:
http://www.roseindia.net/
java/beginners/index.shtml
http
javajava
java swing
Swing is a principal GUI toolkit for the
Java programming language. It is a part of the JFC (
Java Foundation Classes), which is an API for providing a graphical user interface for
Java programs
javajava what is the need of
java if
java is not there what will happen... work unless you have
Java installed, and more are created every day.
Java... to scientific supercomputers, cell phones to the Internet,
Java is everywhere!
http