»ªÎªÃæÊÔÌâ»ã×Ü ÏÂÔØ±¾ÎÄ

ÁªºÏÌåunionµÄ´æ·Å˳ÐòÊÇËùÓгÉÔ±¶¼´ÓµÍµØÖ·¿ªÊ¼´æ·Å£¬ÃæÊÔÕߵĽâ´ðÀûÓøÃÌØÐÔ£¬ÇáËɵػñµÃÁËCPU¶ÔÄÚ´æ²ÉÓÃLittle-endian»¹ÊÇBig-endianģʽ¶Áд¡£Èç¹ûË­Äܵ±³¡¸ø³öÕâ¸ö½â´ð£¬ÄǼòÖ±¾ÍÊÇÒ»¸öÌì²ÅµÄ³ÌÐòÔ±¡£

ÊÔÌâ2£ºÐ´Ò»¸öº¯Êý·µ»Ø1+2+3+¡­+nµÄÖµ£¨¼Ù¶¨½á¹û²»»á³¬¹ý³¤ÕûÐͱäÁ¿µÄ·¶Î§£©

½â´ð£º int Sum( int n ) {

return ( (long)1 + n) * n / 2; //»òreturn (1l + n) * n / 2; }

ÆÊÎö£º

¶ÔÓÚÕâ¸öÌ⣬ֻÄÜ˵£¬Ò²Ðí×î¼òµ¥µÄ´ð°¸¾ÍÊÇ×îºÃµÄ´ð°¸¡£ÏÂÃæµÄ½â´ð£¬»òÕß»ùÓÚÏÂÃæµÄ½â´ð˼·ȥÓÅ»¯£¬²»¹ÜÔõô¡°ÕÛÌÚ¡±£¬ÆäЧÂÊÒ²²»¿ÉÄÜÓëÖ±½Óreturn ( 1 l + n ) * n / 2Ïà±È£¡ int Sum( int n ) {

long sum = 0;

for( int i=1; i<=n; i++ ) {

sum += i; }

return sum; }

ËùÒÔ³ÌÐòÔ±ÃÇÐèÒªÃô¸ÐµØ½«ÊýѧµÈ֪ʶÓÃÔÚ³ÌÐòÉè¼ÆÖС£

ÖÕÓÚÃ÷°×ÁË£º°´Öµ´«µÝÒâζ×ŵ±½«Ò»¸ö²ÎÊý´«µÝ¸øÒ»¸öº¯Êýʱ£¬º¯Êý½ÓÊÕµÄÊÇԭʼֵµÄÒ»¸ö¸±±¾¡£Òò´Ë£¬Èç¹ûº¯ÊýÐÞ¸ÄÁ˸òÎÊý£¬½ö¸Ä±ä¸±±¾£¬¶øÔ­Ê¼Öµ±£³Ö²»±ä¡£°´ÒýÓô«µÝÒâζ×ŵ±½«Ò»¸ö²ÎÊý´«µÝ¸øÒ»¸öº¯Êýʱ£¬º¯Êý½ÓÊÕµÄÊÇԭʼֵµÄÄÚ´æµØÖ·£¬¶ø²»ÊÇÖµµÄ¸±±¾¡£Òò´Ë£¬Èç¹ûº¯ÊýÐÞ¸ÄÁ˸òÎÊý£¬µ÷ÓôúÂëÖеÄÔ­Ê¼ÖµÒ²ËæÖ®¸Ä±ä¡£ ²»¹ÜÊÇÔÚc/c++Öл¹ÊÇÔÚjavaº¯Êýµ÷Óö¼ÊÇ´«Öµµ÷Óã¬.

µ±²ÎÊýÊǶÔÏóµÄʱºò£¬´«µÝµÄÊǶÔÏóµÄÒýÓã¬Õâ¸öºÍc/c++´«µÝÖ¸ÕëÊÇÒ»¸öµÀÀí£¬ÔÚº¯ÊýÖиıäÒýÓñ¾Éí£¬²»»á¸Ä±äÒýÓÃËùÖ¸ÏòµÄ¶ÔÏó.

»ªÎªÃæÊÔÌâ 4¡¢SQLÎÊ´ðÌâ

SELECT * FROM TABLE ºÍ

SELECT * FROM TABLE

WHERE NAME LIKE '%%' AND ADDR LIKE '%%' AND (1_ADDR LIKE '%%' OR 2_ADDR LIKE '%%' OR 3_ADDR LIKE '%%' OR 4_ADDR LIKE '%%' ) µÄ¼ìË÷½á¹ûΪºÎ²»Í¬£¿ ´ð: ǰÕß¼ìË÷È«²¿£¬ºóÕßÓÐÈýÖÖÇé¿ö¼ìË÷²»³ö£ºNAME£½null»òADDR=null»ò1_ADDR LIKE 2_ADDR 3_ADDR 4_ADDRÆäһΪnull.

ǰÕß¼ìË÷ËùÓмǼ£¬ºóÕßÖ»ÄÜ

Ë÷³ö NAME ºÍADDRÖзÇNullµÄ¼Ç¼¡£

5¡¢SQLÎÊ´ðÌâ ±í½á¹¹£º

1¡¢ ±íÃû£ºg_cardapply ×Ö¶Î(×Ö¶ÎÃû/ÀàÐÍ/³¤¶È)£º

g_applyno varchar 8£»//ÉêÇëµ¥ºÅ£¨¹Ø¼ü×Ö£© g_applydate bigint 8£»//ÉêÇëÈÕÆÚ g_state varchar 2£»//ÉêÇë״̬ 2¡¢ ±íÃû£ºg_cardapplydetail ×Ö¶Î(×Ö¶ÎÃû/ÀàÐÍ/³¤¶È)£º

g_applyno varchar 8£»//ÉêÇëµ¥ºÅ£¨¹Ø¼ü×Ö£© g_name varchar 30£»//ÉêÇëÈËÐÕÃû

g_idcard varchar 18£»//ÉêÇëÈËÉí·ÝÖ¤ºÅ g_state varchar 2£»//ÉêÇë״̬

ÆäÖУ¬Á½¸ö±íµÄ¹ØÁª×Ö¶ÎΪÉêÇëµ¥ºÅ¡£ ÌâÄ¿£º

1¡¢ ²éѯÉí·ÝÖ¤ºÅÂëΪ440401430103082µÄÉêÇëÈÕÆÚ select A.g_applydate

from g_cardapply A inner join g_cardapplydetail B on A.g_applyno = B.g_applyno where B.g_idCard = '440401430103082'

2¡¢ ²éѯͬһ¸öÉí·ÝÖ¤ºÅÂëÓÐÁ½ÌõÒÔÉϼǼµÄÉí·ÝÖ¤ºÅÂë¼°¼Ç¼¸öÊý select g_idCard,count(*) as Cnt from g_cardapplydetail group by g_idcard having count(*) > 1

3¡¢ ½«Éí·ÝÖ¤ºÅÂëΪ440401430103082µÄ¼Ç¼ÔÚÁ½¸ö±íÖеÄÉêÇë״̬¾ù¸ÄΪ07 update g_cardapplydetail set g_state = '07' where g_idcard = '440401430103082'

update A set g_state = '07'

from g_cardapply A inner join g_cardapplydetail B on A.g_applyno = B.g_applyno where B.g_idcard = '440401430103082'

4¡¢ ɾ³ýg_cardapplydetail±íÖÐËùÓÐÐÕÀîµÄ¼Ç¼ delete from g_cardapplydetail where g_name like 'Àî%'

3¡¢ ½«Éí·ÝÖ¤ºÅÂëΪ440401430103082µÄ¼Ç¼ÔÚÁ½¸ö±íÖеÄÉêÇë״̬¾ù¸ÄΪ07 update g_cardapplydetail set g_state = '07' where g_idcard = '440401430103082'

update A set g_state = '07'

from g_cardapply A inner join g_cardapplydetail B on A.g_applyno = B.g_applyno where B.g_idcard = '440401430103082' 5¡¢SQLÎÊ´ðÌâ:

/*Select g_cardapply. g_applydate From g_cardapply, g_cardapplydetail

Where g_cardapply. g_applyno=g_cardapplydetail. g_applyno And g_cardapplydetail.g_idcard='440401430103082'*/

/*Select *From (select count(*) g_count , g_idcard From g_cardapplydetail Group by g_idcard ) a Where a. g_count >= 2*/

/*Update g_cardapply set g_state='07'

where g_applyno in (select distinct g_applyno from g_cardapplydetail

where g_idcard ='440401430103082') update g_cardapplydetail set g_state='07'

where g_idcard='440401430103082' */

/*Delete from g_cardapplydetail Where g_name like 'Àî%'*/ ͨ¹ý²âÊÔ

PS:żGF×öµÄ£¬×Ô¼ºÏȺ¹Ò»Ï ½ðɽ¹«Ë¾¼¸µÀÃæÊÔÌâ

4. In C++, there're four type of Casting Operators, please enumerate and explain them especially the difference. ½âÎö£º C++ÀàÐÍת»»ÎÊÌâ

´ð°¸£º reinterpret_cast,static_cast,const_cast,dynamic_cast static_cast ÊýÖÆ×ª»»

dynamic_cast ÓÃÓÚÖ´ÐÐÏòÏÂת»»ºÍÔڼ̳ÐÖ®¼äµÄת»» const_cast È¥µôconst

reinterpret_cast ÓÃÓÚÖ´Ðв¢²»°²È«µÄorimplmentation_dependentÀàÐÍת»»

7 ÒÔÏ´úÂëÓÐʲôÎÊÌ⣬ÈçºÎÐ޸ģ¿ #include #include using namespace std; void print(vector); int

µÚ21/28Ò³ t main() {

vector array; array.push_back(1); array.push_back(6); array.push_back(6); array.push_back(3);

//ɾ³ýarrayÊý×éÖÐËùÓеÄ6 vector::iterator itor; vector::iterator itor2; itor=array.begin();

for(itor=array.begin(); itor!=array.end(); ) {

if(6==*itor) {