editnews.jsp<%@ include file="conn.jsp"%>
<link rel="stylesheet" type="text/css" href="news.css">
<%request.setCharacterEncoding("GB2312");
String id=request.getParameter("id");
if(id!=null){
String sql;
String books_name=request.getParameter("books_name");
String books_author=request.getParameter("books_author");
String books_sort=request.getParameter("books_sort");
String books_bz=request.getParameter("books_bz");
String books_sm=request.getParameter("books_sm");
String books_sy=request.getParameter("books_sy");
String price1=request.getParameter("price1");
String price2=request.getParameter("price2");
String books_bj=request.getParameter("books_bj");
String books_jj=request.getParameter("books_jj");
stmt.executeUpdate("update scott.商品信息 set 名称='"+books_name+"',作者='"+books_author+"',分类='"+books_sort+"',包装='"+books_bz+"',简介='"+books_jj+"',说明='"+books_sm+"',使用='"+books_sy+"',定价='"+price1+"',售价='"+price2+"',标记='"+books_bj+"' where ID='"+id+"'");
out.print("<script language='javascript'>alert('修改成功！！');");
out.print("document.location='newsedit.jsp'</script>");
}
%>
<% id=request.getParameter("id");
String sql="Select * From scott.商品信息 where id='"+id+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){ %>
<form name=form1 method="post" action="editnews.jsp?addtype=modify>">
<input type=hidden name=id value=<%=rs.getString("id")%>>
<P align="center">名称：<INPUT size=85 name=books_name value=<%=rs.getString("名称")%>></P>
<P align="center">作 者：<INPUT size=75 name=books_author <%=rs.getString("作者")%>></P>
<P align="center">分类：<INPUT size=45 name=books_sort value=<%=rs.getString("分类")%>></P>
<P align="center">包装：<INPUT size=45 name=books_bz value=<%=rs.getString("包装")%>></P>
<P align="center">说明：<TEXTAREA cols=73 name=books_sm rows=15><%=rs.getString("说明")%></TEXTAREA></P>
<P align="center">使用：<INPUT size=85 name=books_sy value=<%=rs.getString("使用")%>></P>
<P align="center">定价：<INPUT size=45 name=price1 value=<%=rs.getString("定价")%>>RMB</P>
<P align="center">售价：<INPUT size=45 name=price2 value=<%=rs.getString("售价")%>>RMB</P>
<P align="center">简介：<TEXTAREA cols=73 name=books_jj rows=20><%=rs.getString("简介")%></TEXTAREA></P>
<p align="center">
<INPUT class=buttonface type=submit value=" 确 定 ">
<INPUT class=buttonface type=reset value=" 清 除 "></p>
</form>
<%
}%>
<P align="right">
</BODY>
</HTML>
newswind.jsp
<html>
<head>
<title>商品</title>
<link rel="stylesheet" type="text/css" href="news.css">
</head>
<%@ include file="conn.jsp"%>
<%String id=request.getParameter("id");
String sql="Select * From scott.商品信息 where id='"+id+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){ %>
<table width="100%" HEIGHT=6% border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#FAD185">
<td height=28 align=center bgcolor="#00345A"><b><font color="#ffffff"><%=rs.getString("名称")%></font></b></td>
</tr>
<tr bgcolor="#FAD185">
<td height=28 align=center bgcolor="#00345A"><b><font color="#ffffff"><%=rs.getString("作者")%></font></b></td>
</tr>
<tr bgcolor="#FAD185">
<td height=28 align=center bgcolor="#00345A"><b><font color="#ffffff"><%=rs.getString("分类")%></font></b></td>
</tr>
<tr bgcolor="#FAD185">
<td height=28 align=center bgcolor="#00345A"><b><font color="#ffffff"><%=rs.getString("包装")%></font></b></td>
</tr>
<tr bgcolor="#FAD185">
<td height=28 align=center bgcolor="#00345A"><b><font color="#ffffff"><%=rs.getString("说明")%></font></b></td>
</tr>
<tr bgcolor="#FAD185">
<td height=28 align=center bgcolor="#00345A"><b><font color="#ffffff"><%=rs.getString("使用")%></font></b></td>
</tr>
<tr bgcolor="#FAD185">
<td height=28 align=center bgcolor="#00345A"><b><font color="#ffffff"><%=rs.getString("定价")%></font></b></td>
</tr>
<tr bgcolor="#FAD185">
<td height=28 align=center bgcolor="#00345A"><b><font color="#ffffff"><%=rs.getString("售价")%></font></b></td>
</tr>
<tr bgcolor="#FAD185">
<td height="344" valign=top>
<p><%=rs.getString("简介")%>
</td>
</tr>
<%
}%>
<%
ResultSet rst=stmt.executeQuery(sql);
while(rst.next()) {
%>
<li><a href=newswind.jsp?id=<%=rs.getString("ID")%>><u><%=rs.getString("名称")%></u></a>--<%=rs.getString("作者")%>【<%=rs.getString("时间")%>】
<%
}
rst.close();
stmt.close();
conn.close();
%>
</tr>
</table>
<br>
<b>相关商品：</b>
<ul>
</ul>
</html>
都来帮忙看下，到底哪有问题
