mysqlµÄÐ¶ÔØÎÊÌ⣡
×î½üÔÚѧϰtomcat+mysql¿ª·¢web£¬ÔÚ°²×°ºÍÐ¶ÔØmysqlµÄ¹ý³ÌÖÐÓöµ½ÁËһЩÎÊÌ⣬ÕÛÌÚÁËÎҺü¸Ìì¡£ÔÚÕâÀï¸ø´ó¼Ò½ÌÒ»ÏÂÍêÕûµÄÐ¶ÔØmysqlµÄ¹ý³Ì¡£
ÓÐʱºò֮ǰ°²×°¹ýmysqlÐ¶ÔØºóÓÖÖØÐ°²×°µÄ¹ý³ÌÖУ¬°²×°ºÃµÄmysql½ø²»È¥£¬ÈÃÈ˾õµÃºÜÐÄ·³£¬×Ô¼ºÒÑ¾Ð¶ÔØÁË£¬ÖØÐÂ×°Á˺óΪʲô½ø²»È¥ÄØ¡·£¿£¿ ÔÒòÊÇÐ¶ÔØ¹ý³Ì²¢²»ÍêÕû¡£ÎҰѹý³ÌÖзÖΪÒÔϼ¸¸ö¹ý³Ì¡£
1£ºµ½¿ØÖÆÃæ°å———Ìí¼Ó»òɾ³ý³ÌÐòÀïÕÒµ½mysqlÑ¡ÔñÐ¶ÔØ£»
2£º°ÑÕâ¸öÎļþҲɾ³ýÁËX:\Program Files\MySQL£¬¾ÍÊǰÑÕâ¸öĿ¼Ҳɾ³ýÁË£»
3£ºÏÂÃæÒ²¾ÍÊÇ×îÖØÒªµÄÒ»µã£¬Ò²ÊÇÈúܶàÈËÀ§»óµÄÒ»µã¡£ÆäʵmysqlµÄ°²×°¹ý³ÌÖÐÒѾÔÚÕâ¸öĿ¼ĬÈÏÁËÒ»¸ömysqlÎļþ£»
ÔÚX:\Documents and Settings\All Users\Application DataÔÚÕâ¸öĿ¼Ï»¹ÓÐÒ»¸ömysqlÎļþ£¬°ÑÕâҲɾ³ýÁË£¬Õâ¾ÍÍêÃÀÐ¶ÔØÁË¡£
½ÓÏÂÀ´Äã¾ÍÄÜÖØÐ°²×°ÄãµÄmysqlÁË£¬È»ºó½øÐÐÅäÖá£
ºÙºÙ£¬×£ÄãÃdzɹ¦¡£ ÎÒÊǸö´ó²ËÄñ£¬Ï£ÍûÄܰïÖúµ½Ò»Ð©ºÍÎÒÒ»ÑùµÄ²ËÄñ£¬ÉÙ×ßÍä·£¬ÎÒ×ßÁË£¬Äã¾Í²»ÒªÁË£¡£¡
Ïà¹ØÎĵµ£º
Æô¶¯mysqlµÄ·þÎñ¾³£·¢ÏÖ1067Õâ¸ö´íÎ󡣲鿴ʼþÈÕÖ¾ÒÔºó·¢ÏÖÏÂÃæµÄ´íÎóÐÅÏ¢
Unknown/unsupported table type: INNODB
ÈçºÎ½â¾ö£ºÔÚmysqlÊý¾Ý´æ·ÅĿ¼ÏÂÕÒµ½ ibdata ÒÔ¼°ib_logfile0¡¢ib_logfile1ɾµôÔÙÆô¶¯¾ÍºÃÁË ......
MySQLÈÕÆÚ×ֶηÖDateºÍTimeÁ½ÖÖ£¬oracleÈÕÆÚ×Ö¶ÎÖ»ÓÐDate£¬°üº¬ÄêÔÂÈÕʱ·ÖÃëÐÅÏ¢£¬Óõ±Ç°Êý¾Ý¿âµÄϵͳʱ¼äΪsysdate,¾«È·µ½Ã룬»òÕßÓÃ×Ö·û´®×ª»»ÈÕÆÚÐͺ¯Êý£º
To_date('2001-08-01','YYYY-MM-DD'); Äê-ÔÂ-ÈÕ
24Сʱ£º·ÖÖÓ£ºÃëµÄ¸ñʽ 'YYYY-MM-DD HH24:MI:SS'  ......
MySQLÓжàÖÖ´æ´¢ÒýÇæ£º
MyISAM¡¢InnoDB¡¢MERGE¡¢MEMORY(HEAP)¡¢BDB(BerkeleyDB)¡¢EXAMPLE¡¢FEDERATED¡¢ARCHIVE¡¢CSV¡¢BLACKHOLE¡£
MySQLÖ§³ÖÊý¸ö´æ´¢ÒýÇæ×÷Ϊ¶Ô²»Í¬±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£MySQL´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎñ°²È«±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎñ°²È«±íµÄÒýÇæ£º
¡ô MyISAM¹ÜÀí·ÇÊÂÎñ±í¡£ËüÌṩ¸ßËÙ´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡ ......
package com.wxpn.tutorial.db;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.Statement;
import java.util.Date;
/**
* ÃèÊö: Êý¾Ý¿âÁ¬½Ó³ØÀà
*
*
&n ......
ÍøÕ¾µÄÊý¾Ý¿âÊǵ÷ÓÃÔ¶³Ì·þÎñÆ÷ÉϵÄ,²»ÊDZ¾»úµÄ.ÍøÕ¾´ò¿ª±È½ÏÂý.ÔÚÍøÉÏËÑË÷ÁË·½·¨,Õâ¸ö·½·¨¿ÉÒÔ½â¾ö,µ«ÊÇÓÐÁíÍâµÄÎÊÌâ³öÏÖ:
-----------------------------------------------------------------------
ÔÚ¾ÖÓòÍøÄÚÁ¬½ÓÆäËû»úÆ÷µÄMYSQL,·¢ÏÖËÙ¶ÈÂýµÄºÜ,²»ÖªµÀʲôÔÒò,×ÜÓм¸ÃëµÄÑÓ³Ù.
ºóÀ´ÔÚÍøÉÏ·¢ÏÖ½â¾ö·½·¨,my.iniÀïÃæÌ ......