日期:2014-05-17  浏览次数:20620 次

如何用jsp与oracle数据库实现用户登录功能
用jsp与oracle数据库实现用户登录功能,在jsp界面用户输入用户名和密码,提交到servlet中与数据库中的用户名和密码进行比较成功就提示登录成功否则提示登录失败请重新登录。

------解决方案--------------------
<form action="dologin" method="post" name="frm">
用户名: <input type="text" name="username" id="username">
<br/>
密码:<input type="password" name="userpwd" id="userpwd">
<br/>
<input type="submit" name="subbtn"value="登录">
&nbsp;&nbsp;
<input type="reset" name="rebtn"value="取消">
</form>

servlet:
// 设置编码
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
// 获取参数
String username = request.getParameter("username");
String userpwd = request.getParameter("userpwd");
// 输出流
PrintWriter out = response.getWriter();
HttpSession session = request.getSession(true);
// 
UserDao userdao = new UserDao();
User user = null;
try {
user = userdao.getUser(username);
} catch (Exception e1) {
e1.printStackTrace();
}

// 登录判断
if(!(user== null) &&(user.getPassword().equals(userpwd))){
// 存放到session中
session.setAttribute("user", user);
// 重定向
response.sendRedirect("index.jsp");
}
else{
// 登录失败提示
out.print("<script>alert('登录失败,请重新登录!!');window.location.href='login.jsp';</script>");
}
}

------解决方案--------------------
jsp页面主要代码:
[code=Java]
<form action= "login.action " method= "post ">
用户名: <input type= "text " name= "username "/> </br>
密码: <input type= "password " name= "password "/> </br>
<input type= "submit " value= "提交 "/>
</form>
[/code]
Servlet页面源代码:
[code=Java]
package web;

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;

public class LoginServlet extends HttpServlet {

public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

response.setContentType( "text/html;charset=utf-8 ");
request.setCharacterEncoding( "utf-8 "); //解决jsp页面传值到servlet的中文乱码问题
String uri = request.getRequestURI();
String action = uri.substring(uri.lastIndexOf( "/ "),uri.lastIndexOf( ". "));
if(action.equals( "/login ")){
String username = request.getParameter( "username ");
String password = request.getParameter( "password ");
if(username.equals( "XXX ") && password.equals( "YYY ")){
response.sendRedirect( "success.jsp ");
}else{
respons