IDC资讯中心
//edit.jsp,通过manage.jsp链接过来的修改信息页面
<%@ include file="articleconn.jsp"%><%string id1=request.getparameter("id").trim();
session.setattribute("id", id1);int id=integer.parseint(id1);string queryinfo=" select * from learning where article_id="+id+" ";string updatehits=" update learning set hits=hits+1 where article_id="+id+" ";boolean autocommit=conn.getautocommit();
%>
<html><head><meta http-equiv="content-type" content="text/html; charset=big5"><title>修改信息</title><!–meta name="generator" content="microsoft frontpage 4.0"–><link rel="stylesheet" href="css/style.css"/>
</head><style type="text/css"><!–.style2 { color: #ffffff; font-weight: bold;}.style3 {color: #ff0000}.style5 {color: #0080c0}–></style><form method="post" action="saveedit.jsp" ><%
try{conn.setautocommit(false);preparedstatement ps=conn.preparestatement(updatehits);int results=ps.executeupdate();if(results>0){out.println();}conn.commit();ps=conn.preparestatement(queryinfo);resultset rs=ps.executequery();while(rs.next()){
%> <table width="100%" border="1" cellspacing="1" cellpadding="1"> <tr bordercolor="#ffffff" bgcolor="#b5d85e"> <td height="24" colspan="2"><div align="center"><span class="style2">修 改 信 息</span></div></td> </tr> <tr bordercolor="#ffffff" bgcolor="#ffffff"> <td width="14%" height="24"><span class="style5">信息名稱</span></td> <td width="86%"><input type="text" name="title" value="<%=rs.getstring("title")%>" size=70></td> </tr> <tr bordercolor="#ffffff" bgcolor="#ffffff"> <td height="23"><span class="style5">鏈接地址</span></td> <td><input type="text" name="url" value="<%=rs.getstring("url")%>" size=70></td> </tr> <tr bordercolor="#ffffff" bgcolor="#ffffff"> <td height="28"><span class="style5">信息類型</span></td> <td><input type="text" name="types" value="<%=rs.getstring("types")%>" size=70></td> </tr> <tr bordercolor="#ffffff" bgcolor="#ffffff"> <td height="26"><span class="style5">信息說明</span></td> <td><input type="text" name="content" value="<%=rs.getstring("content")%>" size=70></td> </tr> <tr bordercolor="#ffffff" bgcolor="#ffffff"> <td height="29"><span class="style5">信息大小</span></td> <td><input type="text" name="big" value="<%=rs.getstring("big")%>" size=70></td> </tr> <tr bordercolor="#ffffff" bgcolor="#ffffff"> <td height="27"><span class="style5">信息評價</span></td> <td>目前信息評價<% string temp=rs.getstring("vote"); //out.println(temp); int tempvotes=integer.parseint(temp); for(int i=0; i<tempvotes; i++){%><font color="red">★</font><%} %>重新選定評價<span class="style3"> <input name="vote" type="radio" value="1">★ <input name="vote" type="radio" value="2"> ★★ <input name="vote" type="radio" value="3" checked>★★★<input name="vote" type="radio" value="4"> ★★★★ <input name="vote" type="radio" value="5"> ★★★★★</span></td> </tr> <tr bordercolor="#ffffff" bgcolor="#ffffff"> <td height="24"><span class="style5">相關主頁</span></td> <td><input type="text" name="from1" value="<%=rs.getstring("from1")%>" size=70></td> </tr> <tr bordercolor="#ffffff" bgcolor="#ffffff"> <td height="32"><span class="style5">相關地址</span></td> <td><input type="text" name="form_url" value="<%=rs.getstring("form_url")%>" size=70> </td> </tr> <tr> </tr> </table> id:<%=rs.getstring("article_id")%> 點繫次數:<%=rs.getstring("hits")%> 創建時間:<%=rs.getstring("date_and_time")%> <% }} catch(sqlexception se1) {se1.printstacktrace(); conn.rollback();} catch(numberformatexception n1) {n1.printstacktrace(); throw n1; } finally{ conn.setautocommit(autocommit); conn.close(); } %> <br><center> <input type="submit" value="確認修改" class="buttonface"/> <input type="reset" value="清除" class="buttonface"/></center></form></html>
//************************************保存修改:saveedit.jsp
<%@ include file="articleconn.jsp"%><%@ page import="moonsoft.test.j2ee.news.*"%><%string title1=request.getparameter("title");string url1=request.getparameter("url");string content1=request.getparameter("content");string types1=request.getparameter("types");//string hits1=request.getparameter("hits");string big1=request.getparameter("big");string vote1=request.getparameter("vote");string from1=request.getparameter("from1");string form_url1=request.getparameter("form_url");//string querydbtime=" select to_char(systimestamp, yyyy-mm-dd hh24:mi:ss) from dual ";//filter special characterstring types=filterspecial.filter(types1);string url=filterspecial.filter(url1);string content=filterspecial.filter(content1);string big=filterspecial.filter(big1);int vote=integer.parseint(vote1);string from=filterspecial.filter(from1);string form_url=filterspecial.filter(form_url1);string title=filterspecial.filter(title1);
string id=(string)session.getattribute("id");//out.println(id);boolean autocommit=conn.getautocommit();string update=" update learning "+ " set title="+title+", url="+url+", types="+types+", content="+content+", big="+big+", vote="+vote+", form_url="+form_url+", from1="+from+" "+ " where article_id="+id+" ";//out.println(update);try{conn.setautocommit(false);preparedstatement ps=conn.preparestatement(update);int result =ps.executeupdate();if(result>0){%><div align="center"> <p> </p><table border="1" cellspacing="0" width="50%" bgcolor="#f0f8ff" bordercolorlight="#000000" bordercolordark="#ffffff" align="center"> <tr> <td width="100%" bgcolor="#b5d85e" height="20"> <p align="center"><font color="#ffffff"><b>添加修改成功</b></font> </td> </tr> <tr> <td width="100%" height="177"> <table width="80%" border="0" cellspacing="0" cellpadding="2" align="center" bordercolorlight="#000000" bordercolordark="#ffffff"> <tr> <td>信息名稱為：<font color="#ff0000"><%=title%></font></td> <td>編號為：<font color="#ff0000"><%=id%></font></td> </tr> </table> <p align="center"> </p> <p align="center"><a href="manage.jsp">返回管理頁面</a><br> </p> </td> </tr> </table></div><%//response.sendredirect("manage.jsp");}conn.commit();}
catch(sqlexception se1){se1.printstacktrace(); conn.rollback();}finally{conn.setautocommit(autocommit);conn.close();}%>
//**********************删除页面之一:提示要删除的信息delete.jsp
<%@ include file="article.jsp"%><%
string id=request.getparameter("id");string title=request.getparameter("title");//out.println(title);%><html> <head> <meta http-equiv="content-type" content="text/html; charset=big5"> <title>確認刪除</title> </head> <body> <div align="center"> <p> </p><table border="1" cellspacing="0" width="50%" bgcolor="#f0f8ff" bordercolorlight="#000000" bordercolordark="#ffffff" align="center"> <tr> <td width="100%" bgcolor="#b5d85e" height="20"> <p align="center"><font color="#ffffff"><b>刪除信息</b></font> </td> </tr> <tr> <td width="100%" height="177"> <table width="80%" border="0" cellspacing="0" cellpadding="2" align="center" bordercolorlight="#000000" bordercolordark="#ffffff"> <br><br> <tr> <td>確認刪除編號為：<font color="#ff0000"><%=id%></font> , 名稱為<font color="#ff0000"><%=title%></font>的信息嗎?</td> </tr> </table> <br><br> <p align="center"><a href="savedelete.jsp?id=<%=id%>">是</a> <a href="manage.jsp">否</a></p> </td> </tr> </table></div> </body>
</html>//***************删除页面之二:savedelete.jsp,删除成功后直接跳转到manage.jsp页面
<%@ include file="articleconn.jsp"%><%
string id=request.getparameter("id");boolean autocommit=conn.getautocommit();string delete=" delete from learning where article_id="+id+" ";
try{conn.setautocommit(false);preparedstatement ps=conn.preparestatement(delete);int rs=ps.executeupdate();if(rs>0){response.sendredirect("manage.jsp");}}catch(sqlexception se1){se1.printstacktrace(); conn.rollback();}finally{conn.setautocommit(autocommit); conn.close();}%>
