WebRoot/ScoreSummaryEdit.jsp

（开头部分） 3KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*,prj.db.*,java.util.*" errorPage="" %>
<%
Class.forName(DbConfig.DriverName); 
Connection conn = DriverManager.getConnection(DbConfig.ConnString); 
Statement stmt = conn.createStatement();
ResultSet rs = null;
String sql = null;

request.setCharacterEncoding("utf-8");

Integer userId = (Integer)request.getSession().getAttribute("UserId");
if( request.getParameter("Action") != null ) {
    sql = "UPDATE [ScoreSummary] SET [Student] = "+request.getParameter("Student")+",[Score1] = "+request.getParameter("Score1")+",[Score2] = "+request.getParameter("Score2")+",[Score3] = "+request.getParameter("Score3")+" WHERE [Id]=" + request.getParameter("id");
    sql = sql.replace("'null'", "null");

    stmt.executeUpdate(sql);
    
	response.sendRedirect("ScoreSummaryList.jsp");
    return;
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">
	<style>td { font-size: 12px; }</style>
</head>
<body>

    <table border="1" cellSpacing="0" borderColorLight="#145aa0" borderColorDark="#9cc7ef" cellPadding="4" width="100%" align="center">
		<tr bgColor="#4296e7">
			<td colSpan="2"><div align="center"><font color="#ffffff">修改ScoreSummary</font></div></td>
		</tr>
		<tr>
			<td><br />
<%
        sql = "SELECT [ScoreSummary].*  FROM [ScoreSummary] WHERE [ScoreSummary].[Id]="+request.getParameter("id");

        rs = stmt.executeQuery(sql);
        if(rs.next()){
%>
				<div><form action="" method="post">
					<input type="hidden" name="Action" value="insert" />
					<input type="hidden" name="id" value="<%=rs.getObject("Id")%>" />
                    
                    <table style="border-width: 1px; border-style: solid; width: 100%; height: 50px; border-collapse: collapse;"
						border="1" rules="all" cellSpacing="0" cellPadding="4">
						<tr style="width: 79%;">
							<td style="width: 164px;" align="right">Student</td>
							<td><input id="Student" name="Student" type="text" value="<%=rs.getObject("Student")%>"></td>
						</tr>
						<tr style="width: 79%;">
							<td style="width: 164px;" align="right">Score1</td>
							<td><input id="Score1" name="Score1" type="text" value="<%=rs.getObject("Score1")%>"></td>
						</tr>
						<tr style="width: 79%;">
							<td style="width: 164px;" align="right">Score2</td>
后面还有 23 行代码，购买后查看完整代码

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

AI 解读 AI

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

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