Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

´«Ö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


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......

¸øJAVAÐÂÊÖµÄÒ»·âÐÅ

Ç×°®µÄ Java ÐÂÊÖÃÇ£º
ºÜ¸ßÐËÄãÃÇÔ¸ÒâÀ´ÕâÀﹲͬѧϰ£¬
Java Õâ¸öÓïÑÔ£¬ÒѾ­²»ÔÙÊÇÓïÑÔÁË£¬Ëû¹´ÀÕ³öÒ»¸ö¿ª·ÅʽµÄ¿ª·¢»·¾³£¬
»ù±¾ÉÏ java.sum.com ºÜ´ÖÂÔµØ°Ñ Java ·ÖΪÈý¸ö²¿·Ö£º
(1)  J2SE ( Java 2 Standard Edition )
(2)  J2EE ( Java 2 Enterprise Edition )
(3)  J2ME ( Java 2 Micro Edition ) ......

Java+MysqlµÄÊý¾Ý¿â²éÕÒʵÏÖ


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 ServerµÄ¹¤×÷Ô­ÀíΪʲôÕâÑùÄØ£¿ÎªÊ²Ã´²»°ÑÊý¾ÝÁ¢¿ÌдÈëÊý¾ÝÎļþÄØ£¿Ô­ ......

´«ÖDz¥¿Íjavaѧϰ sql¼òµ¥²éѯÓï¾ä

½ñÌìÎÒѧϰÁËsqlµÄ¼òµ¥²éѯÓï¾ä£¬
 
һЩ»ù±¾µÄ¸ÅÄ
1                  ϵͳȨÏÞ£ºÊý¾Ý¿âÖеĶÔÏó£¬ ±í£¬´´½¨±í£¬É¾³ý±í
2           ¶ÔÏóȨÏÞ£º¶ÔÊý¾ÝµÄÔö¡¢É¾¡¢¸Ä¡¢²é¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ