81,092
社区成员
发帖
与我相关
我的任务
分享
package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import dbutil.DbUtils;
public class Show extends HttpServlet{
public void doPost(HttpServletRequest request,HttpServletResponse response){
response.setContentType("text.html;charset=GB2312");
String username = request.getParameter("user");
String password = request.getParameter("password");
if(username!=null&&password!=null){
String sql = "select password from userinfo where user = '"+username+"'";
Connection con = DbUtils.getConnection();
ResultSet rs = DbUtils.getResultSet(con, sql);
try {
if(rs.next()){
String real = rs.getString(1);
if(real.equals(password)){
RequestDispatcher dis = request.getRequestDispatcher("a.jsp");
dis.forward(request, response);
}else{
request.getSession().setAttribute("message", "登陆失败,请重新输入");
response.sendRedirect("test.jsp");
}
}else{
request.getSession().setAttribute("message", "登陆失败,请重新输入");
response.sendRedirect("test.jsp");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ServletException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response){
doPost(request, response);
}
}
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<form action="show">
用户名:<input type="text" name="user"><br>
密码:<input type="password" name="password"><br>
<input type="submit" value="登录">
</form>
<%
String mess = (String)request.getSession().getAttribute("message");
if(mess!=null){
out.println(mess);
}
%>
</body>
</html>
import java.sql.*