aspµ÷ÓÃsql server´æ´¢¹ý³Ì
ASPµ÷Óô洢¹ý³ÌµÄ·½·¨£º
---- ¡¡¡¡µ÷Óô洢¹ý³ÌµÄ·½·¨ÐèҪʹÓÃADOµÄCommand¶ÔÏó¡£Command¶ÔÏóÊǶÔÒ»¸öÊý¾ÝÔ´ÔËÐÐÌض¨ÃüÁîµÄ¶¨Ò壨ÀýÈ磬һ¸öSQL²éѯ»òÒ»¸öSQL´æ´¢¹ý³Ì£©¡£ÏÂÃæÒÔMS SQL SERVER6.5Ϊºǫ́Êý¾Ý¿â£¬½éÉÜASPµ÷Óô洢¹ý³ÌµÄ·½·¨¡£
---- ¡¡¡¡ÀýÈ磬ÔÚ±íUserÖб£´æÁËÓû§ÃûºÍÃÜÂë¡£ÏÖÔÚ½¨Á¢Ò»¸ö¼ì²éÃÜÂëµÄ´æ´¢¹ý³Ìsp_CheckPassÀ´¼ì²éÓû§ÊÇ·ñÊäÈëÁ˺Ϸ¨µÄÃÜÂë¡£½¨Á¢´æ´¢¹ý³Ì£¬¿ÉÒÔ´ÓMicrosoft SQL Sever³ÌÐò×éÖÐÆô¶¯ISQL/w¡£È»ºó£¬ÔÚ²éѯ´°¿ÚÖÐÊäÈë´æ´¢¹ý³Ì£º
/*´æ´¢¹ý³ÌÀý³Ì*/
CREATE PROCEDURE sp_CheckPass
@CHKName VARCHAR(30),@CHKPass VARCHAR(30),
@ISValid CHAR(8) OUTPUT¡¡¡¡
AS
IF EXISTS(SELECT UserName from Users
WHERE UserName=@CHKName AND UserPwd=@CHKPass)
SELECT @ISVaid="pass"
ELSE
SELECT @ISValid="Invalid"
---- ¡¡¡¡´æ´¢¹ý³Ì½ÓÊÕÁ½¸öÊäÈë²ÎÊý¡£ÊäÈë²ÎÊý@CHKNameÏò´æ´¢¹ý³Ì´«µÝÒ»¸öÓû§Ãû¡£@CHKPassÏò´æ´¢¹ý³Ì´«µÝÒ»¸öÃÜÂë¡£Èç¹ûÓÐÓû§ÓµÓÐÖ¸¶¨µÄÃÜÂ룬Êä³ö²ÎÊý½«·µ»Ø“pass"£¬·ñÔò£¬·µ»Ø“Invalid"¡£
---- ¡¡¡¡ÏÖÔÚÎÒÃÇ¿ÉÒÔÔÚCheckPass.aspÖе÷Óô洢¹ý³Ìsp_CheckPass ÁË¡£
CheckPass.asp
< !--#INCLUDE VIRTUAL="ADOVBS.inc"-- > ’
°üº¬VBSCRIPTµÄ³£Á¿¶¨ÒåÎļþ
< %
Set DataConn=Sever.CreateObject("ADODB.Connection")
'½¨Á¢Á¬½Ó¶ÔÏó
Dataconn.Open"DSN=user;SERVER=APP_SERVER;
UID=sa;PWD=;APP=Microsoft(R) Developer Studio;
WSID=APP_SERVER;Regional=Yes"
Set cmdTemp=Sever.CreateObject("ADODB.Command")
'½¨Á¢ÃüÁî¶ÔÏó
Set cmdTemp.ActiveConnection=DataConn
cmdTemp.CommandType=adC
Ïà¹ØÎĵµ£º
import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
public static void main(String[] args)throws Exception {
Connection conn=null;
//====Á¬½ÓACCESSÊý¾Ý¿â ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
ҪʵÏÖÔÚaspÍøÕ¾ÉÏ·¢ËÍ·ÉÐÅ£¬ÒªÇóÊÇÖйúÒƶ¯µÄÊÖ»úÓû§£¬²¢ÇÒ¿ªÍ¨Òƶ¯·ÉÐŹ¦ÄÜ¡£
ʹÓÃÒÔÏÂasp´úÂ룬Ð޸IJÎÊýΪÄãµÄÊÖ»úºÅ¼°·ÉÐÅÃÜÂ룬¾Í¿ÉÒÔʵÏÖÔÚÍøÕ¾·¢Ãâ·Ñ¶ÌÐŹ¦ÄÜ¡£
fsend.aspÎļþÔ´´úÂëÈçÏ£º
<%
Dim fno,fp,tofno,rurl
......
Sql Serverͬ±íÄڵļ¶ÁªÅÅÐò£¨¼´Í¬¸¸¼¶±ðµÄ×Ó½Úµã×ÔÐа´1~NÅÅÐò£©,2005°æ±¾ÒѾ×Ô´øÁËROW_NUMBER() OVER×Ӿ䣬¿ÉÒԺܷ½±ãµØʵÏÖЧ¹û¡£µ«ÊÇ2000°æ±¾²»Ö§³ÖÕâÖÖ×ö·¨£¬²»¹ýÒ²¿ÉÒÔ²ÉÈ¡ÌØÊâ×ö·¨
--slq2005
select rd.id,r.id ruleId,ROW_NUMBER() OVER(
PARTITION BY r.id
ORDER BY ......