关于如何在JSP页面内传递参数请教
我想实现JSP一个页面内传递参数，页面分为上部分与下部分；
下部分是A,B,C，D实物的小图，比如，当点A时，上部分会从ACCESS数据库中调用出A的详细信息（A,B,C小图也是由ACCESS中调用出来的,运行决报错，请多多指教。。
程序如下：
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.* " errorPage= " " %>
<html xmlns= "http://www.w3.org/1999/xhtml ">
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 " />
<title> 无标题文档 </title>
<link href= "16.css " rel= "stylesheet " type= "text/css " />
</head>
<body>
<%
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver "); //载入驱动程序类别
Connection con = DriverManager.getConnection( "jdbc:odbc:jspdata "); //建立数据库链接,jspdata为ODBC数据源名称
//建立Statement对象
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery( "select * from watch "); //建立ResultSet(结果集)对象，并执行SQL语句
%>
<div id= "container ">
<div id= "left ">
<div id= "logo "> </div>
<div id= "nav ">
<div id= "menu ">
<ul>
<li> <a href= "# "> <span class= "a "> Home </span> </a> </li>
<li> <a href= "# "> <span class= "a "> Message grom CEO </span> </a> </li>
<li> <a href= "# "> <span class= "a "> Background </span> </a> </li>
<li> <a href= "# "> <span class= "a "> Brands </span> </a> </li>
<li> <a href= "# "> <span class= "a "> Watch making expertise </span> </a> </li>
<li> <a href= "# "> <span class= "a "> Values </span> </a> </li>
<li> <a href= "# "> <span class= "a "> Store </span> </a> </li>
<li> <a href= "# "> <span class= "a "> Contact </span> </a> </li>
</ul>
</div>
</div>
</div>
<div id= "right ">
<div id= "right_top ">
<div id= "watch_logo "> <img src= "images/TRDC_new-logo-small.gif " width= "316 " height= "65 " /> </div>
<%
String picId = " ";
if(request.getParameters( "nid ") !=null)
{
picId = request.getParameters( "nid ");
}
%>
<div id= "watch " > <img src= "images/Fuego-orange21888-10-big.gif " width= "109 " height= "250 " /> </div>
<div id= "text ">
<p> Model No : <br />
Size: <br />
Case: <br />
Dial: <br />
Strap: <br />
Movement: <br />
</p>
</div>
</div>
<div id= "right_bottom ">
<div id= "line1 "> </div>
<div id= "watch_list ">
<%
while(rs.next())
{
%>
<a href= "16.jsp?nid= <%= rs.getString( "id ") %> " > <img src= " <%= rs.getString( "small-img ") %> " width= "44 " height= "100 " border= "0 " /> </a>
<%
}
rs.close();
stmt.close();
con.close();
%>
</div>
<div id= "line2 "> </div>
</div>
</div>
</div>
</div>
</body>
</html>
[解决办法]
帮顶~
[解决办法]
报的什么错
[解决办法]
picId = request.getParameters( "nid ") 中的参数只能是String类的，你是不是传个INT进去了
[解决办法]
少 "; "号
[解决办法]
tt.close();去掉
[解决办法]
努力吧..
[解决办法]
byp_002() ( ) 信誉：100 Blog 2007-02-08 12:40:53 得分: 0
你的 "wid= "是数据库里是int 还是varchar,
要是varchar , sql语句是( "select * from watch where wid = ' "+picId+ " ' ");
要是int , ---
单引号加了吗?
另:
symbol : variable nid
nid未定义
[解决办法]
靠，你这是从那里搞来的垃圾代码，这么多拼写错误。
Objece object
这里应该是Object
Object object = connection.executeQuery( "select * from watch where id = picId ");
应该改为
Object object = stmt.executeQuery( "select * from watch where id = picId ");
又或者你在输入代码时心里面在想着晚上该用什么招式和MM过招。
[解决办法]
能写出这样的代码也不容易了
兄弟，要不去看看基础，要不换个行业吧