sqlÖØ¸´Êý¾Ý¼ì²â
sql±ídata½á¹¹ÈçÏÂ
id name class title
1 ¹ØÓÚ °ïÖú ʹÓÃ
1 ¹ØÓÚ °ïÖú ÎÒÃÇ
1 ¹ØÓÚ ÎÒÃÇ ÁªÏµ·½Ê½
2 ÎÄÕ ¼¼Êõ ÎÄÕÂ1
2 ÎÄÕÂ ÎÊ´ð ÎÄÕÂ2
2 ÎÄÕ ½»Á÷ ÎÄÕÂ3
.............
ÏÖÔÚ¼ì²âͬһ id
class+titleÖØ¸´Êý¾Ý
²¢ÁгönameÖµ
ÕâÑùµÄµÄsqlÈçºÎд
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......
ÎÒÏëʹÓÃSql±à¸öС³ÌÐò£¬¾ÍÊÇÅж¨Ò»¸ö×Ö·û´®³öÏÖÁ˼¸´ÎÖ¸¶¨×Ö·û£»
ÀýÈçÔÚstringÐÍ¡°6+4+8+2¡±ÖУ¬ÎÒÐèÒªÅж¨³öÏÖÁ˼¸¸ö¡°+¡±£»²¢ÇÒʵÏÖ
if £¨³öÏÖ3´Î£©
then
¡¡¡¡¡¡£¨Òý·¢Ê¼þ£©£»
......