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

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();
  }
}


Ïà¹ØÎĵµ£º

Java ÃæÏò¶ÔÏóµÄÌØµã

1£®1 ÃæÏò¶ÔÏóµÄ»ù±¾¸ÅÄî
¡¡¡¡ÃæÏò¶ÔÏóµÄ»ù±¾Ë¼Ïë
¡¡¡¡ÃæÏò¶ÔÏóÊÇÒ»ÖÖÐÂÐ˵ijÌÐòÉè¼Æ·½·¨,»òÕßÊÇÒ»ÖÖеijÌÐòÉè¼Æ¹æ·¶(paradigm),Æä»ù±¾Ë¼ÏëÊÇʹÓöÔÏó¡¢Àà¡¢¼Ì³Ð¡¢·â×°¡¢ÏûÏ¢µÈ»ù±¾¸ÅÄîÀ´½øÐÐ
³ÌÐòÉè¼Æ¡£´ÓÏÖʵÊÀ½çÖп͹۴æÔÚµÄÊÂÎ¼´¶ÔÏ󣩳ö·¢À´¹¹ÔìÈí¼þϵͳ£¬²¢ÇÒÔÚϵͳ¹¹ÔìÖо¡¿ÉÄÜÔËÓÃÈËÀàµÄ×ÔȻ˼ά·½Ê½¡£¿ª·¢ ......

ÉîÈëÀí½âjava·´Éä


Ò»¡¢Ê²Ã´ÊÇ·´É䣺
      ·´ÉäµÄ¸ÅÄîÊÇÓÉSmithÔÚ1982ÄêÊ×´ÎÌá³öµÄ£¬Ö÷ÒªÊÇÖ¸³ÌÐò¿ÉÒÔ·ÃÎÊ¡¢¼ì²âºÍÐÞ¸ÄËü±¾Éí״̬»òÐÐΪµÄÒ»ÖÖÄÜÁ¦¡£ÕâÒ»¸ÅÄîµÄÌá³öºÜ¿ìÒý·¢Á˼ÆËã»ú¿ÆÑ§ÁìÓò¹ØÓÚÓ¦Ó÷´ÉäÐÔµÄÑо¿¡£ËüÊ×Ïȱ»³ÌÐòÓïÑÔµÄÉè¼ÆÁìÓòËù²ÉÓÃ,²¢ÔÚLispºÍÃæÏò¶ÔÏó·½ÃæÈ¡µÃÁ˳ɼ¨¡£ÆäÖÐLEAD/LEAD++ ¡¢Open ......

mySqlÖÐÈçºÎÅúÁ¿¸üмÆÊýÆ÷


¼ÙÈçÎÒÃǵÄmysqlÓÐÒ»¸ö¼ÆÊýÆ÷£¬¶øÕâ¸ö¼ÆÊýÆ÷ÐèÒªÎÒÃÇÖØÐÂͳ¼Æ£¬Ôõô°ìÄØ£¿
Ó¦Óó¡¾°£¬±ÈÈç˵ÓÐÒ»¸öÉ̳¡£¬Ã¿ÂôÒ»¸ö²úÆ·¶¼²úÉúÒ»¸öÁ÷Ë®£¬È»ºóÎÒÃÇÐèÒªÖªµÀÿ±ÊÁ÷Ë®ÊǸòúÆ·µÚ¼¸´Î³öÊ۵ģ¬ÕâÑù˵¿ÉÄܲ»Ã÷°×£¬ÎÒÄÃÒ»¸öÏêϸµÄÊý¾Ý
¾ÙÀý°É¡£
recordID,productID,productType,sellDate,counter
1, 1, 1, '2010-1-15 15:20:10 ......

Ôõô°Ñpowerdesignerµ¼³öµÄsqlÓÃPHPµ¼ÈëMysQLÊý¾Ý¿â

ÎÒÃÇÖªµÀÓÃpowerdesignerµ¼³öµÄsqlÎļþºó׺Ϊ'.sql'£»ÓÃphpmyadminºÜÈÝÒ×µ¼ÈëMysQLÊý¾Ý¿â£¬µ«ÊÇÓÃPHPÔõôµ¼ÈëÊý¾Ý¿âÄØ?
ÎÒÓÃpowerdesignerÉè¼ÆÒ»¸öÊý¾Ý¿âºóµ¼³ösqlÎļþ£¨Ò»¸öͶƱϵͳ£©Îª'vote.sql'£»
ÎļþÄÚÈÝΪ£¨Ò»Ð©sqlÓï¾äºÍ×¢ÊÍ£©£º
        
/*======================= ......

JAVA ÀíÂÛ×ܽá

Ò».±àд¹¹ÔìÆ÷µÄÓÐЧ׼Ôò£º       Óþ¡¿ÉÄܼòµ¥µÄ·½·¨Ê¹¶ÔÏó½øÈëÕý³£×´Ì¬£¬Èç¹û¿ÉÒԵϰ£¬±ÜÃâµ÷ÓÃÆäËû·½·¨¡£ÔÚ¹¹ÔìÆ÷ÄÚΨһÄܹ»°²È«µ÷ÓõÄÄÇЩ·½·¨ÊÇ»ùÀàÖеÄfinal·½·¨£¨Ò²ÊÊÓÃÓÚprivate·½·¨£¬ËüÃÇ×Ô¶¯ÊôÓÚfinal·½·¨£©¡£ ¶þ.Óü̳нøÐÐÉè¼ÆµÄ×¼Ôò£º     Óü̳бí´ïÐÐΪ¼äµÄ²îÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ