ÁªºÏÌå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
µÚ21/28Ò³ t main() {
vector
//ɾ³ýarrayÊý×éÖÐËùÓеÄ6 vector
for(itor=array.begin(); itor!=array.end(); ) {
if(6==*itor) {