WebRoot/chengji_add_post.jsp

（完整代码） 1KB 

<%@ page language="java"  pageEncoding="gb2312" import="java.sql.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("gb2312"); 
response.setCharacterEncoding("gb2312"); 
%>
<jsp:useBean id="connDbBean" scope="page" class="db.db"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'adminyanzheng.jsp' starting page</title>
    

  </head>
  
  <body>
  <%
 
String xuenian=request.getParameter("xuenian");String xueqi=request.getParameter("xueqi");String banji=request.getParameter("banji");
String xuehao=request.getParameter("xuehao");String xingming=request.getParameter("xingming");String kecheng=request.getParameter("kecheng");String chengji=request.getParameter("chengji");
ResultSet RS_result=connDbBean.executeQuery("select * from [chengji] where xuehao='"+xuehao+"' and kecheng='"+kecheng+"' and xuenian='"+xuenian+"' and xueqi='"+xueqi+"'");

 if(RS_result.next())
{
out.print("<script>alert('该生的该课程成绩已存在，请重试!');window.history.go(-1);</script>");
	}
else{

	
  	  	String sql="insert into chengji(xuehao,xingming,kecheng,chengji,xuenian,xueqi,banji) values('"+xuehao+"','"+xingming+"','"+kecheng+"','"+chengji+"','"+xuenian+"','"+xueqi+"','"+banji+"') ";
  	  	
  	  	connDbBean.executeUpdate(sql);
  	  	out.print("<script>alert('添加成功!!');location.href='chengji_add.jsp';</script>");
  	  
	}
RS_result.close();

 %>
  </body>
</html>

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。