member.java

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

package ksnb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import ksnb.MemberSql;
public class Member extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GB2312";

    //Initialize global variables
    public void init() throws ServletException {
    }

    //Process the HTTP Get request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        PrintWriter out = response.getWriter();
        ResultSet rs=null;
        Collection c=new ArrayList();
        MemberSql ms=new MemberSql();

        String Account=request.getParameter("account");
        String Name=request.getParameter("name");
        String Age=request.getParameter("age");
        String Email=request.getParameter("email");
        String PostCode=request.getParameter("postcode");

        String selectsql="select * from Shop_Member_Info where ";
        selectsql=selectsql+"Account like '%"+Account+"%' "+"and Name like'%" + Name +"%' "+"and Age like'%" + Age +"%' "+" and Email like'%"+Email+"%' "+" and PostCode like '%"+PostCode+"%' ";
          System.out.println(selectsql);
        rs=ms.Query_Member(selectsql);

                try
                {
                    while(rs.next())
                    {
                        String id;
                        String account;
                        String name;
                        String age;
                        String sex;
                        String address;
                        String tel;
                        String email;
                        String logcount;
                        String datetime;
                        String postcode;
                        id=String.valueOf(rs.getInt("Id"));
                        c.add(id);
                        account=rs.getString("Account");
                        c.add(account);
                        name=rs.getString("Name");
                        c.add(name);
                        age=rs.getString("Age");
                        c.add(age);
                        sex=rs.getString("Sex");
                        c.add(sex);
                        address=rs.getString("Address");
                        c.add(address);
                        tel=rs.getString("Tel");
                        c.add(tel);
                        email=rs.getString("Email");
                        c.add(email);
                        logcount=rs.getString("Log_count");
                        c.add(logcount);
                        datetime=rs.getString("Date_Time");
                        c.add(datetime);
                        postcode=rs.getString("PostCode");
                        c.add(postcode);
                    }
                }
                catch(Exception e)
                {
                    System.out.println(e.toString());
                }
            request.setAttribute("member",c);
            //response.sendRedirect("ShowMember.jsp");
            RequestDispatcher rd=request.getRequestDispatcher("ShowMember.jsp");
            rd.forward(request,response);
            ms.close();
    }

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