有关web数据库查询啦！大虾帮帮我啦！

freebyte 2001-07-12 11:58:49

我正在做一个学校的主页，我想实现学校成绩的查询，当然是基于浏览器页面的查询啦，有关数据库查询！
可我对jsp，java,不大了解，会点pb,和一点做主页工具，大虾请务必请帮帮我啦！这边先行谢过了，最好能发过来源代码，我感激不尽！！！

...全文

79 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

freebyte 2001-07-13

打赏
举报

非常感谢！帮助！！

lemonade 2001-07-13

打赏
举报

<%@ LANGUAGE="JAVASCRIPT" %>


<html>
<head>
<title>Deleting Data From Database: Using Stored Proc</title>
</head>
<body>
<%

var conn = Server.CreateObject("ADODB.Connection");
var recordSet = Server.CreateObject("ADODB.RecordSet");
var numRec;

conn.open("DSN=asp_devguide2");

Response.Write("<h1>Before Delete</h1>");
recordSet.Open("select * from products",conn);

Response.Write("<table border=1>");

while(!recordSet.EOF)
{
Response.Write("<tr>");

Response.Write("<td>");
Response.Write(recordSet("name"));
Response.Write("</td>");

Response.Write("<td>");
Response.Write(recordSet("msrp"));
Response.Write("</td>");

Response.Write("</tr>");

recordSet.MoveNext();
}

Response.Write("</table>");

numRec = -1;
conn.execute("deleteAbove(50.0)",numRec,adCmdStoredProc);

if(numRec == 1)
Response.Write("<h2>Deleteted "+numRec+" row.</h2>")
else
Response.Write("<h2>Deleteted "+numRec+" rows.</h2>")

recordSet.Close();
recordSet.Open("select * from products",conn);

Response.Write("<h1>After Delete</h1>");

Response.Write("<table border=1>");

while(!recordSet.EOF)
{
Response.Write("<tr>");

Response.Write("<td>");
Response.Write(recordSet("name"));
Response.Write("</td>");

Response.Write("<td>");
Response.Write(recordSet("msrp"));
Response.Write("</td>");

Response.Write("</tr>");

recordSet.MoveNext();
}

Response.Write("</table>");

conn.close();
conn = null;

%>

</body>
</html>

that's it