Day2-T3

原题目

  Describe:质数问题

  code:

#pragma GCC optimize(2)
#include<bits/stdc++.h>
#define KKK 1200
using namespace std;
int lasts,n,m,prime[10015],tot,ans;
int maxn,sum[KKK],f[KKK][20];
bool b[KKK];
inline void work(int x){
    for(int i=1;i<=tot&&prime[i]<=sqrt(x);i++)
    if(x%prime[i]==0)return;prime[++tot]=x;b[x]=1;
}
inline int read(){
    int ret=0,f=1;char ch=getchar();
    while (ch<'0'||ch>'9') {if (ch=='-') f=-f;ch=getchar();}
    while (ch>='0'&&ch<='9') ret=ret*10+ch-'0',ch=getchar();
    return ret*f;
}
inline void write(int x){
    if(x<0){putchar('-');write(-x);return;}
    if(x/10) write(x/10);
    putchar(x%10+'0');
}
int main(){
//    freopen("sum.out","w",stdout);
    prime[++tot]=2;f[0][0]=1;
    for(register int i=4;i<=KKK;i+=2)b[i]=1;
    for(register int i=3;i<=KKK;i+=2)work(i);                                                 //打表质数
    
    for(register int i=1;i<=tot;i++){                                                         
        for(register int j=1200;j>=prime[i];j--){
            for(register int k=15;k>=1;k--){
                f[j][k]+=f[j-prime[i]][k-1];                                                  //从上一个质数跳转
            }
        }
    }
    n=read(),m=read();
    while(n&&m){
        write(f[n][m]);
        puts("");
        n=read(),m=read();
    }
    return 0;
}

 

  

 

转载于:https://www.cnblogs.com/sroht/p/9885097.html

SET @sql = NULL; SELECT JSON_ARRAYAGG( CONCAT(&#39;MAX(CASE WHEN td.person_name = &#39;&#39;&#39;, person_name, &#39;&#39;&#39; THEN td.work_time ELSE NULL END) AS &#39;&#39;&#39;, person_name, &#39;&#39;&#39;&#39;) ) INTO @sql FROM ( SELECT DISTINCT t2.person_name FROM task1 t1 INNER JOIN t_ps_person_work_time t2 ON t1.id = t2.task_id WHERE t2.work_day BETWEEN &#39;2025-06-26&#39; AND &#39;2025-07-25&#39; AND t2.status = 0 ) t; -- 更精确地移除JSON数组格式 SET @sql = TRIM(BOTH &#39;[""]&#39; FROM @sql); SET @sql = REPLACE(@sql, &#39;","&#39;, &#39;", "&#39;); -- 可选,如果需要处理中间部分 -- 或者更简单的方式(如果只有两个元素): SET @sql = REPLACE(REPLACE(@sql, &#39;"&#39;, &#39;&#39;), &#39;,&#39;, &#39;, &#39;); SET @sql = REPLACE(@sql, &#39;[&#39;, &#39;&#39;); SET @sql = REPLACE(@sql, &#39;]&#39;, &#39;&#39;); WITH task_data AS ( -- 获取任务和人员工时数据 SELECT t3.task_num , t3.project_name , (SELECT dict_label FROM `js_sys_dict_data` WHERE dict_type = &#39;sys_project_type&#39; AND dict_value = t3.project_type) project_type, t1.duty_person person_name, ROUND(SUM(t2.work_time), 1) work_time, t2.work_day workDay FROM project t3 INNER JOIN task1 t1 ON t3.id = t1.project_id INNER JOIN ( SELECT person_name, task_id, work_time, DATE_FORMAT(work_day, &#39;%Y-%m&#39;) work_day FROM t_ps_person_work_time WHERE work_day BETWEEN &#39;2025-06-26&#39; AND &#39;2025-07-25&#39; AND `status` = 0 ORDER BY work_day ) t2 ON t1.id = t2.task_id WHERE t3.status = 0 AND t1.status = 0 GROUP BY t3.id,t1.person_code ORDER BY t3.task_num ) -- 动态透视表查询 SET @sql = CONCAT(&#39;SELECT td.task_num AS "任务书号", td.project_name AS "项目名称", td.project_type AS "项目类型", ROUND(SUM(td.work_time), 1) AS "项目工时", &#39;, @sql, &#39; FROM task_data td GROUP BY td.task_num ORDER BY td.task_num&#39;); -- 现在,@sql中存储了动态生成的SQL字符串 -- 使用预处理语句执行 PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; 我这样修改,> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#39;SET @sql = CONCAT(&#39;SELECT td.task_num AS "任务书号", td.project_name A&#39; at line 29出现这个错误
08-09
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值