5、效益分析
String typeId=request.getParameter("type");
String bm=request.getParameter("bm");
String bdcs=request.getParameter("bdcs");
String puttime=request.getParameter("puttime");
"news_dt.url,news_dt.bdcs,news_dt.puttime from news_dt,tzbm,usergl where news_dt.news_id='"+newsId+"'"+
" and news_dt.bm_id=tzbm.bm_id and usergl.id=news_er_id ");
<td>
<select name="type">
<option value="0">----请选择----</option>
<%
rs=db.stmt.executeQuery("select * from news_type");
while(rs.next()){
out.print("<option value="+rs.getString(1)+">-----"+new String(rs.getString(2).trim().getBytes("iso8859_1"))+"-----</option>");
%>
<%
}catch(Exception e){
out.print("发生意外错误："+e.toString());
}finally{
if(rs!=null){rs.close();rs=null;}
db.closeConnection();
}
%>
2、查看信息
<%
String newsId=request.getParameter("news_id");
db.stmt.executeUpdate("update news_dt set bdcs=bdcs+1 where news_id='"+newsId+"'");
rs=db.stmt.executeQuery("select news_dt.title,,tzbm.bm_name,news_dt.content,"+
}
%>
</select>
</></tr>
<tr height="40"><td><img src=images/yd.gif>其它：</td>
<td><input type="input" name="url" size="72"></td></tr>
<tr height="40"><td></td>
<tr height="40"><td><img src=images/yd.gif>名称*：</td>
<td><input type="text" name="title" size="72"></td>
<tr height="40"><td><img src=images/yd.gif>简介：</td>
if(title==null||title.length()==0||typeId.equals("0")){
out.print("<script>window.alert('您可能漏填或漏选了某项');history.back()</script>");
return;
}
String content=request.getParameter("context");
if(!rs.next()){
db.closeConnection();
out.print("此条信息可能已被删除！");
return;
}
String url=rs.getString(5);
if(url!=null&&url.length()!=0&&!url.equals("null")){
%>
<td><textarea name="context" rows="15" cols="72"
style="COLOR:#606060; FONT-SIZE: 12px;border-style: solid;border-width: 1;"
></textarea></td></tr>
<tr height="40"><td><img src=images/yd.gif>类别*：</td>
String url=request.getParameter("url");
ResultSet rs=null;
try{
db.creatConnection();
db.stmt.executeUpdate("insert into news_dt(user_id,title,content,type_id,bm_id,url,bdcs,puttime) values"+
结算表：(user_id,book_id,num,price,total,all,all-dz,money)
技术路线（系统实现）
一、采用工具
二、主要功能的实现
1、商品上架
<HTML>
<HEAD>
<LINK href="css.css" rel=stylesheet type=text/css>
<TITLE></TITLE>
<td>
<select name="bm">
<option value="0">--请选择--</option>
<%
ResultSet rs=null;
try{
db.creatConnection();
rs=db.stmt.executeQuery("select * from tzbm");
while(rs.next()){
" ('"+userId+"','"+title+"','"+content+"','"+typeId+"','"+bm+"','"+url+"','0',getdate())");
out.print("恭喜您!!发布已成功,页面在<font color=red>3</font>秒后自动跳转");
out.print("<meta http-equiv=refresh content=2;url=newsview.jsp>");
out.print("<option value="+rs.getString(1)+">--"+new String(rs.getString(2).trim().getBytes("iso8859_1"))+"--</option>");
}
%>
</select>
</td></tr>
<tr><td><img src=images/yd.gif>商品类型*：</td>
ResultSet rs=null;
try{
db.creatConnection();
db.stmt.executeUpdate("update news_dt set bdcs=bdcs+1 where news_id='"+newsId+"'");
rs=db.stmt.executeQuery("select news_dt.title,,tzbm.bm_name,news_dt.content,"+
