??CMS??̳???ݵ红组一统一图库??뵽SQL Server???ݿ?ͼ?Ľ̳?

??Բ֮ҹŮ?ױ? ??;2?????????? ʷ???????Ϸ2?? ÿ??һ??

• ?ֻ??????ı??????ǵ????
• ʲô??ɫ?ij??ȫ????ȫ??ѡ??ɫ????ɫ?ͻ?ɫ
• ?ֻ??ܺĵ???ô?죿?ֻ????̫?ĵ????SIM???Ĵ?
• ??????ڳƺ??????谷û?? ???Ŷ?????ǿ??
• ?Dz?˹???????? 24???ѻ???֢??ʳ?ӳ???????
• 2012ȫ??????Ӱ??????????-?ٶ?CEO??????ϰ?
• ????С??????ô????????С????۸????ý???
• ????Ȼ??࿧??-???????Ƴɿ?????????

• SQL Server 2016:http://www.uzzf.com/soft/181285.html
• SQL Server 2014:http://www.uzzf.com/soft/189594.html
• SQL Server 2012:http://www.uzzf.com/soft/189526.html
• SQL Server 2008:http://www.uzzf.com/soft/189533.html
• SQL Server 2005:http://www.uzzf.com/soft/130153.html
• SQL Server 2000:http://www.uzzf.com/soft/14022.html

SQL Server 2016 CTP2 ?ٷ???ʽ?桾????װ?̳?+??Կ?????ͣ???????????С??3.03G???ԣ????????[????]ʱ?䣺16-03-29???֣?6.0Microsoft sql server 2005 Edition SP4 ????? 32&64λ??????װͼ?⡿???ͣ???????????С??136M???ԣ?????ʱ?䣺16-03-25???֣?4.0

1?? ?ʵ?黷??

??????Ҫ?һ̨DNS????????????һ??????A??¼[url]www.shopping.com[/url]??Ӧ??IP??ַΪ??????ַ172.16.100.100????????DNS??????Ҳ???Բ?ʹ?????????ʡ?

Ȼ????վ????һ̨WEBվ?㣬??Ϊ???ҵ??̵ꡱ??ʹ??????ͷ???ʣ?Ҳ??????IP??ַ???ʡ??????????е?Դ????COPY????վ??Ӧ?ĸ?Ŀ¼?¡?

????վ???Ĭ????ҳΪindex.asp??Ĭ??û?У???Ҫ?ֶ????ӡ?

ѡ????Ŀ¼????ġ????á????????á???·????ִ??Ȩ??ѡ?񡰽ű??Ϳ?ִ???ļ???

???á?WEB??????չ???Active Server Pages???͡?ASP.NET v1.1.4322????״̬Ϊ????????

2?? ͨ??WEB???????װPowerEasy SiteWeaver CMS????web??????????롰[url]http://www.shopping/install.asp[/url]??

???????Ա??½???˺š??????Լ???֤?롣??????֡?HTTP 500 ?ڲ???????????ˢ??һ?¼??ɡ?

????վ??????Բ?????ע??վ???ַһ??Ҫ??д??[url]http://www.shopping/[/url]??????[url]http://172.16.100.100/[/url]????????Ĭ?ϼ??ɡ?

??д???֮?󣬻???????´??????????????ݿ?İ?ȫ??????ɵģ???Ҫ?????ݿ???????޸?Ϊ????д?룬Ϊ?˼???ڼ䣬??????һ??everyone??????????վ??Ŀ¼?Լ???Ŀ¼????????ȫд???Ȩ?ޡ?

ע?⣺ʵ??ʹ????һ??Ҫע??Ȩ?޵????ã?һ?Ų????????????վ???ڵĿ??ܡ?

???????֮??ˢ?°?װҳ??ӿڣ?Ȼ????ʾɾ????Install.asp???????û??ɾ??????Ҫ?ֶ?ɾ????

ɾ?????֮?󣬱????ʹ?ø?ϵͳ?ˡ?

Ҳ??????WEB????????????[url]http://www.shopping/admin/admin_login.asp[/url]????ϵͳ?ĺ?̨??????

??????λ?ã???̬վ????????ɣ????????е????ݻ?ֻ?Ƿ???վ???Լ??????ݿ??С?

3?? ??װSQL Server???ݿ⣬?????÷???????????֤ģʽΪ??SQL Server??Windows??????֤ģʽ???????½?һ?????ݿ???Ϊ??shopping????

?½?һ????½?û?Ϊdreamfire?????????????룬Ĭ?????ݿ?ѡ??shopping????Ҳ????ʹ??ϵͳ?????û?SA????ʵ??Ӧ???У?SA??Ȩ??̫??Ĭ???Dz??????ġ???ý???һ???û????????ʵ???Ȩ?޼??ɡ?

Ϊ?˷?????ԣ??????еķ???????ɫ????dreamfire??ʵ????????Ǿ??Բ??????ġ?

?û?ӳ??ָ?????ݿ?shopping

??¼״̬????Ϊ?????á???SAĬ?ϵ?¼״̬?ǡ????á???

???????֮????Ҫ???????????ݿ⣬ʹ?ղ???????Ч??

4?? ??WEB??̨???ݿ⵼?뵽SQL??

??webվ??????ļ???Database????ʹ?????ݿ??????SiteWeaver.sql????ʹ?øղŴ??????û?dreamfire??¼????????֤ѡ??SQL Server??????֤??

??¼֮?󣬻??ڴ?????ʾһ?󴮴????????????????Ҫ????Щ??????shopping???ݿ???ִ?С???????ǰ???һ?? ??use shopping?????ɡ?

ִ?????֮?????ʾ?????ݿⴴ????ɡ??????ڱ??????ɶ??????

ע?⣺???ִ?д??󣬿??????û?Ȩ?޵????⡣

?????̬??վϵͳĬ??ʹ?õ???ACCESS???ݿ???Ϊ?Լ??ĺ?̨???ݿ?ϵͳ????Ҫ?޸?ΪSQLΪ?Լ???Ĭ??ϵͳ??ʹ??DreamWeaver??Ҳ????ʹ??д?ְ?򿪣???web??Ŀ¼?µ?Conn.asp????????ʾ?޸?????IJ???

Const SystemDatabaseType = "SQL"

Const SqlUsername = "dreamfire"

Const SqlPassword = "123.com"

Const SqlDatabaseName = "shopping"

Const SqlHostIP = "(local)"

?޸????֮??Ȼ???ڿͻ??˷??ʸ?վ?㣬???֡??Ҳ?????ģ?顱?????Խ?database???SiteWeaver.mdb??Ĭ?????ĸ?ģ?飩ģ?鸴?Ƶ?TEMP?ļ????С?

Ȼ???ں?̨???????е?ģ?鵽???ݿ??У?Ȼ??ѡ??һ??ΪĬ?ϼ??ɡ?

???ھͿ??Է??ʸ?WEBվ???ˣ?

5?? ????SQL Server?Ƿ???WEBվ???ϵ?һ??

Ϊ?˼??WEBվ??????ݿ??Ƿ???Ĺҽӵ?SQL Server?У????Դ򿪡????ܹ??ߡ???ġ?SQL Server Profiler??????һ?????١?Ȼ????webվ?????ע?ᣬ???Կ????????????????ʾ?????еĸ??ٽ????

?????û????֮?󣬿?????shopping???ݿ??Ӧ?ı??в鿴ע????û???

ʹ??SQL Server???ݿ?????û??????Բ???????Ҳ??????WEBվ???̨?????޸ģ?

???磬???û?xiaonuo???ʽ????ӵ?1000??

?????ݿ????½?һ????ѯ????????ѯָ??shopping?У?Ȼ??ʹ??????update pe_user set balance =balance + 1000 where username = ??xiaonuo?????ɡ?

΢??SQL Server 2016 SP113.0.4001.0 ?ٷ???ʽ??

΢??SQLServer2016SP1??ʽ???????Ѿ??????ˣ?????һЩ??Ҫ??????ʹ?????ݿ?Ľ????ҾͿ?????ѵ????ذ?װ?£??°??΢??SQLServer2016SP1???ܻ??Ƿdz???ǿ??ģ??Ժܶ?ĵط????????˺ܶ???Ż??Լ??ı?ģ?

• ???ԣ?

  ????

• ??С??

  556.4M

• ???ͣ?

  ???ݿ?

• ???£?

  2016-11-18

• ?Ƽ??ȼ???

  

• ???̣?

ר????ҳ?ƽ???̳???????ɫ?????????İ?pc??ע???