第十一周—1.点类定义

/*
* 程序的版权和版本声明部分
* Copyright (c)2012, 烟台大学计算机学院学生
* All rightsreserved.
* 文件名称: fun.cpp
* 作 者:谷志恒
* 完成日期:2013 年5月20日
* 版本号: v1.0
* 对任务及求解方法的描述部分:略
* 输入描述:略
* 问题描述:略
* 程序输出:如下
*/
#include<iostream>
#include<Cmath>
using namespace std;
class Point //定义坐标点类
{
public:
    Point():x(0),y(0) {};
    Point(double x0, double y0):x(x0), y(y0) {};
    void PrintPoint(); //输出点的信息
    double x,y;   //数据成员,表示点的横坐标和纵坐标
};
void Point::PrintPoint()
{
    cout<<"Point:("<<x<<","<<y<<")";    //输出点
}

class Line: public Point   //利用坐标点类定义直线类, 其基类的数据成员表示直线的中点
{
public:
    Line(Point pts, Point pte):pts(pts),pte(pte){}   ;  //构造函数,初始化直线的两个端点及由基类数据成员描述的中点
    double Length();    //计算并返回直线的长度
    void PrintLine();   //输出直线的两个端点和直线长度
private:
    class Point pts,pte;   //直线的两个端点
};
//下面定义Line类的成员函数
double Line::Length()
{
    double l;
    l=sqrt((pts.x-pte.x)*(pts.x-pte.x)+(pts.y-pte.y)*(pts.y-pte.y));
    return l;
}
void Line::PrintLine()
{
    cout<<"直线长度为:"<<Length()<<endl;
    cout<<"直线中点为:"<<"("<<(pts.x+pte.x)/2<<","<<(pts.y+pte.y)/2<<")"<<endl;
}
int main()
{
    Point ps(-2,5),pe(7,9);
    Line l(ps,pe);
    ps.PrintPoint();
    cout<<endl;
    pe.PrintPoint();
    cout<<endl;
    l.PrintLine();//输出直线l的信息(请补全代码)
    void PrintPoint();//输出直线l中点的信息(请补全代码)
    return 0;
}


运行程序;

心得体会;啊啊!那么多天没编程序都忘了!

declare v_1 date := TO_DATE('20250301', 'YYYYMMDD'); v_start date; v_end date := trunc(sysdate); v_current date; v_sql varchar2(32767); begin v_start :=trunc(v_1); for i in 0..(v_end-v_start) loop v_current := v_start+i; v_sql := 'merge into PURE_BORROW dest using (with t1 as (SELECT a.*,CASE WHEN a.COUNTRY_CODE = ''tz'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ke'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ci'' THEN a.IN_FORCE_DATE WHEN a.COUNTRY_CODE = ''ph'' THEN a.IN_FORCE_DATE + 8 / 24 END AS NEW_DATE FROM LOAN_BORROW_INFO_TEST a WHERE a.COUNTRY_CODE <> ''gh'' AND a.RISK_SERIAL_NO <> ''googleplay'' AND a.ARCHIVED=1 and a.IN_FORCE_DATE is not null), t2 as (select distinct phone,country_code,NEW_DATE from t1 where TRUNC(NEW_DATE)=TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') and user_type_product=0), t3 as ( select t1.NEW_DATE,t1.phone from t2 left join t1 on t2.phone=t1.phone and t2.country_code=t1.country_code and t1.NEW_DATE>=t2.NEW_DATE and t1.new_date is not null), t4 as( select week_num,TRUNC(NEW_DATE)=TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') as pure_in_force_date,count(1) AS pure_borrow from( select week_num,row_number()over(partition by week_num,phone order by week_num) as rn from (SELECT phone, TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7)+1 AS week_num, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 AS week_start, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 + 6 AS week_end FROM t3 WHERE NEW_DATE BETWEEN TO_DATE("2025-03-01", "YYYY-MM-DD") AND TRUNC(ADD_MONTHS(SYSDATE, 12), "YYYY") - 1) ) where rn=1 GROUP BY week_num ORDER BY week_num) select * from t4 pivot(sum(pure_borrow) for week_num IN (1 AS "第一", 2 AS "第二", 3 AS "第三", 4 AS "第四", 5 AS "第五", 6 AS "第六", 7 AS "第七", 8 AS "第八", 9 AS "第九", 10 AS "第十", 11 AS "第十一", 12 AS "第十二", 13 AS "第十三", 14 AS "第十四", 15 AS "第十五", 16 AS "第十六", 17 AS "第十七", 18 AS "第十八", 19 AS "第十九", 20 AS "第二十", 21 AS "第二十一", 22 AS "第二十二", 23 AS "第二十三", 24 AS "第二十四", 25 AS "第二十五", 26 AS "第二十六", 27 AS "第二十七", 28 AS "第二十八", 29 AS "第二十九", 30 AS "第三十", 31 AS "第三十一", 32 AS "第三十二", 33 AS "第三十三", 34 AS "第三十四", 35 AS "第三十五", 36 AS "第三十六", 37 AS "第三十七", 38 AS "第三十八", 39 AS "第三十九", 40 AS "第四十", 41 AS "第四十一", 42 AS "第四十二", 43 AS "第四十三"))) src on ( dest.PURE_IN_FORCE_DATE= src.pure_in_force_date ) WHEN MATCHED THEN UPDATE SET dest."第一" = src."第一",dest."第二" = src."第二",dest."第三" = src."第三",dest."第四" = src."第四",dest."第五" = src."第五",dest."第六" = src."第六",dest."第七" = src."第七",dest."第八" = src."第八",dest."第九" = src."第九",dest."第十" = src."第十",dest."第十一" = src."第十一",dest."第十二" = src."第十二",dest."第十三" = src."第十三",dest."第十四" = src."第十四",dest."第十五" = src."第十五",dest."第十六" = src."第十六",dest."第十七" = src."第十七",dest."第十八" = src."第十八",dest."第十九" = src."第十九",dest."第二十" = src."第二十",dest."第二十一" = src."第二十一",dest."第二十二" = src."第二十二",dest."第二十三" = src."第二十三",dest."第二十四" = src."第二十四",dest."第二十五" = src."第二十五",dest."第二十六" = src."第二十六",dest."第二十七" = src."第二十七",dest."第二十八" = src."第二十八",dest."第二十九" = src."第二十九",dest."第三十" = src."第三十",dest."第三十一" = src."第三十一",dest."第三十二" = src."第三十二",dest."第三十三" = src."第三十三",dest."第三十四" = src."第三十四",dest."第三十五" = src."第三十五",dest."第三十六" = src."第三十六",dest."第三十七" = src."第三十七",dest."第三十八" = src."第三十八",dest."第三十九" = src."第三十九",dest."第四十" = src."第四十",dest."第四十一" = src."第四十一",dest."第四十二" = src."第四十二",dest."第四十三" = src."第四十三" WHEN NOT MATCHED THEN INSERT ( pure_in_force_date, "第一","第二","第三","第四","第五","第六","第七","第八","第九","第十","第十一","第十二","第十三","第十四","第十五","第十六","第十七","第十八","第十九","第二十","第二十一","第二十二","第二十三","第二十四","第二十五","第二十六","第二十七","第二十八","第二十九","第三十","第三十一","第三十二","第三十三","第三十四","第三十五","第三十六","第三十七","第三十八","第三十九","第四十","第四十一","第四十二","第四十三" ) VALUES ( src.pure_in_force_date, src."第一",src."第二",src."第三",src."第四",src."第五",src."第六",src."第七",src."第八",src."第九",src."第十",src."第十一",src."第十二",src."第十三",src."第十四",src."第十五",src."第十六",src."第十七",src."第十八",src."第十九",src."第二十",src."第二十一",src."第二十二",src."第二十三",src."第二十四",src."第二十五",src."第二十六",src."第二十七",src."第二十八",src."第二十九",src."第三十",src."第三十一",src."第三十二",src."第三十三",src."第三十四",src."第三十五",src."第三十六",src."第三十七",src."第三十八",src."第三十九",src."第四十",src."第四十一",src."第四十二",src."第四十三" )' ; EXECUTE IMMEDIATE v_sql; END LOOP; end;[42000][923] ORA-00923: 未找到要求的 FROM 关键字 ORA-06512: 在 line 69
最新发布
06-07
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值