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><meta http-equiv="Content-Type" content="text/html; charset=big5"><title>修改信息</title><!--meta name="GENERATOR" content="Microsoft FrontPage 4.0"--><link rel="stylesheet" href=>
</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")%>&nbsp;    點繫次數:<%=rs.getString("hits")%>&nbsp;    創建時間:<%=rs.getString("date_and_time")%>&nbsp;  <%    }}  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"/>&nbsp;  <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 Char
上一个：原创 Eclipse 3.1M5a中创建RCP程序
下一个：Oracle & JSP 开发的小型信息管理系统 (四) 源代码3
更多图片编程知识:
Oracle &amp; JSP 开发的小型信息管理系统 (五) 源代码4

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