manage.java

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

package ksnb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class Manage 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);

        HttpSession session=request.getSession();
        ManageSql ms=new ManageSql();
        //Query_User q=new Query_User();
        int i;
        int num;
        String name=request.getParameter("name");
        String password=request.getParameter("passd");
        String level=request.getParameter("level");
        //判断数据库中是否有当前输入的管理员名
        num=ms.queryuser(name);
        if(num>0)
        {
            session.setAttribute("info","管理员名称已经存在");
        }
        else
        {

            String sql = "insert into Shop_Admin values ( '" + name + "' , '" +
                         password + "', '" + level + "')";
            //System.out.println(sql);
            i = ms.Insert_Manage(sql);
            if (i > 0) {
                session.setAttribute("info", "增加管理员成功");

            } else {
                session.setAttribute("info", "增加管理员失败");
            }
        }
        RequestDispatcher rd=request.getRequestDispatcher("ok.jsp");
        rd.forward(request,response);

    }

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