Difficulty in compiling a servlet.

[anunay ashish]

Hi,

The code for my bean is:

package com.scheduler;
import java.sql.*;
public class DBUpdate
{
    private Connection conn;
    private Statement stmt;
    private ResultSet rs;
 public DBUpdate()
    {
        conn = null;
        stmt = null;
        rs = null;
    }
 public void process(String query)
    {
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
            Connection conn =
DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.36:1521:myData",
"mangesh", "mangesh");
            stmt = conn.createStatement();
            rs = stmt.executeQuery(query);
   System.out.println("Query: " + query + " executed");
        }
        catch(Exception exception1)
        {
            System.out.println("Error occured in DBUpdate.process()
SQLException :" + exception1);
        }
    }
 public ResultSet getResultSet() throws SQLException
    {
     return rs;
    }
 public void destroy()
 {
        conn = null;
        stmt = null;
        rs = null;
 }
}

And for my servlet is:

package com.scheduler;
import java.io.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class addDataServlet extends HttpServlet
{
 private String pageFormat;
 public void doPost(HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException
 {
  ResultSet testRS;
  DBUpdate dbupdate = new DBUpdate();
  pageFormat = request.getParameter("newPageFormat");
  PrintWriter out = response.getWriter();
  out.print(pageFormat);
  String query = "Select * from lookup_page_format";
  dbupdate.process(query);
  try
  {
   testRS = dbupdate.getResultSet();
      while(testRS.next())
   {
    out.print(testRS.getString(2));
    out.print("hi");
   }
  }
  catch (SQLException e)
  {
   out.println("SQLException :" + e);
  }
  try
  {
   //set the attribute and forward to pageFormat.jsp
   request.setAttribute("servletName", "addDataServlet");

getServletConfig().getServletContext().getRequestDispatcher("/Tracking_syste
m/pageFormat.jsp").forward(request, response);
  }
  catch (Exception ex)
  {
   ex.printStackTrace ();
  }
 }
}

On compiling the addDataServlet.java, an error is coming - Unresolved
symbol:Class DBUpadate is not resolved
Where I am doing wrong?

Thanks in advance.
Regards,
Anunay.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]