Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Windows Mobile 6.0Á¬½ÓSQL Server 2005(PC°æ)


»·¾³´î½¨£º
   windows MobileµÄ¿ª·¢»·¾³µÄ´î½¨ÕâÀï¾Í²»ËµÁË£¬²»Ã÷°×µÄÅóÓÑÔÚÍøÉÏËÑϼ´¿É¡£
²½Öè¸ÅÊö:
1£ºPCÉϵÄSQL SERVER ÐèÒª¿ªÆôÔ¶³ÌÁ¬½Ó¡£
2£ºMoblieÄ£ÄâÆ÷ÐèҪͨ¹ýActiveSyncÁ¬½Ó£¬Ê¹ÆäÄܹ»Í¨¹ýPCÁ¬Íø¡£(Èç¹ûÊÇÊÖ»úµÄ»°£¬ÐèÒªÄܹ»Í¨¹ýÎÞÏßÍøÂçÁ¬È뻥ÁªÍø)
Ïêϸ˵Ã÷£º
1:SQL Server 2005¿ªÆôÔ¶³ÌÁ¬½Ó¡£
    1£©.“¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”
2£©.ÔÚ“SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷”Ò³, µ¥»÷“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”
3£©.È»ºóµ¥»÷Õ¹¿ª“Êý¾Ý¿âÒýÇæ”£¬ Ñ¡ÖГԶ³ÌÁ¬½Ó”£¬ÔÚÓÒ±ßÑ¡ÖГ±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó”£¬
ÔÙÑ¡ÔñҪʹÓõÄЭÒ飬µ¥»÷“Ó¦ÓÔ£¬Äú»á¿´µ½ÏÂÏûÏ¢£º
“Ö±µ½ÖØÐÂÆô¶¯Êý¾Ý¿âÒýÇæ·þÎñºó£¬¶ÔÁ¬½ÓÉèÖÃËù×öµÄ¸ü¸Ä²Å»áÉúЧ¡£”£¬µ¥»÷“È·¶¨”°´Å¥·µ»Ø
4£©.Õ¹¿ª“Êý¾Ý¿âÒýÇæ”£¬ Ñ¡ÖГ·þÎñ”£¬ÔÚÓұߵ¥»÷“Í£Ö¹”£¬µÈµ½ MSSQLSERVER ·þÎñÍ£Ö¹£¬
È»ºóµ¥»÷“Æô¶¯”£¬ÖØÐÂÆô¶¯MSSQLSERVER ·þÎñ¡£
 
2£ºÊ¹windows MobileÄ£ÄâÆ÷ͨ¹ýPCÉÏÍø
MoblieÄ£ÄâÆ÷ÔÚVS2008ÀïÒѾ­´æÔÚ£¬²»ÐèÒªÏÂÔØ
   1£© VS 2008->¹¤¾ß->·ÂÕæÉ豸¹ÜÀíÆ÷
   2£©´ò¿ªºó¼´¿É¿´µ½Ä£ÄâÆ÷£¬Ñ¡ÔñÄãҪģÄâµÄÉ豸£¬ÓÒ¼üµ¥»÷£¬ÔÙµã»÷ Á¬½Ó£¬È»ºó´ò¿ªActiveSync,
ActiveSyncµÄÅäÖÃÈçͼ
 
ÅäÖÃÍê³Éºó ÔÚÉ豸ģÄâÆ÷ÖÐÑ¡ÔñÄãÄ£ÄâµÄÉ豸£¬ÓÒ¼üµ¥»÷ºóÑ¡Ôñ ²åÈëµ××ù£¬ÕâʱÄãµÄÄ£ÄâÆ÷¼´¿ÉÉÏÍø¡£
 
3£©²âÊÔ´úÂë
//Ìí¼ÓÃüÃû¿Õ¼ä
using System.Data.Common;
using System.Data.SqlClient;
//×¢ÒâÕâÀïÓõIJ»ÊÇSqlServerCe;ÏÂÃæµÄÒ²ÊÇÓõÄAdo.netµÄPC°æ£¬²»ÊÇCe°æ¡£
private void ConnetToSQLTest()
{
//Data Source:IP+¶Ë¿ÚºÅ ÆäËûµÄºÍpcÉϵÄÒ»ÖÂ
string connectionString = "Data Source=192.168.0.105,1433;Initial Catalog=wjnTest;User Id=sa;Password=123";
using (SqlConnection ceconn = new SqlConnection(connectionString))
{
ceconn.Open();
SqlCommand cmd = new SqlCommand("insert into Users(username,passwd)values('test','123')", ceconn);


Ïà¹ØÎĵµ£º

SQLÓïÑÔµÄCASEʹÓÃ×ܽá

 ×ª×Ôhttp://lavasoft.blog.51cto.com/62575/23373
SQLÓïÑÔµÄCASEÓï¾ä±¸Íü
 
¸ÅÊö£º
SQLÓï¾äÖеÄCASEÓï¾äÓë¸ß¼¶ÓïÑÔÖеÄswitchÓï¾ä£¬ÊDZê×¼SQLµÄÓï·¨£¬ÊÊÓÃÓëÒ»¸öÌõ¼þÅжÏÓжàÖÖÖµµÄÇé¿öÏ·ֱðÖ´Ðв»Í¬µÄ²Ù×÷¡£Áé»îÓ¦ÓÃCASEÓï¾ä¿ÉÒÔʹSQLÓï¾ä±äµÃ¼ò½àÒ×¶Á£¬ÏÂÃæÔÚDB2»·¾³ÏÂͨ¹ýÒ»¸ö¼òµ¥µÄ²éѯÀ´Õ¹Ê¾SQL CASEÓ ......

³£ÓÃSQLÓï¾äÊéд¼¼ÇÉ

 ×ª×Ô£ºhttp://jianghaifeng.blogchina.com/3841741.html
 SQL½á¹¹»¯²éѯ×Ö·û´®µÄ¸Äд£¬ÊÇʵÏÖÊý¾Ý¿â²éѯÐÔÄÜÌáÉýµÄ×îÏÖʵ¡¢×îÓÐЧµÄÊֶΣ¬ÓÐʱÉõÖÁÊÇΨһµÄÊֶΣ¬±ÈÈçÔÚ²»ÔÊÐí´ó·ù¶ÈÐÞ¸ÄÏÖÓÐÊý¾Ý¿â½á¹¹µÄÇé¿öÏ¡£
ͨ¹ýÓÅ»¯SQLÓï¾äÌá¸ß²éѯÐÔÄܵĹؼüÊÇ£º
 ¸ù¾Ýʵ¼ÊÐèÇóÇé¿ö£¬½¨Á¢ºÏÊʵÄË÷Òý£»
&# ......

¼Ç¼һЩsqlÓï¾äoracleµÄ

 select d.code,d.name, sum(w.weight) weight,round(avg(w.price),2) price,sum(w.money) money
from weight_info w left outer join t_dict d on w.productcode=d.code left outer  join t_balancecode b on w.balancecode=b.balancecode where 1=1 and w.operdate>TO_TIMESTAMP('2009-11-2 04:12:32.0', ' ......

50¸ö³£ÓÃsqlÓï¾ä

Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
  select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
  fr ......

php¶Ôsql injectionµÄ·À·¶

¶Ôhttp request¹ýÀ´µÄÊý¾Ý£¬·²ÊǺ¬Óе¥ÒýºÅ£¬Ë«ÒýºÅ£¬·´Ð±Ïߵȶ¼½øÐмÓбÏß´¦Àí¡£·ÀÖ¹½øÐÐ×¢Èë²Ù×÷¡£
/*
¶ÂSQL©¶´
*/
function quotes($content){

//Èç¹ûmagic_quotes_gpc=Off£¬ÄÇô¾Í¿ªÊ¼´¦Àí
if (!get_magic_quotes_gpc()) {
//ÅжÏ$contentÊÇ·ñΪÊý×é
if (is_array($content)) {
//Èç¹û$contentÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ