ʹÓÃabatorÅäÖÃiBatis£¬¹ÜÀíÊý¾Ý¿â£¨ÒÔMySqlΪÀý£©
ÏàÐźܶàµÄÅóÓѶÔʹÓÃiBatis¹ÜÀíÊý¾Ý¿âºÜ²»Ï°¹ß£¬ÒòΪÎÒÃÇÒªÊÖд´úÂë£¬ÌØ±ðÊÇdynamic
query²¿·Ö¸üÊDz»ÖªÈçºÎǶÌ×£¬¶øÕâЩÊÇ¿ÉÒÔÓù¤¾ßµÄ£¡ÏÂÃæ½éÉÜÒ»ÖÖ×î³£Óõ졲»·Ï»°ÁË£¬Ö±½ÓÉÏÅäÖùý³Ì£¡
1¡¢»ñµÃ http://ibatis.apache.org/abator.html
Eclipse¿ÉÒÔ×Ô¶¯µÄ½øÐÐUpdate»ñÈ¡´ËPlugin£¬¹Ù·½µÄ°²×°²½Öè.
If you've already installed a prior version of Abator, simply run the Eclipse Install/Update tool and the new version will be found automatically.
If you've not already installed Abator, then you can use the built in Eclipse install support by following these steps:
Take the "Help>Software Updates>Find and Install" Menu Option
Select the "Search for new features to install" radio button, press "Next"
Press the "New Remote Site" button
Enter the following information:
Name:
Abator for Eclipse Update Site
URL:
http://ibatis.apache.org/tools/abator
Press OK
Check the box next to "Abator for Eclipse Update Site"
Follow the remainder of the install wizard
2¡¢°²×°ºÃºó½«ÔÚNew²Ëµ¥Öп´µ½Ò»¸öеÄÎļþÀàÐÍAbator for iBATIS Configuration
File£¬´ËÊÇAbatorµÄÅäÖÃÎļþ£¬ÅäÖÃÎļþµÄÏêϸ˵Ã÷¼ûhttp://ibatis.apache.org/docs/tools/abator/
3¡¢Ð½¨Ò»¸öÅäÖÃÎļþ£¬½øÐÐÐ޸쬏ù¾Ý×Ô¼ºµÄʵ¼ÊÐèÇó½øÐÐÐÞ¸Ä
¹Ø¼üµã£º
1£©jdbc
connection£¬°´ÕÕÒ»°ãµÄÅäÖü´¿É£¬ÐèҪ˵Ã÷µÄÊÇËüÐèÒªÖ¸¶¨·ÃÎÊJdbcDriverµÄclassPathEntry£¬¶ÔÓÚMsSqlServer¶øÑÔ£¬Òª½«ÕâÈý¸öjarÎļþ¾ù°üº¬ÔÚÄÚ£¬·ñÔò»á³öÏÖjdbc·ÃÎÊ´íÎó¡£
2£©ÅäÖÃÈý¸öPakage
3£©ÅäÖÃ±í£¬´Ë´¦Ðè˵Ã÷µÄÊǶÔÓÚMsSqlServer²»ÄÜдTableSchema£¬ÎÒ³õ´ÎÖ¸¶¨TableSchema£¬½á¹ûδÕÒµ½¶ÔÓ¦µÄ±í
¼òµ¥µÄÅäÖÃÈçÏ£¬¸´ÔӵļûÅäÖÃÎļþµÄÏêϸ˵Ã÷¡£Ê¾ÀýÅäÖÃÎļþÈçÏÂ
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE abatorConfiguration PUBLIC "-//Apache Software Foundation//DTD Abator for iBATIS Configuration 1.0//EN"
"http://ibatis.apache.org/dtd/abator-config_1_0.dtd">
<abatorConfiguration>
<abatorContext generatorSet="Java5">
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://local
Ïà¹ØÎĵµ£º
http://hi.baidu.com/qk618/blog/item/f61e5830f2125d93a9018e0c.html
½â¾öÔ¶³ÌÁ¬½Ómysql´íÎó1130´úÂëµÄ·½·¨
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ ......
µÃ°²Ææ×¨Âô£¨Ô˶¯ÐÝÏÐЬ£¬°åЬ£©ÌÔ±¦Ð¡µê£ºwww.bxbshoes.com
substring£º
Óï·¨
SUBSTRING ( expression , start , length )
²ÎÊý
expression
ÊÇ×Ö·û´®¡¢¶þ½øÖÆ×Ö·û´®¡¢text¡¢image¡¢Áлò°üº¬Áеıí´ïʽ¡£²»ÒªÊ¹Óðüº¬¾ÛºÏº¯ÊýµÄ ......
×î½üÔÚÑо¿CMS£¬ÔÚÊý¾Ýת»»µÄʱºòÐèÒªÓõ½mysqlµÄreplaceº¯Êý£¬ÕâÀï¼òµ¥½éÉÜһϣ¡
±ÈÈçÄãÒª½« ±í tb1ÀïÃæµÄ f1×ֶεÄabcÌæ»»Îªdef
UPDATE tb1 SET f1=REPLACE(f1, 'abc', 'def');
REPLACE(str,from_str,to_str)
ÔÚ×Ö·û´® str ÖÐËùÓгöÏÖµÄ×Ö·û´® from_str&nbs ......
Õ⼸Ìì×öÒ»¸ö²éѯ£¬ÐèÒªÔÚÒ»¸öÖ¸¶¨µÄ½á¹û¼¯ÖнøÐвéѯ£¬ÀýÈ磺
select * from table_name where doc_id IN ('1dba', 'c20a', '907b')
ÆäÖÐIN×Ó¾äÖеÄdoc_idÁбíÊÇͨ¹ýµ÷ÓÃÒ»¸öÍⲿ½Ó¿Ú»ñµÃÒ»×édoc_id³£Á¿ÁÐ±í£¬È»ºóÔÚ±¾µØ¿âÖÐËÑË÷·ûºÏÕâ¸öÁбíµÄÊý¾Ý
¼Ç¼¡£ºóÀ´·¢ÏÖmysql·µ»ØµÄ½á¹û¼¯µÄÅÅÐòÊǰ´ÕÕÈë¿â˳Ðò¸ø³öµÄ£¬µ«ÊÇÎÒ ......
½ö½öÊÇ¿´Ò»Ð©ÊéÊÇÁãÁãɢɢ¼ÇÏµģ¬¸ø×Ô¼º±¸Íü¶øÒÑ¡£½¨ÒéÈ¥¿´×¨ÒµÍøÕ¾µÄ±Ê¼Ç¡£
1.Ö÷¼üµÄÖµ±ØÐëÊÇΨһµÄ£¬²¢ÇÒ²»ÄÜΪ¿Õ£¬Õâ¿ÉÒÔÌá¸ßMySQL´Ó¶à¸ö±íÖÐÈ¡µÃÊý¾Ý»òÕßÈ¡µÃÖ¸¶¨¼üÖµ¶ÔÓ¦µÄÐеÄËÙ¶È¡£MySQLͨ¹ýÒ»¸öÌØÊâµÄ³ÆÎªIndexË÷ÒýµÄÊý¾Ý½á¹¹×öµ½ÕâÒ»µã£¬IndexÊÇÕÒµ½Ò»Ìõ¼Ç¼µÄ¿ì½Ý·½Ê½£¬¾ÍÏñͼÊé¹ÝµÄ¿¨Æ¬Ä¿Â¼¡£
2.²é¿´±íµÄÁж¨ ......