我是新手,虽然分不多但能说的细致一些吗?
我的代码如下,但是只能跳跳转到Welcome.jsp:
LoginServlet.java的主要部分如下:
//核对用户名和密码,决定是否通过登陆验证
DB_User dbuser = new DB_User();
User user = dbuser.get(UserName, EnPwd);
int userid=0;
if (user != null) {
// 登录成功时,把strUserName设成session变量UserName
userid=user.getId();
request.getSession(true).setAttribute("userid",String.valueOf(userid));
request.getSession(true).setAttribute("username", UserName);
String name = request.getSession(false).getAttribute("username").toString();
if( name.equals("admin") )
{
try {
request.getRequestDispatcher("./Welcome1.jsp").forward(request,response);
}
catch (Throwable t) {
getServletContext().log(t.getMessage());
}
}
else {
try{
request.getRequestDispatcher("./Welcome.jsp").forward(request,response);
}
catch (Throwable t) {
getServletContext().log(t.getMessage());
}
}
} else {
// 否则(记录集为空),表明失败:
request.setAttribute("error", "用户名与密码不匹配,登录失败,请重试!");
try {
request.getRequestDispatcher("./Login.jsp").forward(request, response);
}
catch (Throwable t) {
getServletContext().log(t.getMessage());
}
}
}
}
Login.jsp的主要部分如下:
<form name="login" method="POST" action="./LoginServlet">
<tr>
<td align=right height=32 width=45%>用户名:</td>
<td width="55%"><input type="hidden" name="returl" value="">
<input type="text" name="logname" value="">
</td>
</tr>
<tr>
<td align=right height=32>密码:</td>
<td><input type="password" name="logpwd"></td>
</tr>
<tr>
<td align=right height=32>验证码:</td>
<td><input type="text" name="random" value="">
<image src="./Random.jsp">
</td>
</tr>
<tr>
<td align=center colspan=2 height=32>
<input type="submit" name="login" value="登 录">
<input type="reset" name="reset" value="重 置">
</td>
</tr>
</form>
åè代ç å¦ä¸ï¼
package myservlet;
import mybean.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class IsLogin extends HttpServlet{
public void init(ServletConfig config) throws ServletException{
super.init(config);
}
public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{
//æ¥æ¶åæ°
String user=request.getParameter("user");
String password=request.getParameter("password");
String actor=request.getParameter("actor");
//å 载驱å¨ï¼å»ºç«è¿æ¥
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}catch(Exception e){
System.out.print(e);
}
try{
String uri="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=student";
con=DriverManager.getConnection(uri,"sa","940712");//æ°æ®åºçç»å½å sa 940712
sql=con.createStatement();
//éè¿ifè¯å¥å¤æè§è²ï¼å°å ¶è´¦å·å¯ç ä¸æ°æ®åºçuserInfå çä¿¡æ¯è¿è¡æ¯å¯¹ï¼è§è²çè´¦å·å¯ç ç»ä¸åå¨å¨UserInf表ä¸ï¼
//è¥æ£ç¡®ï¼è½¬åè³è§è²å¯¹åºçç»å½æåçé¢ï¼è¥æ²¡æï¼ç»ä¸è½¬åè³åºéçé¢ï¼æä¾è¿åé¾æ¥ä¾éæ°ç»å½
if(actor=="student"){
rs=sql.executeQuery("select userIs,password from userInf where actor='student'");
while(rs.next()){
if(user==rs.getString(1) && password==rs.getString(2)){
RequestDispatcher dispatcher=request.getRequestDispatcher("loginSuccessS.jsp");
dispatcher.forward(request,response);
}
}
RequestDispatcher dispatcher=request.getRequestDispatcher("loginError.jsp");
dispatcher.forward(request,response);
}
//æ®éç¨æ·è§è²æ§å¶
else if(actor=="teacher"){
rs=sql.executeQuery("select userIs,password from userInf where actor='teacher'");
while(rs.next()){
if(user==rs.getString(1) && password==rs.getString(2)){
RequestDispatcher dispatcher=request.getRequestDispatcher("loginSuccessT.jsp");
dispatcher.forward(request,response);
}
}
RequestDispatcher dispatcher=request.getRequestDispatcher("loginError.jsp");
dispatcher.forward(request,response);
}
//管çåè§è²æ§å¶
else if(actor=="admin"){
rs=sql.executeQuery("select userIs,password from userInf where actor='admin'");
while(rs.next()){
if(user==rs.getString(1) && password==rs.getString(2)){
RequestDispatcher dispatcher=request.getRequestDispatcher("loginSuccessA.jsp");
dispatcher.forward(request,response);
}
}
RequestDispatcher dispatcher=request.getRequestDispatcher("loginError.jsp");
dispatcher.forward(request,response);
}
}catch(SQLException e){
//System.out.print("æ¨çè´¦å·æå¯ç é误ï¼è¯·è¿åéæ°è¾å ¥");
RequestDispatcher dispatcher=request.getRequestDispatcher("loginError.jsp");
dispatcher.forward(request,response);
}
}
}
删除 。
if( name.equals("admin") )
改成:
if( UserName.equals("admin") )
如果还不行,你打印一下username看看是admin吗?注意大小写和空格
<%
ResultSet rs=null;
request.setCharacterEncoding("UTF-8");
String name=request.getParameter("username");
String password=request.getParameter("userpassword");
String check=request.getParameter("rand");
String rand=((String)session.getAttribute("check"));
String s=request.getParameter("selectlogrole");
try
{
if(s!=null)
{switch(s.charAt(0))
{
case's':
String sql01="select * from userinfo where username='"+name+"' and userpassword='"+password+"' and logrole='student'";
rs=query.executeQuery(sql01);
if(rs.next()&&rand.equals(check))
{
String Name=rs.getString("username");
session.setAttribute("name",Name);//记录用户名
session.setAttribute("login","success");//记录成功登录
%>
<script language="javascript">
alert("登录成功!!!");
window.location.href="sss.jsp";
</script>
<%
}else
{
%>
<script language="javascript">
alert("身份错误!!");
history.back();
</script>
<% }
break;
case't':
String sql02="select * from userinfo where username='"+name+"' and userpassword='"+password+"' and logrole='teacher'";
rs=query.executeQuery(sql02);
if(rs.next()&&rand.equals(check))
{
String Name=rs.getString("username");
session.setAttribute("name",Name);//记录用户名
session.setAttribute("login","success");//记录成功登录
%>
<script language="javascript">
alert("登录成功!!!");
window.location.href="ttt.jsp";
</script>
<%
}else
{
%>
<script language="javascript">
alert("身份错误!!");
history.back();
</script>
<%
}
break;
case'a':
String sql03="select * from userinfo where username='"+name+"' and userpassword='"+password+"' and logrole='admin'";
rs=query.executeQuery(sql03);
if(rs.next()&&rand.equals(check))
{
String Name=rs.getString("username");
session.setAttribute("name",Name);//记录用户名
session.setAttribute("login","success");//记录成功登录
%>
<script language="javascript">
alert("登录成功!!!");
window.location.href="ggg.jsp";
</script>
<%
}else
{
%>
<script language="javascript">
alert("身份错误!!");
history.back();
</script>
<%
}
break;
default:
out.println("你没有选择");
}
}
%>
<%
}catch(Exception e)
{
out.println("连接异常login_config");
}
%>本回答被提问者和网友采纳
if(session.getAttribute("login")=="admin")
{
response.sendRedirect("login.jsp");
}
else if(session.getAttribute("login")=="user")) {
response.sendRedirect("XXX.jsp");
}
%>