%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>
<textarea name="name" class="STYLE1" align="middle"></textarea>
<br>
</p>
<p> </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>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货