redetailok.jsp

这是一个在线教育系统

<%@ include file="conn.jsp"%>
<%
request.setCharacterEncoding("GB2312");
String name=request.getParameter("name");
String title=request.getParameter("title");
String message=request.getParameter("message");
String reid=request.getParameter("reid");
if(reid==null){
out.print("<script>alert('非法操作');history.go(-1);</script>");
}
String sql="select * from scott.work where name='"+name+"' and reid='"+reid+"'"; 
ResultSet rs=stmt.executeQuery(sql); 
   if(rs.next()){
out.print("<script>alert('你已经提交过作业了');history.go(-1);</script>");
   }else{
 stmt.executeUpdate("INSERT INTO scott.work(workid,reid,name,title,message) VALUES(scott.workid.nextval,'"+reid+"','"+name+"','"+title+"','"+message+"')");

out.print("<script>alert('添加成功');window.location.href='index.jsp';</script>");
   }
%>