SqlÓï¾ä³ö´í£¬ - Web ¿ª·¢ / ASP
ÔËÐк󱨴íÎóÈçÏ£º
´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ 'Êýѧ + 4where ÐÕÃû='Íõ¾²'' ÖС£
/edit.asp, µÚ 13 ÐÐ
[code=VB][/code]
<html><body>
<%
if session("name")="" then
response.redirect("login.asp")
end if
qkname=request("qkname")
number=request("number")
if qkname<>"" and number<>"" then
set conn=server.CreateObject("ADODB.Connection")
conn.open("driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("student.mdb"))
set rs=Server.CreateObject("ADODB.Recordset")
sql="update info set Êýѧ = Êýѧ + " & number & "where ÐÕÃû='" & qkname & "'"
rs.open sql, conn, 2, 2
conn.close()
end if
'response.write(session("name"))
%>
<form action="edit.asp"method=post>
ÐÕÃû£º<input type="text"name="qkname"size="20">ȱ¿Î½ÚÊý£º<input type="text"name="number"size="20"><p>
<input type="submit"value="Ìá½»">
</form>
</body></html>
sql="update info set Êýѧ = Êýѧ + " &
Ïà¹ØÎÊ´ð£º
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
µÚÒ»¾ä:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join jh on ht.htbh=jh.hth
and ht.htbh not like'del%' and ht. ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
id url rank ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä
Id value state dattime
101 32.3 0 ......