ÎÒʹÓÃNavicat Lite8½øÐÐMYSQLÊý¾Ý¿âºÍ±íµÄ½¨Á¢,È»ºóÓÃJAVA½øÐÐÊý¾ÝµÄÌí¼Ó
µ±Êý¾ÝÌí¼Ó½øÈëÊý¾Ý¿âºó,Ó¢ÎĺÍÊý×Ö¶¼¿ÉÒÔÏÔʾ,µ«ÊÇÖÐÎľͻá±ä³É??
ÎҸоõÊÇ×Ö·û¼¯ÓõIJ»¶Ô
ÔÚʹÓÃNavicat Lite8½øÐÐÊý¾Ý¿âµÄ´´½¨Ê±,»áÓÐÁ½¸öÑ¡Ïî,·Ö±ðÊÇCharacter setºÍCollation
Ç°ÕßÎÒÊÔ¹ýÁËBIG5,gb2312,gbk,utf8,µ±Ñ¡ÓÃutf8ʱ,CollationµÄÑ¡Ïî·Ç³£¶à,ÎÒ¾ÍËæ±ãÑ¡Á˼¸ÖÖ·Ö±ðÊÔÁË,µ«ÊǶ¼ÊDz»ÐÐ,ÖÐÎÄÒ»Ö±ÊÇÏÔʾ??
¶øÓ¢ÎĺÍÊý×Ö¶¼ÊÇÕý³£
»¹ÓÐÒ»µãºÜÆæ¹Ö,ÎÒÖ±½ÓÓÃNavicat Lite8Ìí¼ÓÖÐÎÄÊý¾Ý,select³öÀ´µÄÖÐÎľͿÉÒÔÏÔʾ
ÇëÎÊÏÂ,Õâ¸öÎÊÌâÈçºÎ½â¾ö,Ï£ÍûÄܽ²µÄÏêϸµã,ÎÒÊÇÐÂÊÖ,×îºÃ±ðÌ«Éî°Â
Êý¾Ý¿â±àÂëÉèÖúÃÁË£¬²åÈë·½·¨Ò²ÒªÏàÓ¦µÄÉèÖÃһϱàÂ룬²»ÄܲåÈëµÄÊÇÂÒÂë
Êý¾ÝµÄ²åÈ룬ÎÒÊÇÖ±½ÓÔÚJAVAÀï×öµÄ£¬ÏÂÃæÊÇÏà¹Ø´úÂë
Java code:
String sql = "insert into guest values(?,?,?,?,?,?,?,?)";
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, id);
ps.setString(2, fname.getText().trim());
ps.setString(3, faddress.getText().trim());
ps.setString(4, fkind.getText().trim());
ps.setString(5, ftrade.getText().trim());
ps.setString(6, fnumber.getText().trim());
ps.setString(7, femail.getText().trim());
ps.setString(8, fbusiness.getText().trim());
int r = ps.executeUpdate();
if(r > 0)
{
//µ¯³öÒ»¸ö¶Ô»°¿ò
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......