xiejihuaact.jsp.bak

研究生周考核系统

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorinfo.jsp"%>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%!String sql;%>
<%
String bianma = (String)session.getAttribute("bianma");
//String user=new String(request.getParameter("user").getBytes("iso-8859-1"));
String name=new String(request.getParameter("name").getBytes("iso-8859-1"));
String nianji=new String(request.getParameter("nianji").getBytes("iso-8859-1"));
String riqi=new String(request.getParameter("riqi").getBytes("iso-8859-1"));
String zhouci=new String(request.getParameter("zhouci").getBytes("iso-8859-1"));
String jihua=new String(request.getParameter("jihua").getBytes("iso-8859-1"));
String zongjie=new String(request.getParameter("zongjie").getBytes("iso-8859-1"));
String beizhu=new String(request.getParameter("beizhu").getBytes("iso-8859-1"));
String ip=request.getRemoteAddr();
 sql="insert into kaohe(bianma,name,nianji,riqi,zhouci,jihua,zongjie,ip,beizhu)";
    sql=sql+" values('"+bianma+"','"+name+"','"+nianji+"','"+riqi+"','"+zhouci+"','"+jihua+"','"+zongjie+"','"+ip+"','"+beizhu+"')";
    stmt.executeUpdate(sql);
stmt.close(); 
conn.close();
out.print("<script>");
out.print("alert('恭喜你，本周计划和上周小结添加成功!');");
out.print("window.location.href='kanjihua.jsp';");
out.print("</script>");
%>