j2me+servlet+mysql ÖÐÎÄÂÒÂë
±¾µØ ÊÖ¶¯Ð´ÈëMYSQL ÖÐÎÄÊÇ¿ÉÒÔµÄ
´ÓÊÖ»úдÈëMYSQL¶¼ÊÇ¡°£¿£¿£¿£¿¡±
ÊÖ»úÊÇÓÃHTTP ·ÃÎÊurl
url = MainCanvas.url_add+"&Uname="+Uname+"&Uage="+Uage+"&Usex="+Usex+"&Upass="+Upass;
Uname ÊÇÓ¢ÎĵľͺÜÕý³£ ÖÐÎľͲ»¿ÉÒÔÁË
J2ME ÀïÃæÒѾhttp.setRequestMethod(HttpConnection.POST);
servlet ÀïÃæÒѾrequest.setCharacterEncoding("gbk");
response.setCharacterEncoding("gbk");
Êý¾Ý¿âÀïÃæµÄÖÐÎÄÐÅÏ¢Ò²¿ÉÕý³£µÄ·¢Ë͵½ÊÖ»ú·
Õâ¸öÊÂURLµØÖ·×ªÂëºó³öÏÖµÄÂÒÂ룬¾ÍÊÇÄãÔÚת·¢µÄ¹ý³ÌÖжÔÓÚ+"&Uname="+Uname+"&Uage="+Uage+"&Usex="+Usex+"&Upass="+Upass;
ÖÐÎÄ´«Èë·ûÒª½øÐÐתÂë²ÅÐУ¬ÀýÈç String name = new String(Uname.getBytes("ISO-8859-1"), "GB2312");
¿ÉÒÔÓÃÕâ¸öתÁËÊÔÊÔ£¡
ÊDZàÂëÎÊÌ⣬»»UTF-8ÊÔÊÔ¡£
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......