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();
}
}
Ïà¹ØÎĵµ£º
½«Ä³ class ²úÉú³öÒ»¸ö instance Ö®ºó£¬´Ë class ËùÓÐµÄ instance field ¶¼»áÐÂÔöÒ»·Ý£¬ÄÇôËùÓÐµÄ instance method ÊÇ·ñÒ²»áÐÂÔöÒ»·Ý£¿´ð°¸ÊDz»»á£¬ÎÒÃÇÓÃfield±íʾ×ֶΣ¬ÓÃmethod±íʾ·½·¨£¬ÄÇô¼ÓÉÏstaticÇø·Öºó¾Í ÓÐËÄÖÖ£º
class field£ºÓÐÓÃstaticÐÞÊεÄfield
class method£ºÓÐÓÃstaticÐÞÊεÄmethod
instance fi ......
Ò»¡¢Ê²Ã´ÊÇ·´É䣺
·´ÉäµÄ¸ÅÄîÊÇÓÉSmithÔÚ1982ÄêÊ×´ÎÌá³öµÄ£¬Ö÷ÒªÊÇÖ¸³ÌÐò¿ÉÒÔ·ÃÎÊ¡¢¼ì²âºÍÐÞ¸ÄËü±¾Éí״̬»òÐÐΪµÄÒ»ÖÖÄÜÁ¦¡£ÕâÒ»¸ÅÄîµÄÌá³öºÜ¿ìÒý·¢Á˼ÆËã»ú¿ÆѧÁìÓò¹ØÓÚÓ¦Ó÷´ÉäÐÔµÄÑо¿¡£ËüÊ×Ïȱ»³ÌÐòÓïÑÔµÄÉè¼ÆÁìÓòËù²ÉÓÃ,²¢ÔÚLispºÍÃæÏò¶ÔÏó·½ÃæÈ¡µÃÁ˳ɼ¨¡£ÆäÖÐLEAD/LEAD++ ¡¢Open ......
ÎÒÃÇÖªµÀÓÃpowerdesignerµ¼³öµÄsqlÎļþºó׺Ϊ'.sql'£»ÓÃphpmyadminºÜÈÝÒ×µ¼ÈëMysQLÊý¾Ý¿â£¬µ«ÊÇÓÃPHPÔõôµ¼ÈëÊý¾Ý¿âÄØ?
ÎÒÓÃpowerdesignerÉè¼ÆÒ»¸öÊý¾Ý¿âºóµ¼³ösqlÎļþ£¨Ò»¸öͶƱϵͳ£©Îª'vote.sql'£»
ÎļþÄÚÈÝΪ£¨Ò»Ð©sqlÓï¾äºÍ×¢ÊÍ£©£º
/*======================= ......
ÖÕÓڷżÙÁË£¬ÕýÏëÔÚÕâ¸ö¼ÙÆÚÀïѧѧPHP£¬ÓÉÓÚ×Ô¼ºÓõÄÊÇ×ÀÃæ°æµÄUbuntu8.04,ÓÚÊǾÍÏë¼ÜÉèÒ»¸öLAMP»·¾³À´Ñ§PHP£¬Ò²³Ã´Ë»ú»áѧһÏÂPHP·þÎñÆ÷µÄ¼ÜÉè¡£
Ò»¡¢°²×°Ubuntu8.04
ËäȻ˵ÊÇÅäÖÃLAMP»·¾³£¬µ«ÔÚÎÄÕÂÀï²¢²»»á½²ÊöÈçºÎ°²×°Ubuntu8.04,ÒòΪ¹ØÓÚÈçºÎUbuntu8.04ÔÚÍøÉÏÒѾÓкܶàµÄ½Ì³ÌÁË£¬¾ÍËãÊÇÓ²ÅÌ°²×°Ò²ÊÇÒ»¼þºÜ¼òµ¥µÄÊÂÁ ......
Ò».ÏîÄ¿¼ò½é£º
¡¡¡¡JAVAÓïÑÔÊÇÒ»ÖÖ¿ÉÒÆÖ²µÄ£¬¼òµ¥µÄ£¬½¡×³µÄǶÈëʽÓïÑÔ¡£²¢ÇÒ¶ÔÍøÂ磬Êý¾Ý¿âÓкܺõÄÖ§³Ö£¬»ùÓÚJAVAÓïÑÔµÄÕâÖÖÌØÐÔ¿ÉÒÔÊ®·ÖÈÝÒ׵ؽ¨Á¢Ò»¸öСÐÍINTERNET·þÎñÆ÷¡£
¡¡¡¡±¾ÏîÄ¿ÖУ¬×÷ÕßÓÃJAVAÓïÑÔ±àдÁËÒ»¸öWEB΢ÐÍ·þÎñÆ÷£¬¶Ô¼òµ¥µÄHTTPÇëÇó½øÐÐÏìÓ¦£¬²¢Í¨¹ýºó¶ËÊý¾Ý¿â¶ÔÓû§µÄ²éѯ½øÐд¦Àí£¬´Ó¶ø¶¯Ì¬µØ·µ»ØHT ......