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

java statement×÷ÓÃ


1¡¢´´½¨ Statement ¶ÔÏó
½¨Á¢Á˵½Ìض¨Êý¾Ý¿âµÄÁ¬½ÓÖ®ºó£¬¾Í¿ÉÓøÃÁ¬½Ó·¢ËÍ SQL Óï¾ä¡£Statement ¶ÔÏóÓà Connection µÄ·½·¨ createStatement ´´½¨£¬ÈçÏÂÁдúÂë¶ÎÖÐËùʾ£º
Connection con = DriverManager.getConnection(url, "sunny", "");
Statement stmt = con.createStatement();
ΪÁËÖ´ÐÐ Statement ¶ÔÏ󣬱»·¢Ë͵½Êý¾Ý¿âµÄ SQL Óï¾ä½«±»×÷Ϊ²ÎÊýÌṩ¸ø Statement µÄ·½·¨£º
ResultSet rs = stmt.executeQuery("SELECT a, b, c from Table2");
2¡¢Ê¹Óà Statement ¶ÔÏóÖ´ÐÐÓï¾ä
Statement ½Ó¿ÚÌṩÁËÈýÖÖÖ´ÐÐ SQL Óï¾äµÄ·½·¨£ºexecuteQuery¡¢executeUpdate ºÍ execute¡£Ê¹ÓÃÄÄÒ»¸ö·½·¨ÓÉ SQL Óï¾äËù²úÉúµÄÄÚÈݾö¶¨¡£
·½·¨ executeQuery ÓÃÓÚ²úÉúµ¥¸ö½á¹û¼¯µÄÓï¾ä£¬ÀýÈç SELECT Óï¾ä¡£
·½·¨ executeUpdate ÓÃÓÚÖ´ÐÐ INSERT¡¢UPDATE »ò DELETE Óï¾äÒÔ¼° SQL DDL£¨Êý¾Ý¶¨ÒåÓïÑÔ£©Óï¾ä£¬ÀýÈç CREATE TABLE ºÍ DROP TABLE¡£INSERT¡¢UPDATE »ò DELETE Óï¾äµÄЧ¹ûÊÇÐ޸ıíÖÐÁãÐлò¶àÐÐÖеÄÒ»Áлò¶àÁС£executeUpdate µÄ·µ»ØÖµÊÇÒ»¸öÕûÊý£¬Ö¸Ê¾ÊÜÓ°ÏìµÄÐÐÊý£¨¼´¸üмÆÊý£©¡£¶ÔÓÚ CREATE TABLE »ò DROP TABLE µÈ²»²Ù×÷ÐеÄÓï¾ä£¬executeUpdate µÄ·µ»ØÖµ×ÜΪÁã¡£
·½·¨ execute ÓÃÓÚÖ´Ðзµ»Ø¶à¸ö½á¹û¼¯¡¢¶à¸ö¸üмÆÊý»ò¶þÕß×éºÏµÄÓï¾ä¡£ÒòΪ¶àÊý³ÌÐòÔ±²»»áÐèÒª¸Ã¸ß¼¶¹¦ÄÜ£¬ËùÒÔ±¾¸ÅÊöºóÃæ½«ÔÚµ¥¶ÀÒ»½ÚÖÐ¶ÔÆä½øÐнéÉÜ¡£
Ö´ÐÐÓï¾äµÄËùÓз½·¨¶¼½«¹Ø±ÕËùµ÷ÓÃµÄ Statement ¶ÔÏóµÄµ±Ç°´ò¿ª½á¹û¼¯£¨Èç¹û´æÔÚ£©¡£ÕâÒâζ×ÅÔÚÖØÐÂÖ´ÐÐ Statement ¶ÔÏó֮ǰ£¬ÐèÒªÍê³É¶Ôµ±Ç° ResultSet ¶ÔÏóµÄ´¦Àí¡£
ӦעÒ⣬¼Ì³ÐÁË Statement ½Ó¿ÚÖÐËùÓз½·¨µÄ PreparedStatement ½Ó¿Ú¶¼ÓÐ×Ô¼ºµÄ executeQuery¡¢executeUpdate ºÍ execute ·½·¨¡£Statement ¶ÔÏó±¾Éí²»°üº¬ SQL Óï¾ä£¬Òò¶ø±ØÐë¸ø Statement.execute ·½·¨Ìṩ SQL Óï¾ä×÷Ϊ²ÎÊý¡£PreparedStatement ¶ÔÏó²¢²»½« SQL Óï¾ä×÷Ϊ²ÎÊýÌṩ¸øÕâЩ·½·¨£¬ÒòΪËüÃÇÒѾ­°üº¬Ô¤±àÒë SQL Óï¾ä¡£CallableStatement ¶ÔÏó¼Ì³ÐÕâЩ·½·¨µÄ PreparedStatement ÐÎʽ¡£¶ÔÓÚÕâЩ·½·¨µÄ PreparedStatement »ò CallableStatement °æ±¾£¬Ê¹Óòéѯ²ÎÊý½«Å׳ö SQLException¡£
3¡¢Óï¾äÍê³É
µ±Á¬½Ó´¦ÓÚ×Ô¶¯Ìύģʽʱ£¬ÆäÖÐËùÖ´ÐеÄÓï¾äÔÚÍê³Éʱ½«×Ô¶¯Ìá½»»ò»¹Ô­¡£Óï¾äÔÚÒÑÖ´ÐÐÇÒËùÓнá¹û·µ»ØÊ±£¬¼´ÈÏΪÒÑÍê³É¡£¶ÔÓÚ·µ»ØÒ»¸ö½á¹û¼¯µÄ executeQuery ·½·¨£¬ÔÚ¼ìË÷Íê ResultSet ¶ÔÏóµÄËùÓÐÐÐʱ¸ÃÓï¾äÍê³É¡£¶ÔÓÚ·½·¨ executeUpdate


Ïà¹ØÎĵµ£º

JavaµÄÊ®´óʼþ


1990£­1994£ºJavaÔµÆð
Larry Wall˵£¬ÓÅÐã³ÌÐòÔ±Ó¦ÓеÄÈý¸öÌØµã:ÀÁ¶è¡¢¼±ÔêºÍ°ÁÂý¡£Java¾ÍÊǵ®ÉúÔÚһȺÀÁ¶è¡¢¼±Ôê¶ø°ÁÂýµÄ³ÌÐòÌì²ÅÖ®ÖС£
1990Äê12Ô£¬SunµÄ¹¤³ÌʦPatrick Naughton±»µ±Ê±Ôã¸âµÄSun C++¹¤¾ßÕÛÄ¥µÄ¿ì·èÁË¡£Ëû´óÉù±§Ô¹£¬²¢ÍþвҪÀ뿪SunתͶµ±Ê±ÔÚSteve JobsÁ쵼֮ϵÄNeXT¹«Ë¾¡£Áìµ¼²ãΪÁËÁôסËû£¬¸øËû ......

JavaÈçºÎдעÊÍ


Õû¸öÀàÎļþ×¢ÊÍ
ʾÀýÈçÏÂ
:
/*
 
* @(#)Object.java    
1.61 03/01/23
 
*
 
* Copyright 2003 Sun Microsystems, Inc. All rights reserved.
 
* SUN PROPRIETARY/CONFIDENTIAL. Use is subject to license terms.
 
*/
 
package java.lang;
& ......

JXL(Java Excel API)

ʹÓÃWindows²Ù×÷ϵͳµÄÅóÓѶÔExcel£¨µç×Ó±í¸ñ£©Ò»¶¨²»»áİÉú£¬µ«ÊÇҪʹÓÃJavaÓïÑÔÀ´²Ù×ÝExcelÎļþ²¢²»ÊÇÒ»¼þÈÝÒ×µÄÊ¡£ÔÚWebÓ¦ÓÃÈÕÒæÊ¢ÐеĽñÌ죬ͨ¹ýWebÀ´²Ù×÷ExcelÎļþµÄÐèÇóÔ½À´Ô½Ç¿ÁÒ£¬Ä¿Ç°½ÏΪÁ÷ÐеIJÙ×÷ÊÇÔÚJSP»òServlet Öд´½¨Ò»¸öCSV £¨comma separated values£©Îļþ£¬²¢½«Õâ¸öÎļþÒÔMIME£¬text/csvÀàÐÍ·µ»Ø¸øä¯ÀÀÆ ......

JAVAÐéÄâ»úÄÚ´æÉèÖÃ

»ù±¾¸ÅÄ
PermGen space£ºÈ«³ÆÊÇPermanent Generation space¡£¾ÍÊÇ˵ÊÇÓÀ¾Ã±£´æµÄÇøÓò,ÓÃÓÚ´æ·ÅClassºÍMetaÐÅÏ¢,ClassÔÚ±»LoadµÄʱºò±»·ÅÈë¸ÃÇøÓò
Heap space£º´æ·ÅInstance¡£ GC(Garbage Collection)Ó¦¸Ã²»»á¶ÔPermGen space½øÐÐÇåÀí
ËùÒÔÈç¹ûÄãµÄAPP»áLOADºÜ¶àCLASSµÄ»°,¾ÍºÜ¿ÉÄܳöÏÖPermGen space´íÎó
Java Hea ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ