📄 main.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>学生管理系统</title>
</head>
<body background=1.jpg>
<center>
<table align="center" width="100%" height="10%" border="0">
<tr>
<td align="center" width="100%" border="0"><font size=6 color=red> 学生管理系统</font></th></tr>
</table>
<p align="center"><font size=2 color=black>
<SCRIPT language=JavaScript>
var enabled = 0; today = new Date();
var day;
var date;
var centry ;
if(today.getDay()==0) day = "星期日"
if(today.getDay()==1) day = "星期一"
if(today.getDay()==2) day = "星期二"
if(today.getDay()==3) day = "星期三"
if(today.getDay()==4) day = "星期四"
if(today.getDay()==5) day = "星期五"
if(today.getDay()==6) day = "星期六"
document.fgColor = "ffffff";
centry="";
if (today.getYear()<2000 ) centry = "19" ;
date1 = centry + (today.getYear()) + "年" + (today.getMonth() + 1 ) + "月" + today.getDate() + "日 " ;
date2 = "" + day ;
document.write( date1+date2);
</SCRIPT>
</font>
<hr width="85%" />
<FORM action="main.jsp" Method="post">
<p align=center><font size=3 color=black>帐号:</font>
<Input type=text name="account">
<p align=center><font size=3 color=black>密码:</font>
<Input type=password name="secret">
<p align=center><Input type=submit name="d" value="登录">
</FORM>
<% //获取提交的帐号：
String account=request.getParameter("account");
if(account==null)
{account="";
}
byte b[]=account.getBytes("ISO-8859-1");
account=new String(b);
//获取提交的密码：
String secret=request.getParameter("secret");
if(secret==null)
{secret="";
}
byte c[]=secret.getBytes("ISO-8859-1");
secret=new String(c);
//查询数据库信息，验证身份：
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException event){}
try
{con=DriverManager.getConnection("jdbc:odbc:yonghu");
sql=con.createStatement();
String condition="SELECT * FROM yonghu WHERE name = "+"'"+account+"'";
rs =sql.executeQuery(condition);
while(rs.next())
{
String n=rs.getString("name");
String s=rs.getString("passwd");
if(account.equals(n)&&secret.equals(s))
{ session.setAttribute("account",account);
session.setAttribute("secret",secret);
String s1=response.encodeRedirectURL("login.jsp");
response.sendRedirect(s1);
}
}
if(!(session.isNew()))
{
}
}
catch(SQLException e1) {}
%>
<form action="zhuce.jsp" Method="post">
<div align="center">
<input type=submit name="zhuce" value="注册">
</div>
</form>
<p align="center"><font size=3><a href="chaxun.jsp">查询学生信息</a></p>
<a href="xiugaimima.jsp">修改密码</a>
<p></p>
<p></p>
</tr>
</table>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -