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] | 
