<%@ page contentType="text/html; charset=UTF-8" language="java" import="java.util.Date" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.text.*"%>
<%@ page import="org.apache.log4j.Logger" %>
<%@ page import="db.conn.dataConn;"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
String number=request.getParameter("number");
String theme=request.getParameter("theme");
String content=request.getParameter("content");
Logger log = Logger.getLogger(this.getClass());
if(theme!=null&&!"".equals(theme))
{
dataConn conn=new dataConn();
try{
conn.startConn();
Date now = new Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String time = dateFormat.format(now);
String sql="insert into feedback(theme,content,date,number) values (?,?,?,?);";
sql=new String(sql.getBytes("ISO8859-1"),"utf-8");
PreparedStatement pstmt = conn.getPreparedStat(sql);
pstmt.setString(1,new String(theme.getBytes("ISO8859-1"),"utf-8"));
pstmt.setString(2,new String(content.getBytes("ISO8859-1"),"utf-8"));
pstmt.setString(3,time);
pstmt.setString(4,new String(number.getBytes("ISO8859-1"),"utf-8"));
pstmt.executeUpdate();
log.info("excute sql = "+sql);
out.print("");
}catch(Exception e){
log.error("------->error: "+e.toString());
out.print("");
}
conn.closeConn();
}
%>
Viewin--技术支持
All rights reserved.
Viewin 版权所有 浙ICP备16039039号-1