me, age, FROM Person_Tbl¡±; ps = con.prepareStatement(sql);
//step 4 £ºÖ´ÐвéѯÓï¾ä£¬»ñÈ¡½á¹û¼¯£»
rs = ps.executeQuery();
//step 5£º´¦Àí½á¹û¼¯¡ªÊä³ö½á¹û¼¯Öб£´æµÄ²éѯ½á¹û£»
while (rs.next()){
System.out.print(¡°id = ¡± + rs.getLong(¡°id¡±));
System.out.print(¡± , fname = ¡± + rs.getString(¡°fname¡±));
System.out.print(¡± , lname = ¡± + rs.getString(¡°lname¡±));
System.out.print(¡± , age = ¡± + rs.getInt(¡°age¡±)); }
/************************JDBC ÐÞ ¸Ä*********************/
sql = ¡°UPDATE Person_Tbl SET age=23 WHERE id = ¡±; ps = con.prepareStatement(sql);
ps.setLong(1, 88);
int rows = ps.executeUpdate();
System.out.println(rows + ¡± rows affected.¡±);
} catch (Exception e){
e.printStackTrace();
} finally{
try{
//¹Ø±ÕÊý¾Ý¿âÁ¬½Ó£¬ÒÔÊÍ·Å×ÊÔ´¡£
con.close();
} catch (Exception e1) {
E1.printStackTrace();
} } }
31¡¢Statement,PreparedStatement,CallableStatmentµÄÇø±ð
´ð£º Çø±ðÓÐÒÔϼ¸µã£º 1£© StatementÊÇPreparedStatementºÍCallableStatementµÄ¸¸Àࣻ 2£©StatementÊÇÖ±½Ó·¢ËÍSqlÓï¾äµ½Êý¾Ý¿â£¬ÊÂÏÈûÓнøÐÐÔ¤±àÒë¡£
PreparedStatement»á½«sql½øÐÐÔ¤±àÒ룬µ±sqlÓï¾äÒªÖظ´Ö´ÐÐʱ£¬Êý¾Ý¿â»áµ÷ÓÃÒÔÇ°Ô¤±àÒëºÃµÄsqlÓï¾ä£¬ËùÒÔPreparedStatementÔÚÐÔÄÜ·½Ãæ»á¸üºÃ£»
3£©PreparedStatementÔÚÖ´ÐÐsqlʱ£¬¶Ô´«ÈëµÄ²ÎÊý¿ÉÒÔ½øÐÐÇ¿ÖƵÄÀàÐÍת»»¡£ÒÔ±£Ö¤Êý¾Ý¸ñʽÓëµ×²ãµÄÊý¾Ý¿â¸ñʽһÖ¡£
4£©CallableStatement ÊÊÓÃÓë´æ´¢¹ý³ÌµÄ²éѯ±í´ïÓï¾ä
aop³ÆΪÊÇÃæÏòÇÐÃæ±à³Ì£¬ÄÇô¶ÔËü×îºÃµÄ½âÊ;ÍÊÇÀ¹½ØÆ÷ÁË£¬¶øËûµÄaopÔÀíÄؾÍÊÇ£ºÔÚÖ´ÐÐijЩ´úÂë֮ǰִÐÐÁíÍâµÄ´úÂ룬ÊdzÌÐò±äµÄÁé»î£¬À©Õ¹ÐÔ¸üÁé»î£¬¿ÉÒÔËæÒâµÄɾ³ýºÍÌí¼ÓijЩ¹¦ÄÜ£¡Äã¿ÉÒÔ²ÎÕÕfilter¹ýÂËÆ÷£¬Æäʵfilter¾ÍÊÇÒ»¸öºÜºÃµÄ¶ÔaopµÄ½âÊÍ
AOPÊÇOOPµÄÑÓÐø£¬ÊÇ£¨Aspect Oriented Programming£©µÄËõд£¬Òâ˼ÊÇÃæÏòÇÐÃæ±à³Ì¡£
Ö÷ÒªµÄ¹¦ÄÜÊÇ£ºÈÕÖ¾¼Ç¼£¬ÐÔÄÜͳ¼Æ£¬°²È«¿ØÖÆ£¬ÊÂÎñ´¦Àí£¬Òì³£´¦ÀíµÈµÈ¡£
Ö÷ÒªµÄÒâͼÊÇ£º½«ÈÕÖ¾¼Ç¼£¬ÐÔÄÜͳ¼Æ£¬°²È«¿ØÖÆ£¬ÊÂÎñ´¦Àí£¬Òì³£´¦ÀíµÈ´úÂë´ÓÒµÎñÂß¼´úÂëÖл®·Ö³öÀ´£¬Í¨¹ý¶ÔÕâЩÐÐΪµÄ·ÖÀ룬ÎÒÃÇÏ£Íû¿ÉÒÔ½«ËüÃǶÀÁ¢µ½·ÇÖ¸µ¼ÒµÎñÂß¼µÄ·½·¨ÖУ¬½ø¶ø¸Ä±äÕâЩÐÐΪµÄʱºò²»Ó°ÏìÒµÎñÂß¼µÄ´úÂë¡£
¿ÉÒÔͨ¹ýÔ¤±àÒ뷽ʽºÍÔËÐÐÆÚ¶¯Ì¬´úÀíʵÏÖÔÚ²»ÐÞ¸ÄÔ´´úÂëµÄÇé¿öϸø³ÌÐò¶¯Ì¬Í³Ò»Ìí¼Ó¹¦ÄܵÄÒ»ÖÖ¼¼Êõ¡£AOPʵ¼ÊÊÇGoFÉè¼ÆģʽµÄÑÓÐø£¬Éè¼Æģʽ×Î×β»¾ë×·ÇóµÄÊǵ÷ÓÃÕߺͱ»µ÷ÓÃÕßÖ®¼äµÄ½âñAOP¿ÉÒÔ˵ҲÊÇÕâÖÖÄ¿±êµÄÒ»ÖÖʵÏÖ¡£
ÔÚSpringÖÐÌṩÁËÃæÏòÇÐÃæ±à³ÌµÄ·á¸»Ö§³Ö£¬ÔÊÐíͨ¹ý·ÖÀëÓ¦ÓõÄÒµÎñÂß¼Óëϵͳ¼¶·þÎñ£¨ÀýÈçÉó¼Æ£¨auditing£©ºÍÊÂÎñ£¨transaction£©¹ÜÀí£©½øÐÐÄÚ¾ÛÐԵĿª·¢¡£Ó¦ÓöÔÏóֻʵÏÖËüÃÇÓ¦¸Ã×öµÄ¡ª¡ªÍê³ÉÒµÎñÂß¼¡ª¡ª½ö´Ë¶øÒÑ¡£ËüÃDz¢²»¸ºÔð£¨ÉõÖÁÊÇÒâʶ£©ÆäËüµÄϵͳ¼¶¹Ø×¢µã£¬ÀýÈçÈÕÖ¾»òÊÂÎñÖ§³Ö¡£¿ÉÒÔ¸üºÃµÄ½«±¾À´²»Ó¦¸ÃÕ³ºÏÔÚÒ»ÆðµÄ¹¦ÄÜ·ÖÀ뿪¡£
1.¶¨ÒåÇÐÈëµã£ºspring¸ù¾ÝÐèÒªÖ¯Èë֪ͨµÄÀàºÍ·½·¨À´¶¨ÒåÇÐÈëµã
֪ͨÊǸù¾ÝËûÃǵÄÌØÐÔÖ¯ÈëÄ¿±êÀàºÍ·½·¨µÄ£¬ÈçÀàÃûºÍ·½·¨Ãû
2.¾²Ì¬ÇÐÈëµã£ºspringΪ´´½¨¾²Ì¬ÇÐÈëµãÌṩÁË·½±ãµÄ¸¸Àà¨CStaticMethodMatcherPointcut¡£
1£©Òª´´½¨×ÔÖƵľ²Ì¬ÇÐÈëµã£¬Ö»ÐèÒª¼Ì³ÐÕâ¸öÀ࣬ʵÏÖisMatch()·½·¨
2£©µ±±»µ÷Ó÷½·¨µÄÃû×ÖÓë¸ø³öµÄÓ³ÉäÃû×ÖÆ¥Åäʱ£¬ÇÐÈëµã²ÅÆ¥Åä
3£©Ê¹ÓÃÃ÷È·µÄ·½·¨Ãû£¬Ò²¿ÉÒÔÔÚÃû×ÖµÄÆðʼºÍ½áÊø´¦Ê¹ÓÃͨÅä·û*¡£
81¡¢ÏÖÓÐ1~100¹²Ò»°Ù¸ö×ÔÈ»Êý£¬ÒÑËæ»ú·ÅÈëÒ»¸öÓÐ98¸öÔªËصÄÊý×éa[98]¡£ÒªÇóд³öÒ»¸ö¾¡Á¿¼òµ¥µÄ·½°¸£¬ÕÒ³öûÓб»·ÅÈëÊý×éµÄÄÇ2¸öÊý£¬²¢ÔÚÆÁÄ»ÉÏ´òÓ¡Õâ2¸öÊý¡£×¢Ò⣺³ÌÐò²»ÓÃʵÏÖ×ÔÈ»ÊýËæ»ú·ÅÈëÊý×éµÄ¹ý³Ì¡£ ´ð£º
int[] b = new int[]{¡.´æÈë98¸öËæ»úµÄ1~100µÄÕûÊý};
int[] a = new int[100];
for(int t : b) a[t-1]=t;
for(int t=0; t < a.length; t++)
if(a[t]==0) System.out.println(t+1);
84¡¢ÔÚwebÓ¦Óÿª·¢¹ý³ÌÖо³£Óöµ½Êä³öijÖÖ±àÂëµÄ×Ö·û£¬Èç´ÓGBKµ½iso8859-1µÈ£¬ÈçºÎÊä³öÒ»¸öijÖÖ±àÂëµÄ×Ö·û´®£¿
´ð£ºpublic static String translate(String str) {
String tempStr = ¡°¡±;
try {
tempStr = new String(str.getBytes(¡°GBK¡±), ¡°ISO-8859-1¡å);
tempStr = tempStr.trim();
} catch (Exception e) {
System.err.println(e.getMessage()); }
return tempStr; }
87¡¢JAVAʵÏÖÒ»ÖÖÅÅÐò
´ð£ºÓòåÈë·¨½øÐÐÅÅÐò´úÂëÈçÏÂ
package com.tarena;
import java.util.*;
class InsertSort {
ArrayList list;
public InsertSort(int num,int mod) {
list = new ArrayList(num);
Random rand = new Random();
System.out.println(¡°The ArrayList Sort Before:¡±);
for (int i=0;i
list.add(new Integer(Math.abs(rand.nextInt()) % mod + 1)); System.out.println(¡°list["+i+"]=¡±+list.get(i)); } }
public void SortIt() {
Integer tempInt; int MaxSize=1;
for(int i=1;i
tempInt = (Integer)list.remove(i); if(tempInt.intValue()>=((Integer)list.get(MaxSize-1)).intValue()) { list.add(MaxSize,tempInt);
MaxSize++;
System.out.println(list.toString());.
} else { for (int j=0;j
if (((Integer)list.get(j)).intValue()>=tempInt.intValue()) {
list.add(j,tempInt); MaxSize++; System.out.println(list.toString()); break;