📄 student_005finfo_jsp.java
字号:
ResultSet rs = null;
out.write("\r\n");
out.write("<body class=mainInterface>\r\n");
out.write("<!--显示用户信息列表-->\r\n");
out.write("<form name=\"form1\">\r\n");
out.write("<TABLE class=\"listFrame cellspacing=1 width=\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td align=\"center\">\r\n");
out.write(" <font size=\"4\">\r\n");
out.write(" <strong>学生信息</strong>\r\n");
out.write(" </font>\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write("</TABLE>\r\n");
out.write("<table border=\"1\" cellspacing=\"0\" width=\"100%\" bordercolorlight=\"gray\" class=\"listFrame\" id=\"maintable\">\r\n");
out.write(" <tr>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">学生学号</div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">学生姓名</div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">学生性别</div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">政治面貌</div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">所在系别</div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">学生籍贯</div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">出生日期</div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">相关备注</div>\r\n");
out.write(" </TD>\r\n");
out.write(" </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");
out.write(" <!--表格行操作及显示-->\r\n");
out.write(" <TR onClick=\"showData(this);\" onmousedown=\"changeColor(this);\" onmouseover=this.style.cursor=\"hand\">\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">");
out.print(S_no);
out.write(" </div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">");
out.print(Name);
out.write(" </div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">");
out.print(Sex);
out.write(" </div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">");
out.print(Politic);
out.write(" </div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">");
out.print(Department);
out.write(" </div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">");
out.print(Come);
out.write(" </div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">");
out.print(Birth);
out.write(" </div>\r\n");
out.write(" </TD>\r\n");
out.write(" <TD height=\"5\">\r\n");
out.write(" <div align=\"center\">");
out.print(Memo);
out.write(" </div>\r\n");
out.write(" </TD>\r\n");
out.write(" </TR>\r\n");
}
} catch (Exception e) {
}
out.write("\r\n");
out.write("</table>\r\n");
out.write("<table class=\"listFrame\" cellspacing=\"1\" width=\"100%\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td align=\"right\">\r\n");
out.write(" <!--点击新增按钮执行向数据表新增记录的操作-->\r\n");
out.write(" <input type=\"button\" value=\"新增\" name=\"add\" class=\"buttonout2\" onClick=\"check(this.form,this.value)\">\r\n");
out.write(" </td>\r\n");
out.write(" <td align=\"center\">\r\n");
out.write(" <!--点击修改按钮执行向修改数据表记录的操作-->\r\n");
out.write(" <input type=\"button\" value=\"修改\" name=\"modify\" class=\"buttonout2\" onClick=\"check(this.form,this.value)\">\r\n");
out.write(" </td>\r\n");
out.write(" <td align=\"left\">\r\n");
out.write(" <!--点击删除按钮执行向删除数据表记录的操作-->\r\n");
out.write(" <input type=\"button\" value=\"删除\" name=\"delete\" class=\"buttonout2\" onClick=\"check(this.form,this.value)\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write("</table>\r\n");
out.write("<table border=\"0\" bordercolorlight=\"gray\" width=\"100%\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td width=\"30%\">\r\n");
out.write(" <div align=\"right\">学号：</div>\r\n");
out.write(" </td>\r\n");
out.write(" <td width=\"70%\">\r\n");
out.write(" <input type=\"text\" class=\"text\" size=\"60\" name=\"S_no\" maxlength=\"10\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <div align=\"right\">姓名：</div>\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" <input type=\"text\" class=\"text\" size=\"60\" name=\"Name\" maxlength=\"8\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <div align=\"right\">性别：</div>\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" <input type=\"text\" class=\"text\" size=\"60\" name=\"Sex\" maxlength=\"2\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <div align=\"right\">政治面貌：</div>\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" <input type=\"text\" class=\"text\" size=\"60\" name=\"Politic\" maxlength=\"8\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <div align=\"right\">所在系别：</div>\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" <input type=\"text\" class=\"text\" size=\"60\" name=\"Department\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <div align=\"right\">学生籍贯：</div>\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" <input type=\"text\" class=\"text\" size=\"60\" name=\"Come\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <div align=\"right\">出生日期：</div>\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" <input type=\"text\" class=\"text\" size=\"60\" name=\"Birth\" maxlength=\"10\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <div align=\"right\">相关备注：</div>\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" <input type=\"text\" class=\"text\" size=\"60\" name=\"Memo\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write("</table>\r\n");
out.write("<!--隐藏operation表单属性-->\r\n");
out.write("<input type=\"hidden\" name=\"operation\">\r\n");
out.write("</form>\r\n");
out.write("<!--列表信息结束-->\r\n");
out.write("</body>\r\n");
out.write("</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 + -