Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʹÓÃ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


Ïà¹ØÎĵµ£º

½â¾öÔ¶³ÌÁ¬½Ómysql´íÎó1130´úÂëµÄ·½·¨

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
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ ......

mysql substring

µÃ°²Ææ×¨Âô£¨Ô˶¯ÐÝÏÐЬ£¬°åЬ£©ÌÔ±¦Ð¡µê£ºwww.bxbshoes.com
substring£º
Óï·¨
SUBSTRING ( expression , start , length )   
²ÎÊý
expression     
ÊÇ×Ö·û´®¡¢¶þ½øÖÆ×Ö·û´®¡¢text¡¢image¡¢Áлò°üº¬Áеıí´ïʽ¡£²»ÒªÊ¹Óðüº¬¾ÛºÏº¯ÊýµÄ ......

mysqlÓû§ÈÏ֤ЭÒé¸ü»»£¨mysqlʹÓÃÎÊÌâ)

°²×°ºÃmysqlºó£¬ÔÚʹÓÃmysqʱ£¬³öÏÖÁËÈçÏÂÎÊÌâ.
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:327)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2 ......

MySQLÊý¾Ý¿â±¸·ÝµÄ»ù´¡ÖªÊ¶´óÈ«

ƽʱÎÒÃÇÔÚʹÓÃMySQLÊý¾Ý¿âµÄʱºò¾­³£»áÒòΪ²Ù×÷ʧÎóÔì³ÉÊý¾Ý¶ªÊ§£¬MySQLÊý¾Ý¿â±¸·Ý¿ÉÒÔ°ïÖúÎÒÃDZÜÃâÓÉÓÚ¸÷ÖÖÔ­ÒòÔì³ÉµÄÊý¾Ý¶ªÊ§»ò×ÅÊý¾Ý¿âµÄÆäËûÎÊÌâ¡£
¡¡¡¡Ò»¡¢Êý¾Ý±¸·Ý½Ý¾¶
¡¡¡¡ÒòΪÕâ¸ö·½·¨Ã»Óеõ½¹Ù·½ÕýʽÎĵµµÄÑéÖ¤£¬ÎÒÃÇÔݳÆÎªÊÔÑé°É¡£
¡¡¡¡Ä¿µÄ£º±¸·ÝhostAÖ÷»úÖÐÒ»¸öMySQLÊý¾Ý¿â±¸·ÝTestA£¬²¢»Ö¸´µ½µ½hostB»úÖÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ