python str int_Python不能连接'str'和'int'对象

我正在尝试将XMLfile解析为mysqldb。

这是xml

Woman

T-Shirts

shorts

.py年for category in categories:

for item in category.getElementsByTagName("category"):

category_name = item.childNodes[0].nodeValue.encode("utf-8")

category_id = int(item.getAttribute('id'))

category_parentId = item.getAttribute('parentId')

#connect etc

sqlFillCategories = "INSERT INTO categories(category_id, category_parentId, shop_id, category_name) VALUES ('"+category_id + "', '" + category_parentId + "', '" + TREND_BRANDS_SHOPID + "', '" + category_name + "');"

错误：Traceback (most recent call last):

File "E:/python1/fanswell/parse.py", line 23, in

sqlFillCategories = "INSERT INTO categories(category_id, category_parentId, shop_id, category_name) VALUES ('"+category_id + "', '" + category_parentId + "', '" + TREND_BRANDS_SHOPID + "', '" + category_name + "');"

TypeError: cannot concatenate 'str' and 'int' objects

为什么会这样？怎么了？