package com.nwnu.web;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.nwnu.core.DbUtil;
public class LoginVerify extends HttpServlet {
/**
* Constructor of the object.
*/
public LoginVerify() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* 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 username=request.getParameter("username");
String userpwd=request.getParameter("userpwd");
DbUtil db=new DbUtil();
String sql= "select * from users where name='"+username+"' and password='"+userpwd+"'";
ResultSet rs=db.excuteQuery(sql);
try {
if(rs.next()){
HttpSession hs=request.getSession();
hs.setMaxInactiveInterval(60);
hs.setAttribute("user", username);
response.sendRedirect("welcom.jsp");
}else{
response.sendRedirect("Login.jsp");
}
} catch (SQLException e) {
e.printStackTrace();
}
db.close();
/*
Connection con=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//加载JDBC驱动
String url="jdbc:sqlserver://localhost:1433;databasename=web";
con=DriverManager.getConnection(url, "sa", "123456");
String sql= "select * from users where name=? and password=?";
pstmt=con.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, userpwd);
rs = pstmt.executeQuery();
if(rs.next()){
HttpSession hs=request.getSession();
hs.setMaxInactiveInterval(60);
hs.setAttribute("user", username);
response.sendRedirect("");
}else{
response.sendRedirect("Login.jsp");
}
} catch (Exception e) {
e.printStackTrace();
} finally{
try {
rs.close();
pstmt.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
*/
/*
response.setContentType("text/html");
response.setCharacterEncoding("UTF-8");//设置字符集
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.println("你的用户账号是："+username);
out.println("<br/>");
out.println("你的用户密码是："+userpwd);
out.println("<br/>");
out.println("<a href=\"Login.jsp\">返回到登录页面</a>");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
*/
}
/**
* 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);
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
JavaWeb+Servlet+JSP+sqlserver实现登录注册
4星 · 超过85%的资源 需积分: 47 114 浏览量
2016-07-15
16:49:33
上传
评论 19
收藏 465KB RAR 举报 
web.rar （46个子文件） 
web src com nwnu core 
DbUtil.java 2KB article Article.java 1019B dao ArticleDao.java 2KB servlet ArticleEditOpen.java 2KB ArticleAddSave.java 4KB ArticleView.java 2KB ArticleDel.java 2KB ArticleAddOpen.java 2KB ArticleEditSave.java 3KB ArticleList.java 3KB web UserReg.java 3KB LoginVerify.java 4KB .classpath 529B DATA sql_data.sql 930B .mymetadata 282B .settings org.eclipse.wst.jsdt.ui.superType.container 49B org.eclipse.wst.common.project.facet.core.xml 252B org.eclipse.core.resources.prefs 242B org.eclipse.wst.jsdt.ui.superType.name 6B org.eclipse.wst.common.component 447B .jsdtscope 500B org.eclipse.jdt.core.prefs 364B .myeclipse .project 2KB WebRoot META-INF MANIFEST.MF 36B edit.jsp 1KB list.jsp 1KB Register.jsp 2KB add.jsp 1KB welcom.jsp 925B index.jsp 940B view.jsp 1KB Login.jsp 1KB WEB-INF classes com nwnu core DbUtil.class 2KB article dao ArticleDao.class 3KB Article.class 2KB servlet ArticleEditOpen.class 2KB ArticleAddSave.class 3KB ArticleView.class 2KB ArticleDel.class 2KB ArticleList.class 2KB ArticleAddOpen.class 2KB ArticleEditSave.class 3KB web UserReg.class 3KB LoginVerify.class 2KB lib 
sqljdbc4.jar 455KB web.xml 4KB资源评论
wqnmlgbpang2017-01-03有点乱，但还好
大鱼>2018-05-24还不错，值得新手学习
为了明天
- 粉丝: 7
- 资源: 24
