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ÊÔÊÔ¡£
Ïà¹ØÎÊ´ð£º
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿
PHP code:
<?php
$str="select * from product wh ......