fg_account_servlet.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import java.util.Date;

public class fg_Account_servlet extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";
    boolean gg=false;

    String Account;   //用于取得用户在文本框中输入的用户名
    String Pwd;     //用于取得用户在文本框中输入的密码
    ResultSet rs;
    transform tf=new transform();   //实例化字符转换函数
    int number=0;

    //Date today = new Date();



    public void init() throws ServletException {
    }
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
       ServletException, IOException {
   response.setContentType(CONTENT_TYPE);

   HttpSession session=null;
   session= request.getSession(true);

   session.setAttribute("up_messagze","");
   String button = request.getParameter("button");  //**********
   button=button.trim();

   String logout="logout";
   String Enrollment="Enrollment";
   String update_user="update_user";
   //String update_pwd="update_pwd";
   String contro="user_contro";

   ResultSet rs;
   Account_odbc user=new Account_odbc();

   if(button.equals(contro))         //找回密码
   {
       try{
           rs=user.controPwd(request,response);
           if(rs.next())
           {
               session.setAttribute("Pwd",rs.getString("Pwd").trim());
               response.sendRedirect("user_pwdshow.jsp");
           }
           else
           {
               System.out.println("没有信息");
               session.setAttribute("message","你输入的信息不正确");
               response.sendRedirect("user_contro.jsp");
           }
           rs.close();
           user.close();
       }
       catch(Exception e)
       {
           System.out.println("会员找回密码出现错误！！！");
           user.close();

       }
   }

  //用户登录
   if (button.equals("login") )     //判断是哪一个表单提交的
   {
       SQL_execute manage= new  SQL_execute();   //实例化javabean
       Account = request.getParameter("Account");
       try {
           rs = user.login(request, response);

           if (rs.next()) {
                   session.setAttribute("Account", rs.getString("Account").trim());
                   session.setAttribute("Id", rs.getString("Id").trim()); //转换成字符串类型
                   session.setAttribute("Pwd", rs.getString("Pwd").trim());
                   session.setAttribute("Age", rs.getString("Age").trim());
                   session.setAttribute("Tel", rs.getString("Tel").trim());
                   session.setAttribute("Sex", rs.getString("Sex").trim());
                   session.setAttribute("Name", rs.getString("Name").trim());
                   session.setAttribute("Address", rs.getString("Address").trim());
                   System.out.println(session.getAttribute("Address"));
                   session.setAttribute("Email", rs.getString("Email").trim());
                   String Log_count = String.valueOf(rs.getString("Log_count"));
                   int count = Integer.parseInt(Log_count) + 1;
                   Log_count = String.valueOf(count);
                   String updatesql = "update Shop_Member_Info set Log_count='" +
                                      Log_count + "'  where Account='" + Account + "'";
                   System.out.println(updatesql);
                   session.setAttribute("Log_count", Log_count);
                   session.setAttribute("Date_time", rs.getString("Date_time").trim());
                   session.setAttribute("PostCode", rs.getString("PostCode"));
                   manage.update(updatesql);
                   //调用 manage.Enrollment(updatesql)后，其有一个方法是关闭数据链接的，故不用再调用此   //manage.close();   //关闭数据链接
                   response.sendRedirect("index.jsp");
                   System.out.println("ok");
                   rs.close();
               } else
               {
                   System.out.println("nononononon");
                   session.setAttribute("login", "你输入的用户名或密码不正确");
                   response.sendRedirect("index.jsp");
               }
               manage.close();
           } catch (Exception e) {
               System.out.print("user_login用户登录出现异常：" + e.getMessage());
               manage.close();
           }
}
if (button.equals("zhuxiao") )     //判断是哪一个表单提交的,注销
{

     session.setAttribute("Account",null);
     session.setAttribute("Id",null);  //转换成字符串类型
     session.setAttribute("Pwd",null);
     session.setAttribute("Age",null) ;
     session.setAttribute("Tel",null );
     session.setAttribute("Sex",null) ;
     session.setAttribute("Name",null ) ;
     session.setAttribute("Address",null);
     session.setAttribute("login",null);
     RequestDispatcher rd=request.getRequestDispatcher("index.jsp");
     rd.forward(request,response);
}

  if(button.equals("update_pwd"))       //更改用户密码
   {
       String oldpwd=request.getParameter("password_text");//提取表单中的用户输入的原用户密码
       String sessionpwd=(String)session.getAttribute("Pwd");//取得session中储存的用户原数据库中的密码
       if (oldpwd.equals(sessionpwd))//判断用户输入的旧密码是否与session中用户登录时输入的密码相同
       {
           //System.out.println("得到的用户输入的密码旧密码与session.中的相同");
           try
           {
               int x;
               x =user.update_pwd(request,response);
               if(x>0)
               {
                   session.setAttribute("Pwd",request.getParameter("Pwd"));
                   session.setAttribute("up_message", "信息更新成功");
                   response.sendRedirect("update_pwd.jsp");
               }
               else
               {
                  System.out.println("update_pwd_5");
                   System.out.println("会员修改密码失败！！");
               }
           } catch (Exception e) {
               System.out.print("用户修改密码时出现错误：" + e);
           }
       }
       else
       {
           session.setAttribute("up_message","你输入的原密码错误");
           response.sendRedirect("update_pwd.jsp");
       }
   }


   if(button.equals(update_user))//xiugaiziliao
   {
       try
       {   int x;
           x=user.updateAccount_message(request,response);
           if(x>0)
           {
               session.setAttribute("Age", tf.GBK(request.getParameter("Age")));
               session.setAttribute("Tel", tf.GBK(request.getParameter("Tel")));
               session.setAttribute("Sex",tf.GBK(request.getParameter("Sex")));
               session.setAttribute("Name", tf.GBK(request.getParameter("Name")));
               session.setAttribute("Address", tf.GBK(request.getParameter("Address")));
               System.out.println(session.getAttribute("Address"));
               session.setAttribute("Email", tf.GBK(request.getParameter("Email")));
               session.setAttribute("PostCode",tf.GBK(request.getParameter("PostCode")));
               System.out.println("用户信息修改成功!!!");
               response.sendRedirect("1.jsp?page=xgzl");
           }
       }
       catch (Exception e) {System.out.print("插入数据时出现错误："+e);  }
   }


   if(button.equals(Enrollment))   //判断是哪一个表单提交的  //添加用户
   {
       int ee=0;
       try{
           ee=user.Enrollment(request,response);
       }catch(Exception e){System.out.println(e.getMessage());}

       if (ee!=1)
       {
            session.setAttribute("Enrollment","用户名已存在，请换一个");
            response.sendRedirect("Enrollment.jsp");
            user.close();
       }
       else
       {
           response.sendRedirect("1.jsp?page=zhuce");
           System.out.println("新用户注册成功!!!");
       }

   }
}
    public void destroy()
    {
    }
}