菜鸟请教jsp !!!!!!!!!!!!!!!!!!!!!!!!!1
请大家帮我看一下本人做的程序,有错误的地方请帮我改正一下,谢谢。
代码如下:
<HTML>
<HEAD>
<TITLE> 命运</TITLE>
<META NAME="Description" CONTENT="">
</HEAD>
<BODY>
<form bgcolor="#F5F5F5" method="post" action="list.jsp">
<center><font color=green><h2>在线算命</font></center></h2>
<marquee direction=left behavior=alternate loop=20000 scrollamount=10><p> <IMG SRC="../../../picture.jpg" WIDTH="485" HEIGHT="248" BORDER=0 ALT=""></p></marquee>
<br>
<table border="0" width="600" valign="middle" cellspacing="0" cellpadding="0" align="left" bgcolor="#CCFF00" background="#00FF33">
<p> <tr><td> <p><h2>星座:
<select name="area" size="1" >
<option value=""> ------</option>
<option value='水平座'>水平座</option>
<option value='双鱼座'>双鱼座</option>
<option value='白羊座'>白羊座</option>
<option value='金牛座'>金牛座</option>
<option value='双子座'>双子座</option>
<option value='巨蟹座'>巨蟹座</option>
<option value='狮子座'>狮子座</option>
<option value='处女座'>处女座</option>
<option value='天平座'>天平座</option>
<option value='天蝎座'>天蝎座</option>
<option value='射手座'>射手座</option>
<option value='摩羯座'>摩羯座</option></h2>
</select>
<br>
<p>
<tr >
<td width=344> <h2><input type="submit" name="Input" value="算命"></h2> </td>
</tr>
</p>
</table>
</form>
</BODY>
</HTML>
<list.jsp>代码:
<%@ page import="java.lang.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<HTML>
<HEAD>
<TITLE> 在线算命</TITLE>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
a { text-decoration: none }
a:link { text-decoration: none; color: blue }
a:visited { text-decoration: none; color: blue }
a:active { text-decoration: underline; color: #FF0000 }
a:hover { color: #FF0000; text-decoration: underline }
--></style>
<BODY bgcolor="#FFFFFF" cellPadding=0 cellSpacing=0>
<%
String area=request.getParameter("area");
area=new String(area.getBytes("ISO8859_1"),"GBK");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:book");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSIVE,RssultSet.CONCUR_READ_ONLY);
String sql="select * from text where name='"+area+"'";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
水平座:<%=rs.getString(1)%>
双鱼座: <%=rs.getString(2)%>
白羊座: <%=rs.getString(3)%>
金牛座:<%=rs.getString(4)%>
双子座:<%=rs.getString(5)%>
巨蟹座:<%=rs.getString(6)%>
狮子座:<%=rs.getString(7)%>
处女座:<%=rs.getString(8)%>
天平座:<%=rs.getString(9)%>
天蝎座:<%=rs.getString(10)%>
射手座:<%=rs.getString(11)%>
摩羯座:<%=rs.getString(12)%>
<%}
rs.close();
stmt.close();
con.close();
}
catch(SQLException ex)
{
out.println("sqlexception:"+ex.getMessage()+);
%>
</HEAD>
</BODY>
</HTML>