📄 checkmodify.jsp

📁 毕业设计时做的,一个管理关于污染管理的, 源代码,呵呵想想当时还真厉害,可以实现污染检测

💻 JSP

字号:

<HTML>
<BODY>
<%@ page import="java.util.*, java.sql.*"
	contentType="text/html;charset=GB2312" %>
<jsp:useBean id="pool" scope="application" class="chapter10.ConnPool"/>
<%if (session.getAttribute("Name")==null){
	response.sendRedirect("login.html");	
}%>
<%String type=request.getParameter("type");
  String id=request.getParameter("id");
  String articleid=request.getParameter("articleid");
  String work=request.getParameter("work");
  String title=request.getParameter("title");
  String content=request.getParameter("content");
  Calendar cal=Calendar.getInstance();
  String postdate=cal.get(Calendar.YEAR)+"-"+cal.get(Calendar.MONTH)+"-"+cal.get(Calendar.DATE);
  %>
  <%if (title.equals("") || content.equals("")){%>
  标题和文章内容均不能为空！<br>
  <a href="javascript:history.back();">返回</a>
  <%}else{%>
	<%@ include file="conn.jsp"%>  
	<%sql="select ID from Users where Name='"+session.getAttribute("Name")+"'";
  	ResultSet rs=statement.executeQuery(sql);
  	rs.next();
  	int authorid=rs.getInt("ID");
  	out.print(type+work);
  	title=new String(title.getBytes("iso8859-1"), "gb2312");
  	content=new String(content.getBytes("iso8859-1"), "gb2312");  	
  	if (type.equals("article")){
  		if (work.equals("write")){
  			sql="insert into Articles (AuthorId,PostDate,Title,Content) values ("
  			+authorid+",'"+postdate+"','"+title+"','"+content+"')";
  		}else if (work.equals("modify")){
  			sql="update Articles set PostDate='"+postdate+"',Content='"+content+"' where ID="+id;
  		}
  	}else if (type.equals("re")){
  		if (work.equals("write")){
  			sql="insert into ReArticles (ArticleId,AuthorId,PostDate,Title,Content) values ("
  			+id+","+authorid+",'"+postdate+"','"+title+"','"+content+"')";  		
  		}else if (work.equals("modify")){
  			sql="update ReArticles set PostDate='"+postdate+"',Content='"+content+"' where ID="+id;
  		}
  	}
  	statement.executeUpdate(sql);
	%>
	<%@ include file="disconn.jsp"%>
	<%if (work.equals("write")){
		response.sendRedirect("list.jsp?id="+id+"&type="+type);
	  }else if (work.equals("modify")){
	  	if (type.equals("article")){
	  		response.sendRedirect("detail.jsp?id="+id+"&type=article");
	  	}else if (type.equals("re")){
	  		response.sendRedirect("detail.jsp?id="+id+"&type=re&articleid="+articleid);
	  	}
	  }
	%>
  <%}%>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -