´«ÖDz¥¿Íjavaѧϰ sql¶ÔÏó
ÎÒ½ñÌìѧϰÁËOracleÊý¾Ý¿âÈçºÎÐ޸ıíµÄ֪ʶ£¬ÊÇ·ëÍþÀÏʦ½²µÄ¿Î£¬ÎÒ×öÁ˼òµ¥µÄ¼Ç¼£º
1.ÔÚ±íÖвåÈëеÄÁУº
alter table tablename
add city varchar£¨2£© default 'rr' //¸³Ä¬ÈÏÖµ
2.Ð޸ıíÖеÄÁУº
alter table tablename
modify city varchar£¨20£©
3.ɾ³ý±íÖеÄÁУº
alter table tablename
drop column city
4.ɾ³ý±íµÄÄÚÈÝ£º
TRUNCATE TABLE tablename
Ëü¿ÉÒÔÇå³ý±íÖÐËùÓеļǼ£¬delete¿ÉÒÔÑ¡Ôñɾ³ý±íÖеÄÒ»²¿·Ö
ËüÊÇDDLÓï¾ä£¬²»¿ÉÒԻعö£¬delete¿ÉÒÔʹÓÃrollback»Ø¹ö£¬·ÅÆúÐ޸ġ£
Ëû¿ÉÒÔÊͷűíµÄ´æ´¢¿Õ¼ä£¬delete²»ÊÍ·Å¿Õ¼ä
5.ɾ³ý±íµÄÓï¾ä£ºÕâ¸öɾ³ý²Ù×÷²»Äܻعö
drop table tablename
6.¸Ä±ä¶ÔÏóµÄÃû³Æ£º
ʹÓÃRENAMEÓï¾ä¸Ä±ä¶ÔÏóÃû³Æ£¬¿ÉÒÔÐÞ¸Ä±í¡¢ÊÓͼ¡¢ÐòÁлòÕßͬÒå´ÊµÄÃû³Æ
RENAME old_name TO new_name;
**************************************************************
1.ÔÚOracleÊý¾Ý¿âÖÐµÄ±í£º
Óû§±í:
±»Óû§´´½¨ºÍά»¤µÄһЩ±í
°üÀ¨ÁËÓû§×Ô¼ºµÄÐÅÏ¢
Êý¾Ý×Öµä±í:
±»OracleÊý¾Ý¿â´´½¨ºÍά»¤µÄһЩ±í
°üÀ¨ÁËÊý¾Ý¿âµÄÐÅÏ¢
2.Êý¾Ý×ֵ䣺
ÊÇÿ¸öOracleÊý¾Ý¿âµÄºËÐÄ
ÓÃÓÚÃèÊöÊý¾Ý¿âºÍËüµÄËùÓжÔÏó
°üÀ¨ÁËÖ»¶ÁµÄ±íºÍÊÓͼ
±» SYSÓû§ÓµÓÐ
±» Oracle serverά»¤
Óû§¿ÉÒÔʹÓà SELECT·ÃÎÊ
3.²éѯÓû§ÏÂËùÓÐµÄ±í£º
select * from user_name
4.²éѯµ±Ç°Óû§Ï±íÖеÄÁУº
select table_name ,column_name from user_tab_columuns
5.²éѯµ±Ç°Óû§ÏÂdept±íÖеÄÁУº
6.Ô¼Êø£º¶Ô±íÖеÄÊý¾ÝÏÞÖÆ¡£
7£ºOracle Ö§³ÖÏÂÃæÎåÀàÍêÕûÐÔÔ¼Êø:
1¡¢NOT NULL ·Ç¿Õ
2¡¢UNIQUE Key Ψһ¼ü
3¡¢PRIMARY KEY Ö÷¼ü
4¡¢FOREIGN KEY Íâ¼ü
5¡¢CHECK ¼ì²ì
8.Ô¼Êø£º
Çø·ÖÁм¶Ô¼ÊøºÍ±í¼¶Ô¼Êø£º
Áм¶Ô¼Êø£ºÔÚ½¨±íµÄͬʱ´´½¨
±í¼¶Ô¼Êø£º½¨±íºó´´½¨
9.·Ç¿ÕÔ¼Êø£¨NOT NULL£©£ºÈ·±£×Ö¶ÎÖµ²»ÔÊÐíΪ¿Õ
10.²é¿´±íµÄÔ¼Êø£ºselect
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
Ç×°®µÄ Java ÐÂÊÖÃÇ£º
ºÜ¸ßÐËÄãÃÇÔ¸ÒâÀ´ÕâÀﹲͬѧϰ£¬
Java Õâ¸öÓïÑÔ£¬ÒѾ²»ÔÙÊÇÓïÑÔÁË£¬Ëû¹´ÀÕ³öÒ»¸ö¿ª·ÅʽµÄ¿ª·¢»·¾³£¬
»ù±¾ÉÏ java.sum.com ºÜ´ÖÂÔµØ°Ñ Java ·ÖΪÈý¸ö²¿·Ö£º
(1) J2SE ( Java 2 Standard Edition )
(2) J2EE ( Java 2 Enterprise Edition )
(3) J2ME ( Java 2 Micro Edition ) ......
public class select {
public List XiuGai_select(String keyword){
List list=new ArrayList();
Connection conn = null;
Statement stmt = null;
String sql=null;
ResultSet res = null;
get ......
SQL ServerÖеÄÊý¾Ý¿â¶¼ÊÇÓÉÒ»»ò¶à¸öÊý¾ÝÎļþÒÔ¼°Ò»»ò¶à¸öÊÂÎñÈÕÖ¾Îļþ×é³ÉµÄ¡£
¹ËÃû˼Ò⣬Êý¾ÝÎļþÖ÷Òª´æ´¢Êý¾Ý¿âµÄÊý¾Ý£¬°üÀ¨Êý¾Ý¿âÄÚÈݽṹ£¬Êý¾ÝÒ³£¬Ë÷ÒýÒ³µÈµÈ¡£ÄÇôÊÂÎñÈÕÖ¾µ½µ×ÊǸÉʲôµÄÄØ£¿ËüÖ÷ÒªÊÇÓÃÀ´±£´æÊý¾Ý¿âÐ޸ļǼµÄ£¬ÈçÏÂͼ£º
SQL ServerµÄ¹¤×÷ÔÀíΪʲôÕâÑùÄØ£¿ÎªÊ²Ã´²»°ÑÊý¾ÝÁ¢¿ÌдÈëÊý¾ÝÎļþÄØ£¿Ô ......
½ñÌìÎÒѧϰÁËsqlµÄ¼òµ¥²éѯÓï¾ä£¬
һЩ»ù±¾µÄ¸ÅÄ
1 ϵͳȨÏÞ£ºÊý¾Ý¿âÖеĶÔÏó£¬ ±í£¬´´½¨±í£¬É¾³ý±í
2 ¶ÔÏóȨÏÞ£º¶ÔÊý¾ÝµÄÔö¡¢É¾¡¢¸Ä¡¢²é¡ ......