ÎÒÏëÓÃÒ»¸öjavaдһ¸ö¹ÜÀíÈí¼þ Ïë°ÉjavaºÍSQLÁ¬½ÓÆðÀ´
ÎÒÒѾÓÐJDBCÁË ¾ÍÊDz»ÖªµÀÔõôÓà ÔõôÁ¬½Ó
Ï£Íû¸ßÊÖÃǰï°ïÎÒ
¸üÏ£ÍûÓиöÊÓÆµ½ÌÎÒÓÃ
лл
Íû¸ßÊÖÃÇÖ¸µã
ÔÚÏ¸м¤²»¾¡
http://www.itcast.net/course/detail/945
ÕâÊÇÎÒ×Ô¼ºÔÚ±à³ÌʱһֱÓõÄÁ¬½Ó³Ø£¬Äã¾ÍÖ±½Óµ¼Èë½ø ......
ÕâÁ½·½Ãæ¶¼Ö»ÂÔ¶®Æ¤Ã«£¬ÏÖÔÚÏëÈÏÕæÑо¿Ò»ÖÖÓïÑÔ£¬µ«ÊÇʱ¼ä²»ÊǺܳäÔ£ÁË£¬²»ÖªµÀÔÚ¾ßÌåµÄÕÒ¹¤×÷¹ý³ÌÖÐÄÇÖֱȽÏÓÐÓÅÊÆ¡£
Ŀǰ¸Ð¾õÊÇÒªJAVAµÄ¸Úλ´ó¶àÊÇÁ¿¶à¼ÛµÍ£¬¶øºÜ¶à´óoffer¶¼ÊÇC++µÄ¡£
ÇëÖ¸µã£¡
woshizn
Â¥Ö÷¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄÐËȤ°®ºÃ£¬¸öÈ˾õµÃÄĸö×öºÃÁË£¬¶¼ÊÇÇÀÊÖÈË
ÒýÓÃ
Ŀǰ¸Ð¾õÊÇÒªJAVAµÄ¸Úλ´ó¶àÊÇÁ¿ ......
up.add("result", (right == null ? "falsch" : (right ? "richtig" : "falsch"))).add("result_message", DBUtils.encodeString(message)).add("title", title).add("sql", DBUtils.encodeString(sql));
ÕâÀïÃæµÄÕâ¾ä»° right = ......
mysqlÊý¾Ý±íÓУº¹Ì¶¨¹¤×÷¡¢½±½ð¡¢¶îÍâ½ð¡¢¿Û³ý¡¢Ó¦·¢¹¤×ʵÈ×ֶΡ£ÔõôÔÚ±í¸ñʵÏÖ£ºÓ¦·¢¹¤×Ê=¹Ì¶¨¹¤×Ê+½±½ð+¶îÍâ½ð-¿Û³ý
ôÒâ˼?
Êǽ¨±í?
SQL
¹Ì¶¨¹¤×Ê+½±½ð+¶îÍâ½ð-¿Û³ý AS 'Ó¦·¢¹¤×Ê'
select Ó¦·¢¹¤×Ê=¹Ì¶¨¹¤×Ê+½±½ð+¶îÍâ½ð-¿Û³ý from tb
mysql table pwages(id char(4),name char(8) ......
create table ty_product(
id number(3),
proname varchar(20),
profile varchar(80),
prive number(7),
totalnum number(3),
picname varchar(20),
);
ÎÒÓÃÕâÑùµÄÓï¾ä£¬×ÜÊDZ¨´í£¬mysql²»Ö§³ÖnumberÂð£¬
»»³Écreate table ty_product(
id int(3),
proname varchar(20),
pro ......
ÎÊÌâÈçÏ£º¶à¸ö¿Í»§¶Ë¹²ÏíÒ»¸öÊý¾Ý£¨Ôڴ˳ÆÎªÐòÁкţ©£¬Õâ¸öÐòÁкÅÒÔµÝÔöµÄÐÎʽ³öÏÖ£¬ËùÒԾͱä³Éÿ¸ö¿Í»§¶Ëÿ´ÎÓõÄÐòÁкŲ»Í¬£¬ÏÖÔÚµÄÎÊÌâÊÇÒªÕýÈ·È¡µ½ºÅ¡£ÎÒµÄʵÏÖÊǰÑÕâ¸öÐòÁкŴæÔÚÊý¾Ý¿âÖУ¬Ã¿¸ö¿Í»§¶Ëÿ´ÎÈ¡ÍêºóÒÔÔö1µÄÐÎʽÔÙ¸üлØÈ¥£¬ÕâÑù±£Ö¤Î¨Ò»ÐÔ£¬ÏÖÔÚµÄÎÊÌâÊÇÈçºÎ¿ØÖÆÕâ¸öΨһÐÔ£¬ÓÃÊÂÎñ¡¢Ëø¡¢»¹ÊÇʲô°ì·¨£¿£ ......