1.idea生成类注释和方法注释的正确方法
https://blog.csdn.net/qq_34581118/article/details/78409782
2.spring boot 使用YML文件配置多环境
https://blog.csdn.net/yy756127197/article/details/78193398
3.关于springboot2.0.0配置多数据源出现jdbcUrl is required with driverClassName的错误
https://blog.csdn.net/newhanzhe/article/details/80763581
4.复制出一个新项目
- Rname(Shift+F6)
- 改变文件夹名字(右键项目名,show in Explorer)
- project structrue(Ctrl+Alt+Shift+S)
4.mybatis @Select 模糊查询
@Select("select team_name,team_id from team_info where team_name LIKE CONCAT('%',#{0},'%') ")
TeamInfo selectTeam_name(String team_name);
5.mybatis @Insert 批量插入
@Insert("<script> insert into player_info (name,avg_assist,avg_kill,join_battle_rat5089,kda,most_kill,openid,played,pos,rating,team_id,team_name) values " +
" <foreach collection='result' item='item' separator=',' > " +
" (#{item.name},#{item.avg_assist},#{item.avg_kill},#{item.join_battle_rat5089},#{item.kda},#{item.most_kill},#{item.openid},#{item.played},#{item.pos},#{item.rating},#{item.team_id},#{item.team_name})\n" +
" </foreach> </script>")
Boolean insertPlayerArray(@Param(value = "result") ArrayList<PlayerInfo> result);
6 怎样一次insert插入多条记录呢?
https://jingyan.baidu.com/article/36d6ed1f510dfd1bcf4883cb.html
常见的insert语句,向数据库中,一条语句只能插入一条数据:
insert into persons
(id_p, lastname , firstName, city )
values(204,'haha' , 'deng' , 'shenzhen');
(如上,仅插入了一条记录)
怎样一次insert插入多条记录呢?
使用示例:
insert into persons
(id_p, lastname , firstName, city )
values
(200,'haha' , 'deng' , 'shenzhen'),
(201,'haha2' , 'deng' , 'GD'),
(202,'haha3' , 'deng' , 'Beijing');
这样就批量插入数据了, 遵循这样的语法,就可以批量插入数据了。
执行成功,截图:
7 Mybatis注解式写批量更新
8 爬虫
https://blog.csdn.net/qq_39740187/article/details/78637397