实现效果:
实现目的:
1.在与MySQL数据库连接后,通过添加数据页面,可以自动往数据库中增添数据
2.在添加成功后会自动返回到管理员的学生数据页面,并且数据会更新,但如果更新未成功,则会 报错
3.back则是一如既往的返回上一页功能
实现代码:addstu.jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script>
<!--
function t1()
{if (stu.id.value == "")
{alert("您必须完成学号的的输入!");}
else
if (stu.name.value == "")
{alert("您必须完成姓名的输入!");}
else
if (stu.password.value == "")
{alert("您必须完成密码的输入!");}
else
stu.submit();
}
function t2()
{if (stu.id.value == "")
{document.getElementById("ids").innerHTML="请输入学号!!"}
else
if(stu.name.value == "")
{document.getElementById("nas").innerHTML="请输入姓名!!"}
else
if(stu.password.value == "")
{document.getElementById("pas").innerHTML="请输入密码!!"}
}
-->
</script>
<title>学生信息录入</title>
<base href="<%=basePath%>">
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body bgcolor="#FFFFF0">
<h1><center><font size="6" color="#00FFFF">新增学生</font></center></h1>
<p>
<form action="insert.jsp" method="post" name="stu">
<table border="2" align="center" bgcolor="#E6E6FA">
<tr>
<td>学号</td>
<td><input name ="id" type="text" maxlength ="20" ><span id="ids" style="color: red"></span></td>
</tr>
<tr>
<td>学生姓名</td>
<td><input name="name" type="text" maxlength="20"><span id="nas" style="color: red"></span></td>
<tr>
<td>密码</td>
<td><input name="password" type="password" maxlength="20" onblur="t2()"><span id="pas" style="color: red"></span></td>
</tr>
<tr>
<td>籍贯</td>
<td><select name="jiguan">
<option value="重庆">重庆</option>
<option value="深圳">深圳</option>
<option value="成都">成都</option></select></td>
</tr>
<tr>
<td>系部</td>
<td><select name ="dep">
<option value="计算机系">计算机系</option>
<option value="管理系">管理系</option>
<option value="社科系">社科系</option></select></td>
</tr>
<tr>
<td>性别</td>
<td><select name ="sex">
<option value="男">男</option>
<option value="女">女</option></select></td>
</tr>
<tr>
<td>学分</td>
<td><input name="mark" type="text" maxlength="20"></td>
</tr>
<tr>
<td>电话</td>
<td><input name="tel" type="text" maxlength="20"></td>
</tr>
<td>E_mail</td>
<td><input name="email" type="text" maxlength="20"></td>
</tr>
</table></form>
<tr>
<center>
<td colspan="2">
<input type="submit" name="Submit" value="确定" onclick="t1()">
</td></center>
</tr>
</p>
<br>
<br>
<p>
<td><a href="admstu.jsp"> < < Back</a></td>
</p>
<br>
<br>
<p>
<center><b><font color="#99FF33" size="2" >版权所有©:<a href="names.jsp">(个人信息)</a></font></b></center>
</p>
</body></html>