%complaint.jsp<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<style type="text/css">
<!--
.STYLE1 {
font-size: xx-large;
color: #00FFFF;
}
body {
background-image: url();
}
.STYLE3 {
font-size: x-large;
color: #00FF00;
}
.STYLE5 {
color: #0000FF;
font-size: 36px;
}
.STYLE8 {font-size: 56px; color: #00FFFF; }
.STYLE6 {
font-size: 24px;
color: #FFFF00;
}
-->
</style>
<BODY  bgcolor=purple >
    <p align="center" class="STYLE8">欢迎使用环球旅游网站</p><span class="STYLE2 STYLE6" c>请将您宝贵的意见或建议留给我们,我们会竭诚为您服务!</span>
    <p align="center" class="STYLE8">    
<FORM  action="ComNew.jsp" method="post">
    <div align="center">
      <p align="center" colour=yellow><span class="STYLE3">意见或建议:</span>      &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <textarea name="name" class="STYLE1" align="middle"></textarea>
        <br> 
     </p>
      <p>&nbsp;</p>
      <p align="center"><font size="3"><br> 
          <input type="submit" name="b" class="STYLE5" value="提交" color="#CCFF00"> 
      </font>        </p>
  </div>
</FORM>
   </BODY>
</HTML>
%ComNew.jsp
  
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML><style type="text/css">
<!--
body {
background-image: url();
background-color: #FFFFAA;
}
.STYLE9 {
color: #3300CC;
font-size: 36px;
}
-->
</style>
<BODY>
<div align="center">
<%  
  request.setCharacterEncoding("UTF-8"); 
     String name=request.getParameter("name"); 
     if(name==null) 
       { 
         name=""; 
       } 
     byte b[]=name.getBytes("ISO-8859-1"); 
     name=new String(b); 
 
      Connection con=null; 
      Statement sql=null; 
       ResultSet rs=null; 
      try{ 
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
         } 
      catch(ClassNotFoundException event){} 
 
      try{ 
           con=DriverManager.getConnection("jdbc:odbc:complaint","",""); 
           sql=con.createStatement(); 
           String condition= 
            "INSERT INTO com VALUES"+"("+"'"+name+"','"; 
           sql.executeUpdate(condition); //执行添加操作 
          // System.out.println(condition); 
            
            
           //catch(Exception ee){ 
           //System.out.println(ee.toString()); 
           
           rs=sql.executeQuery("SELECT * FROM com"); 
           out.print("<Table Border>"); 
           out.print("<TR>"); 
           out.print("<TH width=100 bgcolor=yellow>"+"意见及建议"+"</th>"); 
           
 
           while(rs.next()) 
             { 
               out.print("<TR  bordercolorlight=pink>"); 
                String a=rs.getString(1); 
                out.print("<TD bgcolor=pink>"+a+"</TD>"); 
                out.print("</TR>"); 
             } 
 
           out.print("</Table>"); 
           con.close(); 
        } 
         
     catch(SQLException event) 
        {} 
  %> 
  <p><span class="STYLE9">谢谢您的建议,我们会及时采纳!</span></p>
  <p><font size="3"><a href="index.html"><img width="115" height="40" border="0" align="middle" src="sucai/title3.gif"></a></font></p>
</div>
<font size="3"> 
</font>
</BODY>
</HTML>