Javaµ÷Óô洢¹ý³Ì
±¾ÎIJûÊöÁËÔõôʹÓÃDBMS´æ´¢¹ý³Ì¡£ÎÒ²ûÊöÁËʹÓô洢¹ý³ÌµÄ»ù±¾µÄºÍ¸ß¼¶ÌØÐÔ£¬±ÈÈç·µ»ØResultSet¡£±¾ÎļÙÉèÄã¶ÔDBMSºÍJDBCÒѾ·Ç³£ÊìϤ£¬Ò²¼ÙÉèÄãÄܹ»ºÁÎÞÕϰµØÔĶÁÆäËüÓïÑÔд³ÉµÄ´úÂ루¼´²»ÊÇJavaµÄÓïÑÔ£©£¬µ«ÊÇ£¬²¢²»ÒªÇóÄãÓÐÈκδ洢¹ý³ÌµÄ±à³Ì¾Àú¡£
´æ´¢¹ý³ÌÊÇÖ¸±£´æÔÚÊý¾Ý¿â²¢ÔÚÊý¾Ý¿â¶ËÖ´ÐеijÌÐò¡£Äã¿ÉÒÔʹÓÃÌØÊâµÄÓï·¨ÔÚJavaÀàÖе÷Óô洢¹ý³Ì¡£ÔÚµ÷ÓÃʱ£¬´æ´¢¹ý³ÌµÄÃû³Æ¼°Ö¸¶¨µÄ²ÎÊýͨ¹ýJDBCÁ¬½Ó·¢Ë͸øDBMS£¬Ö´Ðд洢¹ý³Ì²¢Í¨¹ýÁ¬½Ó£¨Èç¹ûÓУ©·µ»Ø½á¹û¡£
ʹÓô洢¹ý³ÌÓµÓкÍʹÓûùÓÚEJB»òCORBAÕâÑùµÄÓ¦Ó÷þÎñÆ÷Ò»ÑùµÄºÃ´¦¡£Çø±ðÊÇ´æ´¢¹ý³Ì¿ÉÒԴӺܶàÁ÷ÐеÄDBMSÖÐÃâ·ÑʹÓ㬶øÓ¦Ó÷þÎñÆ÷´ó¶¼·Ç³£°º¹ó¡£Õâ²¢²»Ö»ÊÇÐí¿ÉÖ¤·ÑÓõÄÎÊÌ⡣ʹÓÃÓ¦Ó÷þÎñÆ÷ËùÐèÒª»¨·ÑµÄ¹ÜÀí¡¢±àд´úÂëµÄ·ÑÓã¬ÒÔ¼°¿Í»§³ÌÐòËùÔö¼ÓµÄ¸´ÔÓÐÔ£¬¶¼¿ÉÒÔͨ¹ýDBMSÖеĴ洢¹ý³ÌËùÕû¸öµØÌæ´ú¡£
Äã¿ÉÒÔʹÓÃJava£¬Python£¬Perl»òC±àд´æ´¢¹ý³Ì£¬µ«ÊÇͨ³£Ê¹ÓÃÄãµÄDBMSËùÖ¸¶¨µÄÌØ¶¨ÓïÑÔ¡£OracleʹÓÃPL/SQL£¬PostgreSQLʹÓÃpl/pgsql£¬DB2ʹÓÃProcedural SQL¡£ÕâЩÓïÑÔ¶¼·Ç³£ÏàËÆ¡£ÔÚËüÃÇÖ®¼äÒÆÖ²´æ´¢¹ý³Ì²¢²»±ÈÔÚSunµÄEJB¹æ·¶²»Í¬ÊµÏÖ°æ±¾Ö®¼äÒÆÖ²Session BeanÀ§ÄÑ¡£²¢ÇÒ£¬´æ´¢¹ý³ÌÊÇΪǶÈëSQLËùÉè¼Æ£¬ÕâʹµÃËüÃDZÈJava»òCµÈÓïÑÔ¸ü¼ÓÓѺõط½Ê½±í´ïÊý¾Ý¿âµÄ»úÖÆ¡£ ×Ö´®1
ÒòΪ´æ´¢¹ý³ÌÔËÐÐÔÚDBMS×ÔÉí£¬Õâ¿ÉÒÔ°ïÖú¼õÉÙÓ¦ÓóÌÐòÖеĵȴýʱ¼ä¡£²»ÊÇÔÚJava´úÂëÖÐÖ´ÐÐ4¸ö»ò5¸öSQLÓï¾ä£¬¶øÖ»ÐèÒªÔÚ·þÎñÆ÷¶ËÖ´ÐÐ1¸ö´æ´¢¹ý³Ì¡£ÍøÂçÉϵÄÊý¾ÝÍù·µ´ÎÊýµÄ¼õÉÙ¿ÉÒÔÏ·¾çÐÔµØÓÅ»¯ÐÔÄÜ¡£
ʹÓô洢¹ý³Ì
¼òµ¥µÄÀϵÄJDBCͨ¹ýCallableStatementÀàÖ§³Ö´æ´¢¹ý³ÌµÄµ÷Ó᣸ÃÀàʵ¼ÊÉÏÊÇPreparedStatementµÄÒ»¸ö×ÓÀà¡£¼ÙÉèÎÒÃÇÓÐÒ»¸öpoetsÊý¾Ý¿â¡£Êý¾Ý¿âÖÐÓÐÒ»¸öÉèÖÃÊ«ÈËÊÅÊÀÄêÁäµÄ´æ´¢¹ý³Ì¡£ÏÂÃæÊǶÔÀϾƹíDylan Thomas£¨old soak Dylan Thomas£¬²»Ö¸¶¨ÊÇ·ñÓйصä¹Ê¡¢ÎÄ»¯£¬ÇëÅúÆÀÖ¸Õý¡£Òë×¢£©½øÐе÷ÓõÄÏêϸ´úÂ룺
try{
int age = 39;
String poetName = "dylan thomas";
CallableStatement proc = connection.prepareCall("{ call set_death_age(?, ?) }");
proc.setString(1, poetName);
proc.setInt(2, age);
cs.execute();
}catch (SQLException e){ // ....} ×Ö´®7
´«¸øprepareCall·½·¨µÄ×Ö´®ÊÇ´æ´¢¹ý³Ìµ÷ÓõÄÊéд¹æ·¶¡£ËüÖ¸¶¨ÁË´æ´¢¹ý³ÌµÄÃû³Æ£¬£¿´ú±íÁËÄãÐèÒªÖ¸¶¨µÄ²ÎÊý¡£
ºÍJDBC¼¯³ÉÊÇ´æ´¢¹ý³ÌµÄÒ»¸öºÜ´óµÄ±ãÀû£ºÎªÁË´ÓÓ¦ÓÃÖе÷Óô洢¹ý³Ì£¬²»ÐèÒª´æ¸ù£¨stu
Ïà¹ØÎĵµ£º
ÔËÐÐ bat£¨Åú´¦Àí£© Îļþ
£¨²»È·¶¨£¬ÎÒ×Ô¼ºµÄ¼òµ¥demoÊÇjava¿ÉÒÔÖ´ÐÐÅú´¦ÀíÎļþµÄ£©
Java ¶ÔÅú´¦ÀíÎļþ»¹²»Ö§³Ö¡£¸Õ¿ªÊ¼Ò»Ö±ÔÚÑо¿ Java ÈçºÎµ÷ÓÃÅú´¦ÀíÎļþ£¬Ê¼ÖÕÕÒ²»µ½½â¾ö·½·¨¡£ºóÀ´Ö»ºÃÈÆ¹ýÅú´¦Àí£¬¿¼ÂÇÈçºÎ½«Åú´¦Àíת»»Îªexe¿ÉÖ´ÐÐÎļþ¡£È»ºóÔÙͨ¹ýJ ......
×÷ΪJava³ÌÐòÔ±À´Ëµ£¬×îÍ´¿àµÄÊÂÇéιýÓÚ¿ÉÒÔÑ¡ÔñµÄ·¶Î§Ì«¹ã£¬¿ÉÒÔ¶ÁµÄÊéÌ«¶à£¬ÍùÍùÈÝÒ×ÎÞËùÊÊ´Ó¡£ÎÒÏë¾ÍÎÒ×Ô¼º¶Á¹ýµÄ¼¼ÊõÊé¼®ÖÐÌôÑ¡³öÀ´Ò»Ð©£¬°´ÕÕѧϰµÄÏȺó˳Ðò£¬ÍƼö¸ø´ó¼Ò£¬ÌرðÊÇÄÇЩÏë²»¶ÏÌá¸ß×Ô¼º¼¼ÊõˮƽµÄJava³ÌÐòÔ±ÃÇ¡£
Ò»¡¢Java±à³ÌÈëÃÅÀà
¶ÔÓÚûÓÐJava±à³Ì¾ÑéµÄ³ÌÐòÔ±ÒªÈëÃÅ£¬Ëæ±ã¶ÁʲôÈëÃÅÊé¼®¶¼Ò»Ñù£¬Õâ ......
(1) ÀàÃûÊ××ÖĸӦ¸Ã´óд¡£×ֶΡ¢·½·¨ÒÔ¼°¶ÔÏ󣨾ä±ú£©µÄÊ××ÖĸӦСд¡£¶ÔÓÚËùÓбêʶ·û£¬ÆäÖаüº¬µÄËùÓе¥´Ê¶¼Ó¦½ô¿¿ÔÚÒ»Æð£¬¶øÇÒ´óдÖм䵥´ÊµÄÊ××Öĸ¡£ÀýÈ磺
ThisIsAClassName
thisIsMethodOrFieldName
ÈôÔÚ¶¨ÒåÖгöÏÖÁ˳£Êý³õʼ»¯×Ö·û£¬Ôò´óдstatic final»ù±¾ÀàÐͱêʶ·ûÖеÄËùÓÐ×Öĸ¡£ÕâÑù±ã¿É±êÖ¾³öËüÃÇÊôÓÚ±àÒëÆÚµ ......
javaÖеÄʼþ»úÖÆµÄ²ÎÓëÕßÓÐ3ÖÖ½ÇÉ«£º
1.event object£ºÊ¼þ״̬¶ÔÏó£¬ÓÃÓÚlistenerµÄÏàÓ¦µÄ·½·¨Ö®ÖУ¬×÷Ϊ²ÎÊý£¬Ò»°ã´æÔÚÓëlisternerµÄ·½·¨Ö®ÖÐ
2.event source£º¾ßÌåµÄʼþÔ´£¬±ÈÈç˵£¬Äãµã»÷Ò»¸öbutton£¬ÄÇôbutton¾ÍÊÇevent source£¬ÒªÏëʹbutton¶ÔijЩʼþ½øÐÐÏìÓ¦£¬Äã¾ÍÐèҪע²áÌØ¶¨µÄlistener¡£
3.event listener ......