Python int类型插入数据库 MySQLdb

<p>def test2():<br>32 db = util.DBUnit('mysql_ab') <br>33 params = [[8000080,'8000080','8000080','8000080',8000080]]<br>34 params1 = [['aaaaa','bbbbb']]<br>35 sqls ='''insert into TESTLOG(CASE_ID,TESTTASK_ID,SYNOPSIS,TESTSCENE_ID,PROJECT_ID) values (%s,%s,%s,%s,%s)'''<br>36 sqls1 ='''insert into LogParam(ParamName,ParamAlias) values (%s,%s)'''<br>37 <br>38 n = db.write(sql=sqls,param=params)<br>39 print str(n)</p>
<p></p>
<p>原来int性也是用%s,我用%d搞了半天</p>
<p>write函数源代码</p>
<p> def write(self,sql,param,iscommit=True):<br>153 # animal_categories = [['snake', 'reptile'],<br>154 # ['frog', 'amphibian'],<br>155 # ['tuna', 'fish'],<br>156 # ['racoon', 'mammal']]<br>157 # cursor.executemany('''insert into animal (name, category)<br>158 # values (%s, %s)''', animal_categories)<br>159 # '''sql="insert into cdinfo values(%s,%s,%s,%s,%s)" <br>160 # param should be tuple or list <br>161 # param=((title,singer,imgurl,url,alpha))<br>162 # return update row num<br>163 # can exec update or delete opation<br>164 # batch insert or update ,param like this:<br>165 # param=((title,singer,imgurl,url,alpha),(title2,singer2,imgurl2,url2,alpha2))<br>166 # '''<br>167 try:<br>168 cursor = self.connection.cursor()<br>169 n = cursor.executemany(sql,param)<br>170 # raise<br>171 # print n<br>172 if iscommit :<br>173 self.connection.commit()<br>174 return n<br>175 except:<br>176 print 'Write MysqlDB Error!'<br>177 self.connection.rollback()<br>178 return -1</p>