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

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һϣ¬¿´ÓÐʲôÒì³£
{{


Ïà¹ØÎÊ´ð£º

jsp jdbcÁ¬½Ósqlserver 2000 ³öÏÖÎÊÌâ

´úÂ룺

try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sqlserverÖУ¬Óô洢¹ý³Ì·ÖÒ³

´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡
http://wyf.javaeye.com/blog/462396

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì

  ......

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

aspʹÓÃsqlserverÎÊÌâ

ÎÒÔÚsqlserver2000µÄ²éѯ·ÖÎöÆ÷Àï´´½¨ÁËÒ»¸öÊý¾Ý¿â£¬½¨Á˼¸ÕÅ±í£¬²åÈëÁ˼¸ÌõÊý¾Ý£¬±£´æºóÊÇ.sqlºó׺µÄ£¬aspµ÷ÓÃÊý¾Ý¿âÖеÄÊý¾ÝÖ»ÄÜʹÓÃ.mdfµÄ°É£¬ÎÒ¸ÃÔõô×öÄØ£¿½²ÏêϸµãßÀ¡£¡£¡£¡£ÎÒ³õѧ£¬²»Ì«»á....ÏÈллÁË...
Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ