t; href="css/article.css"> </head> <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> </tr> </table> <p align="center"> </p> <p align="center"> <a href="add.jsp"> 繼續添加數據</a> <a href="manage.jsp">返回管理頁面</a><br> </p> </td> </tr> </table> </div> <%conn.commit();}} catch(SQLException se1) {se1.printStackTrace(); conn.rollback();} finally{
conn.setAutoCommit(autoCommit); conn.close(); } %>
//*******************************显示信息页面:通过javascript 在index.jsp里弹出的窗口:view.jsp <%@ include file="articleconn1.jsp"%> <% String id1=request.getParameter("id").trim(); 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%"><%=rs.getString("title")%></td> </tr> <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <td height="23"><span class="style5">鏈接地址</span></td> <td><%=rs.getString("url")%></td> </tr> <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <td height="28"><span class="style5">信息類型</span></td> <td><%=rs.getString("types")%></td> </tr> <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <td height="26"><span class="style5">信息說明</span></td> <td><%=rs.getString("content")%></td> </tr> <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <td height="29"><span class="style5">信息大小</span></td> <td><%=rs.getString("big")%></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><%} %> </tr> <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <td height="24"><span class="style5">相關主頁</span></td> <td><%=rs.getString("from1")%></td> </tr> <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <td height="32"><span class="style5">相關地址</span></td> <td><%=rs.getString("form_url")%></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"/> --> </center> </form> </html>
上一页 [1] [2] [Web开发]JSP入门学习经验总结 [Sql Server]Sql精妙语句--各种求值函数 [网页制作]网页表格之---多个表格纵向排列 [网页制作]JavaScript另类用法--读取和写入cookie [网页制作]号称非常安全的上网工具---360安全浏览器介绍 [办公软件]信息技术教学篇---Word工具栏的显示、隐藏及四种菜… [操作系统]开始菜单---运行命令大总结 [操作系统]网络转载---64位操作系统与32位的区别 [操作系统]ldap:///(没有响应)Windows无法访问指定设备、路径… [网络技术]安全篇---交换机设置方法介绍
|