Getting Problem in Delete operation in Struts application

Hi All,

I am creating a CRUD struts application. In this application in delete application.
When you delete a record, it should immediately removed from the database and remaining records should be displayed on the jsp.

But in this application when deletion happens for any record, that deletion does not taken into effect untill and unless you restart the application.

Below are the code for jsp where the records are being displayed and LogonData class with getUsers() and removeUser() frunctions.

userlist.jsp
=======

<%@ taglib  uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>

<body>
        <html:errors/>
        <h2><font face="VERDANA"><center><bean:message key="logon.userlist"/></center></font></h2>
        <hr>
        <center>
            <table  border="0"  >
                 <tr >
                     <th><bean:message key="logon.username"/></th>
                     <th><bean:message key="logon.password"/></th>
                 </tr>
                 
 
                 <logic:iterate id="user" name="users">
                     <tr >
                         <td>
                             <bean:write name="user" property="username"/>
                         </td>
                         <td>
                             <bean:write name="user" property="password"/>
                         </td>
                         <td>
                             <a href="Delete.do?username=<bean:write name="user" property="username"/>">Delete</a>
                         </td>
                     </tr>
                 </logic:iterate>
             </table>
        </center>
    </body>
</html>

LogonData.java
==========

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package app;

//import javax.sql.DataSource;
//import org.apache.commons.dbcp.BasicDataSource;
import java.sql.*;
import java.util.ArrayList;
//import app.LogonConn;
//import app.User;

/**
 *
 * @author Jay Shukla
 */
public class LogonData {
    public static ArrayList getUsers(){
        System.out.println("\nThis is a getUsers\n");
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        User user = null;
        ArrayList users = new ArrayList();        
        
        try{            
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/logon", "root", "");
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from user_login_detail");
            while(rs.next()){
                user = new User();
                user.setUsername(rs.getString("username"));
                user.setPassword(rs.getString("password"));
                users.add(user);
                
            }
             System.out.println("\n Count "+ users.size()+"\n  ");
        }catch(Exception e){
            System.err.println(e.getMessage());
        }finally{
            if(rs != null){
                try{
                    rs.close();
                }catch(SQLException sqle){
                    System.err.println(sqle.getMessage());
                }
            }
            if(stmt != null){
                try{
                    stmt.close();
                }catch(SQLException sqle){
                    System.err.println(sqle.getMessage());
                }
            }
            if(conn != null){
                try{
                    conn.close();
                }catch(SQLException sqle){
                    System.err.println(sqle.getMessage());
                }
            }
        }
       return users;
    }
    public static void removeUser(String username){
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
                       
        try{            
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/logon", "root", "");
            stmt = conn.createStatement();
            System.out.println("\nThis is a removeUser functions\n");
            stmt.execute("delete from user_login_detail where username='" + username + "'");
            getUsers();
        }catch(Exception e){
            System.err.println(e.getMessage());
        }finally{
            if(rs != null){
                try{
                    rs.close();
                }catch(SQLException sqle){
                    System.err.println(sqle.getMessage());
                }
            }
            if(stmt != null){
                try{
                    stmt.close();
                }catch(SQLException sqle){
                    System.err.println(sqle.getMessage());
                }
            }
            if(conn != null){
                try{
                    conn.close();
                }catch(SQLException sqle){
                    System.err.println(sqle.getMessage());
                }
            }
        }      
    }   
}

What is going wrong ? What changes needs to be done so when delete a record, it immediately taken into effect. (All records should be immediately displayed without the one deleted).

Thanks in Advance.

Redisplay the page with caching disabled.

Hi David,

Thanks for reply.
Could you let me know how to disable caching?

Thanks in Advance.

Search the web for disabling caching; there are like 3-4 headers to set.