首先是登录界面:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title> JSP </title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<form action="LoginCLServlet" >
用户名:<input type="text" name="username">
<br>
密 码:<input type="text" name="password">
<br>
<input type="submit" value=确定>
<br>
</form>
</body>
</html>
其中 <form action="LoginCLServlet" > 要跳转到 LoginCLServlet
LoginCLServlet 代码:
package xuyan.control;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import xuyan.model.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class LoginCLServlet extends HttpServlet {
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String u=request.getParameter("username");
String p=request.getParameter("password");
UserBeanCL ub=new UserBeanCL();
if( ub.checkUser(u, p))
{
ArrayList al=ub.getUserByPage(1);
int pageCount=ub.getpageCount();
request.setAttribute("result", al);
request.setAttribute("pageCount", pageCount+"");
request.getRequestDispatcher("Main.jsp").forward(request, response);
}
else
{
request.getRequestDispatcher("Login.jsp").forward(request, response);
}
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}
}
调用M ,有三个Model 分别为 ConnDB.java UsrBean.java UserBeanCL.java
ConnDB.java:
//数据库连接
package xuyan.model;
import java.sql.