delphi mysqlÎÊÌâ - Delphi / Êý¾Ý¿âÏà¹Ø
adoconnection1.ConnectionString := 'driver={MySQL ODBC 3.51 Driver};server=localhost;uid=root;pwd=111111;database=xiamen';
adoconnection1.Open;
adodataset1.Connection := adoconnection1;
adodataset1.Active := false;
adodataset1.CommandText := 'select * from blh5_operation_list limit 10';
adodataset1.Active := true;
adodataset1.Append;
adodataset1.FieldByName('op_state').AsInteger := 0;
adodataset1.UpdateBatch();
ÉÏÃæ´úÂëÖÐ adodataset1.FieldByName('op_state').AsInteger := 0;ÕâÒ»¾äÊÇʲôÒâ˼£¬ÓÐʲô×÷Ó㬱íÖж¨Òåop_state×Ö¶ÎÊÇop_state` tinyint(1) NOT NULL default '0', Ö´Ðкó±¨Òì³££¬Field 'paras' doesn't have a default value;
Äĸö¸ßÊÖÖªµÀÊÇʲôÒâ˼£¿£¿
ÔÎÁË£¬Ã»¿´Çå³þ£¬±íÀïÃæµÄparasÕâ¸ö×Ö¶ÎûÓÐĬÈÏÖµµÄ
Ïà¹ØÎÊ´ð£º
Çë½Ì¸÷·¸ßÊÖ¡£ÎäÁÖǰ±²¡£ÎÒ½«B.EXE×ö³É×ÊÔ´Îļþ£¬È»ºó¼Óµ½123.dllÖС£ÓÃA.EXEÀ´µ÷ÓÃ123.dllÖеÄB.EXE
Çë¸÷λǰ±²°ïæָ½ÌÏ¡£A.exeÈçºÎÀ´µ÷ÓÃdllÖеÄexe£¿´úÂëÓÖ¸ÃÈçºÎд£¿
ÎÞÈ˻شð£¿
×ö³É×ÊÔ´Î ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
³ÌÐòʹÓõÄÊÇOrcalÊý¾Ý¿â£¬Ï붨ÆÚ£¨Ã¿¼¾¶È£©¶ÔÊý¾Ý¿â½øÐб¸·Ý£¬Ã»É¶Í·Ð÷£¬ÇëÎÊÓ¦¸ÃÔõôŪ£¿
ÓÐÊ²Ã´ÌØÊâÒªÇóÂ𣬱ÈÈçҪǰ¶Ë½çÃæ£¿
Ò»°ãÓÃÊý¾Ý¿â×Ô´øµÄ¡°¼Æ»®ÈÎÎñ¡±ÅäÖÃһϾ͹»ÁË
ûÓÐÊ²Ã´ÌØÊâÒªÇó¡£ÀýÈ磬ֻҪµ ......
ÔõôÑù²éѯÁ¬½Ó2¸ö±íÖ®ºó µÃ³öµÄбí
ÀýÈç A±í£º·¢¼þÈËID Óʼþ±àºÅ ÓʼþÄÚÈÝ ÊÕ¼þÈËID ·¢¼þʱ¼ä
B±í£ºÊÕ¼þÈËID Óʼþ±àºÅ ÊÕ¼þʱ¼ä
Ê×ÏÈ×öA BµÄÁ¬½Ó²éѯ ¼´ Óʼþ±àºÅÏàµÈ
²é³ö£ ......