wenzhangstore.jsp

jsp做的一个个人网站

<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%  
 request.setCharacterEncoding("gb2312");
String title=request.getParameter("title").trim(); 
String publisher=(String)session.getAttribute("customer");
String ct=request.getParameter("ct").trim();

String publishdate=new java.text.SimpleDateFormat("yyyy年MM月dd日HH时mm分ss秒").format(new java.util.Date());
//publisher=session.getAttribute("customer");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
String sql="insert into wenzhang(timu,zuozhe,neirong,shijian)values('"+title+"','"+publisher+"','"+ct+"','"+publishdate+"')";
//String sql="insert into wenzhang(timu,zuozhe,neirong,shijian)values('title','asas',cont','publishdate')";
Statement stmt=con.createStatement();
stmt.executeUpdate(sql);
con.close();
 out.print("<script> {alert('保存成功！');window.open('zhongshuofenyun.jsp','_self') }</script>");
 %>