Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ñ¡ÔñÌâ

Ñ¡ÔñÌâ
3ÔĶÁһϳÌÐò£º
Boolean a=false;
Boolean b=true;
Boolean c=(a&b)&&(!b);
Int result=b==false?1:2;
Õâ¶Î³ÌÐòÖ´ÐÐÍêºó£¬cÓëresultµÄÖµÊÇ£¨D£©¡£
A  c=false; result=1;  B. c=true;result=2;
C£®c=true;result=1   D. c=false; result=2
 
6.ÏÂÊöÉùÃ÷ÖÐÄÄÖÖ¿É·À ......

java ÐéÄâ»úÔËÐÐʱÊý¾ÝÇøÓò Runtime Data Areas

The Java virtual machine defines various runtime data areas that are used during execution of a program. Some of these data areas are created on Java virtual machine start-up and are destroyed only when the Java virtual machine exits. Other data areas are per thread. Per-thread data areas are create ......

Java Thread.interrupt º¦ÈË£¡ ÖжÏJAVAỊ̈߳¨zz£©


³ÌÐòÊǺܼòÒ׵ġ£È»¶ø£¬ÔÚ±à³ÌÈËÔ±ÃæÇ°£¬¶àÏ̳߳ÊÏÖ³öÁËÒ»×éеÄÄÑÌ⣬Èç¹ûûÓб»Ç¡µ±µÄ½â¾ö£¬½«µ¼ÖÂÒâÍâµÄÐÐΪÒÔ¼°Ï¸Î¢µÄ¡¢ÄÑÒÔ·¢ÏֵĴíÎó¡£
      ÔÚ±¾ÆªÎÄÕÂÖУ¬ÎÒÃÇÕë¶ÔÕâЩÄÑÌâÖ®Ò»£ºÈçºÎÖжÏÒ»¸öÕýÔÚÔËÐеÄÏ̡߳£ 
          & ......

JXL(Java Excel API)

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