📄 addobject.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ include file="author.jsp" %>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%linejdbc.setdrivername();%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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>
<%//查询
%>
<%
Connection conn = linejdbc.getopenConnection();
PreparedStatement ps;
String sqlstr;
String S_id="";
String S_name="";
String Password="";
String Sex="";
String Major="";
String Grade="";
ResultSet result=null;
ResultSet Qresult=null;
int rs=0;
int id=0;
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("addobject.jsp");
}
//result.close();
}
if (id!=0)
{
sqlstr="delete from student where id=?";
ps=conn.prepareStatement(sqlstr);
ps.setInt(1,id);
ps.executeUpdate();
}
sqlstr="select * from student";
ps=conn.prepareStatement(sqlstr);
result=ps.executeQuery();
/*/////////////////////////////////////////////
String xh="";
String xm="";
if (request.getParameter("xh")!="") xh=request.getParameter("xh");
if (request.getParameter("xm")!="") xm=request.getParameter("xm");
if ((xh.compareTo(""))!=0 & xm.compareTo("")=0)
{ ps=conn.prepareStatement("select * from student where s_id=?");
ps.setString(1,xh);
Qresult=ps.executeQuery();}
/////////////////////////////////////////////////////////////*/
%>
<body>
<form action="" method="post" name="formaddobject" >
<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>
<%
//while(Qresult.next())
//{%>
<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="13%" class="table">性别</td>
<td width="13%" class="table">专业</td>
<td width="23%" class="table">年级</td>
<td width="12%" class="table">操作</td>
</tr>
<tr align="center" class="table">
<td class="table"><%//= result.getString("s_id") %> </td>
<td class="table"><%//= result.getString("s_paw") %> </td>
<td class="table"><%//= result.getString("s_name") %> </td>
<td class="table"><%//= (result.getString("sex")!=null?result.getString("sex"):"") %> </td>
<td class="table"><%//= (result.getString("major")!=null?result.getString("major"):"") %> </td>
<td class="table"><%//= (result.getString("grade")!=null?result.getString("grade"):"") %> </td>
<td class="table"><a href="addobject.jsp?id=<%//=result.getString("id")%>">删除</a></td>
</tr>
</table>
<p><br>
</p>
<%//break;
// }%>
<!--hr width="500" class="table"-->
<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="13%" class="table">性别</td>
<td width="13%" class="table">专业</td>
<td width="23%" class="table">年级</td>
<td width="12%" class="table">操作</td>
</tr>
<%
while (result.next())
{
%>
<tr align="center" class="table">
<td class="table"><%= result.getString("s_id") %> </td>
<td class="table"><%= result.getString("s_paw") %></td>
<td class="table"><%= result.getString("s_name") %> </td>
<td class="table"><%= (result.getString("sex")!=null?result.getString("sex"):"") %> </td>
<td class="table"><%= (result.getString("major")!=null?result.getString("major"):"") %> </td>
<td class="table"><%= (result.getString("grade")!=null?result.getString("grade"):"") %> </td>
<td class="table"><a href="addobject.jsp?id=<%=result.getString("id")%>">删除</a></td>
<%
}
%>
</tr>
</table>
<p><br>
</p>
<p class="banquan"><font color="#333333"></font></p>
<p> </p>
</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.formaddobject.action="addobject.jsp";
window.document.all.formaddobject.submit();
}
}
///////////////////////////
function cxbtnclick()
{
//response.sendRedirect("login.jsp");
}
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -