Hi why is it my database never update/edit its data

[RichersooN]

I created a program that will update a database, ms access via odbc, supposedly it will update data in the database, there's no error but the database didn't update:

dbEdit.java

public class dbEdit extends dbConnection{
	PreparedStatement statement=null;
	
	public dbEdit (){
		super();
	}
	
	public void saveToDb(String mySql){
		try{
			statement = con.prepareStatement(mySql);
		    statement.executeUpdate();
		}catch(SQLException sqlex){
			sqlex.printStackTrace();
		}
	}
		
	public static void main(String[]args){
		dbExaminee f = new dbExaminee();
		f.saveToDb("update examineeplanttb set remark='FAILED' ");
	}
}

dbConnection.java

public class dbConnection {

    public dbConnection(){
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        	con = DriverManager.getConnection(dbSearchUrl,dbSearchUser,dbSearchPassword);
        }catch(ClassNotFoundException cnfex){
            JOptionPane.showMessageDialog(null, "Failed to load JDBC/ODBC driver.");
            cnfex.printStackTrace();
            System.exit(1); //terminate program
        }catch(SQLException sqlex){
            JOptionPane.showMessageDialog(null, "Failed to load JDBC/ODBC driver.");
            sqlex.printStackTrace();
            System.exit(1); //terminate program
        }
    }

    protected Connection con;
    protected static final String dataSourceName = "psalmDSN";
    protected static final String dbSearchUrl = "jdbc:odbc:" +dataSourceName;
    protected static final String dbSearchUser = "";
    protected static final String dbSearchPassword = "";
}

Please tell me whats wrong with my code

[Tolls]

Does MS-Access require a commit() call?
I do notice you never close your resources (statement or connection), but that won't be anything to do with it.

If the commit isn't the reason, then does that update statement work directly in Access?

[RichersooN]

Closing of connection and statement will not be an issue, either commit is not an issue, thats not only update the current data in the database.

Help please

[Tolls]

You still need to close your resources...that's basic JDBC.

If it's not a commit issue then either you are not using the same database, you are not checking the update correctly, or there is nothing to update.

None of which we can help you with since we cannot see your database.
How are you confirming whether the update has worked?

[mine0926]

Try

protected static final String dbSearchUrl = "jdbc:Odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" +dataSourceName;

Try to check (in program) if the database exist on the path.