连接数据库的代码:
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open application("ConnectionString")
Set RS=Server.CreateObject("ADODB.Recordset")
Set RS1=Server.CreateObject("ADODB.Recordset")
查询语句:
sqllook="select top 15 id,title,fileformat,series from film where role>="&session("usertype")&" order by downloadtimes desc,mark desc"