小郡肝火锅点餐系统代码实现

create database d_tastyfood;
use d_tastyfood;
/*菜单*/
create table t_food(
     id int primary key auto_increment,
     foodname varchar(20),
     foodprice double,
     img varchar(100),
     des varchar(100),
     t_foodtype_id int
);
/*菜种类*/
create table t_foodtype(
     id int primary key auto_increment,
     typename varchar(20)
);
/*订单*/
create table t_foodorder(
     t_food_id int,
     foodcount int,
     datatime datetime,
     totalprice double
);


alter table t_food add constraint FK_ID 
foreign key(t_foodtype_id) references t_foodtype(id);
alter table  t_foodorder add constraint t_foodorder_t_food_id 
foreign key (t_food_id) references t_food(id);

package com.action;

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

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

import com.dao.DB;
import com.orm.TAdmin;
import com.service.AdminService;

public class admin_servlet extends HttpServlet
{
    public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
    {
        String type=req.getParameter("type");
        
        if(type.endsWith("adminMana"))
        {
            adminMana(req, res);
        }
        if(type.endsWith("adminAdd"))
        {
            adminAdd(req, res);
        }
        if(type.endsWith("adminDel"))
        {
            adminDel(req, res);
        }
    }
    AdminService admin=new AdminService();
    public void adminMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {
        
        
        List adminList=admin.adminMana();
        req.setAttribute("adminList", adminList);
        req.getRequestDispatcher("admin/admin/adminMana.html").forward(req, res);
    }
    public void adminAdd(HttpServletRequest req,HttpServletResponse res)
    {
        String userName=req.getParameter("userName");
        String userPw=req.getParameter("userPw");
        String message=admin.adminAdd(userName, userPw);        
        req.setAttribute("message", message);               
        req.setAttribute("path", "admin?type=adminMana");        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }
    
    public void adminDel(HttpServletRequest req,HttpServletResponse res)
    {
        String userId=req.getParameter("userId");
        String message=admin.adminDel(userId);
        System.out.println(req.getParameter("userId")+"**");
            req.setAttribute("message",message );        
        req.setAttribute("path", "admin?type=adminMana");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }

    public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
    {
        RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
        try 
        {
            dispatch.forward(request, response);
            return;
        } 
        catch (ServletException e) 
        {
                    e.printStackTrace();
        } 
        catch (IOException e) 
        {
            
            e.printStackTrace();
        }
    }
    public void init(ServletConfig config) throws ServletException 
    {
        super.init(config);
    }
    
    public void destroy() 
    {
        
    }
}

package com.action;

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

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

import com.dao.CatelogDao;
import com.dao.DB;
import com.dao.GoodsDao;
import com.dao.impl.CatelogDaoImpl;
import com.dao.impl.GoodsDaoImpl;
import com.orm.TAdmin;
import com.orm.Tgonggao;
import com.orm.Tgoods;
import com.orm.Tuser;
import com.service.liuService;

public class goods_servlet extends HttpServlet
{
    public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
    {
        String type=req.getParameter("type");
        
        
        if(type.endsWith("goodsAdd"))
        {
            goodsAdd(req, res);
        }else if(type.endsWith("goodsMana"))
        {
            goodsMana(req, res);
        }else if(type.endsWith("goodsDel"))
        {
            goodsDel(req, res);
        }else if(type.endsWith("goodsDetail"))
        {
            goodsDetail(req, res);
        }else if(type.endsWith("goodsToModify")){
            goodsToModify(req,res);
        }else if(type.endsWith("goodsModify")){
            goodsModify(req,res);
        }
    }
    
    
    private void goodsModify(HttpServletRequest req, HttpServletResponse res) {
        String id =req.getParameter("id");
        String name=req.getParameter("name");
        String jieshao=req.getParameter("jieshao");
        String jiage=req.getParameter("jiage");
        String catelog_id=req.getParameter("catelog_id");
        
        try {
            String sql="update t_goods set name=?,jieshao=?,jiage=?,catelog_id=? where id=?";
            Object[] params={name,jieshao,jiage,catelog_id,Integer.parseInt(id)};
            DB mydb=new DB();
            mydb.doPstm(sql, params);
            mydb.closed();
            
            req.setAttribute("message", "");
        } catch (Exception e) {
            e.printStackTrace();
            req.setAttribute("message", "");
        }
        
        req.setAttribute("path", "goods?type=goodsMana");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }


    private void goodsToModify(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
        String id=req.getParameter("id");
        CatelogDao catelogDao=new CatelogDaoImpl();
        GoodsDao goodsDao=new GoodsDaoImpl();
        System.out.println(id);
        req.setAttribute("catelogList", catelogDao.findAll());
        req.setAttribute("goods", goodsDao.getGoodById(Integer.parseInt(id)));
        
        req.getRequestDispatcher("admin/goods/goodsToModify.jsp").forward(req, res);
    }


    public void goodsAdd(HttpServletRequest req,HttpServletResponse res)
    {
        int catelog_id=Integer.parseInt(req.getParameter("catelog_id"));
        String name=req.getParameter("name");
        String jieshao=req.getParameter("jieshao");
        int jiage=Integer.parseInt(req.getParameter("jiage"));
        
        String fujian=req.getParameter("fujian");
        String fujianYuanshiming=req.getParameter("fujianYuanshiming");
        String shijian=new Date().toLocaleString();
        String del="no";
        DB mydb=new DB();
        try {
            String sql="insert into t_goods (catelog_id,name,jieshao,jiage,fujian,fujianYuanshiming,shijian,del)values(?,?,?,?,?,?,?,?)";
            Object[] params={catelog_id,name,jieshao,jiage,fujian,fujianYuanshiming,shijian,del};
            
            mydb.doPstm(sql, params);
            req.setAttribute("message", "");
        } catch (Exception e) {
            req.setAttribute("message", "");
        }finally{
            mydb.closed();
        }
        
        
        
        
        req.setAttribute("path", "goods?type=goodsMana");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
        
    }
    
    
    public void goodsDel(HttpServletRequest req,HttpServletResponse res)
    {
        String sql="update t_goods set del=‘yes‘ where id=?";
        Object[] params={Integer.parseInt(req.getParameter("id"))};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
            req.setAttribute("message", "");
        } catch (SQLException e) {
            req.setAttribute("message", "");
            e.printStackTrace();
        }finally{
            mydb.closed();
        }
        
        
        req.setAttribute("path", "goods?type=goodsMana");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }

    public void goodsMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {
        String catelogId=req.getParameter("catelogId");
        String goodsName=req.getParameter("goodsName");
        req.setAttribute("catelogId", catelogId);
        req.setAttribute("goodsName", goodsName);
        
        List goodsList=new ArrayList();
        String sql="select * from t_goods where del=‘no‘ ";
        if(catelogId!=null&&!catelogId.equals("")){
            sql=sql+" and catelog_id= "+catelogId;
        }
        if(goodsName!=null&&!goodsName.equals("")){
            sql=sql+" and name like  ‘%"+goodsName+"%‘";
        }
        sql=sql+" order by catelog_id ";
        Object[] params={};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Tgoods goods=new Tgoods();
                
                goods.setId(rs.getInt("id"));
                goods.setCatelog_id(rs.getInt("catelog_id"));
                goods.setName(rs.getString("name"));
                goods.setJieshao(rs.getString("jieshao"));
                
                goods.setJiage(rs.getInt("jiage"));
                goods.setFujian(rs.getString("fujian"));
                goods.setFujianYuanshiming(rs.getString("fujianYuanshiming"));
                goods.setShijian(rs.getString("shijian"));
                goods.setDel(rs.getString("del"));
                goods.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
                goodsList.add(goods);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        
        CatelogDao catelogDao=new CatelogDaoImpl();
        req.setAttribute("catelogList1", catelogDao.findAll());
        
        req.setAttribute("goodsList", goodsList);
        req.getRequestDispatcher("admin/goods/goodsMana.jsp").forward(req, res);
    }
    
    
    public void goodsDetail(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {
        Tgoods goods=new Tgoods();
        String sql="select * from t_goods where id=?";
        Object[] params={Integer.parseInt(req.getParameter("id"))};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                
                goods.setId(rs.getInt("id"));
                goods.setCatelog_id(rs.getInt("catelog_id"));
                goods.setName(rs.getString("name"));
                goods.setJieshao(rs.getString("jieshao"));
                
                goods.setJiage(rs.getInt("jiage"));
                goods.setFujian(rs.getString("fujian"));
                goods.setFujianYuanshiming(rs.getString("fujianYuanshiming"));
                goods.setShijian(rs.getString("shijian"));
                goods.setDel(rs.getString("del"));
                goods.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("goods", goods);
        req.getRequestDispatcher("qiantai/goods/goodsDetail.html").forward(req, res);
    }
    
    
    
    public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
    {
        RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
        try 
        {
            dispatch.forward(request, response);
            return;
        } 
        catch (ServletException e) 
        {
                    e.printStackTrace();
        } 
        catch (IOException e) 
        {
            
            e.printStackTrace();
        }
    }
    public void init(ServletConfig config) throws ServletException 
    {
        super.init(config);
    }
    
    public void destroy() 
    {
        
    }
}

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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

import com.dao.CatelogDao;
import com.dao.DB;
import com.dao.impl.CatelogDaoImpl;
import com.orm.TAdmin;
import com.orm.Tcatelog;
import com.orm.Tgonggao;
import com.orm.Tuser;
import com.service.liuService;

public class index_servlet extends HttpServlet
{
    public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
    {
        String catelogId=req.getParameter("catelogId");
        String goodsName=req.getParameter("goodsName");
        req.setAttribute("catelogId", catelogId);
        req.setAttribute("goodsName", goodsName);
        
        List gonggaoList=new ArrayList();
        String sql="select * from t_gonggao where 1=1 order by id desc";
        Object[] params={};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Tgonggao gonggao=new Tgonggao();
                
                gonggao.setId(rs.getString("id"));
                gonggao.setTitle(rs.getString("title"));
                gonggao.setContent(rs.getString("content"));
                gonggao.setShijian(rs.getString("shijian"));
                
                gonggaoList.add(gonggao);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        if(gonggaoList.size()>5)
        {
            gonggaoList=gonggaoList.subList(0, 5);
        }
        req.getSession().setAttribute("gonggaoList", gonggaoList);
        mydb.closed();
        
        CatelogDao catelogDao=new CatelogDaoImpl();
        req.setAttribute("catelogList1", catelogDao.findAll());
        
        
        List catelogList=new ArrayList();
        String sql2="select * from t_catelog where 1=1 and del=‘no‘ ";
        if(catelogId!=null&&!catelogId.equals("")){
            sql2=sql2+" and id="+catelogId+" ";
        }
        
        sql2=sql2+" order by id desc ";
        Object[] params0000={};
        DB mydb0000=new DB();
        try
        {
            mydb0000.doPstm(sql2, params0000);
            ResultSet rs0000=mydb0000.getRs();
            while(rs0000.next())
            {
                Tcatelog catelog=new Tcatelog();
                
                catelog.setId(rs0000.getInt("id"));
                catelog.setName(rs0000.getString("name"));
                catelog.setGoodsList(liuService.getGoods(rs0000.getInt("id"),goodsName));
                
                catelogList.add(catelog);
            }
            rs0000.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        
        mydb0000.closed();
        if(catelogList.size()>5)
        {
            catelogList=catelogList.subList(0, 10);
        }
        req.setAttribute("catelogList", catelogList);
        
        
        
        
        req.getRequestDispatcher("qiantai/index.jsp").forward(req, res);
    }
    
    public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
    {
        RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
        try 
        {
            dispatch.forward(request, response);
            return;
        } 
        catch (ServletException e) 
        {
                    e.printStackTrace();
        } 
        catch (IOException e) 
        {
            
            e.printStackTrace();
        }
    }
    public void init(ServletConfig config) throws ServletException 
    {
        super.init(config);
    }
    
    public void destroy() 
    {
        
    }
}

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.Format;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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

import com.dao.DB;
import com.orm.TAdmin;
import com.orm.TClear;
import com.orm.Tgonggao;
import com.orm.Tgoods;
import com.orm.Torder;
import com.orm.Tuser;
import com.service.ClearService;
import com.service.liuService;

public class order_servlet extends HttpServlet
{
    public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
    {
        String type=req.getParameter("type");
        
        
        if(type.endsWith("orderAdd"))
        {
            orderAdd(req, res);
        }
        if(type.endsWith("orderMana_user"))
        {
            orderMana_user(req, res);
        }
        if(type.endsWith("orderMana"))
        {
            orderMana(req, res);
        }
        if(type.endsWith("orderDel"))
        {
            orderDel(req, res);
        }else if(type.endsWith("updateStatus")){
            updateStatus(req,res);
        }
        if(type.endsWith("orderDelUser"))
        {
            orderDelUser(req, res);
        }
        
        if(type.endsWith("orderManaFuwu"))
        {
            orderManaFuwu(req, res);
            
        }
        if(type.endsWith("orderManaFuwu2"))
        {
            orderManaFuwu2(req, res);
            
        }
        if(type.endsWith("orderManaFuwu3"))
        {
            orderManaFuwu3(req, res);
            
        }
        if(type.endsWith("orderDelFuwu"))
        {
            orderDelFuwu(req, res);
        }else if(type.endsWith("updateStatusFuwu")){
            updateStatusFuwu(req,res);
        }
        if(type.endsWith("orderDelFuwu2"))
        {
            orderDelFuwu2(req, res);
        }
        
    }
    
    
    private void updateStatus(HttpServletRequest req, HttpServletResponse res) {
        String sql="update t_order set status=? where id=?";
        System.out.println(req.getParameter("value")+":"+req.getParameter("id"));
        Object[] params={req.getParameter("value"),Integer.parseInt(req.getParameter("id"))};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
            req.setAttribute("message", "");
        } catch (SQLException e) {
            req.setAttribute("message", "");
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("path", "order?type=orderMana");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
        
    }


    public void orderAdd(HttpServletRequest req,HttpServletResponse res)
    {
        Tuser user= (Tuser) req.getSession().getAttribute("user");
        
        int shuliang=Integer.parseInt(req.getParameter("shuliang"));
        
        
        int goods_id=Integer.parseInt(req.getParameter("goods_id"));
        
        String user_id=((Tuser)req.getSession().getAttribute("user")).getId();
        String zhuangtai="daishouli";
        String del="no";
        Double jiaqian=Double.parseDouble(req.getParameter("jiage"));
        String sql="insert into t_order (shuliang,goods_id,user_id,zhuangtai,del,status,jiaqian)values(?,?,?,?,?,?,?)";
        
        Object[] params={shuliang,goods_id,user_id,zhuangtai,del,0,jiaqian};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
            req.setAttribute("message", "");
        } catch (SQLException e) {
            req.setAttribute("message", "");
            e.printStackTrace();
        }
        mydb.closed();
        
        
        req.setAttribute("path", "index");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
        
    }
    
    public void orderMana_user(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {
        System.out.println(req.getParameter("user_id"));
        
        List orderList=new ArrayList();
        String sql="select * from t_order where del=‘no‘ and user_id=?";
        Object[] params={req.getParameter("user_id")};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Torder order=new Torder();
                
                order.setId(rs.getInt("id"));
                order.setShuliang(rs.getInt("shuliang"));
                order.setSonghuodizhi(rs.getString("songhuodizhi"));
                order.setFukuangfangshi(rs.getString("fukuangfangshi"));
                
                order.setGoods_id(rs.getInt("goods_id"));
                order.setUser_id(rs.getString("user_id"));
                order.setZhuangtai(rs.getString("zhuangtai"));
                order.setDel(rs.getString("del"));
                
                order.setStatus(rs.getString("status"));
                order.setTelephone(rs.getString("telephone"));
                order.setOrderDate(rs.getString("orderdate"));
                order.setJiaqian(rs.getDouble("jiaqian")*rs.getInt("shuliang"));
                order.setUser_name(liuService.getUserName(rs.getString("user_id")));
                order.setGoods_name(liuService.getGoodsName(rs.getInt("goods_id")));
            
                orderList.add(order);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("orderList", orderList);
        req.getRequestDispatcher("qiantai/order/orderMana_user.html").forward(req, res);
    }
    
    
    public void orderDel(HttpServletRequest req,HttpServletResponse res)
    {
        String sql="update t_order set del=‘yes‘ where id=?";
        Object[] params={Integer.parseInt(req.getParameter("id"))};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
            req.setAttribute("message", "");
        } catch (SQLException e) {
            req.setAttribute("message", "");
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("path", "order?type=orderMana");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }
    public void orderDelUser(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {
        String sql="delete from t_order  where id=?";
        String user_id=req.getParameter("user_id");
        System.out.println("del++++"+user_id);
        Object[] params={Integer.parseInt(req.getParameter("id"))};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
            req.setAttribute("message", "");
        } catch (SQLException e) {
            req.setAttribute("message", "");
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("path", "order?type=orderMana_user&user_id="+user_id);
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }

    public void orderMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {  
        String status=req.getParameter("status");
        req.setAttribute("status", status);
        List orderList=new ArrayList();
        String sql="select * from t_order where del=‘no‘";
        if(status!=null&&!status.equals("")){
            sql=sql+" and status="+status;
        }
        Object[] params={};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Torder order=new Torder();
                
                order.setId(rs.getInt("id"));
                order.setShuliang(rs.getInt("shuliang"));
                order.setSonghuodizhi(rs.getString("songhuodizhi"));
                order.setFukuangfangshi(rs.getString("fukuangfangshi"));
                
                order.setGoods_id(rs.getInt("goods_id"));
                order.setUser_id(rs.getString("user_id"));
                order.setZhuangtai(rs.getString("zhuangtai"));
                order.setDel(rs.getString("del"));
                
                order.setStatus(rs.getString("status"));
                order.setTelephone(rs.getString("telephone"));
                order.setOrderDate(rs.getString("orderdate"));
                order.setJiaqian(rs.getDouble("jiaqian")*rs.getInt("shuliang"));
                
                order.setUser_name(liuService.getUserName(rs.getString("user_id")));
                order.setGoods_name(liuService.getGoodsName(rs.getInt("goods_id")));
                orderList.add(order);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("orderList", orderList);
        req.getRequestDispatcher("admin/order/orderMana.html").forward(req, res);
    }
    
    public void orderDelFuwu(HttpServletRequest req,HttpServletResponse res)
    {
        String sql="update t_order set del=‘yes‘ where id=?";
        Object[] params={Integer.parseInt(req.getParameter("id"))};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
            req.setAttribute("message", "");
        } catch (SQLException e) {
            req.setAttribute("message", "");
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("path", "order?type=orderManaFuwu");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }
    public void orderDelFuwu2(HttpServletRequest req,HttpServletResponse res)
    {
        ClearService clear=new ClearService();
        TClear tclear=new TClear();
        tclear.setNumber(req.getParameter("username"));
        tclear.setPrice(Double.parseDouble(req.getParameter("sum")));
        String message=clear.jiezhang(tclear,req.getParameter("userid"));
        
        req.setAttribute("path", "order?type=orderManaFuwu2");
        req.setAttribute("message", message);
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }
    public void orderManaFuwu(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {  
        String status=req.getParameter("status");
        req.setAttribute("status", status);
        List orderList=new ArrayList();
        String sql="select * from t_order where del=‘no‘";
        if(status!=null&&!status.equals("")){
            sql=sql+" and status="+status;
        }
        Object[] params={};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Torder order=new Torder();
                
                order.setId(rs.getInt("id"));
                order.setShuliang(rs.getInt("shuliang"));
                order.setSonghuodizhi(rs.getString("songhuodizhi"));
                order.setFukuangfangshi(rs.getString("fukuangfangshi"));
                
                order.setGoods_id(rs.getInt("goods_id"));
                order.setUser_id(rs.getString("user_id"));
                order.setZhuangtai(rs.getString("zhuangtai"));
                order.setDel(rs.getString("del"));
                
                order.setStatus(rs.getString("status"));
                order.setTelephone(rs.getString("telephone"));
                order.setOrderDate(rs.getString("orderdate"));
                order.setJiaqian(rs.getDouble("jiaqian")*rs.getInt("shuliang"));
                
                order.setUser_name(liuService.getUserName(rs.getString("user_id")));
                order.setGoods_name(liuService.getGoodsName(rs.getInt("goods_id")));
                orderList.add(order);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("orderList", orderList);
        
        req.getRequestDispatcher("fuwuyuan/order/orderManaFuwu.jsp").forward(req, res);
    }
    public void orderManaFuwu2(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {  
        String userlogin=req.getParameter("userlogin");
        ClearService clear=new ClearService();
        
        //req.setAttribute("status", status);
        List orderList=clear.findByName(userlogin);
        
        req.setAttribute("orderList", orderList);
        
        req.getRequestDispatcher("fuwuyuan/order/orderManaFuwu2.jsp").forward(req, res);
    }
    public void orderManaFuwu3(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {  
        ClearService clear=new ClearService();
        List orderList=clear.findByAll();
        
        req.setAttribute("orderList", orderList);
        
        req.getRequestDispatcher("fuwuyuan/order/orderManaFuwu3.jsp").forward(req, res);
    }
    private void updateStatusFuwu(HttpServletRequest req, HttpServletResponse res) {
        String sql="update t_order set status=? where id=?";
        System.out.println(req.getParameter("value")+":"+req.getParameter("id"));
        Object[] params={req.getParameter("value"),Integer.parseInt(req.getParameter("id"))};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
            req.setAttribute("message", "");
        } catch (SQLException e) {
            req.setAttribute("message", "");
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("path", "order?type=orderManaFuwu");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
        
    }
    
    public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
    {
        RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
        try 
        {
            dispatch.forward(request, response);
            return;
        } 
        catch (ServletException e) 
        {
                    e.printStackTrace();
        } 
        catch (IOException e) 
        {
            
            e.printStackTrace();
        }
    }
    public void init(ServletConfig config) throws ServletException 
    {
        super.init(config);
    }
    
    public void destroy() 
    {
        
    }
}

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.dao.DB;
import com.orm.Tuser;

public class user_servlet extends HttpServlet
{
    /**
     * 
     */
    private static final long serialVersionUID = 1L;

    public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
    {
        String type=req.getParameter("type");
        
        
        if(type.endsWith("userReg"))
        {
            userReg(req, res);
        }
        if(type.endsWith("userLogout"))
        {
            userLogout(req, res);
        }
        if(type.endsWith("userEdit"))
        {
            userEdit(req, res);
        }else if(type.endsWith("userModify")){
            userModify(req, res);
        }else if(type.endsWith("usreToModify")){
            usreToModify(req,res);
        }
        
        
        if(type.endsWith("userMana"))
        {
            userMana(req, res);
        }
        if(type.endsWith("userDel"))
        {
            userDel(req, res);
        }
    }
    
    
    private void usreToModify(HttpServletRequest req, HttpServletResponse res) {
        String id=req.getParameter("id");
        
        String sql="select * from t_user where del=‘no‘ and id=? ";
        Object[] params={id};
        DB mydb=new DB();
        try 
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            Tuser user=new Tuser();
            while (rs.next()) {
                user.setId(rs.getString("id"));
                user.setLoginname(rs.getString("loginname"));
                user.setLoginpw(rs.getString("loginpw"));
                user.setLoginpw(rs.getString("loginpw"));
                user.setName(rs.getString("name"));
                user.setSex(rs.getString("sex"));
                user.setAge(rs.getString("age"));
                user.setAddress(rs.getString("address"));
                user.setTel(rs.getString("tel"));
                user.setEmail(rs.getString("email"));
                user.setQq(rs.getString("qq"));
            }
            
            
            req.setAttribute("user", user);
            rs.close();
        } 
        catch (SQLException e)
        {
            e.printStackTrace();
        }
        finally
        {
            mydb.closed();
        }
        
        String targetURL = "/admin/user/userXinxi.html";
        dispatch(targetURL, req, res);
    }


    public void userReg(HttpServletRequest req,HttpServletResponse res)
    {
        String id=String.valueOf(new Date().getTime());
        String loginname=req.getParameter("loginname");
        String loginpw=req.getParameter("loginpw");
        String name=req.getParameter("name");
        String sex=req.getParameter("sex");
        String age=req.getParameter("age");
        String address=req.getParameter("address");
        String tel=req.getParameter("tel");
        String email=req.getParameter("email");
        String qq=req.getParameter("qq");
        String del="no";
        
        String sql="insert into t_user (id,loginname,loginpw,name,sex,age,address,tel,email,qq,del)values(?,?,?,?,?,?,?,?,?,?,?)";
        Object[] params={id,loginname,loginpw,name,sex,age,address,tel,email,qq,del};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        mydb.closed();
        
        try {
            userMana(req, res);
        } catch (ServletException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    
    
    
    public void userLogout(HttpServletRequest req,HttpServletResponse res)
    {
        req.getSession().setAttribute("user", null);
        String targetURL = "/qiantai/default.html";
        dispatch(targetURL, req, res);        
    }
    
    public void userEdit(HttpServletRequest req,HttpServletResponse res)
    {
        String id=req.getParameter("id");
        String loginname=req.getParameter("loginname");
        String loginpw=req.getParameter("loginpw");
        String name=req.getParameter("name");
        String sex=req.getParameter("sex");
        String age=req.getParameter("age");
        String address=req.getParameter("address");
        String tel=req.getParameter("tel");
        String email=req.getParameter("email");
        String qq=req.getParameter("qq");
        
        String sql="update t_user set loginpw=?,name=?,sex=?,age=?,address=?,tel=?,email=?,qq=? where id=?";
        Object[] params={loginpw,name,sex,age,address,tel,email,qq,id};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
            
            Tuser user=(Tuser) req.getSession().getAttribute("user");
            user.setId(id);
            user.setLoginname(loginname);
            user.setLoginpw(loginpw);
            user.setName(name);
            user.setSex(sex);
            user.setAge(age);
            user.setAddress(address);
            user.setTel(tel);
            user.setEmail(email);
            user.setQq(qq);
            req.getSession().setAttribute("user",user);
            
            
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        mydb.closed();
        
        String targetURL = "/common/add_success.html";
        dispatch(targetURL, req, res);
    }
    
    public void userModify(HttpServletRequest req,HttpServletResponse res)
    {
        String id=req.getParameter("id");
        String loginname=req.getParameter("loginname");
        String loginpw=req.getParameter("loginpw");
        String name=req.getParameter("name");
        String sex=req.getParameter("sex");
        String age=req.getParameter("age");
        String address=req.getParameter("address");
        String tel=req.getParameter("tel");
        String email=req.getParameter("email");
        String qq=req.getParameter("qq");
        
        String sql="update t_user set loginname=?,loginpw=?,name=?,sex=?,age=?,address=?,tel=?,email=?,qq=? where id=?";
        Object[] params={loginname,loginpw,name,sex,age,address,tel,email,qq,id};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("message", "");
        req.setAttribute("path", "user?type=userMana");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }
    
    
    public void userDel(HttpServletRequest req,HttpServletResponse res)
    {
        String id=req.getParameter("id");
        
        String sql="delete from t_user where id=?";
        Object[] params={id};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("message", "");
        req.setAttribute("path", "user?type=userMana");
        
        String targetURL = "/common/success.html";
        dispatch(targetURL, req, res);
    }

    public void userMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    {
        List userList=new ArrayList();
        String username=req.getParameter("username");
        String sql="select * from t_user where del=‘no‘ ";
        if(username!=null&&!username.equals("")){
            sql=sql+" and loginname like ‘%"+username+"%‘";
        }
        Object[] params={};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Tuser user=new Tuser();
                
                user.setId(rs.getString("id"));
                user.setLoginname(rs.getString("loginname"));
                user.setLoginpw(rs.getString("loginpw"));
                user.setLoginpw(rs.getString("loginpw"));
                user.setName(rs.getString("name"));
                user.setSex(rs.getString("sex"));
                user.setAge(rs.getString("age"));
                user.setAddress(rs.getString("address"));
                user.setTel(rs.getString("tel"));
                user.setEmail(rs.getString("email"));
                user.setQq(rs.getString("qq"));
                
                userList.add(user);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        
        req.setAttribute("userList", userList);
        req.setAttribute("username", username);
        req.getRequestDispatcher("admin/user/userMana.html").forward(req, res);
    }
    public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
    {
        RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
        try 
        {
            dispatch.forward(request, response);
            return;
        } 
        catch (ServletException e) 
        {
                    e.printStackTrace();
        } 
        catch (IOException e) 
        {
            
            e.printStackTrace();
        }
    }
    public void init(ServletConfig config) throws ServletException 
    {
        super.init(config);
    }
    
    public void destroy() 
    {
        
    }
}

package com.dao.impl;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.dao.CatelogDao;
import com.dao.DB;
import com.orm.Tcatelog;

public class CatelogDaoImpl implements CatelogDao {

    @Override
    public List<Tcatelog> findAll() {
        List<Tcatelog> catelogList=new ArrayList<Tcatelog>();
        String sql1="select * from t_catelog where del=‘no‘ order by id desc";
        Object[] params1={};
        DB mydb1=new DB();
        try
        {
            mydb1.doPstm(sql1, params1);
            ResultSet rs1=mydb1.getRs();
            while(rs1.next())
            {
                Tcatelog catelog=new Tcatelog();
                
                catelog.setId(rs1.getInt("id"));
                catelog.setName(rs1.getString("name"));
                
                catelogList.add(catelog);
            }
            rs1.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        
        return catelogList;
    }

    @Override
    public Tcatelog catelogToModify(String id ) {
        // TODO Auto-generated method stub
        String sql="select * from t_catelog where del=‘no‘ and id="+id;
        Object[] params={};
        DB mydb=new DB();
        Tcatelog catelog=new Tcatelog();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                catelog.setId(rs.getInt("id"));
                catelog.setName(rs.getString("name"));
                catelog.setJieshao(rs.getString("jieshao"));
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        return catelog;
    }

    @Override
    public String catelogModify(String id, String name, String jieshao) {
        String message="";
         try {
             
                String sql="update t_catelog set name=?,jieshao=? where id=?";
                Object[] params={name,jieshao,id};
                DB mydb=new DB();
                mydb.doPstm(sql, params);
                mydb.closed();
                
                message= "";
            } catch (Exception e) {
                message= "";
            }
        return message;
    }

}

package com.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.dao.ClearDao;
import com.dao.DB;
import com.orm.TAdmin;
import com.orm.TClear;
import com.orm.Torder;
import com.service.liuService;



public class ClearDaoImpl implements ClearDao {

    @Override
    public List findById(String userId) {
        List orderList=new ArrayList();
        String sql="select * from t_order where del=‘no‘ and user_id=?";
        Object[] params={userId};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Torder order=new Torder();
                
                order.setId(rs.getInt("id"));
                order.setShuliang(rs.getInt("shuliang"));
                order.setSonghuodizhi(rs.getString("songhuodizhi"));
                order.setFukuangfangshi(rs.getString("fukuangfangshi"));
                
                order.setGoods_id(rs.getInt("goods_id"));
                order.setUser_id(rs.getString("user_id"));
                order.setZhuangtai(rs.getString("zhuangtai"));
                order.setDel(rs.getString("del"));
                
                order.setStatus(rs.getString("status"));
                order.setTelephone(rs.getString("telephone"));
                order.setOrderDate(rs.getString("orderdate"));
                order.setJiaqian(rs.getDouble("jiaqian")*rs.getInt("shuliang"));
                order.setGoods_name(liuService.getGoodsName(rs.getInt("goods_id")));
                order.setUser_name(liuService.getUserName(rs.getString("user_id")));
                
                orderList.add(order);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
    return orderList;
    }

    @Override
    public String findByUserLogin(String userloginname) {
        Torder order=new Torder();
        String sql="select * from t_user where loginname=?";
        Object[] params={userloginname};
        DB mydb=new DB();
        String id="";
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {            
                id=rs.getString("id");
                //order.setId(Integer.parseInt(rs.getString("id")));
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        return id;
        //return String.valueOf(order.getId());
    }

    @Override
    public String delete(String user_id) {
        String message="";
        String sql="update t_order set del=‘yes‘ where user_id=?";
        //Object[] params={Integer.parseInt(user_id)};
        Object[] params={user_id};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
           message= "";
        } catch (SQLException e) {
           message="";
            e.printStackTrace();
        }
        mydb.closed();
        return message;
    }

    @Override
    public void insert(TClear clear) {
        String id=String.valueOf(new Date().getTime());
        String number=clear.getNumber();
        String time=new Date().toLocaleString();
        Double price=clear.getPrice();                
        String sql="insert into t_clear (number,time,price)values(?,?,?)";
        Object[] params={number,time,price};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        mydb.closed();
    }

    @Override
    public List findByAll() {
        List orderList=new ArrayList();
        String sql="select * from t_clear ";
        Object[] params={};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                TClear order=new TClear();                
                order.setId(rs.getInt("id"));                
                order.setNumber(rs.getString("number"));
                order.setTime(rs.getString("time"));                
                order.setPrice(rs.getDouble("price"));                
                orderList.add(order);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
    return orderList;
    }

}

package com.dao.impl;

import java.sql.ResultSet;

import com.dao.DB;
import com.dao.GoodsDao;
import com.orm.Tgoods;
import com.service.liuService;

public class GoodsDaoImpl implements GoodsDao{

    @Override
    public Tgoods getGoodById(Integer id) {
        Tgoods goods=new Tgoods();
        String sql="select * from t_goods where del=‘no‘ ";
        
        sql=sql+" and id = "+id;
        Object[] params={};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                
                goods.setId(rs.getInt("id"));
                goods.setCatelog_id(rs.getInt("catelog_id"));
                goods.setName(rs.getString("name"));
                goods.setJieshao(rs.getString("jieshao"));
                
                goods.setJiage(rs.getInt("jiage"));
                goods.setFujian(rs.getString("fujian"));
                goods.setFujianYuanshiming(rs.getString("fujianYuanshiming"));
                goods.setShijian(rs.getString("shijian"));
                goods.setDel(rs.getString("del"));
                goods.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        
        return goods;
    }

}

package com.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.dao.AdminDAO;
import com.dao.DB;
import com.orm.TAdmin;

public class AdminDaoImpl implements AdminDAO {

    @Override
    public List adminMana() {
        List adminList=new ArrayList();
        String sql="select * from t_admin";
        Object[] params={};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                TAdmin admin=new TAdmin();
                admin.setUserId(rs.getInt("userId"));
                admin.setUserName(rs.getString("userName"));
                admin.setUserPw(rs.getString("userPw"));
                adminList.add(admin);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        return adminList;
    }

    @Override
    public String adminAdd(String userName, String userPw) {
        
        String sql="insert into t_admin (userName,userPw)values(?,?)";
        Object[] params={userName,userPw};
        DB mydb=new DB();
        String message="";
        try {
            mydb.doPstm(sql, params);
            message= "";
        } catch (SQLException e) {
            message="";
            e.printStackTrace();
        }finally{
            mydb.closed();
        }
        return message;
        
    }

    @Override
    public String adminDel(String userId) {
        String sql="delete from t_admin where userId="+Integer.parseInt(userId);
        Object[] params={};
        String message="";
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
            message= "";
        } catch (SQLException e) {
            message="";
            e.printStackTrace();
        }finally{
            mydb.closed();
        }
        
        return message;
    }

}

package com.service;

import java.util.ArrayList;
import java.util.List;

import com.dao.AdminDAO;
import com.dao.impl.AdminDaoImpl;

public class AdminService {
    AdminDAO admin=new AdminDaoImpl();
    public List adminMana() {    
        List adminList=admin.adminMana();
        return adminList;
    }
    public String adminAdd(String userName, String userPw) {
        String message=admin.adminAdd(userName, userPw);
        return message;
    }
    public String adminDel(String userId) {
        String message=admin.adminDel(userId);
        return message;
    }
}

package com.service;

import com.dao.CatelogDao;
import com.dao.impl.CatelogDaoImpl;
import com.orm.Tcatelog;

public class CatelogService {
    CatelogDao catelog=new CatelogDaoImpl();
    public Tcatelog catelogToModify(String id){
        Tcatelog tcatelog=catelog.catelogToModify(id);
        return tcatelog;
    }
    public String catelogModify(String id, String name, String jieshao) {
        String message=catelog.catelogModify(id, name, jieshao);
        return message;
    }
}

package com.service;

import java.util.List;

import com.dao.ClearDao;
import com.dao.impl.ClearDaoImpl;
import com.orm.TClear;



public class ClearService {
    ClearDao clear=new ClearDaoImpl();
    public List findByName(String userloginname) {    
        List clearList=clear.findById(clear.findByUserLogin(userloginname));
        return clearList;
    }
    public String jiezhang(TClear tclear,String user_id) {    
        clear.insert(tclear);
        String message=clear.delete(user_id);
        return message;
    }
    public List findByAll() {    
        List clearList=clear.findByAll();
        return clearList;
    }
    
}

package com.service;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.dao.DB;
import com.orm.Tgoods;

public class liuService
{
    public static String getUserName(String id)
    {
        String name="";
        
        String sql="select * from t_user where id=?";
        Object[] params={id};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            rs.next();
            name=rs.getString("loginname");
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        return name;
    }
    
    public static String getCatelogName(int id)
    {
        String name="";
        
        String sql="select * from t_catelog where id=?";
        Object[] params={id};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            rs.next();
            name=rs.getString("name");
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        return name;
    }
    
    public static String getGoodsName(int id)
    {
        String name="";
        
        String sql="select * from t_goods where id=?";
        Object[] params={id};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            rs.next();
            name=rs.getString("name");
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        return name;
    }
    
    public static List getGoods(int catelog_id)
    {
        List goodsList=new ArrayList();
        
        String sql="select * from t_goods where del=‘no‘ and catelog_id=?";
        Object[] params={catelog_id};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Tgoods goods=new Tgoods();
                
                goods.setId(rs.getInt("id"));
                goods.setCatelog_id(rs.getInt("catelog_id"));
                goods.setName(rs.getString("name"));
                goods.setJieshao(rs.getString("jieshao"));
                
                goods.setJiage(rs.getInt("jiage"));
                goods.setFujian(rs.getString("fujian"));
                goods.setFujianYuanshiming(rs.getString("fujianYuanshiming"));
                goods.setShijian(rs.getString("shijian"));
                goods.setDel(rs.getString("del"));
                goods.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
                goodsList.add(goods);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        if(goodsList.size()>10)
        {
            goodsList=goodsList.subList(0, 10);
        }
        
        return goodsList;
    }
    
    public static List getGoods(int catelog_id,String goodsName)
    {
        List goodsList=new ArrayList();
        
        String sql="select * from t_goods where del=‘no‘ and catelog_id=? ";
        if(goodsName !=null &&!goodsName.equals("")){
            sql=sql+" and name like ‘%"+goodsName+"%‘";
        }
        Object[] params={catelog_id};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Tgoods goods=new Tgoods();
                
                goods.setId(rs.getInt("id"));
                goods.setCatelog_id(rs.getInt("catelog_id"));
                goods.setName(rs.getString("name"));
                goods.setJieshao(rs.getString("jieshao"));
                
                goods.setJiage(rs.getInt("jiage"));
                goods.setFujian(rs.getString("fujian"));
                goods.setFujianYuanshiming(rs.getString("fujianYuanshiming"));
                goods.setShijian(rs.getString("shijian"));
                goods.setDel(rs.getString("del"));
                goods.setCatelog_name(liuService.getCatelogName(rs.getInt("catelog_id")));
                goodsList.add(goods);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        if(goodsList.size()>10)
        {
            goodsList=goodsList.subList(0, 10);
        }
        
        return goodsList;
    }
    
}

package com.service;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.http.HttpSession;

import org.directwebremoting.WebContext;
import org.directwebremoting.WebContextFactory;


import com.dao.DB;
import com.orm.TAdmin;
import com.orm.Tcatelog;
import com.orm.Tuser;

public class loginService
{
    public String login(String userName,String userPw,int userType)
    {
        System.out.println("userType"+userType);
        try
        {
            Thread.sleep(700);
        } catch (InterruptedException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
        String result="no";
        
        if(userType==0)//
        {
            String sql="select * from t_admin where userName=? and userPw=?";
            Object[] params={userName,userPw};
            DB mydb=new DB();
            try 
            {
                mydb.doPstm(sql, params);
                ResultSet rs=mydb.getRs();
                boolean mark=(rs==null||!rs.next()?false:true);
                if(mark==false)
                {
                     result="no";
                }
                else
                {
                     result="yes";
                     TAdmin admin=new TAdmin();
                     admin.setUserId(rs.getInt("userId"));
                     admin.setUserName(rs.getString("userName"));
                     admin.setUserPw(rs.getString("userPw"));
                     WebContext ctx = WebContextFactory.get(); 
                     HttpSession session=ctx.getSession(); 
                     session.setAttribute("userType", 0);
                     session.setAttribute("admin", admin);
                }
                rs.close();
            } 
            catch (SQLException e)
            {
                System.out.println("");
                e.printStackTrace();
            }
            finally
            {
                mydb.closed();
            }
            
        }
        
        
        if(userType==1)
        {
            String sql="select * from t_user where del=‘no‘ and loginname=? and loginpw=?";
            Object[] params={userName,userPw};
            DB mydb=new DB();
            try 
            {
                mydb.doPstm(sql, params);
                ResultSet rs=mydb.getRs();
                boolean mark=(rs==null||!rs.next()?false:true);
                if(mark==false)
                {
                     result="no";
                }
                else
                {
                    result="yes";
                    Tuser user=new Tuser();
                    user.setId(rs.getString("id"));
                    user.setLoginname(rs.getString("loginname"));
                    user.setLoginpw(rs.getString("loginpw"));
                    user.setLoginpw(rs.getString("loginpw"));
                    user.setName(rs.getString("name"));
                    user.setSex(rs.getString("sex"));
                    user.setAge(rs.getString("age"));
                    user.setAddress(rs.getString("address"));
                    user.setTel(rs.getString("tel"));
                    user.setEmail(rs.getString("email"));
                    user.setQq(rs.getString("qq"));
                    
                    WebContext ctx = WebContextFactory.get(); 
                    HttpSession session=ctx.getSession(); 
                    session.setAttribute("userType", 1);
                    session.setAttribute("user", user);
                }
                rs.close();
            } 
            catch (SQLException e)
            {
                System.out.println("");
                e.printStackTrace();
            }
            finally
            {
                mydb.closed();
            }
        }
        if(userType==2)
        {
            String sql="select * from t_admin where userName=? and userPw=?";
            Object[] params={userName,userPw};
            DB mydb=new DB();
            try 
            {
                mydb.doPstm(sql, params);
                ResultSet rs=mydb.getRs();
                boolean mark=(rs==null||!rs.next()?false:true);
                if(mark==false)
                {
                     result="no";
                }
                else
                {
                     result="yes";
                     TAdmin admin=new TAdmin();
                     admin.setUserId(rs.getInt("userId"));
                     admin.setUserName(rs.getString("userName"));
                     admin.setUserPw(rs.getString("userPw"));
                     WebContext ctx = WebContextFactory.get(); 
                     HttpSession session=ctx.getSession(); 
                     session.setAttribute("userType", 2);
                     session.setAttribute("admin", admin);
                }
                rs.close();
            } 
            catch (SQLException e)
            {
                System.out.println(");
                e.printStackTrace();
            }
            finally
            {
                mydb.closed();
            }
        }
        return result;
    }

    public String adminPwEdit(String userPwNew)
    {
        System.out.println("DDDD");
        try 
        {
            Thread.sleep(700);
        } 
        catch (InterruptedException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        WebContext ctx = WebContextFactory.get(); 
        HttpSession session=ctx.getSession(); 
        TAdmin admin=(TAdmin)session.getAttribute("admin");
        
        String sql="update t_admin set userPw=? where userId=?";
        Object[] params={userPwNew,admin.getUserId()};
        DB mydb=new DB();
        try {
            mydb.doPstm(sql, params);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
        return "yes";
    }
    
    public List catelogAll()
    {
        try
        {
            Thread.sleep(700);
        } catch (InterruptedException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
        List catelogList=new ArrayList();
        String sql="select * from t_catelog where del=‘no‘";
        Object[] params={};
        DB mydb=new DB();
        try
        {
            mydb.doPstm(sql, params);
            ResultSet rs=mydb.getRs();
            while(rs.next())
            {
                Tcatelog catelog=new Tcatelog();
                catelog.setId(rs.getInt("id"));
                catelog.setName(rs.getString("name"));
                catelog.setJieshao(rs.getString("jieshao"));
                catelogList.add(catelog);
            }
            rs.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        mydb.closed();
        System.out.println(catelogList.size()+"^^");
        return catelogList;
    }
}

package com.util;

import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

public class EncodingFilter implements Filter {  //编码过滤器
    protected String encoding = null;

    protected FilterConfig filterConfig = null;

    public void destroy() {
        this.encoding = null;
        this.filterConfig = null;
    }

    public void doFilter(ServletRequest request, ServletResponse response,
            FilterChain chain) throws IOException, ServletException {
        // Select and set (if needed) the character encoding to be used
        String encoding = selectEncoding(request);
        if (encoding != null) {
            request.setCharacterEncoding(encoding);
            response.setCharacterEncoding(encoding);
        }
        // Pass control on to the next filter
        chain.doFilter(request, response);
    }

    public void init(FilterConfig filterConfig) throws ServletException {
        this.filterConfig = filterConfig;
        this.encoding = filterConfig.getInitParameter("encoding");
    }

    protected String selectEncoding(ServletRequest request) {
        return (this.encoding);
    }
}