急啊大神帮帮忙看看这是怎么个意思？

未见森林 2014-04-29 09:46:06

这是loginbean的代码

package com.bean;



import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.*;

import com.util.*;



public class LoginBean {

Connection conn = null;

Statement st = null;

ResultSet rs = null;

ArrayList al = new ArrayList();



public int login(String name,String pwd){

int temp = 0;

conn = DBConn.getConn();

try {

st = conn.createStatement();

rs = st.executeQuery("select * from login where username='"+name+"'");

if(rs.next()){

String username = rs.getString("username");

String userpwd = rs.getString("mima");

String quanxian = rs.getString("quanxian");

if(pwd.equals(userpwd)){

temp = 1;

al.add(username);

al.add(userpwd);

al.add(quanxian);

}else{

temp = 2;

}

}else{

temp = 3;

}

} catch (SQLException e) {

e.printStackTrace();

} finally{

DBConn.close(conn,st,rs);

}

return temp;

}



public ArrayList getArrayLst(){

return al;

}



}

这是LoginServlet的代码

package com.servlet;



import java.io.IOException;

import java.util.ArrayList;



import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;



import com.bean.LoginBean;



public class LoginServlet extends HttpServlet {



/**

* Constructor of the object.

*/

public LoginServlet() {

super();

}



/**

* Destruction of the servlet. <br>

*/

public void destroy() {

super.destroy(); // Just puts "destroy" string in log

// Put your code here

}



public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String name = request.getParameter("username");

String pwd = request.getParameter("userpwd");

String admin = request.getParameter("admin");

String xuesheng = request.getParameter("xuesheng");

String laoshi = request.getParameter("laoshi");

String str = "";

LoginBean lb = new LoginBean();

int flag = lb.login(name,pwd);

if(flag == 2 || flag == 3){

if(admin != null && admin.equals("1")){

str = "jsp/login/adminLogin.jsp";

request.setAttribute("admin","1");

}

if(xuesheng != null && xuesheng.equals("1")){

str = "jsp/login/xueshengLogin.jsp";

request.setAttribute("xuesheng","1");

}

if(laoshi != null && laoshi.equals("1")){

str = "jsp/login/laoshiLogin.jsp";

request.setAttribute("laoshi","1");

}

}

if(flag == 1){ //登录成功

if(admin != null && admin.equals("1")){

str = "jsp/login/adminWelcomLogin.jsp";

}

if(xuesheng != null && xuesheng.equals("1")){

str = "jsp/login/xueshengWelcomLogin.jsp";

}

if(laoshi != null && laoshi.equals("1")){

str = "jsp/login/jiaoshiWelcomLogin.jsp";

}

ArrayList al = lb.getArrayLst();

HttpSession session = request.getSession();

session.setAttribute("login",al);

}

RequestDispatcher rd=request.getRequestDispatcher(str);

rd.forward(request,response);

}



public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doGet(request,response);

}



/**

* Initialization of the servlet. <br>

*

* @throws ServletException if an error occure

*/

public void init() throws ServletException {

// Put your code here

}



}

在TOMCAT启动后能进入主页面但是一登录或者注册都是这个页面，有人说是数据库的原因，请各位大神看看这是不是数据库的原因，要不是怎么改这个代码啊。我看上面的提示是这两段代码有问题