<% ' --------------------------- 创建连接数据库 --------------------------- '注：以 Access 数据库为连接对象，连接对象名为：Conn。 Set ProduConn = Server.CreateObject("ADODB.Connection") cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & Server.MapPath("Database/Produ.mdb") ProduConn.Open cnnStr Set Conngao = Server.CreateObject("ADODB.Connection") cnnStrgao = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & Server.MapPath("Database/Other.mdb") Conngao.Open cnnStrgao Set ConnNews = Server.CreateObject("ADODB.Connection") cnnStrNews = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & Server.MapPath("Database/News.mdb") ConnNews.Open cnnStrNews Set Conn = Server.CreateObject("ADODB.Connection") cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & Server.MapPath("Database/Book.mdb") Conn.Open cnnStr ' --------------------------- 创建记录集 --------------------------- '注：记录集名 "Rs" 应与表名相加。并以 3, 2 方式打开。 Set ContentRs = Server.CreateObject("ADODB.RecordSet") ContentSQL = "Select * From Content" ContentRs.Open ContentSQL, Conngao, 3, 2 Set ProduRs = Server.CreateObject("ADODB.RecordSet") ProduSQL = "Select * From Produ Order By ID DESC" ProduRs.Open ProduSQL, ProduConn, 3, 2 Set HomeNewsRs = Server.CreateObject("ADODB.RecordSet") HomeNewsSQL = "Select top 8 * From HomeNews Order by ID Desc" HomeNewsRs.Open HomeNewsSQL, ConnNews, 3, 2 Set Produtype = Server.CreateObject("ADODB.RecordSet") Produtype1 = "Select * From Produtype Order By ID DESC" Produtype.Open Produtype1, ProduConn, 3, 2 set Bookrs = Server.CreateObject("ADODB.Recordset") Booksql = "select * from Book" Bookrs.open Booksql,conn,3,2 Dim j j = Produtype.RecordCount Dim Produ_type(30),imaetype(30) For i = 0 to Produtype.RecordCount - 1 Produ_type(i) = Produtype("produtype") imaetype(i)=Produtype("produimage") Produtype.Movenext Next %> 长春净月潭
　　Noble Hotel is the first five-star foreign-related hotel in Jilin Province. Every well trained employee in our hotel will offer every guest meticulous service. At present, Noble Hotel is the largest high-grade hotel in Changchun City, with a construction area of 42,500 m², 25 floors and 301 suites and guest rooms. There is leisure, entertainment, dining and shopping facilities, which provide the best choice for you, either for business or for tourism.Changchun City is the capital of Jilin Province, as well as its political, economic, technological, cultural and educational center. With the transportation extending in all directions, it is also the communication hub of northeast China. Meanwhile, Changchun is a capital city with three famous titles, that is, the biggest auto city, movie city and forest city in China. In addition, Changchun enjoys the reputation of culture city. With broad and straight streets surrounded by green trees on both sides, Changchun has convenient transportation, thus considered a bright pearl in northeast China. Noble Hotel lies just in the middle section of Renmin Street which is the most convenient street in Changchun City.
Number of guest rooms: 320
Single rooms: RMB 1120
yuanSuites: RMB 2240 yuan
Double rooms: RMB 880 yuan
Entertainmnet
　Sight-seeing boat......
　Super swing......
　frog jump......
　special skiing ground......
Hotel
　Chaibai mountain hotel
　Grat wall grand Hotel
　Changchun Noble hotel
　Changchun Shangri-la Grand Hotel
2002@copy the copyright belonging to Changchun Jingyuetan Tourism Development Co., Ltd.
E-mail:jingyuetan@jingyuetan.com
<% If Request("radiobutton")<>"" then strsql2 = "update Book set Hits =hits+1 Where proname ='"&Request("radiobutton")&"'" conn.execute(strsql2) response.write"" End if %>