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

ÓÃjavaÁ¬½ÓMySqlÊý¾Ý¿â

 Ò»¸ö¼òµ¥Ê¾Àý--
1£¬×¼±¸£ºMySQLÊý¾Ý¿âÇý¶¯°ü¡¾mysql-connector-java-5.1.10-bin.jar¡¿µ¼Èë
2£¬´´½¨²âÊÔÁ¬½ÓÖ÷³ÌÐò
package mysqlConnection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class JdbcDemo {
public static void main(String[] args) {
try {
//Êý¾Ý¿âÁ¬½ÓMySQL
Connection conn=null;
Statement stmt=null;
//MySQLÇý¶¯Ãû
String className="com.mysql.jdbc.Driver";
//ÒªÁ¬½ÓµÄURL,localhostÊÇÁ¬½Ó±¾µØ£¬Èç¹ûÁ¬½ÓÆäËû»úÆ÷¸ÄΪIPµØÖ·3306ÊÇMysqlĬÈ϶˿ڣ¬testÊÇÄãÒª²Ù×÷µÄÊý¾Ý¿âµÄÃû³Æ£¬Êý¾Ý¿âÒªÓвÅÐÐ
String url="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8";
//mySqlµÄÓû§ÃûÃÜÂëÒª¸ÄΪÄã×Ô¼ºµÄmysqlÊý¾Ý¿âµÄÓû§Ãû¡¢ÃÜÂë
String user="root";
String password="1314520";
//ÏÂÃæÈýÐÐÊǹ̶¨Ð´·¨
Class.forName(className);
conn=DriverManager.getConnection(url, user, password);
stmt=conn.createStatement();
//¿ªÊ¼²åÈë²Ù×÷£¬ut_testÊÇtestÊý¾Ý¿âÖеÄÒ»ÕÅ±í£¬ÓÐname,age,emailÈý¸ö×ֶΣ¬²åÈëµÄÖµÊÇ'ÁõÒü',22,'354559242@qq.com'¡£
String sql="insert into ut_test(name,age,email) values ('ÁõÒü',22,'354559242@qq.com') ";
//Ö´ÐвÙ×÷
stmt.execute(sql);
System.out.println("²åÈë³É¹¦£¡");
} catch(Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}


Ïà¹ØÎĵµ£º

JavaÐÂÊÖÈëÃźÜÖØÒªµÄ¼¸¸ö»ù±¾¸ÅÄî


¡¡finalÀࣺΪ·ÀÖ¹ËûÈË´ÓÄãµÄÀàÉÏÅÉÉúÐÂÀ࣬´ËÀàÊDz»¿ÉÀ©Õ¹µÄ¡£
¡¡¡¡¶¯Ì¬µ÷ÓñȾ²Ì¬µ÷Óû¨·ÑµÄʱ¼äÒª³¤¡£
¡¡¡¡³éÏóÀࣺ¹æ¶¨Ò»¸ö»ò¶à¸ö³éÏó·½·¨µÄÀà±¾Éí±ØÐ붨ÒåΪabstract¡£
¡¡¡¡Àý£º public abstract string getDescripition
¡¡¡¡JavaÖеÄÿһ¸öÀà¶¼ÊÇ´ÓObjectÀàÀ©Õ¹¶øÀ´µÄ¡£
¡¡¡¡objectÀàÖеÄequalºÍtoString·½·¨¡ ......

11 advanced MySQL questions

 

Explain MySQL architecture
. - The front layer
takes care of network connections and security authentications, the
middle layer does the SQL query parsing, and then the query is handled
off to the storage engine. A storage engine could be either a default
one supp ......

¿ªÆô MySQL query cache£¬¼Ó¿ìÊý¾Ý¿â¶ÁÈ¡ËÙ¶È

 
ÔÚÍøÕ¾½¨Éè»òÕßÔËÓªÖУ¬Èç¹û MySQL server ÊǷdz£·±Ã¦£¬¿ÉÒÔ¿ªÆô query cache ÒÔ¼ÓËÙ»ØÓ¦Ê±¼ä£¬¿ªÆô·½·¨¿ÉÒÔÔÚ my.cnf 裡Ãæ¼ÓÈëÒÔÏÂÏîÄ¿: (Redhat ÏÂÃæÊÇ /etc/my.cnf£»Debian ÊÇÔÚ etc/mysql
/my.cnf).
query_cache_size = 64M
query_cache_type = 1
query_cache_limit = 1048576
ÒÔÉÏÓï·¨µÄÉ趨ÀïÃæ£¬ ......

mysqlĬÈÏÊÇÖ»ÄÜ´Ólocalhost·ÃÎÊ

 ËùÒÔ³ýÁ˸øÕË»§È¨ÏÞÒÔÍâ »¹ÓÐÐÞ¸Ä /etc/mysql/my.cnf
ÕÒµ½ bind-address = 127.0.0.1 ÐÞ¸ÄΪ bind-address = 0.0.0.0
ÖØÆômysql : sudo /etc/init.d/mysql restart
·ñÔò»á±¨ ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x' (111)
ºÃ°É ÎÒÊÇmysql²ËÄñ ÒÔǰ¶¼ÊÇ×ßlocalhostµÄ
......

mysql±äÁ¿ÀàÐÍ

9.3. Óû§±äÁ¿
¿ÉÒÔÏÈÔÚÓû§±äÁ¿Öб£´æÖµÈ»ºóÔÚÒÔºóÒýÓÃËü£»ÕâÑù¿ÉÒÔ½«Öµ´ÓÒ»¸öÓï¾ä´«µÝµ½ÁíÒ»¸öÓï¾ä¡£Óû§±äÁ¿ÓëÁ¬½ÓÓйØ
¡£Ò²¾ÍÊÇ˵£¬Ò»¸ö¿Í»§¶Ë¶¨ÒåµÄ±äÁ¿²»Äܱ»ÆäËü¿Í»§¶Ë¿´µ½»òʹÓᣵ±¿Í»§¶ËÍ˳öʱ£¬¸Ã¿Í»§¶ËÁ¬½ÓµÄËùÓбäÁ¿½«×Ô¶¯ÊÍ·Å¡£
Óû§±äÁ¿µÄÐÎʽΪ@var_name
£¬ÆäÖбäÁ¿Ãûvar_name
¿ÉÒÔÓɵ±Ç°×Ö· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ