Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Àà±»¼ÓÔØÊ±Ö´ÐеÄ˳ÐòÎÊÌâ

public class Parent
{
    //1
    static int a =  1;
    //2
    static
    {
        a = 10;
        System.out.println("parent static c ......

JAVA´úÂëС¼¼ÇÉ£¬ÊµÊ±¸üУ¬¸üе½20100107

    ÔÚCSDNÖп´µ½Á˸öÓйØjava¼¼ÇɵÄÌû×Ó£¬¾õµÃ·Ç³£ÓÐÓ㬿ÉÒÔ±ÜÃ⿪·¢¹ý³ÌÖвúÉúµÄһЩµÍ¼¶µÄ´íÎó£¬Ìû×Ó±¾ÉíÒѾ­½øÐÐÁË×ܽᣬÎÒÌô³öÁËÆäÖÐһЩ¸öÈ˾õµÃƽʱ¿ª·¢¹ý³ÌÖÐÓÐÓõIJ¿·Ö£¬ÔÙ¼ÓÉÏ×Ô¼ºÔÚ¹¤×÷ÖÐѧµ½µÄ¼¼ÇÉ£¬ÕûÀíÔÚ±¾ÎÄÖУ¬²¢Ëæ×Åʱ¼äʵʱ¸üÐÂ
1¡¢Ð´ºÃ×¢ÊÍ¡£ÊäÈë²ÎÊý¡¢Êä³öÀàÐÍ¡¢·½·¨¹¦ÄÜ£¬°ÑÕâÈýµãÃè ......

JXL(Java Excel API)

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

¸ø³õѧÕßÎÄÕ£¬³õѧÕßѧϰJavaӦעÒâʲô£¿

Java×ÜÓÐËüµÄǧ°ãºÃ´¦Ê¹ÄãÑ¡ÔñËü£¬µ«ÕâÐ©Ëæ±ã·­·­Êé»òÔÚÍøÉϹäһȦ¾ÍÄÜÕÒµ½´ð°¸¡£ÔÚ±¾ÎÄÖУ¬±ÊÕß°Ñ×Ô¼ºÑ§Ï°JavaµÄһЩÇÐÉíÌå»áºÍ¹ý³Ìд³öÀ´£¬¹©³õѧÕß×ö¸ö²Î¿¼¡£
http://school.itzcn.com/special-spid-50.html
¡¡¡¡ÎÒÔÚѧϰJavaµÄ¹ý³ÌÖÐÖ÷ÒªÎ§ÈÆÒÔϼ¸¸ö·½ÃæÀ´Ñ§Ï°£º
¡¡¡¡1.ʱ¿ÌÌáÐÑ×Ô¼ºJavaÊÇÒ»ÖÖOOPÓïÑÔ¹¤¾ß£¬¶ø²»½ö½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ