最近在學習Oracle，對測試人員而言必須掌握兩種語言：第一種是DML，數據操縱語言 (Data Manipulation Language) 是SQL語言中，負責對數據庫對象運行數據訪問工作的指令集，以INSERT、UPDATE、DELETE三種指令為核心，分別代表插入、更新與刪除。第二種是：DQL，數據查詢語言 (Data Query Language) 是SQL語言中，負責進行數據查詢而不會對數據本身進行修改的語句，這是最基本的SQL語句。核心指令為SELECT，以及一些輔助指令，如FROM、WHERE等，FROM：表示來源，可以搭配JOIN做鏈接查詢； WHERE：過濾條件；GROUP BY：在使用聚合函數時用到，如SUM,COUNT,MAX,AVG；HAVING：對聚合結果進行篩選，這是和WHERE的不同點；ORDER BY：排序。
標簽： oracle 基礎 資料
上傳時間： 2016-09-15
上傳用戶：天涯云海
This example shows how to detect and COUNT cars in a video sequence using foreground detector based on Gaussian mixture models (GMMs)
標簽： Detecting Gaussian Mixture Models Using Cars
上傳時間： 2016-12-10
上傳用戶：Fgufsett
#include <malloc.h> #include <stdio.h> #include <stdlib.h> #include <string.h> #define NULL 0 #define MaxSize 30 typedef struct athletestruct /*運動員*/ { char name[20]; int score; /*分數*/ int range; /**/ int item; /*項目*/ }ATH; typedef struct schoolstruct /*學校*/ { int COUNT; /*編號*/ int serial; /**/ int menscore; /*男選手分數*/ int womenscore; /*女選手分數*/ int totalscore; /*總分*/ ATH athlete[MaxSize]; /**/ struct schoolstruct *next; }SCH; int nsc,msp,wsp; int ntsp; int i,j; int overgame; int serial,range; int n; SCH *head,*pfirst,*psecond; int *phead=NULL,*pafirst=NULL,*pasecond=NULL; void create(); void input () { char answer; head = (SCH *)malloc(sizeof(SCH)); /**/ head->next = NULL; pfirst = head; answer = 'y'; while ( answer == 'y' ) { Is_Game_DoMain: printf("\nGET Top 5 when odd\nGET Top 3 when even"); printf("\n輸入運動項目序號 (x<=%d):",ntsp); scanf("%d",pafirst); overgame = *pafirst; if ( pafirst != phead ) { for ( pasecond = phead ; pasecond < pafirst ; pasecond ++ ) { if ( overgame == *pasecond ) { printf("\n這個項目已經存在請選擇其他的數字\n"); goto Is_Game_DoMain; } } } pafirst = pafirst + 1; if ( overgame > ntsp ) { printf("\n項目不存在"); printf("\n請重新輸入"); goto Is_Game_DoMain; } switch ( overgame%2 ) { case 0: n = 3;break; case 1: n = 5;break; } for ( i = 1 ; i <= n ; i++ ) { Is_Serial_DoMain: printf("\n輸入序號 of the NO.%d (0<x<=%d): ",i,nsc); scanf("%d",&serial); if ( serial > nsc ) { printf("\n超過學校數目,請重新輸入"); goto Is_Serial_DoMain; } if ( head->next == NULL ) { create(); } psecond = head->next ; while ( psecond != NULL ) { if ( psecond->serial == serial ) { pfirst = psecond; pfirst->COUNT = pfirst->COUNT + 1; goto Store_Data; } else { psecond = psecond->next; } } create(); Store_Data: pfirst->athlete[pfirst->COUNT].item = overgame; pfirst->athlete[pfirst->COUNT].range = i; pfirst->serial = serial; printf("Input name:) : "); scanf("%s",pfirst->athlete[pfirst->COUNT].name); } printf("\n繼續輸入運動項目(y&n)？"); answer = getchar(); printf("\n"); } } void calculate() /**/ { pfirst = head->next; while ( pfirst->next != NULL ) { for (i=1;i<=pfirst->COUNT;i++) { if ( pfirst->athlete[i].item % 2 == 0 ) { switch (pfirst->athlete[i].range) { case 1:pfirst->athlete[i].score = 5;break; case 2:pfirst->athlete[i].score = 3;break; case 3:pfirst->athlete[i].score = 2;break; } } else { switch (pfirst->athlete[i].range) { case 1:pfirst->athlete[i].score = 7;break; case 2:pfirst->athlete[i].score = 5;break; case 3:pfirst->athlete[i].score = 3;break; case 4:pfirst->athlete[i].score = 2;break; case 5:pfirst->athlete[i].score = 1;break; } } if ( pfirst->athlete[i].item <=msp ) { pfirst->menscore = pfirst->menscore + pfirst->athlete[i].score; } else { pfirst->womenscore = pfirst->womenscore + pfirst->athlete[i].score; } } pfirst->totalscore = pfirst->menscore + pfirst->womenscore; pfirst = pfirst->next; } } void output() { pfirst = head->next; psecond = head->next; while ( pfirst->next != NULL ) { // clrscr(); printf("\n第%d號學校的結果成績:",pfirst->serial); printf("\n\n項目的數目\t學校的名字\t分數"); for (i=1;i<=ntsp;i++) { for (j=1;j<=pfirst->COUNT;j++) { if ( pfirst->athlete[j].item == i ) { printf("\n %d\t\t\t\t\t\t%s\n %d",i,pfirst->athlete[j].name,pfirst->athlete[j].score);break; } } } printf("\n\n\n\t\t\t\t\t\t按任意建 進入下一頁"); getchar(); pfirst = pfirst->next; } // clrscr(); printf("\n運動會結果:\n\n學校編號\t男運動員成績\t女運動員成績\t總分"); pfirst = head->next; while ( pfirst->next != NULL ) { printf("\n %d\t\t %d\t\t %d\t\t %d",pfirst->serial,pfirst->menscore,pfirst->womenscore,pfirst->totalscore); pfirst = pfirst->next; } printf("\n\n\n\t\t\t\t\t\t\t按任意建結束"); getchar(); } void create() { pfirst = (struct schoolstruct *)malloc(sizeof(struct schoolstruct)); pfirst->next = head->next ; head->next = pfirst ; pfirst->COUNT = 1; pfirst->menscore = 0; pfirst->womenscore = 0; pfirst->totalscore = 0; } void Save() {FILE *fp; if((fp = fopen("school.dat","wb"))==NULL) {printf("can't open school.dat\n"); fclose(fp); return; } fwrite(pfirst,sizeof(SCH),10,fp); fclose(fp); printf("文件已經成功保存\n"); } void main() { system("cls"); printf("\n\t\t\t 運動會分數統計\n"); printf("輸入學校數目 (x>= 5):"); scanf("%d",&nsc); printf("輸入男選手的項目(x<=20):"); scanf("%d",&msp); printf("輸入女選手項目(<=20):"); scanf("%d",&wsp); ntsp = msp + wsp; phead = (int *)calloc(ntsp,sizeof(int)); pafirst = phead; pasecond = phead; input(); calculate(); output(); Save(); }
標簽： 源代碼
上傳時間： 2016-12-28
上傳用戶：150501
題目：古典問題：有一對兔子，從出生后第3個月起每個月都生一對兔子，小兔子長到第三個月后每個月又生一對兔子，假如兔子都不死，問每個月的兔子總數為多少？ //這是一個菲波拉契數列問題 public class lianxi01 { public static void main(String[] args) { System.out.println("第1個月的兔子對數: 1"); System.out.println("第2個月的兔子對數: 1"); int f1 = 1, f2 = 1, f, M=24; for(int i=3; i<=M; i++) { f = f2; f2 = f1 + f2; f1 = f; System.out.println("第" + i +"個月的兔子對數: "+f2); } } } 【程序2】 題目：判斷101-200之間有多少個素數，并輸出所有素數。 程序分析：判斷素數的方法：用一個數分別去除2到sqrt(這個數)，如果能被整除， 則表明此數不是素數，反之是素數。 public class lianxi02 { public static void main(String[] args) { int COUNT = 0; for(int i=101; i<200; i+=2) { boolean b = false; for(int j=2; j<=Math.sqrt(i); j++) { if(i % j == 0) { b = false; break; } else { b = true; } } if(b == true) {COUNT ++;System.out.println(i );} } System.out.println( "素數個數是: " + COUNT); } } 【程序3】 題目：打印出所有的 "水仙花數 "，所謂 "水仙花數 "是指一個三位數，其各位數字立方和等于該數本身。例如：153是一個 "水仙花數 "，因為153=1的三次方＋5的三次方＋3的三次方。 public class lianxi03 { public static void main(String[] args) { int b1, b2, b3;
上傳時間： 2017-12-24
上傳用戶：Ariza
可用作字頻統計，詞頻分析，論文查重，支持中文分析
標簽： 詞頻統計
上傳時間： 2018-04-30
上傳用戶：Dear
#include<stdio.h> #define TREEMAX 100 typedef struct BT { char data; BT *lchild; BT *rchild; }BT; BT *CreateTree(); void Preorder(BT *T); void Postorder(BT *T); void Inorder(BT *T); void Leafnum(BT *T); void Nodenum(BT *T); int TreeDepth(BT *T); int COUNT=0; void main() { BT *T=NULL; char ch1,ch2,a; ch1='y'; while(ch1=='y'||ch1=='y') { printf("\n"); printf("\n\t\t 二叉樹子系統"); printf("\n\t\t*****************************************"); printf("\n\t\t 1---------建二叉樹 "); printf("\n\t\t 2---------先序遍歷 "); printf("\n\t\t 3---------中序遍歷 "); printf("\n\t\t 4---------后序遍歷 "); printf("\n\t\t 5---------求葉子數 "); printf("\n\t\t 6---------求結點數 "); printf("\n\t\t 7---------求樹深度 "); printf("\n\t\t 0---------返 回 "); printf("\n\t\t*****************************************"); printf("\n\t\t 請選擇菜單號 （0--7）"); scanf("%c",&ch2); getchar(); printf("\n"); switch(ch2) { case'1': printf("\n\t\t請按先序序列輸入二叉樹的結點:\n"); printf("\n\t\t說明：輸入結點（‘0’代表后繼結點為空）后按回車。\n"); printf("\n\t\t請輸入根結點:"); T=CreateTree(); printf("\n\t\t二叉樹成功建立！\n");break; case'2': printf("\n\t\t該二叉樹的先序遍歷序列為:"); Preorder(T);break; case'3': printf("\n\t\t該二叉樹的中序遍歷序列為:"); Inorder(T);break; case'4': printf("\n\t\t該二叉樹的后序遍歷序列為:"); Postorder(T);break; case'5': COUNT=0;Leafnum(T); printf("\n\t\t該二叉樹有%d個葉子。\n",COUNT);break; case'6': COUNT=0;Nodenum(T); printf("\n\t\t該二叉樹總共有%d個結點。\n",COUNT);break; case'7': printf("\n\t\t該樹的深度為:%d",TreeDepth(T)); break; case'0': ch1='n';break; default: printf("\n\t\t***請注意：輸入有誤！***"); } if(ch2!='0') { printf("\n\n\t\t按【Enter】鍵繼續，按任意鍵返回主菜單！\n"); a=getchar(); if(a!='\xA') { getchar(); ch1='n'; } } } } BT *CreateTree() { BT *t; char x; scanf("%c",&x); getchar(); if(x=='0') t=NULL; else { t=new BT; t->data=x; printf("\n\t\t請輸入%c結點的左子結點:",t->data); t->lchild=CreateTree(); printf("\n\t\t請輸入%c結點的右子結點:",t->data); t->rchild=CreateTree(); } return t; } void Preorder(BT *T) { if(T) { printf("%3c",T->data); Preorder(T->lchild); Preorder(T->rchild); } } void Inorder(BT *T) { if(T) { Inorder(T->lchild); printf("%3c",T->data); Inorder(T->rchild); } } void Postorder(BT *T) { if(T) { Postorder(T->lchild); Postorder(T->rchild); printf("%3c",T->data); } } void Leafnum(BT *T) { if(T) { if(T->lchild==NULL&&T->rchild==NULL) COUNT++; Leafnum(T->lchild); Leafnum(T->rchild); } } void Nodenum(BT *T) { if(T) { COUNT++; Nodenum(T->lchild); Nodenum(T->rchild); } } int TreeDepth(BT *T) { int ldep,rdep; if(T==NULL) return 0; else { ldep=TreeDepth(T->lchild); rdep=TreeDepth(T->rchild); if(ldep>rdep) return ldep+1; else return rdep+1; } }
上傳時間： 2020-06-11
上傳用戶：ccccy
全志A20核心板配套開發底板Cadence原理圖+ Pads2005格式PCB文件+轉換后的AD格式原理圖PCB文件：A20_DVK1_BASE_V16_Altium_Designer15.PcbDocA20_DVK1_BASE_V16_BOM_20151015.xlsxA20_DVK1_BASE_V16_Gerber制板文件.rarA20_DVK1_BASE_V16_PADS2005_PCB30.pcbA20_DVK1_BASE_V16_PADS2005_PCB_ASCII.PcbDocA20_DVK1_BASE_V16_PADS9.5.pcba20_dvk1_base_v16_SCH_20151015.pdfA20_DVK1_BASE_V16_元件位置查找圖_20151102.pdfA20_DVK1_BASE_V16_原理圖_OrCAD16.5.DSNA20_DVK1_BASE_V16_導出到AD格式的原理圖和PCBA20_DVK1_BASE_V16_導出到AD格式的原理圖和PCB.rarA20_DVK1_BASE_V16_頂層元件編號絲印圖_20151102.pdfA20_DVK1_BASE_V16_頂層元件規格絲印圖_20151102.pdf主要器件如下：Library Component COUNT : 58Name Description----------------------------------------------------------------------------------------------------ANTBATTERY_1BEAD CAPCAP NP 貼片電容,Y5V,6.3V,2.2uF,+80%-20%,0603CAP NP_2_Dup1 X5RCAP NP_Dup2 0402 1uF X5R 6.3V +/-10%CAP NP_Dup3 0402 1uF X5R 6.3V +/-10%CAPACITOR CAPACITOR POLCON1 CON12 CON3 CON4 CON50 CON6CON6A CONNECTOR45X4 C_Generic DB15-VGA_0 DIODE DIODE DUAL SERIESFM25CL64 FR9886SPGTR FUSEHOLDER_0 HDMI19_PLUG HEADER 2 INDUCTOR/SMINDUCTOR_4 C4K-2.5HINDUCTOR_Dup2 INDUCTOR_Dup3 IRM-2638LED_0M93C46_0 MINI USB-B_6 MODULE_CAM_PA0505 PH163539 PLAUSB-AF5P-WSMT_0 PUSHBUTTON_TSKB-2L_0PowerJACK R1 0805 R1_0805 RES2X4RESISTOR RESISTOR_Dup1 RESISTOR_Dup2 RESISTOR_V RJ45_8PGR_Generic S9013SMD_Dup2 SD_MMC_CARD2_0 TP_5 TestPoint_3TitleBlock_Gongjun USBPORT2 USB_WIFI_0 XC6204VZ_3 LDO 3.3V 300mA( SOT-25 )rRClamp0524P
上傳時間： 2021-11-08
上傳用戶：
全志A33核心板應用開發底板OrCAD16.5格式原理圖+PADS9.5格式PCB圖+轉AD格式的原理圖PCB文件,可以做你的學習設計參考，應用開發底板主要器件如下：Library Component COUNT : 180Name Description----------------------------------------------------------------------------------------------------1_0.5KE100A1_1.5KE100A1_2.5KE100A1_3.5KE100A1_4.5KE100A2N6770_0?_0 ACA-5036 ADV7123_0 ANTANT_0 ANT_1 ANT_2AP6493_0AP6493_1AP6493_2AT24C16 AT88SC0104CAW1625_CSI_eLQFP176_0R0603R1 0805R1 0805_Dup1R1_0805RESISTOR RESISTOR_0RESISTOR_V RT9266PE_0RT9266PE_1 RTL8152B_0 R_0 R_Dup1R_Dup2R_Dup3 R_GenericS9013SMDSD_MMC_CARD2_0 SEW290_0 SEW290_1 SIM_SOCKET_0 SWL-N10S_0SWL-N10S_1 SWPB2X1BSchottkyTC_SMD TP_5TestPoint_3TitleBlock0-AW TitleBlock_Gongjun U-CONN_0USBHOST_X2 USB_WIFI_0WPM4005_11bga280_3 capnp cappoleLQFP176_0 eLQFP176_6 eMMC-BGA169
上傳時間： 2021-11-13
上傳用戶：
74HC595 A4950 MAX3232 ULN2003AD STM32F207VCT6 AD集成封裝庫，原理圖庫器件型號列表：Library Component COUNT : 53Name Description----------------------------------------------------------------------------------------------------1N4148 High Conductance Fast Diode1N4448 High Conductance Fast Diode1N914 High Conductance Fast Diode1N914A High Conductance Fast Diode1N914B High Conductance Fast Diode1N916 High Conductance Fast Diode1N916A High Conductance Fast Diode1N916B High Conductance Fast Diode2N3904 NPN General Purpose Amplifier74ALS86 74HC595 8M貼片晶振 A4950 直流電機驅動AO4805CAP CapacitorCAP SMD CapacitorCON2 ConnectorCON2*10 ConnectorCON2*12P ConnectorCON2*7 ConnectorCON2*9 ConnectorCON3 ConnectorCON4 ConnectorCON5 ConnectorCON7 ConnectorCap Pol 極性電解電容DIODE DiodeFUSE1 FuseFUSE2 FuseINDUCTOR2 IRF7351PbF N-MOSJS1-12V-FLED MAX487 MAX809RD R0.125 Less than 1/4 Watt Power Resistor.RES2 RGRPI*4 Res1 ResistorSGM8955XN5G/TR 測量放大器SM712 SN74LV4052AD SP3232ESST25VF016B-50-4I-S2AFI2C Real-Time Clock.STM32F107VTC6 STM32F107VTC6SW DIP-4 編碼開關SW-PB SwitchTPS54302 45UA靜態電流 3ATVS SMBJ30CAULN2003 XC6214XTAL Crystal OscillatorPCB封裝庫列表：Component COUNT : 40Component Name-----------------------------------------------4G模塊-外置7D181K0603-LED0603C0603R0805C12061210181232255569-2*1P直針5569-2*2P直針AT-26CAP-D8DO-214AANHSOP-8J-SPDT-5JTAGL
上傳時間： 2021-11-15
上傳用戶：ttalli
基于NE555設計的聲音傳感器模塊ALTIUM硬件原理圖+PCB文件，2層板設計，大小為29x30mm，Altium Designer 設計的工程文件，包括原理圖及PCB文件，可以用Altium(AD)軟件打開或修改，可作為你的產品設計的參考。主要器件型號列表如下：Library Component COUNT : 8Name Description----------------------------------------------------------------------------------------------------2N3904 NPN General Purpose AmplifierCap CapacitorComponent_1_1 Header 3H Header, 3-Pin, Right AngleLED3 Typical BLUE SiC LEDMKF 麥克風Res 電阻Res2 Resistor
上傳時間： 2021-11-17
上傳用戶：
