clientmanage.java

java web开发宝典源代码

package com.yxq.servlet;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.yxq.bean.Change;
import com.yxq.bean.DBO;
import com.yxq.bean.UserInfo;

public class ClientManage extends HttpServlet {
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doPost(request,response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		HttpSession session=request.getSession();
		String selectmenu=(String)session.getAttribute("selectmenu");
		if(selectmenu==null||selectmenu.equals("")||!selectmenu.equals("client")){
			System.out.println("非法访问！");
		}
		else{
			String op=request.getParameter("op");
			if(op==null||op.equals("")){
				System.out.println("显示<客户管理>子菜单！");
				getSubMenuList(request,response);
			}
			else if(op.equals("add")){
				System.out.println("执行 客户添加 操作！");
				doClientAdd(request,response);
			}
			else if(op.equals("look")){
				System.out.println("执行 客户查看 操作！");
				doClientLook(request,response);
			}
			else if(op.equals("search")){
				System.out.println("执行 客户查询 操作！");
				doClientSearch(request,response);
			}
			else if(op.equals("modify")){
				System.out.println("执行 客户修改 操作！");
				doClientModify(request,response);
			}
			else if(op.equals("delete")){
				System.out.println("执行 客户删除 操作！");
				doClientDel(request,response);
			}			
		}		
	}
	
	private void getSubMenuList(HttpServletRequest request,HttpServletResponse response){
		HttpSession session=request.getSession();
		List submenulist=new ArrayList();
		DBO db=new DBO();
		
		String sql="select * from tb_ShopMenu where menu_parentid='client' and menu_level=2 order by menu_order";
		submenulist=db.getMenulist(sql);
		db.closed();
		session.setAttribute("submenulist",submenulist);
		
		RequestDispatcher rd=request.getRequestDispatcher("/view/default.jsp");
		try {
			rd.forward(request,response);
		} catch (Exception e) {
		    System.out.println("获取<客户管理>子菜单后，进行转发出错！");
			e.printStackTrace();
		}
	}	
	private void doClientAdd(HttpServletRequest request,HttpServletResponse response){
		HttpSession session=request.getSession();
		session.setAttribute("selectsubmenu","client_add");
		RequestDispatcher rd=null;
		
		String currentMain=getCurrentPos();
		session.setAttribute("currentPos",currentMain+"添加客户");
		
		String type=request.getParameter("type");
		if(type==null||type.equals("")||!type.equals("clientInsert")){
			rd=request.getRequestDispatcher("/pages/client/ClientAdd.jsp");
			try {
				rd.forward(request,response);
			} catch (Exception e) {
				e.printStackTrace();
			}			
		}
		else{
			UserInfo user=(UserInfo)request.getAttribute("user");
			if(user!=null){
				String sql="insert into tb_user values('"+user.getUserId()+"','"+user.getUserName()+"','"+user.getUserPwd()+"','"+user.getUserEmail()+"','"+user.getUserPhone()+"','"+user.getUserAddr()+"')";
				System.out.println("执行向数据库中插入记录的代码！");
				DBO db=new DBO();
				int i=db.update(sql);
				if(i<=0){
					request.setAttribute("message","添加客户失败！");
				}
				else{
					request.setAttribute("message","添加客户成功！");
					user=new UserInfo();
					request.setAttribute("user",user);
				}
				db.closed();
			}
			else{
				System.out.println("UserInfo对象为NULL！");
			}
			rd=request.getRequestDispatcher("/pages/client/ClientAdd.jsp");
			try{
				rd.forward(request,response);				
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
	private void doClientLook(HttpServletRequest request,HttpServletResponse response){
		HttpSession session=request.getSession();
		session.setAttribute("selectsubmenu","client_look");
		RequestDispatcher rd=null;
		
		String currentMain=getCurrentPos();
		session.setAttribute("currentPos",currentMain+"查看客户");
		
		int currentP=1;
		String strCP=request.getParameter("showpage");
		if(strCP==null||strCP.equals(""))
			strCP=(String)session.getAttribute("lookCurrentP");
		if(strCP==null||strCP.equals(""))
			strCP="1";
		try{
			currentP=Integer.parseInt(strCP);
		}catch(Exception e){
			currentP=1;
		}
		session.setAttribute("lookCurrentP",strCP);
		String sql="select * from tb_user";
		DBO db=new DBO();
		
		List userlist=db.getCurrentList(currentP,sql);
		db.closed();
		request.setAttribute("userlist",userlist);
		request.setAttribute("pageinfo",db.getCreatepage().PrintPageInfo());
		request.setAttribute("pagelink",db.getCreatepage().PrintPageLink("admin/subMenu/client?op=look"));
		rd=request.getRequestDispatcher("/pages/client/ClientLook.jsp");
		try {
			rd.forward(request,response);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	private void doClientSearch(HttpServletRequest request,HttpServletResponse response){
		HttpSession session=request.getSession();
		session.setAttribute("selectsubmenu","client_search");
		RequestDispatcher rd=null;
		
		String currentMain=getCurrentPos();
		session.setAttribute("currentPos",currentMain+"查询客户");
		String sql="";
		String type=request.getParameter("type");
		if(type==null||type.equals("")){
			type="link";
		}
		if(type.equals("dosearch")||type.equals("dolink")){
			int currentP=1;
			String strCP=request.getParameter("showpage");
			if(strCP==null||strCP.equals(""))
				strCP=(String)session.getAttribute("searchCurrentP");
			if(strCP==null||strCP.equals(""))
				strCP="1";
			try{
				currentP=Integer.parseInt(strCP);
			}catch(Exception e){
				currentP=1;
			}
			session.setAttribute("searchCurrentP",strCP);
			
			String subsql=request.getParameter("subsql");
			String sqlvalue=request.getParameter("sqlvalue");
			sqlvalue=Change.ChangeEncoding(sqlvalue);
			
			if(type.equals("dosearch")){
				sql="select * from tb_user where "+subsql+" like '%"+sqlvalue+"%'";
				session.setAttribute("searchSQL",sql);				
			}
			else{
				sql=(String)session.getAttribute("searchSQL");
			}
			
			DBO db=new DBO();		
			List userlist=db.getCurrentList(currentP,sql);
			request.setAttribute("userlist",userlist);
			request.setAttribute("pageinfo",db.getCreatepage().PrintPageInfo());
			request.setAttribute("pagelink",db.getCreatepage().PrintPageLink("admin/subMenu/client?op=search&type=dolink"));
			rd=request.getRequestDispatcher("/pages/client/ClientSearch.jsp");
			try {
				rd.forward(request,response);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		else{
			rd=request.getRequestDispatcher("/pages/client/ClientSearch.jsp");
			try {
				rd.forward(request,response);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}	
	}
	private void doClientModify(HttpServletRequest request,HttpServletResponse response){
		HttpSession session=request.getSession();
		session.setAttribute("selectsubmenu","client_modify");
		RequestDispatcher rd=null;
		
		String currentMain=getCurrentPos();
		session.setAttribute("currentPos",currentMain+"修改客户");
		
		String type=request.getParameter("type");
		if(type==null)
			type="lookup";
		
		String sql="";
		DBO db=new DBO();
		
		if(type.equals("lookup")){
			String strid=request.getParameter("id");
			if(strid==null)
				strid="";
			int id=-1;
			try{
				id=Integer.parseInt(strid);
			}catch(Exception e){
				id=-1;
				e.printStackTrace();
			}
			sql="select * from tb_user where id='"+id+"'";
			try {
				ResultSet rs=db.getRs(sql);
				if(!rs.next()){
					request.setAttribute("message","修改的客户不存在！");
				}
				else{
					UserInfo single=new UserInfo();
					single.setId(rs.getInt("id"));
					single.setUserId(rs.getString("user_id"));
					single.setUserName(rs.getString("user_name"));
					single.setUserPwd(rs.getString("user_pwd"));
					single.setUserEmail(rs.getString("user_email"));
					single.setUserPhone(rs.getString("user_phone"));
					single.setUserAddr(rs.getString("user_addr"));
					request.setAttribute("user",single);
				}
				rd=request.getRequestDispatcher("/pages/client/ClientModify.jsp");
				rd.forward(request,response);
			} catch (Exception e) {
				System.out.println("修改客户-查询失败！");
				e.printStackTrace();
			}
		}
		else if(type.equals("doUpdate")){
			String userid=request.getParameter("userName");
			userid=Change.ChangeEncoding(userid);
			String trueName=Change.ChangeEncoding(request.getParameter("trueName"));
			String userPwd=Change.ChangeEncoding(request.getParameter("userPwd"));
			String userEmail=Change.ChangeEncoding(request.getParameter("userEmail"));
			String userPhone=Change.ChangeEncoding(request.getParameter("userPhone"));
			String address=Change.ChangeEncoding(request.getParameter("address"));
			
			sql="update tb_user set user_name='"+trueName+"',user_pwd='"+userPwd+"',user_email='"+userEmail+"',user_phone='"+userPhone+"',user_addr='"+address+"' where user_id='"+userid+"'";
			int i=db.update(sql);
			if(i<=0)
				request.setAttribute("message","客户修改失败！");
			else{
				request.setAttribute("message","客户修改成功！");
				request.setAttribute("user",null);
			}
			rd=request.getRequestDispatcher("/pages/client/ClientModify.jsp");
			try {
				rd.forward(request,response);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}
	private void doClientDel(HttpServletRequest request,HttpServletResponse response){
		String from=request.getParameter("from");
		if(from==null||from.equals(""))
			from="look";
		String strid=request.getParameter("id");
		if(strid==null)
			strid="-1";
		int id=-1;
		try{
			id=Integer.parseInt(strid);
		}catch(Exception e){
			id=-1;
			e.printStackTrace();
		}
		
		String sql="delete from tb_user where id="+id;
		DBO db=new DBO();
		int i=db.update(sql);
		if(i<=0){
			request.setAttribute("deleteR","客户删除失败！");
		}
		else{
			request.setAttribute("deleteR","客户删除成功！");						
		}
		if(from.equals("search"))
			doClientSearch(request,response);
		else
			doClientLook(request,response);
	}
	private String getCurrentPos(){
		return "客户管理 --> ";
	}
}