You should try using the servlet as an object in your jsp page, rather than trying the
include.
Example:
<html>
<head>
<meta http-equiv="Cache-Control" content="no-cache, must-revalidate">
<meta http-equiv="Expires" content="0">
<title>Employee List</title>
</head>
<body>
Employee List
<%
EmployeeList.displayList(response.getWriter()); /* this is a static function in
EmployeeList that would do pretty much the same thing as doGet in your current
implementation, except it would use the PrintWriter that you pass in in the function
above to display it. */
%>
</body>
</html>
Try that and let me know if it works.
Travis Reeder
Chief Software Architect
www.ThinkVirtual.com
---- Original Message ----
From: "Adress, David S." <[EMAIL PROTECTED]>
Sent: 2000-12-08 07:40:57.0
To: [EMAIL PROTECTED]
Subject: RE: RE: $20 bucks to the 1st person who actually solves my problem!!!
Here is a copy of the jsp page and the servlet....
JSP PAGE
<html>
<head>
<meta http-equiv="Cache-Control" content="no-cache, must-revalidate">
<meta http-equiv="Expires" content="0">
<title>Employee List</title>
</head>
<body>
Employee List
<jsp:include page="/servlet/EmployeeList" flush="true" />
</body>
</html>
List Servlet
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Enumeration;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class EmployeeList extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException
{
HttpSession session = request.getSession(true);
response.setIntHeader("Expires",0);
response.setHeader("Cache-Control","no-cache");
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String Logon = session.getAttribute("Logon").toString();
String Level = session.getAttribute("Level").toString();
if (Logon.compareTo("TRUE") == 0);
else
{
out.println("No Access");
return;
}
if (Level.compareTo("A") == 0);
else
{
out.println("No Access you need to be an Admin");
return;
}
String query = "SELECT EmployeeID, LastName, Firstname FROM
employees order by lastname";
out.println("<TABLE BORDER=1>");
out.println(" <TR>");
out.println(" <TD COLSPAN=4 ALIGN=CENTER><a
href=\"/skills/EmployeeAdd.jsp\">Add New Employee</a></TD>");
out.println(" </TR>");
out.println(" <TR>");
out.println(" <TD>EmployeeID</TD>");
out.println(" <TD>Lastname</TD>");
out.println(" <TD>Firstname</TD>");
out.println(" <TD>Commands</TD>");
out.println(" </TR>");
try
{
Connection dbconn;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbconn =
DriverManager.getConnection("jdbc:odbc:ADB");
Statement statement = dbconn.createStatement();
ResultSet rs = statement.executeQuery( query );
while(rs.next())
{
String empid = rs.getString(1);
out.println(" <TR>");
out.println(" <TD>" + empid +
"</TD>");
out.println(" <TD>" +
rs.getString(2) + "</TD>");
out.println(" <TD>" +
rs.getString(3) + "</TD>");
out.println(" <TD><a
href=\"/servlet/EmployeeP?Process=D&EmpID=" + empid + "\">Delete</a>
Edit</TD>");
out.println(" </TR>");
}
}
catch ( Exception excp )
{
// process remaining Exceptions here
excp.printStackTrace();
out.println(excp.toString());
}
out.println("</TABLE>");
}
}
Process Servlet gets called on delete and add form sens data to this servlet
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Enumeration;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class EmployeeP extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException
{
Connection dbconn;
String Process = request.getParameter("Process");
String query = "";
if (Process.equals("D"))
{
String EmpID = request.getParameter("EmpID");
query = "DELETE FROM Employees WHERE EmployeeID = "
+ EmpID;
}
if (Process.equals("A"))
{
String Lastname = request.getParameter("Lastname");
String Firstname =
request.getParameter("Firstname");
query = "INSERT INTO Employees " +
"(FirstName,Lastname) " +
"VALUES (" +
"'" + Firstname + "'" +
"," + "'" + Lastname + "'" + ")";
}
response.setHeader("Cache-Control","no-cache");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
out.println(query);
dbconn =
DriverManager.getConnection("jdbc:odbc:ADB");
Statement statement =
dbconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDA
TABLE);
int result = statement.executeUpdate( query
);
if (result == 1)
{
int ct = (int) (Math.random()*1000);
response.sendRedirect("/skills/EmployeeList.jsp");
}
else
{
out.println("Error");
}
}
catch ( Exception excp )
{
// process remaining Exceptions here
excp.printStackTrace();
out.println(excp.toString());
}
}
}
-----Original Message-----
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 9:37 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: $20 bucks to the 1st person who actually solves my
problem!!!
Hi David , are you using any meta tags in the HTML you are spitting out. You
should use the meta cache tags , to ensure fresh content.
Email me if you need the syntax.
Justin
>-----Original Message-----
>From: Adress, David S. [mailto:[EMAIL PROTECTED]]
>Sent: Friday, December 08, 2000 1:29 PM
>To: JRun-Talk
>Subject: $20 bucks to the 1st person who actually solves my problem!!!
>
>
>I am on this for days and I can't figure out what I'm doing wrong. I will
>send $20 bucks to 1st person who actually solves my problem.
>
>I am using jsp page's to control the layout of my page and servlets to spit
>back
>table data or to do database transactions.
>
>I have a jsp page that displays a list of employees. The jsp page
>has an include statement to include the servlet to spit out the table.
>The jsp just handles the general look of the page and the servlet just
>spits out the table and table html tags. Next to each record I have an add
>and
>delete hyperlink. If someone clicks the add link it displays
>another page to
>add
>an employee and then the action servlet adds the record and then goes back
>to the jsp
>list page. If some one deletes a record it calls a servlet to delete and
>then the servlet redirects back to the jsp list page. But the list doesn't
>display the updated data without having me hit the refresh button in the
>browser.
>
>I tried using Tomcat and now am using Jrun and am still having the same
>problem.
>
>I've included all the proper meta tags in the jsp list page not to
>cache but
>it's not working. I've also tries doing it with reponse.setHeader but it
>doesn't work either.
>
>I've tried sending a random number param to the page
>ShowList?rnd=Randomnumber it still doesn't work.
>
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Your ad could be here. Monies from ads go to support these lists
>and provide more resources for the community.
http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
