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

jbossƽ̨ÏÂjspÁ¬½Ósql2005ºÍsql2000

1¡¢ÅäÖÃjava»·¾³£¬MyEclipse7.0¡£ÅäÖÃjboss5.0£¬Õ¹¿ªÑ¡ÔñjdkΪÒѰ²×°µÄjdk·¾¶¡£
2¡¢°²×°2005ºÍsql2000£¬×°2000ʱҪװsp4.Çý¶¯Ñ¡Ôñjdbc2.0¡£ÔÙ×°2000ʱʵÀýÃû×Ô¼ºÊäÈëÒ»¸ö¡£ÕâÀïµÄÎÊÌâ¾ÍÊǵǼÃûºÍÃÜÂëµÄÉèÖã¬ÓÒ»÷“SQL   Server×é”ϵÄʵÀýÃû£¨Windows   NT)"µÄ“ÊôÐÔ”£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖÐÑ¡Ôñ“°²È«ÐԔѡÏ£¬°ÑÉí·ÝÑéÖ¤µÄÑ¡ÏîÉèΪÉÏÒ»ÏSQl   ServerºÍWindows£¬µã»÷È·¶¨¼´¿É£¡ÔÚ°²È«ÐÔÀïÃæÐ½¨Ò»¸öÓû§£¬·þÎñÆ÷½ÇɫѡÔñpublic£¬Êý¾Ý¿â½ÇɫѡÔñower¡£¶Ï¿ªÒ»¿ªÊ¼ÒÔwindowsÉí·ÝµÄÊý¾Ý¿âµÇ¼£¬2000ÀïÃæ±à¼­×¢²áÊôÐÔ£¬Ñ¡ÔñÓû§ÃûºÍÃÜÂë¡£ÔÙ´ÎÁ¬½ÓÊý¾Ý¿â£¬²âÊÔһϣ¬¿´Äܲ»Äܳɹ¦¶Á³öÊý¾Ý¡£»¹ÓÐÒ»µã¶ù£ºÔÚ·þÎñÆ÷sql2000·þÎñÆ÷ÍøÂçʵÓù¤¾ßµÄtcp¶Ë¿Ú¸ÄΪ1433.È»ºóÖØÆôÉúЧ¡£
3¡¢Ð½¨Ò»¸öweb Project£¬Á¬½ÓÓï¾äΪ
 public static final String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
 public static final String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=Knowledge_Base";
 public static final String userName = "yue";
 public static final String password = "123456";
4¡¢MyEclipse7.0---windows---ÊôÐÔ£¬java---ÒѰ²×°jar£¬Ñ¡Ôñsqljdbc4.jar¡£
5¡¢²¿ÊðÏîÄ¿£¬ÔÚä¯ÀÀÆ÷ÊäÈ룺http://localhost:8080/?,  ?ΪÏîÄ¿Ãû³Æ¡£


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

JSPÓëServletµÄÌø×ª¼°µÃµ½Â·¾¶·½·¨ÕûÀí

  ½ñÌìÕûÀíÏîÄ¿µÄÁ÷³Ì£¬ÔÚJSPºÍServletÖ®¼äÌøÀ´ÌøÈ¥£¬Ôø¾­Ò»¶Îʱ¼ä£¬ÎÒ¶¼ÊǰÑServlet·¾¶¶¨ÒåΪ¡°/SomeServlet¡±£¬Ò²¼´¶¨ÒåΪ¸ùĿ¼£¬ÒòΪ¼æÈÝÐԱȽϺ㬵«ÊÇÓÃÁËMyEclipseÖ®ºó£¬Ð½¨µÄServletĬÈÏ·¾¶ÊÇ¡°/servlet/SomeServlet¡±£¬ÕâÑùд±ãÓÚ¹ÜÀí£¬ÁíÍâ¾ÍÊǸüÊʺϵ¥¶ÀΪServletÉèÖÃFilter£¨¹ØÓÚFilterµÄÉèÖÿÉÒԲο¼ ......

JSPÓï·¨Ïê½â11ÔÂ17ÈÕ[תÌû]

                               JSPÓï·¨Ïê½â[תÌû]
HTML×¢ÊÍ:
  1) ¿ÉÒÔÓÃ×¢ÊÍÄÚÈÝ,Ò²¿ÉÒÔÓñí´ïʽ.
  2)Òþ²Ø×¢ÊÍ:
  ×¢Êͻᱠ......

C# Ö´ÐÐSQLÊÂÎñʵÀý´úÂë

 [C#]
public void RunSqlTransaction(string myConnString)
{
    SqlConnection myConnection = new SqlConnection(myConnString);
    myConnection.Open();
    SqlCommand myCommand = myConnection.CreateCommand();
    SqlTransaction m ......

¼¸Ìõ³£¼ûµÄÊý¾Ý¿â·ÖÒ³ SQL Óï¾ä

 ÎÒÃÇÔÚ±àдMISϵͳºÍWebÓ¦ÓóÌÐòµÈϵͳʱ£¬¶¼Éæ¼°µ½ÓëÊý¾Ý¿âµÄ½»»¥£¬Èç¹ûÊý¾Ý¿âÖÐÊý¾ÝÁ¿ºÜ´óµÄ»°£¬Ò»´Î¼ìË÷ËùÓеļǼ£¬»áÕ¼ÓÃϵͳºÜ´óµÄ×ÊÔ´£¬Òò´ËÎÒÃdz£³£²ÉÓã¬ÐèÒª¶àÉÙÊý¾Ý¾ÍÖ»´ÓÊý¾Ý¿âÖÐÈ¡¶àÉÙÌõ¼Ç¼£¬¼´²ÉÓ÷ÖÒ³Óï¾ä¡£¸ù¾Ý×Ô¼ºÊ¹ÓùýµÄÄÚÈÝ£¬°Ñ³£¼ûÊý¾Ý¿âSQL Server,OracleºÍMySQLµÄ·ÖÒ³Óï¾ä£¬´ÓÊý¾Ý¿â±íÖÐµÄµÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ