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

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 server ÉϵÄС¼¼ÇÉ

ת×Ôhttp://www.linuxbyte.org/yi-ge-mysql-server-shang-de-xiao-ji-qiao.html
ÔÚmy.cnf µÄ mysql ¶Ë Ìí¼ÓÈçÏÂÉèÖÃ
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
prompt="(\u:mysql1@linuxbyte.org \R:\m)[\d]: "
»á²úÉúÈçÏÂЧ¹û:
root@ubuntu:/home/hew# mysql -u hew -p
Enter pass ......

MySQL´æ´¢ÒýÇæ

MySQLÓжàÖÖ´æ´¢ÒýÇæ£º
MyISAM¡¢InnoDB¡¢MERGE¡¢MEMORY(HEAP)¡¢BDB(BerkeleyDB)¡¢EXAMPLE¡¢FEDERATED¡¢ARCHIVE¡¢CSV¡¢BLACKHOLE¡£
MySQLÖ§³ÖÊý¸ö´æ´¢ÒýÇæ×÷Ϊ¶Ô²»Í¬±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£MySQL´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎñ°²È«±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎñ°²È«±íµÄÒýÇæ£º
¡ô MyISAM¹ÜÀí·ÇÊÂÎñ±í¡£ËüÌṩ¸ßËÙ´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡ ......

JSPÊý¾Ý¿âÁ¬½ÓÒÉÎÊ£¨Mysql£©

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 ......

¹ØÓÚMySQLµÄJDBCÇý¶¯µÄÎÊÌâ

°²×°JDBCÇý¶¯£º
½âѹËõmysql-connector-java-3.1.10.zip
½«ÒªÊ¹ÓõÄÊÇmysql-connector-java-3.1.10-bin-g.jarºÍmysql-connector-java-3.1.10-bin.jar
ÅäÖÃ
ÔÚC:\Program Files\JavaĿ¼Ï½¨Á¢mysqlforjdbc×ÓĿ¼£¬½øÈë¸ÃĿ¼½«mysql-connector-java-3.1.10-bin.jarµ½¸ÃĿ¼ÏÂ
½øÈëC:\Program Files\Java\jdk1.5.0_04\l ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ