📄 title.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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>
</head>
<body background="images/title.jpg">
<jsp:useBean id="date" class="student.JSPDate" />
<%
if(session.isNew())
response.sendRedirect("index.jsp");
String accountID,typeString,sql;
Object id = session.getAttribute("id");
Object type = session.getAttribute("type");
accountID = id.toString();
typeString = type.toString();
%>
<jsp:useBean id="statement" class="student.Connect" />
<%
Connection con = statement.getCon();
Statement smt = con.createStatement();
if(!type.equals("s"))
sql = "SELECT A_Name FROM Administrator WHERE A_ID = '"+accountID+"'";
else
sql = "SELECT S_Name FROM student WHERE S_ID = '"+accountID+"'";
ResultSet rs=smt.executeQuery(sql);
if(rs.next())
{
if(type.equals("s"))
{
%>
<table align="center">
<tr>
<td align="center"><font size="50" color="#FF0000"><%=rs.getString(1) %>同学欢迎你来到学生选课系统</font></td>
</tr>
<tr>
<td align="right"><font size="50" color="#FF0000"><%=date.getYear() %>年<%=date.getMonth() %>月<%= date.getDay() %>日星期<%=date.getDayOfWeek() %></font></td>
</tr>
</table>
<%
}
else
{
%>
<table align="center">
<tr>
<td align="center"><font size="50" color="#FF0000"><%=rs.getString(1) %>管理员欢迎你来到学生选课系统</font></td>
</tr>
<tr>
<td align="right"><font size="50" color="#FF0000"><%=date.getYear() %>年<%=date.getMonth() %>月<%= date.getDay() %>日星期<%=date.getDayOfWeek() %></font></font></td>
</tr>
</table>
<%
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -