📄 login.jsp
字号:
<%@ page session="true"%>
<%@ page contentType="text/html;charset=gb2312" %>
<html>
<html>
<title>login...</title>
</head>
<body>
<!-- 设置脚本语言为java,引用java.sql包 -->
<%@ page language="java" import="java.sql.*,javax.sql.*;" %>
<%
String name=request.getParameter("name");
String pwd=request.getParameter("pwd");
String jdbcDriver="com.mysql.jdbc.Driver";
String jdbcURL="jdbc:mysql://localhost:3306/teacher";
try{
Class.forName(jdbcDriver);
Connection con=DriverManager.getConnection(jdbcURL,"root","000000");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from teacher where name='"+name+"' and code='"+pwd+"'");
if(rs.next()){
session.setAttribute("user",name);
%>
<jsp:forward page="teacher.html" />
<jsp:forward page="teacher.html">
</jsp:forward>
<%
}else{
%>
<br><br>
<h1 align="center"><font color="00ff00" size=5>教师科研信息管理系统</font></h1>
<hr color="#ff8000">
<br><br><br><br>
<center>用户名或密码错误，请重试！[<a href="login.html" target=_top>返回</a>]</center>
<br>
<%
}
rs.close();
stmt.close();
con.close();
System.out.println("Test OK!");
}catch(ClassNotFoundException e){
System.out.println("未找到要加载的驱动类");
}catch(SQLException e){
System.out.println("SQL错误提示:"+e);
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -