大海无量的博客

ZSJC1 和ZSJC2 是一对多关系 @Data @TableName("zsj_c1") public class ZSJC1 { private int id; private String name; @TableField(exist = false) private List<ZSJC2> zsjc2s; } @Data @TableName("zsj_c2") public class ZSJC2 { private int id;.

sql: SELECT DATE_FORMAT(create_time,'%Y%m') months FROM studentGROUP BY months mapper中： List<String> hasmonths(); xml中： <select id="hasmonths" resultType="java.lang.String"> ...

List<Test> selectById(List<Integer> id); <select id="selectById" parameterType="java.util.List" resultMap="BaseResultMap"> select * from test where status = 'A' a...

参考：https://www.cnblogs.com/AlienXu/p/9436829.html https://www.cnblogs.com/xiaostudy/p/10079502.html @echo off set yy=%date:~,4% set mm=%date:~5,2% set dd=%date:~8,2% if /i %time:~0,2% lss 10 set ...

预订会议，有开始时间startTime,结束时间endTime;实体类字段对应类型Date 数据库中对应开始时间和结束时间：start_time,end_time对应类型datetime 先查询要预定的时间startTime，endTime在数据库中是否包含和含有，如果包含或者含有，说明不能预订。不满足图片中四种no情况，满足两种yes情况，说明可以预订 SELECT count(*)...

转载：https://blog.csdn.net/qq_41942909/article/details/80749766

转载：https://blog.csdn.net/c_henjinxing521/article/details/51788963 select MAX(CAST(userNo as SIGNED INTEGER))from userInfo ; 或者 select MAX(CAST(userNo as UNSIGNED INTEGER))from userInfo ; ————var...

参考：https://blog.csdn.net/danuo2011/article/details/79939385

参考：https://blog.csdn.net/u012538675/article/details/80819952

参考链接：https://blog.csdn.net/zhaozao5757/article/details/79183757 插入数据库时报： Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (6122 &gt; 1024). You can change this value on...

创建数据库时，选择utf-8.创建表也选择utf-8.。修改my.ini文件，在[mysqld]下面加上character-set-server=utf8 collation-server=utf8_general_ci关掉mysql,再重启。参考：https://www.cnblogs.com/hello-daocaoren/p/7846990.html...