📄 addstudent.jsp
字号:
<%@page import="java.util.*"%>
<%@ include file="change.jsp"%>
<%@ page language="java" import="java.sql.*"%>
<%@ include file="author.jsp" %>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%linejdbc.setdrivername();%>
<html>
<head>
<title>创建学生信息</title>
<link href="../img/cssexamin.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.unnamed1 {
font-size: 12px;
font-weight: lighter;
color: #FF0000;
text-decoration: none;
}
-->
</style>
</head>
<body>
<%
Connection conn = linejdbc.getopenConnection();
PreparedStatement ps;
String sqlstr;
String S_id="";
String S_name="";
String Password="";
String sid="";
String Sex="";
String Major="";
String Grade="";
ResultSet result=null;
ResultSet Qresult=null;
int rs=0;
int id=0;
//boolean i=false;
//if (request.getParameter("id")!=null) id=Integer.parseInt(request.getParameter("id"));
if (request.getParameter("s_id")!=null) S_id=request.getParameter("s_id");
if (request.getParameter("s_name")!=null) S_name=request.getParameter("s_name");
if (request.getParameter("password")!=null) Password=request.getParameter("password");
if (request.getParameter("sex")!=null) Sex=request.getParameter("sex");
if (request.getParameter("major")!=null) Major=request.getParameter("major");
if (request.getParameter("grade")!=null) Grade=request.getParameter("grade");
if (S_id.compareTo("")!=0)
{
ps=conn.prepareStatement("select * from student where s_id=?");
ps.setString(1,S_id);
ResultSet res=ps.executeQuery();
if(!res.next())
{res.close();
sqlstr="insert into student (s_id,s_name,s_paw,sex,major,grade) values (?,?,?,?,?,?)";
ps=conn.prepareStatement(sqlstr);
ps.setString(1,S_id);
ps.setString(2,S_name);
ps.setString(3,Password);
ps.setString(4,Sex);
ps.setString(5,Major);
ps.setString(6,Grade);
rs=ps.executeUpdate();
}
if (rs==1)
{
%>
<script language="JavaScript">alert("添加成功！")</script>
<%
}
else
{
%>
<script language="JavaScript">alert("添加失败，请重新添加！")</script>
<% response.sendRedirect("addstudent.jsp");
}
}
%>
<form action="" method="post" name="formaddstudent" >
<p align="center" class="banquan">------------------添加学生------------------</p>
<table width="56%" border="0" align="center">
<tr>
<td width="16%" align="center" valign="middle" class="table">学号: </td>
<td width="84%" class="table"><input name="s_id" type="text" class="textborder" id="s_id" style="color: #333300; border: 1px solid #99FF66; padding: 0; background-color: #FFFFFF" size="30">
<span class="unnamed1">*</span></td>
</tr>
<tr>
<td align="center" valign="middle" class="table">密码:</td>
<td class="table"><input name="password" type="text" class="textborder" id="password2" style="color: #333300; border: 1px solid #99FF66; padding: 0; background-color: #FFFFFF" size="30">
<span class="unnamed1">*</span></td>
</tr>
<tr>
<td align="center" valign="middle" class="table">姓名:</td>
<td class="table"><input name="s_name" type="text" class="textborder" id="s_name2" style="color: #333300; border: 1px solid #99FF66; padding: 0; background-color: #FFFFFF" size="30">
<span class="unnamed1">*</span></td>
</tr>
<tr>
<td align="center" valign="middle" class="table">性别:</td>
<td class="table"><select name="sex" class="table">
<option value="男" selected>男</option>
<option value="女">女</option>
</select></td>
</tr>
<tr>
<td align="center" valign="middle" class="table">专业:</td>
<td class="table"><input name="major" type="text" class="textborder" id="major2" style="color: #333300; border: 1px solid #99FF66; padding: 0; background-color: #FFFFFF" size="30">
</td>
</tr>
<tr>
<td align="center" valign="middle" class="table">年级:</td>
<td class="table"><input name="grade" type="text" class="textborder" id="grade2" style="color: #333300; border: 1px solid #99FF66; padding: 0; background-color: #FFFFFF" size="30">
</td>
</tr>
<tr align="center" valign="top">
<td colspan="2" class="table">
<input name="okbtn" type="button" id="okbtn" value="提交" onclick="okbtnclick()">
<font color="#FF0000">*</font>:为必填<font color="#333333">项</font></td>
</tr>
</table>
<p><br>
</p>
<%/////////查询///////////////////////////////%>
<div align="center">学号：<input name="xh" id="xh" type="text" class="textborder"> 姓名：<input name="xm" id="xm"type="text" class="textborder"><input name="cx" type="button" class="textborder" id="button" value="查询" onclick="cxclick()"></div><p></p><br>
<table width="75%" border="0" align="center" class="table">
<tr align="center" class="table">
<td width="13%" class="table">学号</td>
<td width="13%" class="table">密码</td>
<td width="13%" class="table">姓名</td>
<td width="8%" class="table">性别</td>
<td width="30%" class="table">专业</td>
<td width="13%" class="table">年级</td>
<td width="10%" class="table">操作</td>
</tr>
<%sqlstr="select * from student";
ps=conn.prepareStatement(sqlstr);
Qresult=ps.executeQuery();
while(Qresult.next())
{%>
<tr align="center" class="table">
<td class="table"><%= Qresult.getString("s_id") %> </td>
<td class="table"><%= Qresult.getString("s_paw") %> </td>
<td class="table"><%= Qresult.getString("s_name") %> </td>
<td class="table"><%= (Qresult.getString("sex")!=null?Qresult.getString("sex"):"") %> </td>
<td class="table"><%= (Qresult.getString("major")!=null?Qresult.getString("major"):"") %> </td>
<td class="table"><%= (Qresult.getString("grade")!=null?Qresult.getString("grade"):"") %> </td>
<td class="table"><a href="javascript:othersubmit('<%=Qresult.getString(7)%>')">删除</a></td>
</tr><%}%>
</table>
</form>
</body>
</html>
<script language="JavaScript">
function StringTrim(str) {
return str.replace(/(^\s*)|(\s*$)/g, "");
}
function okbtnclick() {
str = StringTrim(window.document.all.s_id.value);
if (str == "") {
alert("学号不能为空！");
window.document.all.s_id.focus();
return false;
}
str = StringTrim(window.document.all.s_name.value);
if (str == "") {
alert("姓名不能为空！");
window.document.all.s_name.focus();
return false;
}
str = StringTrim(window.document.all.password.value);
if (str == "") {
alert("密码不能为空！");
window.document.all.password.focus();
return false;
}
if (confirm("您确认所填内容正确吗？") == 1) {
window.document.all.formaddstudent.action="addstudent.jsp";
window.document.all.formaddstudent.submit();
}
}
function cxclick(){
window.document.all.formaddstudent.action="searchstudent.jsp";
window.document.all.formaddstudent.submit();
}
</script>
<script language="javascript">
function othersubmit(op)
{
var ss;
ss=op;
if (window.confirm("确认要删除吗?")==true)
{
window.location="deletestudent.jsp?id="+ss;
}
}
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -