qq_43121524的博客

URL连接(需要抛出异常)：Document document = Jsoup.connect("url").timeout(10 * 1000).get();select查找元素：查找id.select("#id")查找class.select(".class")获取文章.select.html()获取文本.select.text()获取href.attr("href")获取script标签.getElementsByTag("script")去除空格TextUtils.removeWhi

删除重复数据，保留最小delete from 表名 where 主键（id） not in ( select t.min_id from ( select min(id) as min_id from 表名 group by 重复数值的列名 ) as t );根据a表数据删除b表的数据delete from a where exists (select 'X' from b where a.bm=b.bm and a.mc=b.mc);空白列自动递增SELECT @rowNO