login.jsp

来自「这是一个web数据库(运用jsp技术)的课设项目(教师科研信息管理系统),题目和」· JSP 代码 · 共 54 行

JSP
54
字号
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?