📄 ins.jsp
字号:
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
<html>
<jsp:useBean id="ins" scope="session" class="bean.Ins" />
<head>
<title>添加学生成绩</title>
</head>
<body>
<h3>请输入学生学号及成绩</h3>
<a href="amain.jsp">返回</a>
<form name="insfrom" method="post" action="ins.jsp">
<table border="2">
<tr>
<td><center>学号</center></td><td><center>姓名</center></td><td><center>密码</center></td>
<td><center>英语</center></td><td><center>数学</center></td><td><center>计算机</center></td>
</tr>
<tr>
<td>
<input type="text" name="num" maxlength="10" size="10">
</td>
<td>
<input type="text" name="name" maxlength="10" size="10">
</td>
<td>
<input type="text" name="pass" maxlength="10" size="10">
</td>
<td>
<input type="text" name="Escore" maxlength="3" size="10">
</td>
<td>
<input type="text" name="Mscore" maxlength="3" size="10">
</td>
<td>
<input type="text" name="Cscore" maxlength="3" size="10">
</td>
</tr>
</table>
<input name="submit" type="submit" value="确认">
<input name="reset" type="reset" value="重写">
</form>
<%
if(request.getParameter("submit")!=null){
int i=0;
String num=request.getParameter("num");
String name=request.getParameter("name");
String pass=request.getParameter("pass");
String Escore=request.getParameter("Escore");
String Mscore=request.getParameter("Mscore");
String Cscore=request.getParameter("Cscore");
i=ins.Insert(num);
ins.InsName(num,name,pass);
ins.InsScore(num,Escore,Mscore,Cscore);
if(i==2)
out.println("<p>学号 "+num+" 已存在");
else if(i==1)
out.println("<p>学号 "+num+" 插入成功");
else if(i==0&&request.getParameter("submit")!=null)
out.println("<p>学号 "+num+" 插入失败");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -