📄 student_005finfp_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.util.*;
public final class Student_005finfp_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static java.util.Vector _jspx_dependants;
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n\r\n\r\n<!--初始化accessDB类Bean-->\r\n");
Database.accessDB accessDB = null;
synchronized (_jspx_page_context) {
accessDB = (Database.accessDB) _jspx_page_context.getAttribute("accessDB", PageContext.PAGE_SCOPE);
if (accessDB == null){
accessDB = new Database.accessDB();
_jspx_page_context.setAttribute("accessDB", accessDB, PageContext.PAGE_SCOPE);
}
}
out.write("\r\n<html>\r\n<head>\r\n<title>\r\n学生信息\r\n</title>\r\n<meta content=\"text/html;charset=gb2312\" http-equiv=\"Content-Type\">\r\n<link rel=\"stylesheet\" href=\"main.css\">\r\n<!--引入JavaScript文件-->\r\n<script src=\"changRowColor.js\" type=\"\"></script>\r\n<script src=\"onclickbutton.js\" type=\"\"></script>\r\n<script language=\"javascript\" src=\"jsfunction.js\" type=\"\"></script>\r\n<!--定义表格数据赋值各级表单的函数-->\r\n<script language=\"javascript\" type=\"text/javascript\">\r\nfunction showData(obj){\r\n document.all.S_no.value=obj.cells(0).innerText.TRim();\r\n document.all.Name.value=obj.cells(1).innerText.TRim();\r\n document.all.Sex.value=obj.cells(2).innerText.TRim();\r\n document.all.Politic.value=obj.cells(3).innerText.TRim();\r\n document.all.Department.value=obj.cells(4).innerText.TRim();\r\n document.all.Come.value=obj.cells(5).innerText.TRim();\r\n document.all.Birth.value=obj.cells(6).innerText.TRim();\r\n document.all.Memo.value=obj.cells(7).innerText.TRim();\r\n}\r\n<!--验证提交的信息是否存在和正确-->\r\nfunction checkSubmit(){\r\n if(form1.S_no.value==\"\"||!isNumber(form1.S_no.value)){\r\n");
out.write(" alert(\"请输入正确的学号！\")；\r\n form1.S_no.focus();\r\n return false;\r\n}\r\nelse if(form1.Name.value==\"\"){\r\n alert(\"请输入正确的姓名！\")；\r\n form1.Name.focus();\r\n return false;\r\n}\r\nelse if(form1.Sex.value==\"\"||!isSex(form1.Sex.value){\r\n alert(\"请输入正确的性别！\")；\r\n form1.Name.foucs();\r\n return false;\r\n}\r\nelse if(form.Politic.value==\"\"){\r\n alert(\"请输入正确的政治面貌！\")；\r\n form1.Politic.focus();\r\n return false;\r\n}\r\nelse if(form1.Department.value==\"\"){\r\n alert(\"请输入正确的系别！\")；\r\n form1.Department.focus();\r\n return false;\r\n}\r\nelse if(form1.Come.value==\"\"){\r\n alert(\"请输入正确的籍贯！\")；\r\n form1.Come.focus();\r\n return false;\r\n}\r\nelse if(form1.Brith.value==\"\"){\r\n alert(\"请输入正确的出生日期！\")；\r\n form1.Brith.focus();\r\n return false;\r\n}\r\nreturn true;\r\n}\r\n<!--判断所做的操作，执行相应的操作-->\r\nfunction check(form,operation){\r\n if(operation==\"新增\"){\r\n var dataTable=document.all.maintable;\r\n var flag=true;\r\n //检验学号是否已经存在\r\n for(var i=1;i<dataTable.rows.length;i++)\r\n");
out.write(" {\r\n if(dataTable.rows[i].cells(0).innerTex.Trim()==document.all.S_no.value.Trim()){\r\n alert(\"新增失败：学号为\"+document.all.S_no.value+\"的学生已经存在！\")；\r\n form.S_no.focus();\r\n flag=false;\r\n }\r\n }\r\n if(flag){\r\n //设置operation表单的值为\"add\"\r\n form.operation.value=\"add\";\r\n //设置from的action动作为carryout.jsp页面\r\n form.action=\"carryout.jsp\";\r\n //设置form的提交模式为post\r\n form.method=\"post\";\r\n //检验各表单数据是否符合要求\r\n if(checkSubmit()){\r\n //执行提交动作\r\n form.submit();\r\n }\r\n }\r\n}\r\nif(operation==\"修改\"){\r\n var flag=false;\r\n var dataTable=document.all.maintable;\r\n for(var i=1;i<dataTable.rows.length;i++){\r\n if(dataTable.rows[i].cells(0).innerText.Trim()==document.all.S_no.value.Trim()){\r\n flag=true;\r\n }\r\n }\r\n if(!flag){\r\n alert(\"修改失败：不能修改学号！\")；\r\n");
out.write(" }\r\n else if(flag){\r\n form.operation.value=\"modify\";\r\n form.action=\"carryout.jsp\";\r\n form.method=\"post\";\r\n if(checkSubmit()){\r\n form.submit();\r\n }\r\n }\r\n}\r\nif(operation==\"删除\"){\r\n var flag=false;\r\n var dataTable=document.all.maintable;\r\n for(var i=1;i<dataTable.rows.length;i++){\r\n if(dataTable.rows[i].cells(0).innerText.Trim()==document.all.S_no.value.Trim()){\r\n flag=true;\r\n }\r\n }\r\n if(!flag){\r\n alert(\"删除失败：不存在该学生学号！\")；\r\n }\r\n else if(confirm(\"确定要删除此项？\")){\r\n if(flag){\r\n form.operation.value=\"del\";\r\n form.action=\"carryout.jsp\";\r\n form.method=\"post\";\r\n form.submit();\r\n }\r\n }\r\n}\r\n}\r\n</script>\r\n<style type=\"text/css\">\r\n<!--\r\n.style1{\r\n font-size:12pt;\r\n font-weight:bold;\r\n }\r\n-->\r\n</style>\r\n</head>\r\n");
String S_no="";
String Name="";
String Sex="";
String Politic="";
String Department="";
String Come="";
String Birth="";
String Memo="";
ResultSet rs=null;
out.write("\r\n<body class=mainInterface>\r\n<!--显示用户信息列表-->\r\n<form name=\"form1\" action=\"\">\r\n<TABLE class=\"listFrame cellspacing=1 width=\"100%\">\r\n<tr><td align=\"center\"><font size=\"4\"><strong>学生信息</strong></font></td></tr>\r\n</TABLE>\r\n<TABLE border=\"1\" cellspacing=\"0\" width=\"100%\" bgcolor=\"gray\" class=\"listFrame\" id=\"maintable\">\r\n<tr>\r\n<TD height=\"5\">\r\n <div align=\"center\">学生学号\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">学生姓名\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">学生性别\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">政治面貌\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">所在系别\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">学生籍贯\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">出生日期\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">相关备注\r\n</div></TD>\r\n</TR>\r\n");
try{
String sql="select*from tb_student order by S_no";
//执行sql语句查询
rs=accessDB.executeQuery(sql);
while(rs.next()){
S_no=rs.getString("S_no");
Name=rs.getString("Name");
Sex=ra.getString("Sex");
Politic=rs.getString("Politic");
Departement=rs.getString("Department");
Come=rs.getString("Come");
Birth=rs.getString("Birth");
Memo=rs.getString("Memo");
out.write("\r\n<!--表格行操作及显示-->\r\n<TR onClick=\"showData(this);\" onmousedown=\"changeColor(this);\"\r\nonmouseover=this.style.cursor=\"hand\">\r\n<TD height=\"5\">\r\n <div align=\"center\">");
out.print(S_no);
out.write("\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">");
out.print(Name);
out.write("\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">");
out.print(Sex);
out.write("\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">");
out.print(Politic);
out.write("\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">");
out.print(Department);
out.write("\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">");
out.print(Come);
out.write("\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">");
out.print(Birth);
out.write("\r\n</div></TD>\r\n<TD height=\"5\">\r\n <div align=\"center\">");
out.print(Memo);
out.write("\r\n</div></TD>\r\n</TR>\r\n");
}
}
cacth(Exception e){
}
out.write("\r\n</TABLE>\r\n<table class=\"listFrame\" cellspacing=\"1\" width=\"100%\">\r\n<tr>\r\n <td align=\"right\">\r\n<!--点击新增按钮执行向数据表新增记录的操作-->\r\n 〈input type=\"button\" value=\"新增\" name=\"add\" class=\"buttonout2\" onClick=\"check(this.form.this.value)\">\r\n</td>\r\n<td align=\"center\">\r\n<!--点击修改按钮执行向修改数据表记录的操作-->\r\n 〈input type=\"button\" value=\"修改\" name=\"modify\" class=\"buttonout2\" onClick=\"check(this.form.this.value)\">\r\n</td>\r\n<td align=\"left\">\r\n<!--点击删除按钮执行向删除数据表记录的操作-->\r\n 〈input type=\"button\" value=\"删除\" name=\"delete\" class=\"buttonout2\" onClick=\"check(this.form.this.value)\">\r\n</td>\r\n</tr>\r\n</table>\r\n<table border=\"0\" bgcolor=\"gray\" width=\"100%\">\r\n <tr>\r\n <td width=\"30%\"><div align=\"right\">学号：</div></td>\r\n <td width=\"70%\"><input type=\"text\" class=\"text\" size=\"60\" name=\"S_no\" maxlength=\"10\"></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"right\">姓名：</div></td>\r\n <td><input type=\"text\" class=\"text\" size=\"60\" name=\"Name\" maxlength=\"8\"></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"right\">性别：</div></td>\r\n <td><input type=\"text\" class=\"text\" size=\"60\" name=\"Sex\" maxlength=\"2\"></td>\r\n");
out.write(" </tr>\r\n <tr>\r\n <td><div align=\"right\">政治面貌：</div></td>\r\n <td><input type=\"text\" class=\"text\" size=\"60\" name=\"Politic\" maxlength=\"8\"></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"right\">所在系别：</div></td>\r\n <td><input type=\"text\" class=\"text\" size=\"60\" name=\"Department\"></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"right\">学生籍贯：</div></td>\r\n <td><input type=\"text\" class=\"text\" size=\"60\" name=\"Come\"></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"right\">出生日期：</div></td>\r\n <td><input type=\"text\" class=\"text\" size=\"60\" name=\"Birth\" maxlength=\"10\"></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"right\">相关备注：</div></td>\r\n <td><input type=\"text\" class=\"text\" size=\"60\" name=\"Memo\"></td>\r\n </tr>\r\n</table>\r\n<!--隐藏operation表单属性-->\r\n<input type=\"hidden\" name=\"operation\">\r\n</form>\r\n<!--列表信息结束-->\r\n</body>\r\n</html>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -