xreportaudit.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%
//
	String idx=request.getParameter("id");
	String comments = request.getParameter("comments");
	String user=(String)session.getAttribute("user");
	String part=(String)session.getAttribute("part");
	String pubtime = dateformat.getStringDate();
	String sql = "insert into  reportcomments(reportid,comments,user,part,pubtime,cid) values('"+idx+"','"+comments+"','"+user+"','"+part+"','"+pubtime+"','"+scid+"')";
	//out.println(charset.ISO_2_GBK(sql));
	dbc.getConnection();
	dbc.update(charset.ISO_2_GBK(sql));
	dbc.close();
	response.sendRedirect("../reportlist.jsp");
%>