Help..Java(EDITING A STORED DATA IN ACCESS)..

[johnC]

---

unsa sayup ani ako code?di lagi sya mo edit!!humana ko sa add ug delete..edit nlng gyud kuwang!!

edit.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){

Connection con = null;

String value1,value2,value3,value4,value5,value6,value7,v alue8;

value1 = searchM1.getText();
value2 = RegisterLN1.getText();
value3 = RegisterFN1.getText();
value4 = RegisterMN1.getText();
value5 = RegisterAGE1.getText();
value6 = RegisterGENDER1.getText();
value7 = RegisterADDRESS1.getText();
value8 = RegisterNUMBER1.getText();

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:vid");

Statement sti = con.createStatement();
sti.executeUpdate("UPDATE Membership_Record SET MemberLastName = '"+value2+"', MemberFirstName = '"+value3+"', MemberMiddleName = '"+value4+"', Age = '"+value5+"', Gender = '"+value6+"', Address = '"+value7+"', ContactNumber = '"+value8+"' WHERE MemberID = '"+value1+"'");

JOptionPane.showMessageDialog(null,"Updated successfully");
con.close();
}
catch(Exception e) {

JOptionPane.showMessageDialog(null,"Error in updating edit fields");
}

}
});

plss help mga bro

[sideon]

If this code doesnt have any exception, possible reason is that the supplied MemberID is not on the database. Maybe there is some unnecessary spaces on it, kindly check.

[johnC]

same ghapon..wala gyud..wala syay sayop ana brad?

[sideon]

would you mind to try another alternative... e.g use PreparedStatement instead. It makes your code cleaner and besides its a god practice than using Statement.

String updateQuery = "UPDATE Membership_Record SET MemberLastName = ?, MemberFirstName = ?, MemberMiddleName = ?, Age = ?, Gender = ?, Address = ?, ContactNumber = ? WHERE MemberID = ?";

PreparedStatement ps = con.prepareStatement(updateQuery);
ps.setString(1, value2);
ps.setString(2, value3);
// .... continue to set your parameter here

ps.executeUpdate();

[johnC]

is it the same as edit?hehe

[stealthghost]

same ra na siya bro..

unsa man ang Exception or error message ni-gawas?
Ilisi imu catch og ingon ani,

catch(Exception e){
e.printStackTrace(); //Mu-gawas ni sa console or command-prompt ang error
JOptionPane.showMessageDialog(null,"Error in updating edit fields \nError: "+e.getMessage());
}

makit.an na dayon nimo ang katag.. hehehe..

post nya unsa'y error message.. or how you solved it.

[peterparker]

bro, dili ko kamao ug java pero medyo parehas raman ug c# ang syntax, i noticed sa imong code murag kulangan ug executeNonquery, pero im not sure ha if applicable na cya in java.

[johnC]

same ra na siya bro..

unsa man ang Exception or error message ni-gawas?
Ilisi imu catch og ingon ani,

catch(Exception e){
e.printStackTrace(); //Mu-gawas ni sa console or command-prompt ang error
JOptionPane.showMessageDialog(null,"Error in updating edit fields \nError: "+e.getMessage());
}

makit.an na dayon nimo ang katag.. hehehe..

post nya unsa'y error message.. or how you solved it.

found the error..ako ki ilisan ang sa MemberID=' "+value1+" ' " into MemberID = "+value+" "..hehe..kalimot ko na number man diay ako nagamit..autonumber man gud..ako ki tang2x single quote unya na okie na..hehe..ty sa help bro

bro, dili ko kamao ug java pero medyo parehas raman ug c# ang syntax, i noticed sa imong code murag kulangan ug executeNonquery, pero im not sure ha if applicable na cya in java.

tnx bro..pero okie na ako code..hehe