01_05 JSP basic Syntax (Database authentication login page)

User Login program Implementation (JSP+JDBC)

The user login operation must be saved in the data table, the user entered the user name and password, to verify. If the input is correct, the login succeeds and the login fails if it is incorrect.

First, data table creation

Netstart MySQL start the MySQL service

MySQL –uroot–pmysqladmin into MySQL

showdatabases; View Database

/*======= using the MLDN database =========*/

USEMLDN;

/*======= Delete user data table =========*/

droptable IF EXISTS User;

/*======= Create user data table =========*/

CreateTable User (

UserID VARCHAR (PRIMARY KEY),

Name VARCHAR (+) is not NULL,

Password VARCHAR () not NULL

);

/*======= inserting test data =========*/

Insertinto User (userid, name, password) VALUES ("admin", "admin", "admin");

Second, the page design

login.htm provide user login form

 login_check.jsp      
<% @page  contenttype= "text/html"  pageencoding= "GBK"%><%@ page import= "java.sql.*"% >
login_sucess.jsp Success Page
<% @page contenttype= "text/html" pageencoding= "GBK"%>
login_failure.htm failed page


The above content reference Javaweb development actual combat Classics (teacher pulpit)

01_05 JSP basic Syntax (Database authentication login page)