chong
Posts: 2
Nickname: hoong2003
Registered: Jun, 2004
|
|
Re: problem creating login system
|
Posted: Jun 16, 2004 2:28 AM
|
|
This is another login system that i've created using servlet.but when i compile it,there's 14 error message appear.please help me up.
package studentshowservlets;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class LoginServlet extends HttpServlet
{
private String bnDbDriver="org.gjt.mm.mysql.Driver";
private String bnDbId="jdbc:mysql://127.0.0.1:3306/coursediarydb";
private String bnDbUser="root";
private String bnDbPassword="";
public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
doGet(request,response);
}
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
Class.forName(bnDbDriver);
Connection myConnection=DriverManager.getConnection(bnDbId,bnDbUser,bnDbPassword);
response.setContentType("text/html");
String studentId=request.getParameter("frmId");
String studentPassword=request.getParameter("frmPassword");
Statement myStatement=myConnection.createStatement();
String sqlQuery1="Select dbId from student where dbId='"+studentId+"'";
String sqlQuery2="Select dbPassword from student where dbPassword='"+studentPassword+"'";
ResultSet myResultSet1=myStatement.executeQuery(sqlQuery1);
ResultSet myResultSet2=myStatement.executeQuery(sqlQuery2);
String result1=myResultSet1.getString("dbId");
String result2=myResultSet2.getString("dbPassword");
System.out.println("LoginServlet.doGet():studentId="+studentId);
System.out.println("LoginServlet.doGet():studentPassword="+studentPassword);
if((studentId==result1)&&(studentPassword==result2))
{
forwardTo("inbox.jsp",request,response);
}
else
{
forwardTo("relogin.jsp",request,response);
}
}
private void forwardTo(String url,HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
RequestDispatcher myReqDisp;
myReqDisp=getServletContext().getRequestDispatcher(url);
myReqDisp.forward(request,response);
}
}
|
|
Previous Topic
