📄 studentinfo_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
public final class studentinfo_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static java.util.List _jspx_dependants;
public Object 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,
"", 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");
out.write("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
out.write("<style type=\"text/css\">\r\n");
out.write("<!--\r\n");
out.write(".style1 {\r\n");
out.write("\tfont-family: \"宋体\";\r\n");
out.write("\theight: 0.6cm;\r\n");
out.write("\twidth: 20%;\r\n");
out.write("}\r\n");
out.write(".style3 {\r\n");
out.write("\tfont-family: \"宋体\";\r\n");
out.write("\tfont-size: 18px;\r\n");
out.write("\tfont-weight: bold;\r\n");
out.write("}\r\n");
out.write(".style7 {\r\n");
out.write("\tfont-family: \"宋体\";\r\n");
out.write("\tfont-size: medium;\r\n");
out.write("\tfont-weight: bold;\r\n");
out.write("\tline-height: normal;\r\n");
out.write("\ttext-align: left;\r\n");
out.write("\tvertical-align: middle;\r\n");
out.write("\tword-spacing: normal;\r\n");
out.write("\twhite-space: normal;\r\n");
out.write("\tdisplay: table-row;\r\n");
out.write("\twidth: 50%;\r\n");
out.write("\theight: 0.6cm;\r\n");
out.write("\tborder: dashed #9933CC;\r\n");
out.write("}\r\n");
out.write(".style8 {\r\n");
out.write("\tfont-size: medium;\r\n");
out.write("\tvertical-align: top;\r\n");
out.write("}\r\n");
out.write(".style9 {\r\n");
out.write("\tfont-weight: bold;\r\n");
out.write("\tfont-family: \"仿宋_GB2312\";\r\n");
out.write("\tfont-size: 24px;\r\n");
out.write("\tcolor: #993366;\r\n");
out.write("\tline-height: 0.5cm;\r\n");
out.write("\tbackground-color: #0000FF;\r\n");
out.write("\ttext-decoration: blink;\r\n");
out.write("}\r\n");
out.write(".style11 {\r\n");
out.write("\tfont-family: \"宋体\";\r\n");
out.write("\tfont-size: medium;\r\n");
out.write("\tfont-weight: bold;\r\n");
out.write("}\r\n");
out.write("body,td,th {\r\n");
out.write("\tcolor: #FF0099;\r\n");
out.write("\tfont-family: 宋体;\r\n");
out.write("}\r\n");
out.write("body {\r\n");
out.write("\tbackground-color: #3399FF;\r\n");
out.write("}\r\n");
out.write(".style12 {\r\n");
out.write("\tfont-size: 18px;\r\n");
out.write("\tfont-weight: bold;\r\n");
out.write("}\r\n");
out.write(".style13 {\r\n");
out.write("\tfont-size: 14px;\r\n");
out.write("\tfont-style: italic;\r\n");
out.write("}\r\n");
out.write(".style15 {font-size: 14px}\r\n");
out.write(".style16 {color: #FF00FF}\r\n");
out.write("-->\r\n");
out.write("</style>\r\n");
out.write(" ");
String sid = request.getParameter("sid");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=meizi3204";
Connection con= DriverManager.getConnection(url,"mz","3204");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs;
String sql;
sql="select * from students where Sid='"+sid+"'";
rs=stmt.executeQuery(sql);//查询数据库
if (!rs.next())
{
out.println("用户不存在");
return;
}
out.write("\r\n");
out.write("\r\n");
out.write("<table width=\"60%\" height=\"100%\" border=\"0\" align=\"center\" bgcolor=\"#0033FF\">\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td width=\"139\"><div align=\"center\" class=\"style3\">学号：</div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"center\" class=\"style8\">\r\n");
out.write(" <div align=\"left\">\r\n");
out.write(" <input name=\"sid\" type=\"text\" class=\"style7\" id=\"sid\" value=");
out.print(sid);
out.write(">\r\n");
out.write("* <span class=\"style15\">8位学号</span></div>\r\n");
out.write(" </div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td><div align=\"center\" class=\"style3\">姓名：</div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"center\" class=\"style8\">\r\n");
out.write(" <div align=\"left\">\r\n");
out.write("<input name=\"sname\" type=\"text\" class=\"style7\" id=\"sname\" value=");
out.print(rs.getObject(2));
out.write(">\r\n");
out.write("* <span class=\"style15\">真实姓名</span></div>\r\n");
out.write(" </div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td><div align=\"center\" class=\"style3\">登录密码：</div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"center\" class=\"style8\">\r\n");
out.write(" <div align=\"left\">\r\n");
out.write(" <input name=\"sdept\" type=\"text\" class=\"style7\" id=\"dept\" value=");
out.print(rs.getObject(8));
out.write(">\r\n");
out.write(" </div>\r\n");
out.write(" </div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td><div align=\"center\" class=\"style3\">性别：</div></td> \r\n");
out.write(" \r\n");
out.write(" <td width=\"54%\"> \r\n");
if(ssex.equals("男")){
out.write("\r\n");
out.write("\t\t<select name=\"ssex\" size=\"1\">\r\n");
out.write(" <option value=\"男\" selected>男</option>\r\n");
out.write(" <option value=\"女\">女</option>\r\n");
out.write(" </select>\r\n");
}
else{
out.write("\r\n");
out.write("\t\t<select name=\"ssex\" size=\"1\">\r\n");
out.write(" <option value=\"男\" >男</option>\r\n");
out.write(" <option value=\"女\"selected>女</option>\r\n");
out.write(" </select>\r\n");
}
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" \r\n");
out.write(" </tr>\r\n");
out.write(" \r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td><div align=\"center\" class=\"style3\">年龄：</div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"center\" class=\"style8\">\r\n");
out.write(" <div align=\"left\">\r\n");
out.write(" <input name=\"sage\" type=\"text\" class=\"style1\" id=\"sage\" value=");
out.print(rs.getObject(4));
out.write("> \r\n");
out.write(" </div>\r\n");
out.write(" </div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td><div align=\"center\" class=\"style3\">教育背景：</div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"center\" class=\"style8\">\r\n");
out.write(" <div align=\"left\">\r\n");
out.write(" <input name=\"sdept\" type=\"text\" class=\"style7\" id=\"dept\" value=");
out.print(rs.getObject(5));
out.write(">\r\n");
out.write(" </div>\r\n");
out.write(" </div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td><div align=\"center\" class=\"style3\">学院：</div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"center\" class=\"style8\">\r\n");
out.write(" <div align=\"left\">\r\n");
out.write(" <input name=\"sdept\" type=\"text\" class=\"style7\" id=\"dept\" value=");
out.print(rs.getObject(6));
out.write(">\r\n");
out.write(" </div>\r\n");
out.write(" </div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td><div align=\"center\" class=\"style3\">班级：</div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"center\" class=\"style8\">\r\n");
out.write(" <div align=\"left\">\r\n");
out.write(" <input name=\"sdept\" type=\"text\" class=\"style7\" id=\"dept\" value=");
out.print(rs.getObject(7));
out.write(">\r\n");
out.write(" </div>\r\n");
out.write(" </div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td><div align=\"center\"><span class=\"style3\">E-MAIL：</span></div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"left\"><span class=\"style8\">\r\n");
out.write(" <input name=\"smail\" type=\"text\" class=\"style7\" id=\"smail\" value=");
out.print(rs.getObject(9));
out.write(">\r\n");
out.write(" </span></div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td><div align=\"center\"><span class=\"style3\">联系电话：</span></div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"left\"><span class=\"style8\">\r\n");
out.write(" <input name=\"smail\" type=\"text\" class=\"style7\" id=\"smail\" value=");
out.print(rs.getObject(10));
out.write(">\r\n");
out.write(" </span></div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#0000FF\">\r\n");
out.write(" <td height=\"105\" valign=\"top\"><div align=\"center\"><span class=\"style3\">个人简介：</span></div></td>\r\n");
out.write(" <td colspan=\"2\"><div align=\"left\"><span class=\"style8\">\r\n");
out.write(" <textarea name=\"sresume\" cols=\"50%\" rows=\"5\" class=\"style8\" id=\"textarea2\" value=");
out.print(rs.getObject(11));
out.write("></textarea>\r\n");
out.write(" </span></div></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr valign=\"middle\" bgcolor=\"#0000FF\">\r\n");
out.write(" <td height=\"61\" colspan=\"3\"><div align=\"center\">\r\n");
out.write(" <input name=\"zuce\" type=\"submit\" class=\"style9\" value=\"确定\">\r\n");
out.write(" </div></td>\r\n");
out.write(" </tr>\r\n");
out.write("</table>\r\n");
out.write(" ");
request.getSession(true);
String chk="true";
session.putValue("Enter",chk);
session.putValue("sid",rs.getString("sid"));
rs.close();
stmt.close();
con.close();
out.write('\r');
out.write('\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 + -