Help in MVC please

Hi,

i've written the below jsp. now i want to make it into a MVC pattern. could you please help me how do i do it. i request you to please divide the code and edit it(i want to have an idea how it is to be done so that i'll implement in my other jsps).

<%@page import="java.util.Date"%>
<%@include file="DBCon.jsp" %>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
    
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
<script language="javascript">
    function UnBloc1(test){
        var temp3id= 'temp3' + test;
        var temp4id= 'temp4' + test;
      //alert(temp3id);
      
      document.getElementById(temp3id).style.display='block';
      document.getElementById(temp4id).style.display='block';
    }
    
    function invoke(but1)
    {
        //var x=document.getElementById("temp3"+but).value;
        //alert(x);
         document.abc.action="Up_Query_DB.jsp?val1="+but1;
         document.abc.submit();
    }
    function invoke1(but)
            {    
         document.abc.action="Users_2.jsp?val="+but;
         document.abc.submit();
         
         //var t=document.getElementById("ab")+z;
         //alert(t);
            }
</script>
</head>
<body>
<form name="abc" method="post" action=""><table>
<%
try
               {
    String s=(String)session.getAttribute("muusername");
    int i=0;
    int temp=0, temp1=0,temp2=0, temp3=0, temp4=0;
    ps=con.prepareStatement("Select DBID,Query_Raised,TR from Scope2 where TR!='null' AND (Query_Answered is null OR Count1 is null) And Specialist='"+s+"'");
    rs=ps.executeQuery();
    out.println("<b>QueryRaised</b>");
       while(rs.next())
                   
        {
                  
           i++;
           %>
                      
                      <tr>
                      <td><input type="text" value="<%=i%>" name="id1" id="id1"></td>
                      <td><center><input type="text" value="<%=rs.getString("DBID")%>" readonly id="abc<%=i%>" name="abc<%=i%>" size="100"></center></td>
                      <td><input type="Submit" value="Resume" name="temp1<%=i%>" id="temp1<%=i%>" onclick="invoke1(<%=i%>)"></td>
                      <td><input type="button" value="Update Answer"  name="temp2<%=i%>" id="temp2<%=i%>" onClick="UnBloc1(<%=i%>)"></td>
                      <td><input type="text" name="temp3<%=i%>" id="temp3<%=i%>" style="display: none"/></td> 
                      <td><input type="Submit" value="Submit Answer" name="temp4<%=i%>" id="temp4<%=i%>" style="display: none" onClick="invoke(<%=i%>)"/>                      </td>
                      </tr>

<% }

}
catch(Exception e)
           {

out.println(e);

}
%>  
  </table>  
 </form>

</body>
</html>

Thanks

If you haven't read this article yet, it might be helpful.

Essentially you'd move the DB access to the model, control to a servlet, and leave only view in the JSP.

And, of course, no Java code in the JSP!

thanks for the suggestion Bear