基于javaweb+mysql的jsp+servlet会员卡积分管理系统(java+jsp+javascript+mysql)

基于javaweb+mysql的jsp+servlet会员卡积分管理系统(java+jsp+javascript+mysql)

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的JSP+Servlet会员卡积分管理系统(java+jsp+javascript+mysql)

项目介绍

管理员角色包含以下功能： 登录,系统用户管理,修改后台登录密码,会员管理,添加会员,注册用户管理,会员卡管理,添加会员卡,会员卡充值,商品管理,会员积分统计,留言管理,信息统计图,积分兑换商品等功能。

用户角色包含以下功能： 登录,登录后页面,修改密码,修改详细资料,留言板等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 5.数据库：MySql 5.7版本；

技术栈

HTML+CSS+JavaScript+jsp+mysql

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/login.jsp 登录

					request.getRequestDispatcher("admin/hyk/index.jsp").forward(request, response); 
				}
			}
		}
		else if(method.equals("gshyk")){ ///update  
			String id = request.getParameter("id"); 
			String str=cBean.getString("select gs from hyk where id='"+id+"'");
			if(str.equals("未")){
				String sql="update hyk  set gs='已' where id='"+id+"'";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/hyk/index.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/hyk/index.jsp").forward(request, response); 
				}
			}
			else{
				String sql="update hyk  set gs='未' where id='"+id+"'";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/hyk/index.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/hyk/index.jsp").forward(request, response); 
				}
			}
		}
		else if(method.equals("czhyk")){ ///update  
			String hykid = request.getParameter("hykid"); 
			String je = request.getParameter("je"); 
			 
			String sql="insert into cz(hykid,je,sj) values('"+hykid+"','"+je+"','"+date2+"')";
			int flag = cBean.comUp(sql);
			if(flag == Constant.SUCCESS){  
				cBean.comUp("update hyk set je=je+'"+je+"' where id='"+hykid+"'");
				request.setAttribute("message", "操作成功！");
				request.getRequestDispatcher("admin/hyk/cz.jsp").forward(request, response); 
			}
			else { 
				request.setAttribute("message", "操作失败！");
				request.getRequestDispatcher("admin/hyk/cz.jsp").forward(request, response); 
			}
			 
		}
		else if(method.equals("delcz")){ ///update  
			String id = request.getParameter("id"); 

        {
            java.io.File file = new java.io.File(m_application.getRealPath(s));
            return file.exists();
        }
        else
        {
            return false;
        }
    }
}

public class ComServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public ComServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here

public class UpServlet extends HttpServlet {

	private ServletConfig config;
	/**
	 * Constructor of the object.
	 */
	public UpServlet() {
		super();
	}

	final public void init(ServletConfig config) throws ServletException
    {
        this.config = config;  
    }

    final public ServletConfig getServletConfig()
    {
        return config;
    }
	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.

            return s;
        }
    }

    private String getContentDisp(String s)
    {
        //String s1 = new String();
        String s1 = "";
        int i = 0;
        int j = 0;
        i = s.indexOf(":") + 1;
        j = s.indexOf(";");
        s1 = s.substring(i,j);
        return s1;
    }

    private void getDataSection()
    {
        //boolean flag = false;
        //String s = "";
        //String s = new String();
        int i = m_currentIndex;
        int j = 0;
        int k = m_boundary.length();
        m_startData = m_currentIndex;
        m_endData = 0;
        while(i < m_totalBytes)
        {
            if(m_binArray[i] == (byte)m_boundary.charAt(j))
            {
                if(j == k - 1)
                {
                    m_endData = ((i - k) + 1) - 3;
                    break;
                }
                i++;
                j++;
            }
            else
            {
                i++;
                j = 0;
            }
        }
        m_currentIndex = m_endData + k + 3;
    }

    public int save(String s,int i) throws ServletException,IOException,SmartUploadException
    {
        int j = 0;
        if(s == null)
        {
            s = m_application.getRealPath("/");
            //System.out.println("s == null,m_application.getRealPath:" + s);
        }
        if(s.indexOf("/") != -1)
        {
            if(s.charAt(s.length() - 1) != '/')
            {
                s = s + "/";
                //System.out.println("m_application.getRealPath::" + s);
            }
        }
        else
        {
            if(s.charAt(s.length() - 1) != '\\')
            {
                s = s + "\\";
                //System.out.println("m_application.getRealPath" + s);
            }
        }
        //System.out.println("m_application.getRealPath:::" + s);
        FileNames = new String[m_files.getCount()];
        for(int k = 0;k < m_files.getCount();k++)
        {
            if(!m_files.getFile(k).isMissing())
            {
              //  System.out.println("s + m_files.getFile(k).getFileName():" + s + m_files.getFile(k).getFileName());
                m_files.getFile(k).saveAs(s + m_files.getFile(k).getFileName(),i);
                FileNames[j] = s + m_files.getFile(k).getFileName();
                j++;
            }
        }
        return j;
    }

    //Add
    private String[] FileNames;
    public String[] getFileNames()
    {
        //Method may expose internal representation by returning array
        //Returning an array value stored in one of the object's fields exposes the internal representation of the object.? For classes shared by other untrusted classes, this could potentially be a security issue.? Returning a new copy of the array is better approach in many situations.
        String[] vFileNames = new String[FileNames.length];
        System.arraycopy(FileNames,0,vFileNames,0,FileNames.length);
        return vFileNames;

	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}

/**
 * 
 * 
 */

public class UpServlet extends HttpServlet {

	private ServletConfig config;
	/**
	 * Constructor of the object.
	 */
	public UpServlet() {
		super();
	}

	final public void init(ServletConfig config) throws ServletException
    {
        this.config = config;  
    }

    final public ServletConfig getServletConfig()
    {
        return config;
    }
	/**
	 * Destruction of the servlet. <br>
	 */

					request.setAttribute("username", username);
					request.setAttribute("message", "对不起，该用户名已存在，请重新选择！");
					request.getRequestDispatcher("reg2.jsp").forward(request, response);
				}
				else{
					request.setAttribute("message", "系统维护中，请稍后再试！");
					request.getRequestDispatcher("reg2.jsp").forward(request, response);
				}
			}
		}
		else if(method.equals("Editpwd")){//会员修改登陆密码
			String member=(String)session.getAttribute("member");
			String type=(String)session.getAttribute("type");
			if(member==null||type==null){
				response.sendRedirect("error.jsp");
			}
			else{
				String oldpwd = MD5.MD5(request.getParameter("oldpwd").trim());
				String newpwd = MD5.MD5(request.getParameter("newpwd").trim());
				int flag = memberBean.editPassword(member, oldpwd, newpwd);
				switch (flag){
					case Constant.SUCCESS:
						request.setAttribute("message", "密码修改成功！");
						request.getRequestDispatcher("member/info/editpwd.jsp").forward(request, response);
						break;
					case Constant.PASSWORD_ERROR:
						request.setAttribute("message", "原始密码错误，请确认权限！");
						request.getRequestDispatcher("member/info/editpwd.jsp").forward(request, response);
						break;
					case Constant.SYSTEM_ERROR:
						request.setAttribute("message", "系统维护中，请稍后再试！");
						request.getRequestDispatcher("member/info/editpwd.jsp").forward(request, response);
						break;
				}
			}
		}
		/*********************************************
		 * 个人会员注册、修改资料 
		 *********************************************/
		else if(method.equals("PREG")){//个人会员详细资料
			String username = Filter.escapeHTMLTags(request.getParameter("username").trim());
			String password = Filter.escapeHTMLTags(request.getParameter("password").trim());
			String type = "person";
			String realname = Filter.escapeHTMLTags(request.getParameter("realname").trim());
			String sex = Filter.escapeHTMLTags(request.getParameter("sex").trim());
			String sheng = Filter.escapeHTMLTags(request.getParameter("sheng").trim());
			String city = Filter.escapeHTMLTags(request.getParameter("city").trim());
			String bir = Filter.escapeHTMLTags(request.getParameter("bir").trim());
			String telphone = Filter.escapeHTMLTags(request.getParameter("telphone").trim());
			String email = Filter.escapeHTMLTags(request.getParameter("email").trim());
			String question = Filter.escapeHTMLTags(request.getParameter("question").trim());
			String answer = Filter.escapeHTMLTags(request.getParameter("answer").trim());
			String address = Filter.escapeHTMLTags(request.getParameter("address").trim());

	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request,response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType(Constant.CONTENTTYPE);
		request.setCharacterEncoding(Constant.CHARACTERENCODING);
		String sysdir = new SystemBean().getDir();
		HttpSession session = request.getSession();
		String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
		try{
			String username2 = (String)session.getAttribute("user");
			 

//						for(int i = 0;i<check.length;i++){
//							int s = Integer.parseInt(check[i]);				
//							id2[i] = s;
//						}
//						int flag = new NewsBean().delNews(id2,strDirPath); 
//						if(flag == Constant.SUCCESS){
//							request.getRequestDispatcher(sysdir+"/news/up.jsp").forward(request, response);
//						}
//						else{
//							request.setAttribute("message", "系统维护中，请稍后再试！");
//							request.getRequestDispatcher(sysdir+"/news/up.jsp").forward(request, response);
//						}
//					}
//				}
				
				
				else{
	            	request.getRequestDispatcher("error.jsp").forward(request, response);
	            }
			}
		}catch(Exception e){
			
		}
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}

/**
 * 网站公告
 *
 */

					}
				}
				else if(method.equals("dDD2")){
					String ddid = request.getParameter("ddid");
					NewsBean nb=new NewsBean(); 
					int flag = nb.exeUp("delete from dd where ddid='"+ddid+"'");
					if(flag == Constant.SUCCESS){
						request.setAttribute("message", "操作成功！");
						request.getRequestDispatcher("admin/prep/fh.jsp").forward(request, response);
					}
					else{
						request.setAttribute("message", "系统维护中，请稍后再试！");
						request.getRequestDispatcher("admin/prep/fh.jsp").forward(request, response);
					}
				}
				查询统计
				else if(method.equals("sDDrq")){
					String year=request.getParameter("year");
					 String month=request.getParameter("month");
					 String day=request.getParameter("day");
					 String str=year+"-"+month+"-"+day;
					 String sql="select * from dd where addtime like '%"+str+"%'  ";
					 request.setAttribute("sql", sql);
					 request.getRequestDispatcher("admin/prep/s1.jsp").forward(request, response);
				}
				else if(method.equals("sDDid")){
					String ddid=request.getParameter("ddid"); 
					 request.setAttribute("ddid", ddid);
					 request.getRequestDispatcher("admin/prep/s2.jsp").forward(request, response);
				}
				else if(method.equals("sYye")){
					String year=request.getParameter("year");
					 String month=request.getParameter("month");
					 String day=request.getParameter("day");
					 
					 String year2=request.getParameter("year2");
					 String month2=request.getParameter("month2");
					 String day2=request.getParameter("day2");
					 String str=year+"-"+month+"-"+day+" "+"00:00:00";
					 String str2=year2+"-"+month2+"-"+day2+" "+"23:59:59";
					 String sql="select  * from  prep where  addtime>'"+str+"' and addtime<'"+str2+"' order by  id desc";
					 //String sql="select * from prep where addtime>'"+str+"' and addtime<'"+str2+"'  ";

				}
		}
		else if(method.equals("deldhsp")){ ///update  
			String id = request.getParameter("id");  
				String sql="delete from dhsp where id='"+id+"'";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
		}
		
		else if(method.equals("jfdhsp")){ ///update  
			String dhspid = request.getParameter("dhspid"); 
			String hykid = request.getParameter("hykid"); 
			
			float hykjf=cBean.getFloat("select sum(jf) from xs where hykid='"+hykid+"'");
			float syjf=cBean.getFloat("select sum(syjf) from dh where  hykid='"+hykid+"'");
			float jf=cBean.getFloat("select jf from dhsp where id='"+dhspid+"'");
			if((hykjf-syjf)>=jf){
				String sql="insert into dh(dhspid,hykid,syjf,sj) values('"+dhspid+"','"+hykid+"','"+jf+"','"+date2+"')";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/jf/dhinfo.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/jf/dhinfo.jsp").forward(request, response); 
				}
			}
			else{
				request.setAttribute("message", "积分不够！");
				request.getRequestDispatcher("admin/jf/dhinfo.jsp").forward(request, response);
			}
				
		}
		
		
		else if(method.equals("deldhinfo")){ ///update  
			String id = request.getParameter("id");  
				String sql="delete from dh where id='"+id+"'";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  

        int j = 0;
        if(s == null)
        {
            throw new IllegalArgumentException("There is no specified destination file (1025).");
        }
        if(s.length() == 0)
        {
            throw new IllegalArgumentException("There is no specified destination file (1025).");
        }
        if(!isVirtual(s) && m_denyPhysicalPath)
        {
            throw new SecurityException("Physical path is denied (1035).");
        }
        i = m_request.getContentLength();
        m_binArray = new byte[i];
        int k;
        for(;j < i;j += k)
        {
            try
            {
                k = m_request.getInputStream().read(m_binArray,j,i - j);
            }
            catch(Exception exception)
            {
                throw new SmartUploadException("Unable to upload.");
            }
        }

        if(isVirtual(s))
        {
            s = m_application.getRealPath(s);
        }
        try
        {
            java.io.File file = new java.io.File(s);
            FileOutputStream fileoutputstream = new FileOutputStream(file);
            fileoutputstream.write(m_binArray);
            fileoutputstream.close();
        }
        catch(Exception exception1)
        {
            throw new SmartUploadException("The Form cannot be saved in the specified file (1030).");
        }
    }

    private boolean isVirtual(String s)
    {
        if(m_application.getRealPath(s) != null)

        }
        else
        {
            if(s2.length() == 0)
            {
                m_response.setHeader("Content-Disposition","attachment;");
            }
            else
            {
                m_response.setHeader("Content-Disposition","attachment; filename=" + s2);
            }
        }
        m_response.getOutputStream().write(abyte0,0,abyte0.length);
    }

    public void fieldToFile(ResultSet resultset,String s,String s1) throws ServletException,IOException,SmartUploadException,SQLException
    {
        try
        {
            if(m_application.getRealPath(s1) != null)
            {
                s1 = m_application.getRealPath(s1);
            }
            InputStream inputstream = resultset.getBinaryStream(s);
            FileOutputStream fileoutputstream = new FileOutputStream(s1);
            int i;
            while((i = inputstream.read()) != -1)
            {
                fileoutputstream.write(i);
            }
            fileoutputstream.close();
        }
        catch(Exception exception)
        {
            throw new SmartUploadException("Unable to save file from the DataBase (1020).");
        }
    }

    private String getDataFieldValue(String s,String s1)
    {
        String s2 = ""; // = new String();
        String s3 = ""; // = new String();
        int i = 0;
        //boolean flag = false;
        //boolean flag1 = false;
        //boolean flag2 = false;
        s2 = s1 + "=" + '"';
        i = s.indexOf(s2);
        if(i > 0)
        {
            int j = i + s2.length();
            int k = j;

					}
					else{
						request.setAttribute("message", "系统维护中请稍后再试！");
						request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
					}
				}
				else if(method.equals("editAffiche")){//修改公告
					String id=Filter.escapeHTMLTags(request.getParameter("id").trim());
					String title = Filter.escapeHTMLTags(request.getParameter("title").trim());
					String content = Filter.escapeHTMLTags(request.getParameter("content").trim());
					String adder = username2;
					String ifhide = Filter.escapeHTMLTags(request.getParameter("ifhide").trim());
					int flag = afficheBean.updateAffiche(Integer.parseInt(id), title, content, adder, ifhide);
					if(flag == Constant.SUCCESS){
						request.setAttribute("message", "操作成功！");
						request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
					}
					else{
						request.setAttribute("message", "系统维护中请稍后再试！");
						request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
					}
				}
				else if(method.equals("hideAffiche")){
					String id = Filter.escapeHTMLTags(request.getParameter("id").trim());
					int flag = afficheBean.hideAffiche(Integer.parseInt(id));
					if(flag == Constant.SUCCESS){
						request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
					}
					else{
						request.setAttribute("message", "系统维护中，请稍后再试！");
						request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
					}
				}
				else if(method.equals("delaffiche")){//删除公告
					String check[] = request.getParameterValues("checkit");
					if(check == null){
						request.setAttribute("message", "请选择要删除的记录！");
						request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
					}
					else{
						int id[]= new int[check.length];
						for(int i = 0;i<check.length;i++){
							int s = Integer.parseInt(check[i]);				
							id[i] = s;
						}
						int flag = afficheBean.delAffiche(id);
						if(flag == Constant.SUCCESS){
							request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
						}
						else{
							request.setAttribute("message", "系统维护中，请稍后再试！");
							request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
						}
					}

			String mc = request.getParameter("mc"); 
			String jf = request.getParameter("jf"); 
				String sql="update dhsp set mc='"+mc+"',jf='"+jf+"' where id='"+id+"'";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
		}
		else if(method.equals("deldhsp")){ ///update  
			String id = request.getParameter("id");  
				String sql="delete from dhsp where id='"+id+"'";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
		}
		
		else if(method.equals("jfdhsp")){ ///update  
			String dhspid = request.getParameter("dhspid"); 
			String hykid = request.getParameter("hykid"); 
			
			float hykjf=cBean.getFloat("select sum(jf) from xs where hykid='"+hykid+"'");
			float syjf=cBean.getFloat("select sum(syjf) from dh where  hykid='"+hykid+"'");
			float jf=cBean.getFloat("select jf from dhsp where id='"+dhspid+"'");
			if((hykjf-syjf)>=jf){
				String sql="insert into dh(dhspid,hykid,syjf,sj) values('"+dhspid+"','"+hykid+"','"+jf+"','"+date2+"')";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/jf/dhinfo.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/jf/dhinfo.jsp").forward(request, response); 
				}
			}
			else{
				request.setAttribute("message", "积分不够！");
				request.getRequestDispatcher("admin/jf/dhinfo.jsp").forward(request, response);
			}
				
		}
		

		}
		else if(method.equals("updhsp")){ ///update  
			String id = request.getParameter("id");  
			String mc = request.getParameter("mc"); 
			String jf = request.getParameter("jf"); 
				String sql="update dhsp set mc='"+mc+"',jf='"+jf+"' where id='"+id+"'";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
		}
		else if(method.equals("deldhsp")){ ///update  
			String id = request.getParameter("id");  
				String sql="delete from dhsp where id='"+id+"'";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/jf/dhsp.jsp").forward(request, response); 
				}
		}
		
		else if(method.equals("jfdhsp")){ ///update  
			String dhspid = request.getParameter("dhspid"); 
			String hykid = request.getParameter("hykid"); 
			
			float hykjf=cBean.getFloat("select sum(jf) from xs where hykid='"+hykid+"'");
			float syjf=cBean.getFloat("select sum(syjf) from dh where  hykid='"+hykid+"'");
			float jf=cBean.getFloat("select jf from dhsp where id='"+dhspid+"'");
			if((hykjf-syjf)>=jf){
				String sql="insert into dh(dhspid,hykid,syjf,sj) values('"+dhspid+"','"+hykid+"','"+jf+"','"+date2+"')";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/jf/dhinfo.jsp").forward(request, response); 
				}

			if(username.trim().equals("admin")){
				request.setAttribute("username", username);
				request.setAttribute("message", "非法的用户名，请重新选择！");
				request.getRequestDispatcher("reg2.jsp").forward(request, response);
			}
			else{
				int flag = memberBean.checkRegName(username);
				if(flag == Constant.SUCCESS){
					if(reg_type.equals("person")){//如果是个人会员
						request.getRequestDispatcher("personreg.jsp").forward(request, response);
					}
					else if(reg_type.equals("co")){//如果是企业会员
						request.getRequestDispatcher("coreg.jsp").forward(request, response);
					}
					else{
						request.getRequestDispatcher("index.jsp").forward(request, response);
					}
				}
				else if(flag == Constant.SAME_NAME){
					request.setAttribute("username", username);
					request.setAttribute("message", "对不起，该用户名已存在，请重新选择！");
					request.getRequestDispatcher("reg2.jsp").forward(request, response);
				}
				else{
					request.setAttribute("message", "系统维护中，请稍后再试！");
					request.getRequestDispatcher("reg2.jsp").forward(request, response);
				}
			}
			
			
		}
		else if(method.equals("checksame")){//检查注册名是否可用
			String username = Filter.escapeHTMLTags(request.getParameter("username").trim());
			if(username.trim().equals("admin")){
				request.setAttribute("username", username);
				request.setAttribute("message", "非法的用户名，请重新选择！");
				request.getRequestDispatcher("reg2.jsp").forward(request, response);
			}
			else{
				int flag = memberBean.checkRegName(username);
				if(flag == Constant.SUCCESS){
					request.setAttribute("username", username);
					request.setAttribute("message", "恭喜您，这个名字可以使用！");
					request.getRequestDispatcher("reg2.jsp").forward(request, response);
				}
				else if(flag == Constant.SAME_NAME){
					request.setAttribute("username", username);
					request.setAttribute("message", "对不起，该用户名已存在，请重新选择！");
					request.getRequestDispatcher("reg2.jsp").forward(request, response);
				}
				else{
					request.setAttribute("message", "系统维护中，请稍后再试！");
					request.getRequestDispatcher("reg2.jsp").forward(request, response);