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ÊÔÊÔ¡£
Ïà¹ØÎÊ´ð£º
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý
Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......