Servlet Login

[Robert Saxxon]

I am a beginner JSP/Servlet writer and I'm having a problem which is probably simple.

I am trying to create a jsp that uses a servlet to connect to a database and display, if they user is a member, it displays information and if not, it sends them back to the login page.

I am using two java files to do this, one is a servlet (Controller.java) that controls the information between the jsp and the second file (DBConn.java), which connects to the DB and creates an object which has the user info in it, and then returns it to the servlet.

DBConn compiles but Controller does not see the class DBConn. Here is the code for Controller.java

  
package sdez;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
public class Controller extends HttpServlet
{
public DBConn UData = new DBConn(); // here is where the error occurs.
 
public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException,IOException
{
String username = req.getParameter("username");
String password = req.getParameter("password");
 
UData = UData.DBAction(username, password); // call to method in DBConn
 
if(UData == null)
System.out.println("**************"); // test to see if it works
 
} // end doPost
 
} // end class Controller
 

The DBConn source is:

package sdez;
import java.sql.*;
import java.io.*;
import java.util.*;
 
public class DBConn {
 
 public String PW;
 public String UN;
 public String FirstName;
 public String LastName;
 public String Sex;
 
 public DBConn DBAction (String username, String password) throws SQLException {
 
Connection conn = null;
Statement stmt = null;
ResultSet rst = null;
DBConn UserData = new DBConn();
 
try{
DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
 
  // connect to database using a connection object
  conn = DriverManager.getConnection("jdbc :-o	 racle:thin:@localhost:1521:TempstDB", "scott", "tiger");
 
  stmt = conn.createStatement();
  rst = stmt.executeQuery("select * from customer where username = " + username + " and password = " + password);
 
  if(rst == null) {
  return UserData;
  }
 
  else {
UserData.UN = rst.getString(1);
UserData.LastName = rst.getString(2);
UserData.FirstName = rst.getString(3);
UserData.Sex = rst.getString(4);
UserData.PW = rst.getString(5);
 
 } // end else
 
 return UserData;
 
 } // end try
 catch (SQLException SQEx)
 {
  SQEx.printStackTrace();
  return UserData;
 
 }
 finally {
  if(rst != null) {
  rst.close();
  stmt.close();
  conn.close();
 
  }
 
 }// end finally
 
 }// end DBAction
 
}// end DBConn

Any ideas?

Thanks

[Robert Saxxon]

btw, the error im getting is:

Controller.java:9: cannot resolve symbol
symbol : class DBConn
location: class shamik.Controller
public DBConn UData = new DBConn();
^
Controller.java:9: cannot resolve symbol
symbol : class DBConn
location: class shamik.Controller
public DBConn UData = new DBConn();
^
2 errors

[N S Raju]

Hai

guess ur using command line compilation, just try
java -classpath <DIR> Controller.java

where DIR is the path till the dir where the DBConn.class is located

bye

Surya

[Ali Gohar]

Controller.java:9: cannot resolve symbol
symbol : class DBConn
location: class shamik.Controller
public DBConn UData = new DBConn();

As you can see it is showing location: class shamik.Controller. You have define the Controller class in shamik package and you are accessing class DBConn which is in sdez package

So use import sdez at the top in definition of Controller class