最近在做下载m3u8视频下载方面,发现往Sqlite中插入下载记录后,下载进度始终为0,通过Log分析发现往Sqlite中插入视频名称中存在英文单引号,解决办法是把英文单引号转换成中文单引号,希望给遇到同样问题的朋友一些帮助。
一:使用ORMLite单引号处理方法
1、问题描述:
E/SQLiteLog(13416):<strong> <span style="color:#ff0000;">(1) near "s": syntax error</span></strong>
E/SQLiteLog(13416): (257) Record real error code: 1
E/SQLiteLog(13416): (257) Record real error code: 1
W/System.err(13416): java.sql.SQLException: Problems executing runUpdate Android statement: UPDATE `t_m3u8_download_list` SET `<strong><span style="color:#ff0000;">movie_name` = 'It's Yo'</span></strong> ,`total_duration` = 296 ,`total_size` = 0 ,`downloaded_duration` = 296 ,`download_state` = 'DONE' ,`movie_name` = 'It's Yo' WHERE `