VCÏÂÔÚmysqlÊý¾Ý¿âÖÐÔõô²åÈëͼƬ(bmp¡¢jepg¸ñʽ)£¬ÁíÍâÔõô¶Á³öͼƬ²¢ÏÔʾ£¿
Çë¸÷λָµãһϣ¬Ð»Ð»¡£
PS:СµÜÊÇÓÃodbc¶ÁÈ¡Êý¾Ý¿â²Ù×÷¡£
Èç¹ûÎļþÔÚmysqlÊý¾Ý¿â·þÎñÉÏ£¬¿ÉÒÔÓÃload_fileº¯Êý£º
insert table tb_name(picture) values(load_file('d:\\test.jpb'));
ÖÁÓÚ¶Áร¬Ö»ÄÜÓóÌÐò¶Á³öÁ÷¡ ......
ÎÒÓÃtest.html Ö¸Ïòlogin.phpÀ´²åÈëÕʺÅÃÜÂëµ½mysqlÖÐÈ¥£¬µ«²Ù×÷Íêºóµ½mysqlÀï¿´µ½Ö»ÓÐid×Ô¶¯Ôö¼Ó£¬ÆäËûµÄÖµ¶¼Êǿհ׵ģ¬ÊÇʲôÔÒò£¬ÊÇÎÒ´úÂëд´í»¹ÊÇÎÒµÄÊý¾Ý¿â×Ö¶ÎûÅäÖúã¿
test.htmlÖеĴúÂëÈçÏÂ
HTML code:
<meta content="text/html; charset=gb2312" http-equiv="Content-Type"/&g ......
ÏÈ¿´Òì³££º
org.springframework.dao.CannotAcquireLockException: SqlMapClient operation;
...
...
...
CannotAcquireLockException: SqlMapClient operation
...
...
...
springµÄÅäÖÃ
XML code:
<!-- ****************ÊÂÎñ֪ͨ(ÊÂÎñÔöÇ¿)**************** -->
......
mysqlµÄË÷ÒýÀàÐÍÓÐÄÄЩ£¿ ÊÇ·ñÊÇÔÚmysqlÖд洢ΪB*Ê÷Ë÷Òý£¬ÔÚorcaleÖÐBË÷Òý ÓÐÇø±ðÂð Çë¸ø½âÊÍÏÂ
ÈýÖÖË÷Òý
BTREE | HASH | RTREE
²»ÊÇB* Ë÷Òý¡£
BTREE | HASH | RTREE
fulltext
hash Ö»ÓÐmemoryÖ§³Ö
ÒýÓÃ
BTREE | HASH | RTREE
fulltext
hash Ö»ÓÐmemoryÖ§³Ö
......
winxp ÏÂ,mysql5.0
mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine | Support | Comment & ......
ÄÇλ´óϺ°ï°ïæѽ£¡£¡ ÎÒÔÚphpmyAdmin ÓÃinsert ²åÈëÖÐÎľÍûÊ¡£
µ«ÊÇ×Ô¼ºÔÚ¡£netÖÐ ²åÈë¾ÍÊÇÂÒÂëÁË¡£¡£
´óϺ£¡£¡
±í£¬×ֶΣ¬Á¬½Ó´®£¬¶¼ÒªÖ¸¶¨×Ö·û¼¯
±í£º Éè¼Æ±í½çÃæÓеط½Ñ¡Ôñ×Ö·û¼¯
×ֶΣºÒ²Óеط½Ñ¡Ôñ×Ö·û¼¯
Á¬½Ó´®£ºString.Format("server={0}; user id={1}; password= ......