📄 student_005finfo_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_005finfo_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>学生信息</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=\"");
out.print(request.getContextPath());
out.write("/changeRowColor.js\" type=\"\"></script>\r\n<script src=\"");
out.print(request.getContextPath());
out.write("/onclickbutton.js\" type=\"\"></script>\r\n<script language=\"javascript\" src=\"");
out.print(request.getContextPath());
out.write("/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==\"\"||!isNumberic(form1.S_no.value)){\r\n 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");
out.write(" form1.Sex.focus();\r\n return false;\r\n}\r\nelse if(form1.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.Birth.value==\"\"){\r\n alert(\"请输入正确的出生日期！\");\r\n form1.Birth.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 {\r\n if(dataTable.rows[i].cells(0).innerText.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");
out.write(" }\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\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(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");
out.write(" 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><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\">\r\n<TABLE class=\"listFrame cellspacing=1 width=\">\r\n <tr>\r\n <td align=\"center\">\r\n <font size=\"4\">\r\n <strong>学生信息</strong>\r\n </font>\r\n </td>\r\n </tr>\r\n</TABLE>\r\n<table border=\"1\" cellspacing=\"0\" width=\"100%\" bordercolorlight=\"gray\" class=\"listFrame\" id=\"maintable\">\r\n <tr>\r\n <TD height=\"5\">\r\n <div align=\"center\">学生学号</div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">学生姓名</div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">学生性别</div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">政治面貌</div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">所在系别</div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">学生籍贯</div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">出生日期</div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">相关备注</div>\r\n </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 = rs.getString("Sex");
Politic = rs.getString("Politic");
Department = 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);\" onmouseover=this.style.cursor=\"hand\">\r\n <TD height=\"5\">\r\n <div align=\"center\">");
out.print(S_no);
out.write(" </div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">");
out.print(Name);
out.write(" </div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">");
out.print(Sex);
out.write(" </div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">");
out.print(Politic);
out.write(" </div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">");
out.print(Department);
out.write(" </div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">");
out.print(Come);
out.write(" </div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">");
out.print(Birth);
out.write(" </div>\r\n </TD>\r\n <TD height=\"5\">\r\n <div align=\"center\">");
out.print(Memo);
out.write(" </div>\r\n </TD>\r\n </TR>\r\n");
}
} catch (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\" bordercolorlight=\"gray\" width=\"100%\">\r\n <tr>\r\n <td width=\"30%\">\r\n <div align=\"right\">学号：</div>\r\n </td>\r\n <td width=\"70%\">\r\n <input type=\"text\" class=\"text\" size=\"60\" name=\"S_no\" maxlength=\"10\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <div align=\"right\">姓名：</div>\r\n </td>\r\n <td>\r\n <input type=\"text\" class=\"text\" size=\"60\" name=\"Name\" maxlength=\"8\">\r\n");
out.write(" </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <div align=\"right\">性别：</div>\r\n </td>\r\n <td>\r\n <input type=\"text\" class=\"text\" size=\"60\" name=\"Sex\" maxlength=\"2\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <div align=\"right\">政治面貌：</div>\r\n </td>\r\n <td>\r\n <input type=\"text\" class=\"text\" size=\"60\" name=\"Politic\" maxlength=\"8\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <div align=\"right\">所在系别：</div>\r\n </td>\r\n <td>\r\n <input type=\"text\" class=\"text\" size=\"60\" name=\"Department\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <div align=\"right\">学生籍贯：</div>\r\n </td>\r\n <td>\r\n <input type=\"text\" class=\"text\" size=\"60\" name=\"Come\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <div align=\"right\">出生日期：</div>\r\n </td>\r\n <td>\r\n <input type=\"text\" class=\"text\" size=\"60\" name=\"Birth\" maxlength=\"10\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td>\r\n <div align=\"right\">相关备注：</div>\r\n </td>\r\n <td>\r\n <input type=\"text\" class=\"text\" size=\"60\" name=\"Memo\">\r\n </td>\r\n </tr>\r\n</table>\r\n");
out.write("<!--隐藏operation表单属性-->\r\n<input type=\"hidden\" name=\"operation\">\r\n</form>\r\n<!--列表信息结束-->\r\n</body>\r\n</html>\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 + -