?? login.jsp
字號:
<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@page import="java.sql.*"%><%--The taglib directive below imports the JSTL library. If you uncomment it,you must also add the JSTL library to the project. The Add Library... actionon Libraries node in Projects view can be used to add the JSTL 1.1 library.--%><%--<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> --%><!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=UTF-8"> <title>網(wǎng)上銀行</title> </head> <body> <% String userName=request.getParameter("nameField"); String userPassword = request.getParameter("passwordField"); String dbUrl = "jdbc:odbc:afei"; String user = "scott"; String password = "tiger"; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection(dbUrl,user,password); String sql = "Select * from netMember where loginID = '"+userName+"' and loginPW = '"+userPassword+"'"; Statement stat = conn.createStatement(); ResultSet result = stat.executeQuery(sql); if(!result.next()) { out.println("用戶名或密碼錯誤,請重新輸入!"); %> <meta http-equiv="refresh" content="2; URL=Login.html"> <% } else { session.setAttribute("userName",userName); conn.close(); %> <meta http-equiv="refresh" content="2; URL=Main.html"> <% } } catch(Exception connectException) { out.println("連接數(shù)據(jù)庫失敗! 請與管理員聯(lián)系!"); } %> </body></html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -