JavaÖнӿڵÄ×÷ÓÃ
½Ó¿ÚµÄ×÷ÓÃ
½Ó¿ÚµÄ×÷Óüòµ¥Ò»µã¾ÍÊÇ:½Ó¿ÚÊÇÓÃÀ´±ê¼ÇÀàµÄ£¬²»Í¬µÄÀàÊôÓÚ²»Í¬µÄ½Ó¿Ú£¨Í¨¹ýÏòÉÏתÐÍ£©£¬¹ÜÀí½Ó¿Ú±È¹ÜÀí¸÷ÖÖ¸÷ÑùµÄÀà·½±ã¶àÁË£¬½Ó¿ÚÌåÏÖÁ˳éÏóµÄ¹Ûµã,ʲôÊdzéÏ󣿳éÏó¾ÍÊÇ"³éÈ¥ÏñµÄ²¿·Ö"¡£
ʹÓýӿڽâ¾öÎÊÌâ
ÎÊÌâ:ÏÖÔÚÎÒÃÇҪд¸öÁ¬½ÓÊý¾Ý¿âµÄÀà¸øÓû§Ê¹Óã¬ÓÐÁ½¸öº¯Êý:Ò»¸ö·µ»ØConnection¶ÔÏó£¬ÁíÒ»¸öÊǹرÕÊý¾Ý¿â,close(),Ò»°ãµÄ½â¾ö·½·¨ÊÇ:¸øÿ¸öÊý¾Ý¿âдһ¸öÀ࣬ÔÙ¸ù¾ÝÓû§Ê¹ÓõÄÊý¾Ý¿â¾ö¶¨Ê¹ÓþßÌåµÄÀà¡£
ºÃµÄ£¬ÎÒÃÇ¿´¿´ÕâÑùÓÐʲô²»ºÃÖ®´¦:
(1).Ê×ÏÈÿ¸öÀ඼ҪÓÐÖظ´µÄ´úÂ룬Ôì³É´úÂëµÄÅòÕÍ£»
(2).Æä´Î×îÖØÒªµÄÊÇÎÒÃDz¢²»ÖªµÀÓû§Ê¹ÓÃʲôÊý¾Ý¿â£¬¿ÉÄÜÊÇOracle,¿ÉÄÜÊÇmysql,Ò²¿ÉÄÜÊÇsqlserverµÈ£¬Õâ¸öÎÊÌâºÜÄѽâ¾ö¡£
½â¾ö·½°¸:
Ê×ÏÈÎÒÃǶ¨Òå½Ó¿Ú:
public interface DataBase
¡¡¡¡{
¡¡¡¡java.sql.Connection openDB(String url,String user,String password);
¡¡¡¡void close();
¡¡¡¡}
ÎÒÃǶ¨ÒåÁËÁ½¸ö·½·¨£¬openDB·µ»ØConnection¶ÔÏó,close()¹Ø±ÕÊý¾Ý¿â;
¾ßÌåµÄʵÏÖÔÚʵÏÖDataBase½Ó¿ÚµÄÀàÖÐ;
ÏÂÃæ¿´¿´ÊµÏÖ:
import java.sql.*;
¡¡¡¡public class Mysql implements DataBase
¡¡¡¡{
¡¡¡¡private String url=”jdbc:mysql:localhost:3306/test”;
¡¡¡¡private String user=”root”;
¡¡¡¡private String password=””;
¡¡¡¡private Connection conn;
¡¡¡¡public Connection openDB(url,user,password)
¡¡¡¡{
¡¡¡¡¡¡¡¡//Á¬½ÓÊý¾Ý¿âµÄ´úÂë
¡¡¡¡}
¡¡¡¡public void close()
¡¡¡¡{
¡¡¡¡¡¡¡¡//¹Ø±ÕÊý¾Ý¿â
¡¡¡¡}
¡¡¡¡}
ÀàmysqlʵÏÖÁËDataBase½Ó¿Ú£¬ÏÂÃ滹ÓÐʵÏÖÁËDataBase½Ó¿ÚµÄoraclesqlµÈÀࣻ
ÕâЩÀ඼¹éÓÚDataBase½Ó¿ÚÁË£¬ÈçºÎÔÚÓ¦ÓóÌÐòÖÐʹÓÃÄØ?
ÎÒÃÇÒª¶¨ÒåDataBase¶ÔÏó myDB,ͨ¹ýmyDBÀ´²Ù×ÝÊý¾Ý¿â£¬¿ÉÒÔ²»Òª·ÖÇåÊÇÄĸöÀàÁË¡£
ÁíÍâµÄÎÊÌâ:JavaÖв»ÐíÎÒÃÇʵÀý»¯½Ó¿Ú£¬ÈçDataBase myDB=new DataBase();
ÎÒÃÇÖ»ÄÜmyDB=new Mysql()»òÕßmyDB=new Oracle()¡£ÕâÑùÎÒÃÇ»¹±ØÐëÖ¸¶¨ÊµÀý»¯Äĸö¶ÔÏ󣬺ÃÏñÇ°ÃæµÄŬÁ¦¶¼°×·ÑÁË°¡!!ÄÇÔõô°ìÄØ£¬ÎÒÃÇÐèÒªÒ»¸ö¹¤³§:
public class DBFactory
¡¡¡¡{
¡¡¡¡public static DataBase Connection get
Ïà¹ØÎĵµ£º
1 ÒýÑÔ
JavaµÄÒ»¸öÖØÒªÓŵã¾ÍÊÇͨ¹ýÀ¬»øÊÕ¼¯Æ÷GC £¨Garbage Collection£©×Ô¶¯¹ÜÀíÄÚ´æµÄ»ØÊÕ£¬³ÌÐòÔ±²»ÐèҪͨ¹ýµ÷Óú¯ÊýÀ´ÊÍ·ÅÄÚ´æ¡£Òò´Ë£¬ºÜ¶à³ÌÐòÔ±ÈÏΪJava ²»´æÔÚÄÚ´æй©ÎÊÌ⣬»òÕßÈÏΪ¼´Ê¹ÓÐÄÚ´æй©Ҳ²»ÊdzÌÐòµÄÔðÈΣ¬¶øÊÇGC »òJVMµÄÎÊÌâ¡£Æäʵ£¬ÕâÖÖÏë·¨ÊDz»ÕýÈ·µÄ£¬ÒòΪJava Ò²´æÔÚÄÚ´æ ......
1¡¢×÷ÓÃÓòpublic,private,protected,ÒÔ¼°²»Ð´Ê±µÄÇø±ð
×÷ÓÃÓò µ±Ç°Àà ͬһpackage ×ÓËïÀà ÆäËûpackage
public √ √ √ √
protected √ √ √ ×
²»Ð´Ê±Ä¬ÈÏΪfriendly √ √ × ×
private √ × × ×
2¡¢ArrayListºÍVect ......
ÎÄÕÂÒ»
ÎÄÕ¶þ
ÎÄÕÂÈý
ÔÎÄ
J2ME¿ª·¢ÓÅ»¯
1¡¢²Â²âVectorµÄ³¤¶È
2¡¢Ê¹Óþֲ¿±äÁ¿
3¡¢±ÜÃâ×Ö·û´®±È½Ï
4¡¢½«±äÁ¿ºÍ·½·¨ÉùÃ÷ΪfinalºÍstatic£¬ÒÔ¼Ó¿ì·ÃÎÊ
5¡¢Ê¹ÓöèÐÔʵÀý»¯
6¡¢´¦ÀíoutofmemoryError´íÎó
7¡¢Ê¹ÓÃÊý×é¶ø²»ÊǶÔÏó
8¡¢µ¹¼ÆÖÁÁãµÄµü´úÑ»·£¬ÒòΪºÍÁã±È½Ï½«»á½Ï¿ì
9¡¢°ÑÒýÓÃÉèÖÃΪNULL
10¡¢×î´óÏÞ¶ÈµÄ ......
ÓÐÈçÏÂÇé¿öÏ¿ÉÒÔÓõ½ÄÚ´æÎļþÓ³Éä¼¼Êõ½â¾öÎÊÌâ:
1.²»Òª¸´ÖÆÎļþÖÐËùÓеÄÊý¾Ý£¬Ö»ÐèÒªÐÞ¸ÄÎļþÖоֲ¿µÄÊý¾Ý¡£
2.²¢ÐÐ\·Ö¶Î´¦Àí´óÎļþ¡£
ÈçÏ´úÂëʾʹÓÃjavaNIO¾Ö²¿ÐÞ¸ÄÎļþÖÐÖ¸¶¨Î»ÖõIJ¿·ÖÊý¾Ý£º
Java´úÂë
/**
* ÐÞ¸ÄÎļþÖеÄijһ²¿·ÖµÄÊý¾ ......
´úÂëÄÚÈÝ
create or replace procedure batchUpdateCustomer(p_age in number) as
begin
update CUSTOMERS set AGE=AGE+1 where AGE>p_age;
end;
ÒÔÉÏ´æ´¢¹ý³ÌÓÐÒ»¸ö²ÎÊýp_age£¬´ú±í¿Í»§µÄÄêÁ䣬ӦÓóÌÐò¿É°´ÕÕÒÔÏ·½Ê½µ÷Óô洢¹ý³Ì£º
´úÂëÄÚÈÝ
tx = session.beginTransaction();
Connection con=session.c ......