whm_pwd.java

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

package ksnb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class whm_pwd extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=gb2312";
    Connection con=null;
    Statement st=null;
    ResultSet rs=null;
    conn cn=null;
    //Initialize global variables
    public void init() throws ServletException {
    }

    //Process the HTTP Get request
    public void service(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        HttpSession session=request.getSession();
        String page="";
        int count=0;
        String oldpwd=request.getParameter("oldpwd");
        String newpwd=request.getParameter("newpwd");
        String username=(String)session.getAttribute("username");
        String sql1="select Count(*) as coun from Shop_Admin where name='"+username+"' and Pwd='"+oldpwd+"'";
        String sql2="update Shop_Admin set Pwd='"+newpwd+"' where name='"+username+"'";
        try{
            cn = new conn();
            con = cn.getConncetion();
            st = con.createStatement();
            rs=st.executeQuery(sql1);
            while(rs.next()){
                count = Integer.parseInt(rs.getString("coun"));
            }
            if(count!=0){
                st.executeUpdate("sql2:"+sql2);
                System.out.println("密码修改成功！");
                page = "succeed.jsp";
            }else
            {
                page="whm_pwd.jsp?msg=Old Password Error";
            }
        }catch(Exception e){
            page="whm_pwd.jsp?msg=Rework INV";
            System.out.println(e.toString());
        }
        RequestDispatcher rd=request.getRequestDispatcher(page);
        rd.forward(request,response);
    }

    //Clean up resources
    public void destroy() {
        try{
            cn.conClose();}
        catch(Exception e){}
    }
}