Oracle & JSP 开发的小型信息管理系统 (五) 源代码4

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

</head>

<!--

.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()){

</tr>

</tr>

</tr>

</tr>

</tr>

</tr>

<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">★

★★

★★★★

★★★★★</span></td>

</tr>

</tr>

</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();

}

</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 Character

String 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){

<tr>

<p align="center"><font color="#FFFFFF"><b>添加修改成功</b></font>

</td>

</tr>

<tr>

<tr>

<td>信息名稱為：<font color="#FF0000"><%=title%></font></td>

</tr>

</table>

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

</head>

<body>

<tr>

</td>

</tr>

<tr>

<tr>

<td>確認刪除編號為：<font color="#FF0000"><%=id%></font>

, 名稱為<font color="#FF0000"><%=title%></font>的信息嗎?</td>

</tr>

</table>

</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();}

Oracle &amp; JSP 开发的小型信息管理系统 (五) 源代码4

Oracle & JSP 开发的小型信息管理系统 (五) 源代码4