学生登录系统的学生密码核查：：： index.jsp <%@ page language="java" import="java.util.*" pageEncoding="gbk"%>

网上选课系统

	管理员登录
	学生进入登录

manlogin.jsp <%@ page language="java" import="java.util.*" pageEncoding="gbk"%>

学生登陆界面

---

用户名:	(仅支持英文)
密 码：

点击后返回首页

ManLoginServlet....... package servlet; import com.*; import sqlbean.*; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; public class ManLoginServlet extends HttpServlet { public ManLoginServlet() { super(); } public void destroy() { super.destroy(); } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); response.setCharacterEncoding("gbk"); request.setCharacterEncoding("gbk"); HttpSession session=request.getSession(); //PrintWriter out=response.getWriter(); //System.out.println("hahah"); String manName=request.getParameter("manName"); String manPassword=request.getParameter("manPassword"); Man m=null; ManWorksql ms=null; if(manName.equals("")||manPassword.equals("")){ session.setAttribute("manloginstr","请填写完整"); request.getRequestDispatcher("/manloginfail.jsp").forward(request,response); }else{ m=new Man(); ms=new ManWorksql(); m.setManName(manName); m.setManPassword(manPassword); Man m1=ms.selectInformation(m); //System.out.println(manName); //System.out.println(m1.getManName()); if(manName.equals(m1.getManName())&&manPassword.equals(m1.getManPassword())) { session.setAttribute("manloginname",manName); response.sendRedirect("manjinru.jsp"); //request.getRequestDispatcher("/manjinru.jsp").forward(request,response); }else{ if(!manName.equals(m1.getManName())){ session.setAttribute("manloginstr","没有此用户"); request.getRequestDispatcher("/manloginfail.jsp").forward(request,response); }else{ session.setAttribute("manloginstr","密码或用户名不正确"); request.getRequestDispatcher("/manloginfail.jsp").forward(request,response); } } } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request,response); } public void init() throws ServletException { } } UserWorksql 这是javabean package sqlbean; import com.User; import java.sql.*; public class UserWorksql { //Connsql connsql=new Connsql(); //添加管理员信息 public int insertInformation(User u){ int n=0;//n=0说明添加不成功 try{ Connsql connsql=new Connsql(); Connection con=connsql.getConnection(); Statement stmt=con.createStatement(); n=stmt.executeUpdate("insert into user values('"+u.getUserName()+"','"+u.getUserPassword()+"');"); stmt.close(); con.close(); } catch(SQLException e){ } return n; } //查询管理员信息 public User selectInformation(User u){ User u1=new User(); try{ Connsql connsql=new Connsql(); Connection con=connsql.getConnection(); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select * from user where name='"+u.getUserName()+"';"); if(rs!=null){ while(rs.next()){ u1.setUserName(rs.getString(1)); u1.setUserPassword(rs.getString(2)); } } stmt.close(); con.close(); } catch(Exception e){ } return u1; } //修改管理员信息 public int amendInformation(User u){ int n=0;//n=0说明修改不成功 try{ Connsql connsql=new Connsql(); Connection con=connsql.getConnection(); Statement stmt=con.createStatement(); n=stmt.executeUpdate("update user set password='"+u.getUserPassword()+"' where name='"+u.getUserName()+"';"); stmt.close(); con.close(); } catch(Exception e){ } return n; } //删除管理员信息 public int deleteInformation(User u){ int n=0;//n=0说明删除不成功 try{ Connsql connsql=new Connsql(); Connection con=connsql.getConnection(); Statement stmt=con.createStatement(); n=stmt.executeUpdate("delete from user where name='"+u.getUserName()+"';"); stmt.close(); con.close(); } catch(Exception e){ } return n; } } manloginfail.jsp <%@ page language="java" import="java.util.*" pageEncoding="gbk"%>

<%String str=(String)session.getAttribute("manloginstr"); %> <%=str%>

返回到用户登录界面

manjcok.jsp <%@ page language="java" import="java.util.*" pageEncoding="gbk"%>

<%String str=(String)session.getAttribute("manjcstr"); %> <%=str%>

返回到用户登陆界面