//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();
%>
//************************************保存修改: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){%>
| 添加修改成功 | ||
|
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);%>
//***************删除页面之二: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();}%>