搜索到
304
篇与
的结果
-
-
C Quartz 任务调度 要实现任务调度的类继承父类 /// <summary> /// 任务调度基类 /// </summary> [DisallowConcurrentExecution()] public abstract class JobBase : IJob { #region IJob 成员 public Task Execute(IJobExecutionContext context) { try { ExcuteJob(context); return Task.CompletedTask; ; } catch (Exception ex) { throw ex; } } #endregion /// <summary> /// 执行计划，子类可以重写 /// </summary> public virtual string Cron => 0/1 * * * * ?; /// <summary> /// Job具体类去实现自己的逻辑 /// </summary> protected abstract void ExcuteJob(IJobExecutionContext context); } 任务调度工具类 public class QuartzManager { public static Action<Type> JoinToQuartz = (type) => { StdSchedulerFactory.GetDefaultScheduler().Result.Start(); var obj = Activator.CreateInstance(type); string cron = type.GetProperty(Cron).GetValue(obj).ToString(); var jobDetail = JobBuilder.Create(type) .WithIdentity(type.Name) .Build(); var jobTrigger = TriggerBuilder.Create() .WithIdentity(type.Name + Trigger) .StartNow() .WithCronSchedule(cron) .Build(); StdSchedulerFactory.GetDefaultScheduler().Result.ScheduleJob(jobDetail, jobTrigger); }; }
-
MybatisPlus 分页插件 配置 //Spring boot方式 @Configuration @MapperScan("com.baomidou.cloud.service.*.mapper*") public class MybatisPlusConfig { // 旧版 @Bean public PaginationInterceptor paginationInterceptor() { return new PaginationInterceptor(); } // 最新版 @Bean public MybatisPlusInterceptor mybatisPlusInterceptor() { MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor(); interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2)); return interceptor; } } 使用
-
QueryWrapper 常用方法 AbstractWrapper 下的方法及使用 方法名 说明 使用 allEq(Map<R, V> params) 全部 =(或个别 isNull) allEq(params,true) eq = eq("real_name”,"王昭君”) ne <> ne("nick_name”,"空想 4”) gt > gt("age”,21) ge >= ge("age”,22) lt < lt("age”,22) le <= le("age”,21") between cloum between ? and ? between("age”,0,21) notBetween cloum between ? and ? notBetween("age”,0,21) like cloum like '% 王 %’ like("real_name”,"王”) notLike not like '% 王 %’ notLike("real_name”,"王”) likeLeft like '% 王’ likeLeft("real_name”,"昭”) likeRight like '王 %’ likeRight("real_name”,"昭”) isNull is null isNull("gender”) isNotNull is not null isNotNull("gender”) in in (1,2,3) in("nick_name”,lists) notIn age not in (1,2,3) notIn("nick_name”,lists) inSql age in (1,2,3,4,5,6) inSql("nick_name”,"'空想 4’,'空想 5’,'空想 6’") notInSql age not in (1,2,3,4,5,6) notInSql("nick_name”,"'空想 4’,'空想 5’,'空想 6’") groupBy group by id,name groupBy("nick_name”,"age”) orderByAsc order by id ASC,name ASC orderByAsc("nick_name”,"age”) orderByDesc order by id DESC,name DESC orderByDesc("age”) orderBy order by id ASC,name ASC orderBy(true,true,"age”) having having sum(age) > 10 having("sum(age) > 10”) or id = 1 or name = '老王’ eq("nick_name”,"空想 4”).or(i->i.eq("age”,21) eq("nick_name”,"空想 4”).or().eq("nick_name”,"空想 5”) and and (name = '李白’ and status <> '活着’) and(i->i.eq("age”,21)) nested (name = '李白’ and status <> '活着’) nested(i->i.eq("age”,21).eq("nick_name”,"空想 4”)) apply id = 1 apply("nick_name = '空想 4’”) last 最后添加多个以最后的为准，有 sql 注入风险 last("limit 1”) exists 拼接 EXISTS (sql 语句) exists("select id from table where age = 1”) notExists 拼接 NOT EXISTS (sql 语句) notExists("select id from table where age = 1”)
-
