jdbcÁ¬½ÓmysqlÎÊÌâ
Java code:
import java.sql.*;
public class DBTester1 {
public static void main(String[] args) throws Exception {
Connection con;
Statement stmt;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl =
"jdbc:mysql://localhost:3306/STOREDB?useUnicode=true&characterEncoding=GB2312";
String dbUser = "dbuser";
String dbPwd ="1234";
con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt= con.createStatement();
stmt.executeUpdate("insert into CUSTOMERS (NAME,AGE,ADDRESS)"
+"VALUES('СÍõ',20,'ÉϺ£')");
rs = stmt.executeQuery("SELECT ID,NAME,AGE,ADDRESS from CUSTOEMRS");
while(rs.next())
{
long id = rs.getLong(1);
String name = rs.getString(2);
int age = rs.getInt(3);
String address = rs.getString(4);
System.out.println("id="+id+",name="+name+",age="+age+",address="+address);
}
stmt.executeUpdate("delete from CUSTOMERS where name='СÍõ'");
rs.close();
stmt.close();
con.close();
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
±í½á¹¹
mysqlÊý¾Ý
ÍøÒ³ÏÔʾµÄÊý¾Ý
ÏÖÔÚÎÊÌâ¾ÍÊÇ£¬³ýÁËÖ÷¼üÓÐÖµÍ⣬ÆäËü×Ö¶ÎÈ«²¿Îª¿Õ¡£
ÕâÀïºÍÈÕÎÄÓйØÏµ£¬Ï£ÍûÓÐÄÜÓÐÄãµÄ°ïÖú¡£Ð»Ð»
ÓÐʱºòһˢеÄʱºò£¬»¹³öÏÖÕâÖÖÎ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......