login.java

来自「一些基本jsp」· Java 代码 · 共 32 行

package my.servlet;
import my.data.MyOdbc;
import my.data.MyParameter;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Login extends HttpServlet{
	public void doPost(HttpServletRequest request,
	   HttpServletResponse reponse)
	   throws IOException{
	   	MyParameter cn=new MyParameter(request);
	   String userId,password;
	   userId=cn.getParameter("userId");
	   password=cn.getParameter("password");
	   MyOdbc myodbc=new MyOdbc();
	   if(myodbc.login(userId,password)){
	   	String sql="update 用户表 set 访问次数=访问次数+1 where 用户名='"+userId+"'";
	   	myodbc.executeUpdate(sql);
	   	HttpSession session=request.getSession(true);
	    session.setAttribute("userId",userId);
	    session.setAttribute("Type","user");
	   	reponse.sendRedirect("index.jsp");
	   }else{
	   	reponse.sendRedirect("err.jsp?id=2");
	   } 
	   	myodbc.closeConn(); 
	                  	
	   }
	
}