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

JavaÊý¾Ý¿â°üjava.sql.*Ïê½â(jdk1.6)

1:Ó¦ÓóÌÐò²»ÔÙÐèҪʹÓà Class.forName() ÏÔʽµØ¼ÓÔØ JDBC Çý¶¯³ÌÐò¡£µ±Ç°Ê¹Óà Class.forName() ¼ÓÔØ JDBC Çý¶¯³ÌÐòµÄÏÖÓгÌÐò½«ÔÚ²»×÷Ð޸ĵÄÇé¿öϼÌÐø¹¤×÷¡£
2:ÐèҪעÒâÒÔÏÂÃüÁ
executeUpdate£ºÊÇ×î»ù´¡µÄÊý¾Ý¿âµÄ¸üС¢²åÈëºÍɾ³ý²Ù×÷¡£Ð§ÂʵÍÏ¡£   
executeQuery£ºÊÇ×î»ù´¡µÄÖ´ÐвéѯÓï¾ä£¬Í¬ÑùÒ²ÊÇЧÂʵÍÏ¡£   
execute£º¼æ¾ßÉÏÃæ¶þÕߵŦÄܵ«·µ»ØÒ»¸öbooleanÐͱäÁ¿
executeBatch£ºn¸öSQLÓï¾ä³õʼ»¯ºÃ£¬Ò»ÆðÌá½»¸øÊý¾Ý¿âÖ´ÐУ¬Ð§Âʺܸߣ¡£¡£¡½¨ÒéʹÓÃ
3£ºÓÉ2¿ÉÖª£¬²åÈë²Ù×÷²»ÄÜÓÉexcuteQueryÀ´Ö´ÐÐ:
String n=request.getParameter("userName");
String sql=" insert into user value( null,' "+n+" ' ) ";
stmt.execute(sql);


Ïà¹ØÎĵµ£º

javaÁ¬½Ó³Ø¼¼Êõ

2009-04-14 15:37
ËäÈ»ÏÖÔÚÓÃAPACHE COMMONS DBCP¿ÉÒԷdz£·½±ãµÄ½¨Á¢Êý¾Ý¿âÁ¬½Ó³Ø£¬
µ«ÊÇÏñÕâÆªÎÄÕ°ÑÊý¾Ý¿âÁ¬½Ó³ØµÄÄÚ²¿Ô­ÀíдµÄÕâô͸³¹£¬×¢ÊÓÕâôÍêÕû£¬
ÕæÊǷdz£Äѵã¬Èÿª·¢ÈËÔ±¿ÉÒÔ¸üÉî²ã´ÎµÄÀí½âÊý¾Ý¿âÁ¬½Ó³Ø£¬ÕæÊǷdz£¸Ð
лÕâÆªÎÄÕµÄ×÷Õß¡£
import java.sql.Connection;
import java.sql.DatabaseMetaData; ......

ÔÚJavaÓ¦ÓóÌÐòÖÐʹÓÃJfreechartÅäÖÃ[z]

ÕªÒª£º±¾ÎĽ«Ì¸Ì¸ÔÚJavaÓ¦ÓóÌÐòÖÐʹÓÃJfreechartÅäÖã¬JFreeChartÊÇÓÃJava¿ª·¢µÄÒ»¸öÃâ·ÑµÄchartͼÐδ¦ÀíÀà¿â¡£
²âÊÔ»·¾³£º
OS¡¡£ºWindowsXP
Java£ºjdk1.5.0_06
JFreeChart£º1.0.9£¨2008Äê3Ô¡¡×îа汾£©
ÒòΪJFreeChart²ÉÓÃJava¿ª·¢¶ø³É£¬ËùÒÔÔÚÆäËûϵͳҲÄÜÕý³£ÔËÐС£
JFreeChartµÄ°²×°
1£¬ÏÂÔØ
´ÓSourceforge. ......

SQL_ѧÉú

 
µÚ¶þ²¿·Ö
1.ËùÓÐÄÐÉúµÄÐÕÃû¡¢ÄêÁä:
Select Sname£¬Sage
from student;
2.ËùÓÐÄêÁä´óÓÚ20£¬¼ÆËã»ú¿ÆÑ§ÏµÑ§ÉúÃûµ¥:
SELECT Sname
from Student
WHERE Sage>20 AND Sdept='CS';
3.³É¼¨´óÓÚ60µÄѧÉúѧºÅ:
SELECT Sno
from SC
WHERE Grade>60;
4.³É¼¨ÔÚ70µ½80Ö®¼äµÄѧÉúѧºÅ:
SELECT Sno
from SC ......

Java/JspÅäÖÃ

JAVAÅäÖãº
1£º JAVA_HOME £º  C:\Program Files\Java\jdk1.6.0_12
2£ºCLASSPATH £º    .;%JAVA_HOME%\lib;%JAVA_HOME%\lib\tools.jar
3£ºPATH £º              %JAVA_HOME%\bin;%JAVA_HOME%\jre\bin
TomcatÅäÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ