³£ÓÃSQLÓï¾ä[ÒÔµ³Ô±¹ÜÀíϵͳΪÀý]
µ³Ô±¹ÜÀíϵͳµÄÊý¾Ý¿âÉè¼Æ
ÐèÒªÒÔÏÂ×ֶΣº
l ѧÉú£º
//ѧÉú»ù±¾ÐÅÏ¢
u ѧÉúѧºÅ[id]£¨char£©Ö÷¼ü
u ѧÉúÉí·ÝÖ¤ºÅ[id_num]£¨char£©
u ѧÉúÐÕÃû[name]£¨char£©
u ѧÉú³öÉúÈÕÆÚ[born_date]£¨date£©
u ѧÉú¼®¹á[native]£¨int£©Íâ¼ü
u ѧÉú¼Òͥסַ[address]£¨char£©
u ѧÉú¼ÒÍ¥Óʱà[home_zip]£¨char£©
u ѧÉúÐÔ±ð[sex]£¨bit£©
u ѧÉúÕþÖÎÃæÃ²[polity]£¨int£©Íâ¼ü
u ѧÉúËùÊôѧԺ[school]£¨int£©Íâ¼ü
u ѧÉúËùÊô°à¼¶[class]£¨int£©Íâ¼ü
u ѧÉúËùÊôµ³Ö§²¿[party]£¨int£©Íâ¼ü
u ѧÉúÊÖ»úºÅÂë[mobilephone]£¨char£©
u ѧÉúÊÖ»úºÅÂë[telephone]£¨char£©
u ѧÉúÃñ×å[nation]£¨int£©
//ÅàÑøÈË
u ÅàÑøÈË1[foster_one]£¨char£©
u ÅàÑøÈË2[foster_two]£¨char£©
//¸÷½×¶Îʱ¼ä
u µÝ½»Èëµ³ÉêÇëÊéʱ¼ä[hand_date]£¨date£©
u È·¶¨Îª»ý¼«·Ö×Óʱ¼ä[sure_date] £¨date£©
u ³ÉΪԤ±¸µ³Ô±Ê±¼ä[pre_date] £¨date£©
u תΪÕýʽµ³Ô±Ê±¼ä[official_date] £¨date£©
//Èëµ³²ÄÁÏÏà¹ØÐÅÏ¢
u Èëµ³ÉêÇëÊé[application]£¨bit£©
u Èëµ³»ý¼«·Ö×Ó¿¼²ìµÇ¼Ç±í[review]£¨bit£©
u ×Ô´«[memoir]£¨bit£©
u ˼Ïë»ã±¨·ÝÊý[reports]£¨int£©
u ÕþÉó²ÄÁÏ[political]£¨bit£©
u Õ÷Çóµ³ÍâȺÖÚÊéÃæÒâ¼û[idea]£¨bit£©
u µ³Ð£Åàѵ²ÄÁÏ[train]£¨bit£©
u ÍÆÓÅÈëµ³²ÄÁÏ[commend]£¨bit£©
//ѧÉú¸¸Ä¸Ïà¹ØÐÅÏ¢
u ¸¸Ç×ÐÕÃû[father_name]£¨char£©
u ¸¸Ç׵绰[father_tel]£¨char£©
u ¸¸Ç×µ³Ö§²¿Ãû³Æ[father_party]£¨char£©
u ¸¸Ç×µ³Ö§²¿Óʱà[father_zip]£¨char£©
u ĸÇ×ÐÕÃû[mother_name]£¨char£©
u ĸÇ׵绰[mother_tel]£¨char£©
u ĸÇ×µ³Ö§²¿Ãû³Æ[mother_party]£¨char£©
u ĸÇ×µ³Ö§²¿Óʱà[mother_zip]£¨char£©
l µ³Ö§²¿£º
u µ³Ö§²¿±àºÅ[party_id]£¨int£©
u µ³Ö§²¿Ãû³Æ[party_name]£¨char£©
u µ³Ö§²¿ËùÊôѧԺ[party_school]£¨int£©Íâ¼ü
u µ³Ö§²¿¹«¸æ[inform]£¨char£©
u µ³Ö§²¿Êé¼Ç[secretary ]£¨char£©Íâ¼ü
u µ³Ö§²¿Ðû´«Î¯Ô±[propaganda]£¨char£©Íâ¼ü
u µ³Ö§²¿×é֯ίԱ[organization]£¨char£©Íâ¼ü
l ÕþÖÎÃæÃ²£º
u ÕþÖÎÃæÃ²±àºÅ[polity
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
ÏîÄ¿ÖÐÐèÒª¸ù¾Ý¿Î¼þÃû³Æ°´ÔÂͳ¼Æ³ö·ÃÎʵÄÇé¿ö£¬µÚÒ»´ÎÎÒ²ÉÓÃÁË×îÍÁµÄÒ»ÖÖ°ì·¨£¬Ê¹ÓÃÑ»·£¬¸øsql´«µÝÄêÔÂÁ½¸ö²ÎÊý£¬
for(var y=2009;y<=2010;y++){
for(var m=1;m<=12;m++){
// todo : SQL ²éѯ
}
}
ÕâÑù£¬Í³¼Æ2 ......
ʹÓà TRUNCATE TABLE ɾ³ýËùÓÐÐÐ
ÈôҪɾ³ý±íÖеÄËùÓÐÐУ¬Ôò TRUNCATE TABLE Óï¾äÊÇÒ»ÖÖ¿ìËÙ¡¢ÓÐЧµÄ·½·¨¡£TRUNCATE TABLE Óë²»º¬ WHERE ×Ó¾äµÄ DELETE Óï¾äÀàËÆ¡£µ«ÊÇ£¬TRUNCATE TABLE Ëٶȸü¿ì£¬²¢ÇÒʹÓøüÉÙµÄϵͳ×ÊÔ´ºÍÊÂÎñÈÕÖ¾×ÊÔ´¡£
Óë DELETE Óï¾äÏàͬ£¬Ê¹Óà TRUNCATE TABLE Çå¿ÕµÄ±íµÄ¶¨ÒåÓëÆäË÷ÒýºÍÆäËû¹ØÁª¶ÔÏóÒ ......