bgtranmiste.java

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

package ksnb;

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

public class bgTranmiste extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GB2312";

    //Initialize global variables
    public void init() throws ServletException {
    }
    Byte b=new Byte();
    Query_User q=new Query_User();
    ResultSet rs;
    //定义三个字符串，用来接收从数据库查出的Name,Pwd,Level
    String name;
    String pass;
    String level;
    //Process the HTTP Get request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        HttpSession session=request.getSession();
        String username=b.convert(request.getParameter("admin"));
        session.setAttribute("username",username);
        String password=b.convert(request.getParameter("passd"));


        rs=q.Q_User(username,password);
        try
            {
                while(rs.next())
                {
                  name=rs.getString("Name");
                  //System.out.println(name);
                  pass=rs.getString("Pwd");
                  level=rs.getString("Level");
                  session.setAttribute("level",level);
                }

            }
            catch(Exception e)
            {
                System.out.println(e.toString());
            }
        if(username.equals(name) && password.equals(pass))
        {

            response.sendRedirect("Background_index.jsp");
        }
        else
        {
            session.setAttribute("shibai","非法用户，你的IP已经被记录");
            response.sendRedirect("Back_index.jsp");
        }


    }

    //Clean up resources
    public void destroy() {
    }
}