leavewords1.jsp

jsp做的一个个人网站

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*"   errorPage=""%>
<% //request.setCharacterEncoding("gb2312");
request.setCharacterEncoding("gb2312");
String content=request.getParameter("content").trim();
String publisher=(String)session.getAttribute("customer");
//String publishdate="发表于"+new SimpleDateFormat("yyyy年MM月dd日 HH:mm:ss").format(new Date());
//String publishdate="2008-12-13";
String publishdate="发表于"+new java.text.SimpleDateFormat("yyyy年MM月dd日HH时mm分ss秒").format(new java.util.Date());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
String sql="insert into leavewords(publisher,content,publishdate)values('"+publisher+"','"+content+"','"+publishdate+"')";
Statement set=con.createStatement();
set.executeUpdate(sql);
con.close();
out.print("<script> {alert('感谢您的留言！');window.open('allleavewords.jsp','_self') }</script>");%>