java

Hi Mr.Deepak,

I have executed this particular program login user authentication using java beans as shown in ur example, but i have an error when i key in the username and password then it is giving me an error called the requested resource is not available.

my login.java code is:

package logbean;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class login extends HttpServlet{

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();

System.out.println("MS Access Connect Example.");
Connection conn = null;
String url = "jdbc:odbc:Driver={Microsoft Access Driver "
+ "(*.mdb, *.accdb)};DBQ=C:\\Database\\register.accdb";
// String dbName = "register.accdb";
//String driver = "jdbc:odbc:Driver={Microsoft Access Driver " +
// "(*.mdb, *.accdb)}";
//String userName = "root";
//String password = "root";

String username="";
String userpass="";
String strQuery= "";
Statement st=null;
ResultSet rs=null;
HttpSession session = request.getSession(true);

try {
Class.forName(url).newInstance();
conn = DriverManager.getConnection(url);
if(request.getParameter("username")!=null && request.getParameter("username")!= "" && request.getParameter("password")!=null &&request.getParameter("password")!= "")
{
username = request.getParameter("username").toString();
userpass = request.getParameter("password").toString();
strQuery="select * from Registration where username='"+username+"' and password='"+userpass+"'";
System.out.println(strQuery);
st = conn.createStatement();
rs = st.executeQuery(strQuery);
int count=0;
while(rs.next())
{

session.setAttribute("username",rs.getString(2));
count++;
}

if(count>0)
{
response.sendRedirect("welcome.jsp");
}
else
{
response.sendRedirect("login.jsp");
}


}
else
{
response.sendRedirect("login.jsp");
}

System.out.println("Connected to the database");

conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}
}
}

http://www.roseindia.net/jsp/loginbean.shtml

sir please check the code and modify if any problem, please help me its urgent.am using MS Access database, Netbeans IDE.

Reply me soon.

Thanks
Lisy