ʹÓÃ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
Ïà¹ØÎĵµ£º
Î塢ʼþµ÷¶ÈÆ÷²âÊÔ
5.1¡¢²âÊÔÄ¿µÄ
5.1.1 ÅäÖ÷½·¨
5.1.2 ÊÇ·ñÕý³£¹¤×÷
5.1.3 ÈÕ³£µÄά»¤
5.2¡¢Ê¼þµ÷¶ÈÆ÷½éÉÜ
×ÔMySQL5.1.6Æð£¬Ôö¼ÓÁËÒ»¸ö·Ç³£ÓÐÌØÉ«µÄ¹¦ÄÜ
–ʼþµ÷¶ÈÆ÷(Event Scheduler)£¬¿ÉÒÔÓÃ×ö¶¨Ê±Ö´ÐÐÄ³Ð©ÌØ¶¨ÈÎÎñ£¨ÀýÈ磺ɾ³ý
¼Ç¼¡¢¶ÔÊý¾Ý
½øÐлã×ܵȵȣ©£¬À´È¡´ ......
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XP
쵀Apache+PHP+MySQL
°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003
ϵͳϵݲװºÍÅäÖá£
1.
°²×°»·¾³
²Ù×÷ϵͳÊÇ Windows XP
ÖÐÎİæ, Apache,
PHP, MySQL
µÄ×îа汾ÊǽØÖ¹µ½ 2007.09.07
£¬·Ö±ðÔÚÆä¹ÙÍøÏÂÔØµÄ:
* Apache 2.2.6
£ºhttp://apache.mirror.phpchina.c ......
°²×°ºÃ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 ......
ÖÐÎÄÏÔʾÎÊÌâÒ»Ö±ÊÇÀ§ÈÅÎÒÃǵÄÒ»¸öÄÑÌ⣬²»ÐÅÄãÉÏgoogleËÑË÷һϣ¬ÕâÀàµÄÎÊÌâºÍ½â´ð¿ÉÒÔ˵ÊÇÆÌÌì¸ÇµØ£¬ºÃ¶àÍøÕ¾ÉõÖÁ½«ÆäÌá³öÀ´×÷ΪרÌâÀ´ÌÖÂÛ£¬¹ÜÖпú±ª£¬¿É¼ûÒ»°ß¡£
¿ªÊ¼Ò²ÔøÎªÕâ¸öÎÊÌâÍ·ÌÛ£¬ÉÏÍø²éÔÄ´óÁ¿µÄ×ÊÁϺͽâ¾ö·½·¨£¬ÖÕÓÚÕÒµ½ÁËÒ»Öּȼòµ¥ÓÖºÃÓõİ취£¬ÒÔJSP+MYSQL´æ´¢ÎªÀý£¬¼òµ¥½éÉÜÒ ......
MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈëÒ»¸ö² ......