ÓÃ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();
}
}
}
Ïà¹ØÎĵµ£º
Enum×÷ΪSunÈ«ÐÂÒý½øµÄÒ»¸ö¹Ø¼ü×Ö£¬¿´ÆðÀ´ºÜÏóÊÇÌØÊâµÄclass, ËüÒ²¿ÉÒÔÓÐ×Ô¼ºµÄ±äÁ¿£¬¿ÉÒÔ¶¨Òå×Ô¼ºµÄ·½·¨£¬¿ÉÒÔʵÏÖÒ»¸ö»òÕß¶à¸ö½Ó¿Ú¡£ µ±ÎÒÃÇÔÚÉùÃ÷Ò»¸öenumÀàÐÍʱ£¬ÎÒÃÇÓ¦¸Ã×¢Òâµ½enumÀàÐÍÓÐÈçϵÄÒ»Ð©ÌØÕ÷¡£
¡¡ ......
package com.xinnuo.jdbc;
import java.io.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
/*
* ¸ÃÀàÖ»ÄÜ´´½¨Ò»¸öʵÀý£¬ÆäËü¶ÔÏóÄܹ»µ÷ÓÃÆä¾²Ì¬·½·¨£¨Ò²³ÆÎªÀà·½·¨£©»ñµÃ¸ÃΨһʵÀýµÄÒýÓá£
* DBConnectionManagerÀàµÄ½¨¹¹º¯ÊýÊÇ˽Óеģ¬ÕâÊÇΪÁ˱ÜÃâÆäËü¶ÔÏó´´½¨¸ÃÀ ......
±³¾°£ºÄ³¸öϵͳµÄmysqlÊý¾Ý¿âdnname²ÉÓÃĬÈϵÄlatin1×Ö·û¼¯£¬ÏµÍ³Éý¼¶ÐèÒª½«ËùÓÐÊý¾Ýת»»³Éutf-8¸ñʽ£¬Ä¿±êÊý¾Ý¿âΪnewdbname(½¨¿âʱʹÓÃutf8)
·½·¨Ò»£º
²½ÖèÒ» ÃüÁîÐÐÖ´ÐУºmysqldump --opt -hlocalhost -uroot -p*** --default-character-set=lantin1 dbname > /usr/local/dbname.sql
²½Öè¶þ ½« dbname.s ......
ÔÚÍøÕ¾½¨Éè»òÕßÔËÓªÖУ¬Èç¹û 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ÊǷdzּÌÁ¬½Óº¯Êý¶ømysqliÊÇÓÀÔ¶Á¬½Óº¯Êý¡£Ò²¾ÍÊÇ˵
mysqlÿ´ÎÁ´½Ó¶¼»á´ò¿ªÒ»¸öÁ¬½ÓµÄ½ø³Ì¶ømysqli¶à´ÎÔËÐÐmysqli½«Ê¹ÓÃͬһÁ¬½Ó½ø³Ì,´Ó¶ø¼õÉÙÁË·þÎñÆ÷µÄ¿ªÏú
ÓÐЩÅóÓÑÔÚ±à³ÌµÄʱºò£¬Ê¹ÓÃnew mysqli('localhost', usenamer', 'password', 'databasename');×ÜÊDZ¨´í£¬Fatal error: Class 'mysqli' not found in ......