/ltd/ccs/ccs_gz_lastyear/cx/CF_TEST/detail.asp

http://github.com/zhaowe/bc · ASP · 122 lines · 113 code · 8 blank · 1 comment · 2 complexity · e58bfcc829203cc34981f19fce594bd8 MD5 · raw file 

    

  1. <%@ Language=VBScript %>

    2. 

  2. <%

    3. 

  3.    OledbStr_cf = "provider=sqloledb;server=10.254.0.46;database=cftest;uid=sa;pwd=szx6275;"  

    4. 

  4.    Set objConn_cf = Server.CreateObject("ADODB.Connection")

    5. 

  5.    objConn_cf.Open OledbStr_cf

    6. 

  6.    Set objRst=server.CreateObject ("ADODB.Recordset")

    7. 

  7.    objRst.LockType=3

    8. 

  8.    objRst.CursorType=3

    9. 

  9.    set objRst.activeConnection=objConn_cf    

    10. 

  10.    'Á¬½ÓÊý¾Ý¿â

    11. 

  11.    

    12. 

  12.    id=Request.QueryString ("Q")

    13. 

  13.    

    14. 

  14.    SqlIns ="select * from cf_comm where id='"& id &"' "    

    15. 

  15.    objrst.Source =sqlins    

    16. 

  16.    objrst.Open    

    17. 

  17.    

    18. 

  18.    if objrst("sex")=0 then

    19. 

  19.       sex="Å®"

    20. 

  20.    else

    21. 

  21.       sex="ÄÐ"

    22. 

  22.    end if   

    23. 

  23.    

    24. 

  24. %>

    25. 

  25. <HTML>

    26. 

  26. <HEAD>

    27. 

  27. <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">

    28. 

  28. </HEAD>

    29. 

  29. <style type="text/css">

    30. 

  30. 

    31. 

  31. TD {

    32. 

  32.     FONT-FAMILY: ËÎÌå; FONT-SIZE: 15px

    33. 

  33. }

    34. 

  34. </style>

    35. 

  35. <body>

    36. 

  36. <p align="center">¡¡

    37. 

  37. </p>

    38. 

  38. 

    39. 

  39. <p align="center"><b><font size="5"><font color="#CC3300"><%=objrst("name")%></font>¡ª¡ª<font color="#0066FF">Ïêϸ×ÊÁÏ</font></font></b>

    40. 

  40. </p>

    41. 

  41. 

    42. 

  42.  <table border="0" cellspacing="1" width="100%" height="1" bgcolor="#0000FF" bordercolor="#0000FF">

    43. 

  43.     <tr>

    44. 

  44.       <td width="4%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>ÐÕÃû</b></font></td>

    45. 

  45.       <td width="7%" height="1" bgcolor="#FFFFFF"><%=objrst("name")%></td>

    46. 

  46.       <td width="4%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>ÐÔ±ð</b></font></td>

    47. 

  47.       <td width="3%" height="1" bgcolor="#FFFFFF"><%=sex%></td>

    48. 

  48.       <td width="4%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>ÄêÁä</b></font></td>

    49. 

  49.       <%if objrst("age")>0 then%>

    50. 

  50.       <td width="3%" height="1" bgcolor="#FFFFFF"><%=objrst("age")%></td>

    51. 

  51.       <%else%>

    52. 

  52.       <td width="3%" height="1" bgcolor="#FFFFFF"></td>

    53. 

  53.       <%end if%>

    54. 

  54.       <td width="4%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>ÉúФ</b></font></td>

    55. 

  55.       <td width="3%" height="1" bgcolor="#FFFFFF"><%=objrst("shengxiao")%></td>

    56. 

  56.       <td width="4%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>ÐÇ×ù</b></font></td>

    57. 

  57.       <td width="6%" height="1" bgcolor="#FFFFFF"><%=objrst("constellation")%></td>

    58. 

  58.       <td width="4%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>ѪÐÍ</b></font></td>

    59. 

  59.       <td width="3%" height="1" bgcolor="#FFFFFF"><%=objrst("bloodtype")%></td>      

    60. 

  60.       <td width="8%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>³öÉúÈÕÆÚ</b></font></td>

    61. 

  61.       <%if objrst("age")>0 then%>

    62. 

  62.       <td width="15%" height="1" bgcolor="#FFFFFF"><%=objrst("birthday")%></td>

    63. 

  63.       <%else%>

    64. 

  64.       <td width="15%" height="1" bgcolor="#FFFFFF"></td>

    65. 

  65.       <%end if%>

    66. 

  66.     </tr>

    67. 

  67.  </table>  

    68. 

  68.  <table border="0" cellspacing="1" width="100%" height="1" bgcolor="#0000FF" bordercolor="#0000FF">

    69. 

  69.     <tr>

    70. 

  70.       <td width="8%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>°ì¹«µç»°</b></font></td>

    71. 

  71.       <td width="15%" height="1" bgcolor="#FFFFFF"><%=objrst("office_tel")%></td>

    72. 

  72.       <td width="8%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>¼ÒÍ¥µç»°</b></font></td>

    73. 

  73.       <td width="16%" height="1" bgcolor="#FFFFFF"><%=objrst("home_tel")%></td>

    74. 

  74.       <td width="8%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>ËÞÉáµç»°</b></font></td>

    75. 

  75.       <td width="17%" height="1" bgcolor="#FFFFFF"><%=objrst("dorm_tel")%></td>

    76. 

  76.     </tr>

    77. 

  77.  </table>  

    78. 

  78.  <table border="0" cellspacing="1" width="100%" height="1" bgcolor="#0000FF" bordercolor="#0000FF">

    79. 

  79.     <tr>

    80. 

  80.       <td width="5%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>ÊÖ»ú</b></font></td>

    81. 

  81.       <td width="9%" height="1" bgcolor="#FFFFFF"><%=objrst("mobile_tel")%></td>

    82. 

  82.       <td width="5%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>´«ºô</b></font></td>

    83. 

  83.       <td width="15%" height="1" bgcolor="#FFFFFF"><%=objrst("bp_call")%></td>

    84. 

  84.       <td width="6%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>EMAIL</b></font></td>

    85. 

  85.       <td width="26%" height="1" bgcolor="#FFFFFF"><a href="mailto:<%=objrst("email")%>"><%=objrst("email")%></a></td>

    86. 

  86.       <td width="3%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>QQ</b></font></td>

    87. 

  87.       <td width="12%" height="1" bgcolor="#FFFFFF"><%=objrst("qq_code")%></td>

    88. 

  88.     </tr>

    89. 

  89.  </table>   

    90. 

  90.  <table border="0" cellspacing="1" width="100%" height="1" bgcolor="#0000FF" bordercolor="#0000FF">

    91. 

  91.     <tr>

    92. 

  92.       <td width="8%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>¹¤×÷µ¥Î»</b></font></td>

    93. 

  93.       <td width="73%" height="1" bgcolor="#FFFFFF"><%=objrst("corporation")%></td>

    94. 

  94.     </tr>

    95. 

  95.     <tr>

    96. 

  96.       <td width="8%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>¹«Ë¾µØÖ·</b></font></td>

    97. 

  97.       <td width="73%" height="1" bgcolor="#FFFFFF"><%=objrst("office_addr")%></td>

    98. 

  98.     </tr>

    99. 

  99.     <tr>

    100. 

  100.       <td width="8%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>¼ÒÍ¥µØÖ·</b></font></td>

    101. 

  101.       <td width="73%" height="1" bgcolor="#FFFFFF"><%=objrst("home_addr")%></td>

    102. 

  102.     </tr>

    103. 

  103.     <tr>

    104. 

  104.       <td width="8%" height="1" bgcolor="#FFFFFF"><font color="#990099"><b>¹«Ô¢µØÖ·</b></font></td>

    105. 

  105.       <td width="73%" height="1" bgcolor="#FFFFFF"><%=objrst("dorm_addr")%></td>

    106. 

  106.     </tr>            

    107. 

  107.  </table>   

    108. 

  108.  <table border="0" cellspacing="1" width="100%" height="1" bgcolor="#0000FF" bordercolor="#0000FF">

    109. 

  109.     <tr>

    110. 

  110.       <td width="8%" height="1" bgcolor="#FFFFFF"><font color="#990099">&nbsp;&nbsp; 

    111. 

  111.         <b>±¸×¢</b></font></td>

    112. 

  112.       <td width="73%" height="1" bgcolor="#FFFFFF"><%=objrst("memo")%></td>

    113. 

  113.     </tr>         

    114. 

  114.  </table>    

    115. 

  115. <p align="center"><b><font size="4"><font color="#0066FF"><a href="com_modi.asp?Q=<%=id%>">ÐÞ  ¸Ä</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="com_disp.asp">·µ  »Ø</a></font></font></b>

    116. 

  116. </p> 

    117. 

  117. </body>

    118. 

  118. </HTML>

    119. 

  119. <%

    120. 

  120. objrst.Close 

    121. 

  121. 

    122. 

  122. %>
    123.