67,515
社区成员
发帖
与我相关
我的任务
分享
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class loginServlet extends HttpServlet{
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
ConnSql conMyData = new ConnSql();
String username = req.getParameter("UserName");
String password = req.getParameter("PassWord");
ResultSet rs = null;
rs = conMyData.executeQuery("select * from users where dbusername='" + username +"'");
resp.setStatus(HttpServletResponse.SC_MOVED_PERMANENTLY);
try
{
if(rs.next())//如果用户名存在
{
if(password.equals(rs.getString("dbpassword")))
{
resp.sendRedirect("loginSuccess.html");
return;
}else
{
resp.sendRedirect("javascript:alert('密码错误!!');");
resp.sendRedirect("index.html");
return;
}
}else
{
resp.sendRedirect("javascript:alert('用户名不存在!!');");
resp.sendRedirect("index.html");
return;
}
}catch(SQLException e)
{
e.printStackTrace();
}finally
{
try
{
if(rs != null)
{
rs.close();
rs = null;
}
conMyData.close();
}catch(SQLException e)
{
e.printStackTrace();
}
}
}
}