javaÁ¬½ÓmysqlÊý¾Ý¿â
Ê×ÏÈ£¬ÒªÏÂÔØÒ»¸öÁ¬½ÓmysqlÊý¾Ý¿âµÄÇý¶¯³ÌÐò: mysql-connector-java-3.0.15-ga-bin.jar, Õâ¸öÇý¶¯³ÌÐò²»ÐèÒª×öÆäËüÅäÖÃ,Ò²¾ÍÊÇ˵£¬¶ÔÓÚmysqlÊý¾Ý¿â£¬²»±ØÏñaccess»òÕßoracleÒª½¨Á¢odbcÊý¾ÝÔ´¡£
Æä´Î£¬½«ÉÏÃæµÄ.jarÎļþ¼ÓÈëµ½classpath»·¾³±äÁ¿ÖС£
×îºó£¬¾ÍÊÇд´úÂë½øÐвâÊÔÁË¡£
Ö÷Òª´úÂëÈçÏ£º
import java.sql.*;
public class Test{
private Connection conn;
private Statement stat;
public Test()
{
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//¼ÓÔØÇý¶¯³ÌÐò
Class.forName("com.mysql.jdbc.Driver"); //¼ÓÔØÇý¶¯³ÌÐò
}
catch (Exception ex)
{
System.out.println("sql exception: driver ERROR!!!!");
ex.printStackTrace();
}
try
{
conn = DriverManager.getConnection("jdbc:mysql://10.64.10.100:3306/test","root","root");//½¨Á¢Á¬½Ó£¬
stat = conn.createStatement();//´´½¨Statement¶ÔÏó
}
catch (SQLException ex)
{
//sql exception
System.out.println("sql exception: connect or driver!!!!");
ex.printStackTrace();
}
}
Ïà¹ØÎĵµ£º
1£®1 ÃæÏò¶ÔÏóµÄ»ù±¾¸ÅÄî
¡¡¡¡ÃæÏò¶ÔÏóµÄ»ù±¾Ë¼Ïë
¡¡¡¡ÃæÏò¶ÔÏóÊÇÒ»ÖÖÐÂÐ˵ijÌÐòÉè¼Æ·½·¨,»òÕßÊÇÒ»ÖÖеijÌÐòÉè¼Æ¹æ·¶(paradigm),Æä»ù±¾Ë¼ÏëÊÇʹÓöÔÏó¡¢Àà¡¢¼Ì³Ð¡¢·â×°¡¢ÏûÏ¢µÈ»ù±¾¸ÅÄîÀ´½øÐÐ
³ÌÐòÉè¼Æ¡£´ÓÏÖʵÊÀ½çÖп͹۴æÔÚµÄÊÂÎ¼´¶ÔÏ󣩳ö·¢À´¹¹ÔìÈí¼þϵͳ£¬²¢ÇÒÔÚϵͳ¹¹ÔìÖо¡¿ÉÄÜÔËÓÃÈËÀàµÄ×ÔȻ˼ά·½Ê½¡£¿ª·¢ ......
1.JavaµÄ´úÂëÒ»°ã·ÖΪÁ½´óÀࣺһÖÖÊǽṹ¶¨ÒåÓï¾ä£»Ò»ÖÖÊǹ¦ÄÜÓï¾ä£¨¹¦ÄÜÓï¾äÒªÓ÷ֺŽá⣩¡£
2.ÓÃ/* ÄÚÈÝ */×¢ÊÍ£¬ÄÚÈÝÀïÃæÊDz»ÄÜ´æÔÚ/* */µÄ£»µ«ÊÇ¿ÉÒÔ´æÔÚ//£»ÒòΪÕâÑù¾Í²»»á·¢Éúϵͳ²»ÖªµÀÄĸö*/²ÅÊÇÕæµÄ½áÊø·û¡£
3.±äÁ¿Ê¹ÓÃǰ±ØÐë³õʼ»¯£¬Ê¹Óõ¥ÒýºÅµÄ×÷ÓþÍÊǰÑÀïÃæµÄ×Ö ......
ʱ¼ä¹ýµÄÕæ¿ì£¬²»Öª²»¾õÀ´µ½´«ÖDz¥¿ÍÒѾһ¸ö¶àÔÂÁË£¬ÕâÒ»¸öÔÂÖ÷ҪѧϰÁËJava»ù´¡²¿·Ö£¬ËäȻÿÌì¶¼ÊÇÇôúÂëµ½ÍíÉÏ1¡¢2µã²Å˯¾õ£¬µ«ÊÇ»¹ÊǸоõʱ¼ä²»¹»Óã¬ÒòΪÐèҪѧϰ¹®¹ÌµÄ¶«Î÷Ì«¶àÌ«¶àÁË£¬×ܸоõÕÆÎյIJ»¹»ºÃ£¬ÕâÒ»¸öÔ¹ýµÄºÜÀÛµ«Ò²ºÜ³äʵ¡£
Õ⼸Ì쿪ʼ ......
ÔÚeclipseÖÐн¨ÁËÒ»¸öwebÏîÄ¿ È»ºóÔÚwebÏîÄ¿ÖÐÏëÌí¼Óflex ¿ª·¢Ç°Ì¨¡£ÔÚwebÏîÄ¿ÃûÉϵã»÷ÓÒ¼ü ----flex project Nature ----- Add flex project Nature ÔÚµ¯³öµÄ¶Ô»°¿òÖÐ ÉèÖÃÈçͼ£º
È»ºó µã»÷ next
Flex WAR file £º Ñ¡Ôñ ÄãµÄblazeds µÄ·¾¶ È»ºóµã»÷ Finish
½á¹û ÏîÄ¿ÏÔʾº ......
¼ÙÈçÎÒÃǵÄmysqlÓÐÒ»¸ö¼ÆÊýÆ÷£¬¶øÕâ¸ö¼ÆÊýÆ÷ÐèÒªÎÒÃÇÖØÐÂͳ¼Æ£¬Ôõô°ìÄØ£¿
Ó¦Óó¡¾°£¬±ÈÈç˵ÓÐÒ»¸öÉ̳¡£¬Ã¿ÂôÒ»¸ö²úÆ·¶¼²úÉúÒ»¸öÁ÷Ë®£¬È»ºóÎÒÃÇÐèÒªÖªµÀÿ±ÊÁ÷Ë®ÊǸòúÆ·µÚ¼¸´Î³öÊ۵ģ¬ÕâÑù˵¿ÉÄܲ»Ã÷°×£¬ÎÒÄÃÒ»¸öÏêϸµÄÊý¾Ý
¾ÙÀý°É¡£
recordID,productID,productType,sellDate,counter
1, 1, 1, '2010-1-15 15:20:10 ......