Originally posted by Subhradip Podder:
Hi all,
I'm created a userLogin form with using struts-1.1(MyEclipse),oracle 9i,and using odbc14.jar.
The problem is when i'm written loginAction.java I get bellow error message.
oracle cannot be resolved to a type given bellow is my loginAction.java code.
/*
* Generated by MyEclipse Struts
* Template path: templates/java/JavaClass.vtl
*/
package com.iotde.struts.action;
import
javax.servlet.http.HttpServletRequest;
import
javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.iotde.struts.form.LoginForm;
import
javax.servlet.http.HttpSession;
import java.sql.*;
import java.io.*;
/**
* MyEclipse Struts
* Creation date: 10-04-2007
*
* XDoclet definition:
* @struts.action path="/login" name="loginForm" input="/login.jsp" scope="request" validate="true"
* @struts.action-forward name="success" path="success.jsp"
* @struts.action-forward name="failure" path="failure.jsp"
*/
public class LoginAction extends Action {
/*
* Generated Methods
*/
/**
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
{
LoginForm loginForm = (LoginForm) form;
String username = loginForm.getUsername();
String password = loginForm.getPassword();
HttpSession session = request.getSession();
//get connection from database
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection conn=DriverManager.getConnection ("jdbc
racle:thin:@172.16.90.139:1521
ROD","apps","apps");
Statement smt = conn.createStatement();
ResultSet rs;
String query="select first_name,password from users where first_name='"+username+"' and password='"+password+"'";
rs=smt.executeQuery(query);
while(rs.next())
{
String name = rs.getString("first_name");
String pwd = rs.getString("password");
if (username.equalsIgnoreCase("name") &&
password.equals("pwd"))
{
// we are in
return mapping.findForward("success");
} else
{
// not allowed
return mapping.findForward("failure");
}
}
smt.close();
rs.close();
conn.close();
}
private Object getSession() {
// TODO Auto-generated method stub
return null;
}
}
i'm trying to solve this problem many times but i'm fail....... please help me.....
0
