WebService·¢²¼ºóÎÞ·¨·ÃÎÊSQLSERVERÊý¾Ý¿â
¿ª·¢»·¾³vs2008+xp+sql server express¡£ÎÒÔÚvs2008µÄ¿ª·¢»·¾³ÔËÐÐWebService¿ÉÒÔ·ÃÎʵ½Êý¾Ý¿âÖеÄÊý¾Ý£¬µ«ÊÇ·¢²¼µ½IISºó£¬¾ÍÎÞ·¨·ÃÎÊÊý¾Ý¿âÊý¾ÝÁË£¬ÆäÖпª·¢Ä¿Â¼ºÍ·¢²¼µÄĿ¼ָÏòͬһ¸öĿ¼£¬¼´Í¬Ò»¸öÎļþ¼Ð¡£²»ÖªµÀ£¬Ê²Ã´ÔÒò£¬Çë¸÷λ´óÏÀ°ïÎÒ½â´ðһϡ£
Êý¾Ý¿âÁ¬½Ó×Ö·û´®ÊÇÔõôÉèÖõģ¿
Á¬½Ó×Ö·û´®ÊÇ·ñÕýÈ·¡£·½·¨ÊÇÈçºÎµ÷ÓõÄ
¼ì²éÁ¬½Ó×Ö·û´®»¹ÓзÃÎʵÄȨÏÞ
¿ª·¢»·¾³ÖеÄweb.configºÍ·¢²¼IISÉϵÄweb.configÖ¸¶¨µÄĿ¼ÊÇͬһ¸öĿ¼£¬ËùÒÔÎļþ¶¼ÊÇͬһ¸ö¡£
<add key="ConnectionString" value="Data Source=.\sqlexpress; Initial Catalog=codematic; Integrated Security=True; Persist Security Info=False"/>Á¬½Ó´®£¬¾ÍÊÇÕâ¸ö¡£¹Ø¼üÊÇÎÒÔÚ¿ª·¢»·¾³Ï£¬ÔËÐÐÁ¬½ÓÊÇûÓÐÈκÎÎÊÌâµÄ¡£°ÑWebService·¢²¼µ½IISÉϺ󣬲ųöÏÖÎÞ·¨·ÃÎʵÄÇé¿ö¡£
ÔÚÊý¾Ý¿âÁ¬½ÓµÄÀàÀïÌí¼ÓµãÈÕÖ¾²Ù×÷£¬½«Á¬½Ó×Ö·û´®µÈÐÅÏ¢Óà Á÷дÈëµ½ÎļþÀï´ò¿ª¿´¿´
ÅжÏÔÚiisÀïÔËÐеÄʱºò ÊÇ·ñÕýÈ·µÄÈ¡µÄµ½ÁËÁ¬½Ó×Ö·û´®£¬ÔÙtryһϣ¬¿´ÓÐʲôÒì³£
{{
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
Êý¾Ý10WÌõÒÔÉÏ,wm6.5ƽ̨,ÄÚ´æÓÐÏÞ
C# code:
private void connserver()
{
Cursor.Current = Cursors.WaitCursor;
try
{
......
СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍÆ¼öÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐÊ²Ã´ÌØ±ð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.
JDBC
ÇëÎÊÔÚSwingÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......
ÎÒÔÚsqlserver2000µÄ²éѯ·ÖÎöÆ÷Àï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬½¨Á˼¸ÕÅ±í£¬²åÈëÁ˼¸ÌõÊý¾Ý£¬±£´æºóÊÇ.sqlºó׺µÄ£¬aspµ÷ÓÃÊý¾Ý¿âÖеÄÊý¾ÝÖ»ÄÜʹÓÃ.mdfµÄ°É£¬ÎÒ¸ÃÔõô×öÄØ£¿½²ÏêϸµãßÀ¡£¡£¡£¡£ÎÒ³õѧ£¬²»Ì«»á....ÏÈллÁË...
Ä ......
ÔÚjspÒ³ÃæÖÐ,ÎÒÏëÏÔʾÊý¾Ý¿â±íÖÐijЩ×ֶεÄÖµ,ÔÚ·½·¨ÖÐ,ÎÒÓ¦¸ÃÓÃʲôÑùµÄ¼¯ºÏÀàÐÍ×öΪ·µ»ØÖµ±È½ÏºÃ,»¹ÓÐ,ÔÚÒ³ÃæÉÏÈçºÎÑ»·Êä³öÎÒ²éѯµÄÄÚÈÝ..¼±ÓÃ!!!!!°ÝÍÐ
ÓÃList²»ÐÐÂð£¿
ÓÃlist
Ò³ÃæÓà <c:forEach& ......