QueryRunner类实现数据库的增删改查

QueryRunner类实现数据库的增删改查

添加数据

 @Override
    public int save(ProductCategory productCategory) {
        //初始化QueryRunner对象 封装了CRUD，快速实现增删改查
        QueryRunner queryRunner = new QueryRunner();

        try {
            int result = queryRunner.update(DBHelper.getConn(), "insert into tb_productCategory(name,remark) values(?,?)", productCategory.getName(), productCategory.getRemark());
            if (result > 0) {
                System.out.println("保存成功");
            } else {
                System.out.println("保存失败");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return 0;
    }

修改数据

@Override
    public int update(ProductCategory productCategory) {
        //初始化QueryRunner对象 封装了CRUD，快速实现增删改查
        QueryRunner queryRunner = new QueryRunner();

        try {
            int result = queryRunner.update(DBHelper.getConn(), "update tb_productCategory set name = ?,remark = ? where id = ?", productCategory.getName(), productCategory.getRemark(), productCategory.getId());
            if (result > 0) {
                System.out.println("修改成功");
            } else {
                System.out.println("修改失败");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return 0;
    }

删除数据

@Override
    public int delete(Integer id) {
        //初始化QueryRunner对象 封装了CRUD，快速实现增删改查
        QueryRunner queryRunner = new QueryRunner();

        try {
            int result = queryRunner.update(DBHelper.getConn(), "delete from tb_productCategory where id = ?", id);
            if (result > 0) {
                System.out.println("删除成功");
            } else {
                System.out.println("删除失败");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return 0;
    }

查询所有数据

@Override
    public List<ProductCategory> findAll() {
        //初始化QueryRunner对象 封装了CRUD，快速实现增删改查
        QueryRunner queryRunner = new QueryRunner();
        List<ProductCategory> productCategoryList = new ArrayList<ProductCategory>();
        try {
            productCategoryList = queryRunner.query(DBHelper.getConn(),"select * from tb_productCategory",new BeanListHandler<ProductCategory>(ProductCategory.class));
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return productCategoryList;
    }

通过id查询单条数据

@Override
    public ProductCategory proOne(Integer id) {
        //初始化QueryRunner对象 封装了CRUD，快速实现增删改查
        QueryRunner queryRunner = new QueryRunner();
        ProductCategory productCategory = new ProductCategory();
        try {
            productCategory= queryRunner.query(DBHelper.getConn(),"select * from tb_productCategory where id = ?",new BeanHandler<ProductCategory>(ProductCategory.class),id);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return productCategory;
    }