📄 readtxt.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="connect.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<%
'create the fso object
set fso = Server.Createobject("Scripting.FileSystemObject")
path = "c:/daibiao.txt"
' open the file
set file = fso.opentextfile(path, 1)
'接着，分析每一行，并且格式化数据：
Set rs = Server.CreateObject("ADODB.Recordset")
sqlStr = "select * from tblDelegate"
rs.open sqlStr,dataConn,1,3
do until file.AtEndOfStream
text = file.ReadLine
rs.AddNew
temp = replace(left(text,6)," ","")
rs("fldname") = replace(temp," ","")
rs("fldresume") = replace(text," ","")
rs.Update
loop
rs.close
set rs=nothing
'close and clean up
file.close
set file = nothing
set fso = nothing
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -