ʹÓÃ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
Ïà¹ØÎĵµ£º
¾³£ÔÚÒ»¸ö±íÖÐÓи¸×Ó¹ØÏµµÄÁ½¸ö×ֶΣ¬±ÈÈçempnoÓëmanager£¬ÕâÖֽṹÖÐÐèÒªÓõ½Ê÷µÄ±éÀú¡£ÔÚOracle ÖпÉÒÔʹÓÃconnect by¼òµ¥½â¾öÎÊÌ⣬²Î¼ûhttp://blog.csdn.net/wzy0623/archive/2007/06/18/1656345.aspx£¬µ«MySQL 5.1Öл¹²»Ö§³Ö£¨¾Ý˵ÒÑÄÉÈëto doÖУ©£¬Òª×Ô¼ºÐ´¹ý³Ì»òº¯ÊýÀ´ÊµÏÖ¡£
Ò»¡¢½¨Á¢²âÊÔ±íºÍÊý¾Ý£º
DROP TABLE ......
¡¡¡¡ÊÂÎñÊÇDBMSµÃÖ´Ðе¥Î»¡£ËüÓÉÓÐÏÞµÃÊý¾Ý¿â²Ù×÷ÐòÁÐ×é³ÉµÃ¡£µ«²»ÊÇÈÎÒâµÃÊý¾Ý¿â²Ù×÷ÐòÁж¼ÄܳÉΪÊÂÎñ¡£Ò»°ãÀ´Ëµ£¬ÊÂÎñÊDZØÐëÂú×ã4¸öÌõ¼þ£º£¨ACID£©
¡¡¡¡Ô×ÓÐÔ£¨Autmic£©£ºÊÂÎñÔÚÖ´ÐÐÐÔ£¬Òª×öµ½“Ҫô²»×ö£¬ÒªÃ´È«×ö£¡”£¬¾ÍÊÇ˵²»ÔÊÐíÊÂÎñ²¿·ÖµÃÖ´ÐС£¼´Ê¹ÒòΪ¹ÊÕ϶øÊ¹ÊÂÎñ²»ÄÜÍê³É£¬ÔÚrollbackʱҲҪÏû³ý¶ÔÊ ......
1
°²×°MYSQLºó¸ü¸ÄÁËROOTµÄÃÜÂëºóÓÃ
net startmysql
Æô¶¯Ê±ÎÒ¾ÍÓöµ½ÁËÕâÑùµÄÎÊÌ⣮ʹÓÃÒÔÏÂÃüÁîºó
c:\mysql\bin\mysqladmin-u root -p shutdown
ÔÙnet start mysql¾ÍûÓÐÕâ¸ö´íÎóÌáʾÁË!
*************
2
MySQLµÄ1067´íÎó
Q£ºÎÒµÄMysqlÅöµ½ÁË 1067 ´íÎó
´íÎóÐÅϢΪ£º
A system error has occurred.
......
http://hi.baidu.com/tianxia_1209/blog/item/a2613822fec7e7f6d6cae267.html
MYSQLµÄʼþÊÇ5.1ÐÂÔö¼ÓµÄ£¬Èç¹ûÏëÌåÑ飬½¨ÒéÉý¼¶°æ±¾¡£
ÖÁÓÚÓï·¨ÎҾͲ»¶à˵ÁË£¬ÊÖ²áÉϽ²µÄºÜÏêϸ£¬ÎÒÀ´ËµËµ¼¸¸öÒªµãÒÔ¼°Ò»Ð©ÊµÀý¡£
×¢ÒâÊÂÏ
1¡¢EVENTȨÏÞÊÇÕë¶ÔģʽµÄ£¨ÔÚMYSQLÖÐÒ²¾ÍÊÇ¿âµÄ¼¶±ð£©£¬²»ÄܶԵ¥¶À±íÀ´¸³ÓèȨÏÞ¡£
2¡¢±ØÐëÔÚ ......
Ò»¡¢MySql¼ò½é¸ÅÒª
MySQLÊÇÒ»¸öСÐ͹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬¿ª·¢ÕßΪÈðµäMySQL AB¹«Ë¾£¬ºóÀ´
±»Sun¹«Ë¾ÊÕ¹º£¬ÏÖÔÚÕýÔÚ±»¼×¹ÇÎÄÊÕ¹º£¬Ö§³ÖFreeBSD¡¢Linux¡¢MAC¡¢Windows
µÈ¶àÖÖ²Ù×÷ϵͳ ÓëÆäËûµÄ´óÐÍÊý¾Ý¿âÀýÈçOracle¡¢DB2¡¢SQL ServerµÈÏà±È¹¦ÄÜÉÔÈõ
һЩ ÌâÍâ»°£ºPostgresql&n ......