xmycalendarmodify.jsp

来自「1.安装配置tomcat+mysql5环境; 2.执行sql.sql; 3.」· JSP 代码 · 共 54 行

JSP
54
字号
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="../oa.css" rel="stylesheet" type="text/css">
</head>
<body class="notice">
        <p>
          <%
	String idx = request.getParameter("id"); 
	String byear = request.getParameter("byear"); 
	String bmon = request.getParameter("bmon"); 
	String bday = request.getParameter("bday"); 
	String eyear = request.getParameter("eyear"); 
	String emon = request.getParameter("emon"); 
	String eday = request.getParameter("eday"); 
	String content = request.getParameter("content"); 
	content = content.replaceAll("\"","&quot;");
	content = content.replaceAll("\'","&quot;");
	String title = request.getParameter("title"); 
	String myyes = request.getParameter("myyes"); 
	
	String sql="";
	String beg = byear+"-"+bmon+"-"+bday;
	String end = eyear+"-"+emon+"-"+eday;

	
	
	if((idx==null)){
		response.sendRedirect("../showcalendar.jsp?t=1");
	}
	else {
		sql = "update  xcalendar set title='"+title+"',content='"+content+"',begtime='"+beg+"',endtime='"+end+"',check='"+myyes+"' ";
		sql = sql+" where id='"+idx+"' ";
	dbc.getConnection();
		//out.println(sql);
		dbc.update(charset.ISO_2_GBK(sql));

	dbc.close();

		response.sendRedirect("../calendarquery.jsp?t=0");
	}
	
%>
</p>

 <p align="center"><%@include file="../include/foot.jsp" %></p>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?