addpet_do.jsp

宠物网站jsp

<%@ page contentType="text/html;charset=GBK" pageEncoding="gb2312"  import ="java.util.*"%>

<%@ page import ="java.sql.*,cn.wy.Pet.Pet,cn.wy.DBConnection,org.lxh.smart.Request,cn.wy.Pet.User" %>
<jsp:useBean id="up" scope="page" class="org.lxh.smart.SmartUpload"/>

<%         
        HttpSession s = request.getSession();
        User user = (User)s.getAttribute("user");
        DBConnection dbc = null ;
        String sql ="";
        String forUrl = "adminiindex.jsp";
        String imgPath = "";
        boolean isShopping = false ;
        String msgStr = "";
        //是修改还是添加
        int isUpdata = 0;
        
        try {
            up.initialize(pageContext) ;
            up.upload() ;
            Request req = up.getRequest();                
            boolean flageShoping = true;            
            //是修改还是添加
            isUpdata = Integer.parseInt(req.getParameter("isUpdata")); 
            //取出单选按扭的值
            String str[] = req.getParameterValues("radiobutton");     
            //如果第一个选重
            if(str[0].equals("true"))
                isShopping = true ;
            String ext = up.getFiles().getFile(0).getFileExt();

            //指定图片路径
            String PhotoPath = "";
            
            //确定是否选择了图片
//System.out.println("isMissing:" + up.getFiles().getFile(0).isMissing());

            //如果有文件
            if (!up.getFiles().getFile(0).isMissing())
            {
                if (isUpdata == 0 | req.getParameter("imgPath").length()<13)
                    PhotoPath = "/upPetImages/"+ "Pet" + String.valueOf(System.currentTimeMillis()) + "." + ext ;
                else
                    PhotoPath = "/upPetImages/"+  req.getParameter("imgPath");
                //判断文件大小最大1M，类型必须是图片类型
                if (up.getFiles().getFile(0).getSize()<=1048576 & up.getFiles().getFile(0).getTypeMIME().equals("image"))
                {                
                    //验证成功，开始上传文件
                    up.getFiles().getFile(0).saveAs(PhotoPath);
                    System.out.println("文件上传成功");
                    imgPath = "spphotopath='" + PhotoPath + "'," ;
                }else
                {
                    //文件不符合规定返回到上一个页面 
                    out.print("<script>alert('文件不合法,文件大小必须在1M以内，必须是图片（如 jpg,gif,png）')</script>");
                    out.print("<script>history.go(-1)</script>");
                    return ;
                }
            }
            PreparedStatement ps = null ;
            dbc = new DBConnection();
            
//开始提交表单信息           
            
            //如果是更新宠物的信息
            if (req.getParameter("editPetId") != null & !req.getParameter("editPetId").endsWith("/"))
            {                
                sql = "update ShoppingPet set spbreed=?,"+imgPath+"spBirthDate=?,sparea=?,spcansp=?,spifsale=?,spprice=?,spsellprice=?,uname=?,spremark=? where SPetID=" + String.valueOf(req.getParameter("editPetId"));
                ps = dbc.getCon().prepareStatement(sql);
                ps.setString(1, req.getParameter("spbreed"));
                ps.setString(2,req.getParameter("spBirthDate"));
                ps.setString(3, req.getParameter("sparea"));
                ps.setBoolean(4, isShopping);
                ps.setBoolean(5, false);
                ps.setFloat(6, Float.parseFloat(req.getParameter("spprice")));
                ps.setFloat(7, Float.parseFloat(req.getParameter("spsellprice")));
                ps.setString(8, user.getUName());//测试用
                ps.setString(9, req.getParameter("spremark") + " ");            
                ps.executeUpdate();
                ps.close();    
                //取出该宠物所在的页
                
                forUrl = "petList.jsp?pageNo=" + req.getParameter("pageNo");
                System.out.println("更新成功！ ");
                msgStr = "修改" ;
            }
            //否则就是添加宠物
            else{
                sql = "insert into ShoppingPet(spbreed,spphotopath,spBirthDate,sparea,spcansp,spifsale,spprice,spsellprice,uname,spremark) values(?,?,?,?,?,?,?,?,?,?)";
                ps = dbc.getCon().prepareStatement(sql);
                ps.setString(1, req.getParameter("spbreed"));
                ps.setString(2, PhotoPath);
                ps.setString(3,req.getParameter("spBirthDate"));
                ps.setString(4, req.getParameter("sparea"));
                ps.setBoolean(5, isShopping);
                ps.setBoolean(6, false);
                ps.setFloat(7, Float.parseFloat(req.getParameter("spprice")));
                ps.setFloat(8, Float.parseFloat(req.getParameter("spsellprice")));
                ps.setString(9, user.getUName());//测试用
                ps.setString(10, req.getParameter("spremark") + " ");
                ps.executeUpdate();
                ps.close();
                forUrl = "addPet.jsp";
                System.out.println("宠物入库成功！");
                msgStr = "添加" ;
            }
        }catch(Exception e)
        {
            //添加失败，浏览器后退
            out.print("<script>alert('表单信息错误，宠物入库失败，请检查您填写的信息无误。');history.go(-1)</script>");
            e.printStackTrace();}
        finally
        {
            if (dbc != null)
                dbc.dbClose();
        }
        out.print("<script>alert('宠物" + msgStr + "成功！');history.go(-1)</script>");   
        //response.sendRedirect("ctrladmin?page=" + forUrl);
    %>