%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%
//try{
String title = request.getParameter("title") == null ? "" : sqlbean.GB(request.getParameter("title"));
String content = request.getParameter("content") == null ? "" : sqlbean.GB(request.getParameter("content"));
String id = request.getParameter("id") == null ? "" : sqlbean.GB(request.getParameter("id"));
String status = request.getParameter("status") == null ? "0" : request.getParameter("status");
String name = request.getParameter("name") == null ? "sunneo" : request.getParameter("name");
String pass = request.getParameter("pass") == null ? "sunneo" : request.getParameter("pass");
String s_power = "a";
String s_name = request.getParameter("s_name") == null ? "" : request.getParameter("s_name");
ResultSet sqlRst = null;
String strCon = null;
String strSQL = null;
String name_feedback = request.getParameter("name_feedback") == null ? "#" : sqlbean.GB(request.getParameter("name_feedback"));
String email_feedback = request.getParameter("email_feedback") == null ? "#" : sqlbean.GB(request.getParameter("email_feedback"));
String idea_feedback = request.getParameter("idea_feedback") == null ? "#" : sqlbean.GB(request.getParameter("idea_feedback"));
String tel_feedback = request.getParameter("tel_feedback") == null ? "#" : sqlbean.GB(request.getParameter("tel_feedback"));
//提取提交的留言信息
if(!name_feedback.equals("#"))
{ java.util.Date s_date = new java.util.Date();
java.text.SimpleDateFormat time=new java.text.SimpleDateFormat("yyyy-MM-dd kk:mm:ss");
String dd = time.format(s_date);
sqlbean.executeInsert("insert into t_guestbook(name,email,idea,tel,s_time) values('" + name_feedback + "','" + email_feedback + "','" + idea_feedback + "','" + tel_feedback + "','" + dd + "')");
sqlbean.CloseDataBase();
}
%>
广州三新信息科技有限公司
|
|
|
|
| |
 |
 |
|
|
|
|
<%
sqlRst.close();
sqlbean.CloseDataBase();
//}
//catch(Exception e)
//{out.print(e);}
%>