商城项目笔记1，顶层商品类别的添加（注意JSP,Bean,DAO,DB的分层书写结构）

最新推荐文章于 2022-04-06 20:28:07 发布

Tuzki_小辣鸡

最新推荐文章于 2022-04-06 20:28:07 发布

阅读量210

点赞数 1

文章标签： bean jsp 商城

本文链接：https://blog.csdn.net/weixin_37659242/article/details/79648922

版权

1.Bean层：

    public static void addTopCategroy(String name, String descr) {
        Category c = new Category();
        c.setId(-1);
        c.setName(name);
        c.setDescr(descr);
        c.setPid(0);
        c.setLeaf(true);
        c.setGrade(1);
        CategoryDAO.save(c);
        //add(c);
    }

2.DAO层：

public static void save(Category c) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            conn = DB.getConn();
            String sql = "";
            if(c.getId() == -1) {
                sql = "insert into category values (null, ?, ?, ?, ?, ?)";
            } else {
                sql = "insert into category values (" + c.getId() + ", ?, ?, ?, ?, ?)";
            }
            pstmt = DB.prepareStmt(conn, sql);
            pstmt.setInt(1, c.getPid());
            pstmt.setString(2, c.getName());
            pstmt.setString(3, c.getDescr());
            pstmt.setInt(4,c.isLeaf() ? 0 : 1); 
            pstmt.setInt(5, c.getGrade());
            pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            DB.close(pstmt);
            DB.close(conn);
        }
    }

3.JSP层：

String action = request.getParameter("action");
if(action != null && action.equals("add")){
    String name = request.getParameter("name");
    String descr = request.getParameter("descr");
    Category.addTopCategroy(name, descr);
    out.println("OK");
    }