HashTable實(shí)例 public class HashTable_msg { public HashTable_msg() { String sum_sql="select mobilenum,count(*) from SJSJ_Msg where (left(in_date,6)=(select left(CONVERT(varchar(12) , getdate(), 112 ),6)))group by mobilenum" Hashtable<String,Integer> ht = new Hashtable<String,Integer>() try{ ResultSet rs= DBAccess.getInstance().select(sum_sql) while(rs!=null) { ht.put(rs.getString(1),rs.getInt(2)) rs.next() } } catch (Exception e) { Logs.printError(e) } } }
標(biāo)簽: HashTable_msg public HashTable sum_sql
上傳時(shí)間: 2014-12-07
上傳用戶:a6697238
public class guestbook{ String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver" String sConnStr = "jdbc:odbc:guestbook" Connection conn = null ResultSet rs = null
標(biāo)簽: String JdbcOdbcDriver guestbook sDBDriver
上傳時(shí)間: 2017-05-23
上傳用戶:qiaoyue
TMS2407開發(fā)平臺(tái)鍵盤LED試驗(yàn),鍵盤輸入0,1,2,3,4,5,6,7,8,9,a,b,c,d,e,f,LED輸出0,1,2,3,4,5,6,7,8,9,-,E,H,L,NULL
標(biāo)簽: 2407 TMS LED 開發(fā)平臺(tái)
上傳時(shí)間: 2017-05-30
上傳用戶:541657925
AddUser 功能 增加用戶 參數(shù) szServerName,主機(jī)名,如果為本機(jī)增加用戶,設(shè)置為NULL szUserName,用戶名 szPassword,密碼
標(biāo)簽: szServerName AddUser 用戶 參數(shù)
上傳時(shí)間: 2017-07-01
上傳用戶:wang0123456789
三: 針對(duì)帶表頭結(jié)點(diǎn)的單鏈表,試編寫下列函數(shù)。 (1) 定位函數(shù)Locate:在單鏈表中尋找第i個(gè)結(jié)點(diǎn)。若找到,則函數(shù)返回第i個(gè)結(jié)點(diǎn)的地址;若找不到,則函數(shù)返回NULL。 (2) 求最大值函數(shù)max:通過一趟遍歷在單鏈表中確定值最大的結(jié)點(diǎn)。 (3) 統(tǒng)計(jì)函數(shù)number:統(tǒng)計(jì)單鏈表中具有給定值x的所有元素。 (4) 建立函數(shù)create:根據(jù)一維數(shù)組a[n]建立一個(gè)單鏈表,使單鏈表中各元素的次序與a[n]中各元素的次序相同,要求該程序的時(shí)間復(fù)雜性為O(n)。 (5) 整理函數(shù)tidyup:在非遞減有序的單鏈表中刪除值相同的多余結(jié)點(diǎn)。
上傳時(shí)間: 2017-07-20
上傳用戶:CSUSheep
員工管理系統(tǒng) 在一個(gè)公司里員工之間都有工作上的聯(lián)系。對(duì)方的聯(lián)系方式,部門這些資料的獲取;或是上級(jí)對(duì)員工資料的更改,工資的調(diào)整,員工對(duì)資料的查看,修改。 5.1.1 功能描述 1:管理員能對(duì)員工資料進(jìn)行添加,刪除,修改操作。普通用戶不能進(jìn)行添加或刪除操作 2:界面要求使用簡便,操作簡單 3:信息要做到保密,不同權(quán)限的用戶操作不同,看到的信息也不一樣 4:對(duì)不同的工資段進(jìn)行高亮標(biāo)記 §5.2 設(shè)計(jì)思想 根據(jù)不同用戶的行為來實(shí)現(xiàn)不同的操作 §5.2.1 系統(tǒng)構(gòu)思 不同用戶返回不同的操作,具有不同的權(quán)限 §5.2.2 關(guān)鍵技術(shù)與算法 修改界面與表格的同步更新,直接雙擊表格修改數(shù)據(jù) §5.2.3關(guān)鍵數(shù)據(jù)結(jié)構(gòu) 以下是員工的數(shù)據(jù) workerID int IDENTITY(1,1) , name varchar (20) NULL, sex varchar (10) NULL, age int NULL, position varchar (20) NULL, cellphone varchar (20) NULL, salary int NULL, userl varchar (20) NOT NULL, userp varchar (20) NOT NULL, classify int NOT NULL
標(biāo)簽: 管理系統(tǒng) 方式
上傳時(shí)間: 2017-08-25
上傳用戶:三人用菜
說明: column_list列出要添加數(shù)據(jù)的列名。在給表或視圖中部分列添加數(shù)據(jù)時(shí),必須使用該選項(xiàng)說明這部分列名。 DEFAULT VALUES說明向表中所有列插入其缺省值。對(duì)于具有INDENTITY屬性或timestamp數(shù)據(jù)類型的列,系統(tǒng)將自動(dòng)插入下一個(gè)適當(dāng)值。對(duì)于沒有設(shè)置缺省值的列,根據(jù)它們是否允許空值,將插入null或返回一錯(cuò)誤信息。
標(biāo)簽: column_list 數(shù)據(jù) 分
上傳時(shí)間: 2017-08-29
上傳用戶:離殤
兩個(gè)鏈表的交集 #include<stdio.h> #include<stdlib.h> typedef struct Node{ int data; struct Node *next; }Node; void initpointer(struct Node *p){ p=NULL; } int printlist(struct Node* head){ int flag=1; head=head->next; /* 因?yàn)闃?biāo)記1的地方你用了頭結(jié)點(diǎn),所以第一個(gè)數(shù)據(jù)域無效,應(yīng)該從下一個(gè)頭元結(jié)點(diǎn)開始 */ if(head==NULL) printf("NULL\n"); else { while(head!=NULL) { if(flag==1) { printf("%d",head->data); flag=0; } else { printf(" %d",head->data); } head=head->next; } printf("\n"); } return 0; } struct Node *creatlist(struct Node *head) { int n; struct Node *p1=(struct Node *)malloc(sizeof(struct Node)); p1->next=NULL; while(scanf("%d",&n),n!=-1) { struct Node *pnode=(struct Node *)malloc(sizeof(struct Node)); pnode->next=NULL; pnode->data=n; if(head==NULL) head=pnode; p1->next=pnode; p1=pnode; } return head; } struct Node *Intersect(struct Node *head1, struct Node *head2) { struct Node *p1=head1,*p2=head2;/*我這里沒有用頭指針和頭結(jié)點(diǎn),這里是首元結(jié)點(diǎn)head1里面就是第一個(gè)數(shù)據(jù),一定要理解什么事頭指針, 頭結(jié)點(diǎn),和首元結(jié)點(diǎn) 具體你一定要看這個(gè)博客:http://blog.sina.com.cn/s/blog_71e7e6fb0101lipz.html*/ struct Node *head,*p,*q; head = (struct Node *)malloc(sizeof(struct Node)); head->next = NULL; p = head; while( (p1!=NULL)&&(p2!=NULL) ) { if (p1->data == p2->data) { q = (struct Node *)malloc(sizeof(struct Node)); q->data = p1->data; q->next = NULL; p->next = q;//我可以認(rèn)為你這里用了頭結(jié)點(diǎn),也就是說第一個(gè)數(shù)據(jù)域無效 **標(biāo)記1** p = q; p1 = p1->next; p2 = p2->next; } else if (p1->data < p2->data) { p1 = p1->next; } else { p2 = p2->next; } } return head; } int main() { struct Node *head=NULL,*headt=NULL,*t; //initpointer(head);//這里的函數(shù)相當(dāng)于head=NULL; // initpointer(headt);//上面已經(jīng)寫了headt=NULL那么這里可以不用調(diào)用這個(gè)函數(shù) head=creatlist(head); headt=creatlist(headt); t=Intersect(head,headt); printlist(t); }
標(biāo)簽: c語言編程
上傳時(shí)間: 2015-04-27
上傳用戶:coco2017co
asp實(shí)現(xiàn)限制一個(gè)ip只能訪問一次的方法 <% '///////////////////////////////////////////////////// '// // '//作用:一個(gè)IP地址只允許訪問本頁一次 // '//引用:<!-- #include file="Check_Ip.asp" --> // '// // '///////////////////////////////////////////////////// 'Response.Charset = 936 '設(shè)置輸出編碼為簡體中文 'Response.Buffer = false '關(guān)閉緩沖區(qū) Dim Fso,ts,IpList,Cfs '設(shè)置Cookies函數(shù) Function SetCookie() Response.Cookies("IsBrow") = "Brow" Response.Cookies("IsBrow").Expires = Date+365 End Function '記錄IP地址函數(shù) Function WriteIp(FileName, IpAddress) Set Fso = Server.CreateObject("Scripting.FileSystemObject") Set ts = Fso.OpenTextFile(Server.MapPath(FileName),8,true) ts.WriteLine IpAddress ts.Close Set ts = Nothing Set Fso = Nothing End Function '讀取IP地址函數(shù) Function ReadIpList(FileName) Set Fso = Server.CreateObject("Scripting.FileSystemObject") If Not Fso.FileExists(Server.MapPath(FileName)) Then CreateFile("Iplist.txt") Exit Function End If Set ts = Fso.OpenTextFile(Server.MapPath(FileName)) Iplist = ts.ReadAll ts.Close Set ts = Nothing Set Fso = Nothing ReadIpList = Iplist End Function '創(chuàng)建文件函數(shù) Function CreateFile(FileName) Set Fso = Server.CreateObject("Scripting.FileSystemObject") Set Cfs = Fso.CreateTextFile(Server.MapPath(FileName)) Cfs.Close Set Cfs = Nothing Set Fso = Nothing End Function '關(guān)閉當(dāng)前IE窗口函數(shù)(注:IE6下通過,其他瀏覽器未測試) Function CloseWindow() 'Response.Write "<script>window.location='javascript:window.opener=null;window.close();'</script>" Response.Redirect "http://www.baidu.com" End Function Ip = Request.ServerVariables("REMOTE_ADDR") '獲取瀏覽者IP地址 Cookie = Request.Cookies("IsBrow") '獲取當(dāng)前Cookies 'Response.Write Cookie If Request.ServerVariables("HTTP_X_FORWARDED_FOR") <> "" Then Response.Write "本站不允許使用代理訪問" Response.End() Else If Cookie = "Brow" Then CloseWindow() Else If Instr(ReadIpList("Iplist.txt"),Ip) <>0 Then CloseWindow() Else WriteIp "Iplist.txt" , Ip End If SetCookie() End If End If %>
上傳時(shí)間: 2016-07-14
上傳用戶:helei0915
#include <malloc.h> #include <stdio.h> #include <stdlib.h> #include <string.h> #define NULL 0 #define MaxSize 30 typedef struct athletestruct /*運(yùn)動(dòng)員*/ { char name[20]; int score; /*分?jǐn)?shù)*/ int range; /**/ int item; /*項(xiàng)目*/ }ATH; typedef struct schoolstruct /*學(xué)校*/ { int count; /*編號(hào)*/ int serial; /**/ int menscore; /*男選手分?jǐn)?shù)*/ int womenscore; /*女選手分?jǐn)?shù)*/ 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輸入運(yùn)動(dòng)項(xiàng)目序號(hào) (x<=%d):",ntsp); scanf("%d",pafirst); overgame = *pafirst; if ( pafirst != phead ) { for ( pasecond = phead ; pasecond < pafirst ; pasecond ++ ) { if ( overgame == *pasecond ) { printf("\n這個(gè)項(xiàng)目已經(jīng)存在請(qǐng)選擇其他的數(shù)字\n"); goto Is_Game_DoMain; } } } pafirst = pafirst + 1; if ( overgame > ntsp ) { printf("\n項(xiàng)目不存在"); printf("\n請(qǐng)重新輸入"); 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輸入序號(hào) of the NO.%d (0<x<=%d): ",i,nsc); scanf("%d",&serial); if ( serial > nsc ) { printf("\n超過學(xué)校數(shù)目,請(qǐng)重新輸入"); 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繼續(xù)輸入運(yùn)動(dòng)項(xiàng)目(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號(hào)學(xué)校的結(jié)果成績:",pfirst->serial); printf("\n\n項(xiàng)目的數(shù)目\t學(xué)校的名字\t分?jǐn)?shù)"); 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按任意建 進(jìn)入下一頁"); getchar(); pfirst = pfirst->next; } // clrscr(); printf("\n運(yùn)動(dòng)會(huì)結(jié)果:\n\n學(xué)校編號(hào)\t男運(yùn)動(dòng)員成績\t女運(yùn)動(dòng)員成績\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按任意建結(jié)束"); 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("文件已經(jīng)成功保存\n"); } void main() { system("cls"); printf("\n\t\t\t 運(yùn)動(dòng)會(huì)分?jǐn)?shù)統(tǒng)計(jì)\n"); printf("輸入學(xué)校數(shù)目 (x>= 5):"); scanf("%d",&nsc); printf("輸入男選手的項(xiàng)目(x<=20):"); scanf("%d",&msp); printf("輸入女選手項(xiàng)目(<=20):"); scanf("%d",&wsp); ntsp = msp + wsp; phead = (int *)calloc(ntsp,sizeof(int)); pafirst = phead; pasecond = phead; input(); calculate(); output(); Save(); }
標(biāo)簽: 源代碼
上傳時(shí)間: 2016-12-28
上傳用戶:150501
蟲蟲下載站版權(quán)所有 京ICP備2021023401號(hào)-1