JSP_ implements servlet login, register, link MySQL database.

This article Http://blog.csdn.net/svitter

is also an example of MVC

Source: http://download.csdn.net/detail/svitter/7532621

User.sql:

--phpMyAdmin SQL dump--version phpstudy 2014--http://www.phpmyadmin.net----Host: localhost--generated date: June 21, 2014 17:4 2--Server version: 5.5.38--PHP version: 5.3.28SET sql_mode= "No_auto_value_on_zero"; Set time_zone = "+00:00";/*!40101 set @[email protected] @CHARACTER_SET_CLIENT */;/*!40101 set @[email  Protected] @CHARACTER_SET_RESULTS */;/*!40101 set @[email protected] @COLLATION_CONNECTION */;/*!40101 set NAMES UTF8 */;----database: ' users '----------------------------------------------------------------the structure of the table ' ur '--create tables IF Not EXISTS ' ur ' (' name ' varchar (255) is not NULL, ' passwd ' varchar (255) is not NULL, ' ID ' bigint () ' is not NULL auto_increment , PRIMARY KEY (' id ')) engine=myisam DEFAULT CHARSET=GBK auto_increment=2;----Dump the data in the table ' ur '--insert into ' ur ' (' name ', ' passwd ', ' id ') VALUES (' A ', ' a ', 1);/*!40101 set [email protected]_character_set_client */;/*!40101 set [email  protected]_character_set_results */;/*!40101 SET [email protected]_collation_connection */;

Xml:

<?xml version= "1.0" encoding= "UTF-8"? ><web-app xmlns:xsi= "Http://www.w3.org/2001/XMLSchema-instance" xmlns= "Http://xmlns.jcp.org/xml/ns/javaee" xsi:schemalocation= "Http://xmlns.jcp.org/xml/ns/javaee/http Xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd "version=" 3.1 "> <display-name>jsp_servlet_javabean</ display-name><servlet><description> configuration for user login servlet</description><display-name> Loginservlet</display-name><servlet-name>loginservlet</servlet-name><servlet-class> Loginservlet</servlet-class></servlet> <servlet-mapping><servlet-name>loginservlet</ Servlet-name><url-pattern>/loginservlet</url-pattern></servlet-mapping><servlet> <description> Configure Servlet</description><display-name>registerservlet</display-name for user registration ><servlet-name>registerservlet</servlet-name><servlet-class>registerservlet</ Servlet-class></servlet> <servlet-mapping><servlet-name>registerservlet</servlet-name><url-pattern>/ Registerservlet</url-pattern></servlet-mapping><welcome-file-list> <welcome-file> Login.html</welcome-file> </welcome-file-list></web-app>

Lib:

Mysql-connector-java.jar;

Mysql-connector-java-5.1.17.jar;

Login.html:

<! DOCTYPE html>

LOGINCHECK.JSP:
<%@ page language= "java" contenttype= "text/html; Charset=utf-8 "    pageencoding=" UTF-8 "%><! DOCTYPE HTML PUBLIC "-//w3c//dtd HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd" >

LOGINSUCCESS.JSP:
<%@ page contenttype= "text/html; Charset=utf-8 "%><%@ page import=" Bean.userbean "%>
Register.html:
<! DOCTYPE html>
Loginservlet.java:
Import Java.io.*;import Javax.servlet.*;import Javax.servlet.http.httpservlet;import Javax.servlet.http.httpservletrequest;import Javax.servlet.http.httpservletresponse;import Bean. Connectionbean;import bean.userbean;/** * @author svitter * */@SuppressWarnings ("Serial") public class Loginservlet Extends HttpServlet {UserBean user = new UserBean (); Connectionbean Connbean = new Connectionbean ();p ublic void DoPost (HttpServletRequest request, HttpServletResponse Response) throws Servletexception, IOException {String checklogin; String username = request.getparameter ("login"); String Password = request.getparameter ("password"); Checklogin = connbean.checkuser (username, password); if ( Checklogin.equals ("Success")) {User.setusername (username); Request.setattribute ("User", user); Getservletconfig (). Getservletcontext (). Getrequestdispatcher ("/loginsuccess.jsp"). Forward (request, response);} else {request.setattribute ("Checklogin", Checklogin), Getservletconfig (). Getservletcontext (). Getrequestdispatcher ("/logincheck.jsp "). Forward (request, response);} public void doget (HttpServletRequest request, httpservletresponse response) throws Servletexception, ioexception{ DoPost (request, Response);}}

Registerservlet.java:
import Java.io.*;import Javax.servlet.*;import Javax.servlet.http.httpservlet;import Javax.servlet.http.httpservletrequest;import Javax.servlet.http.httpservletresponse;import Bean. Connectionbean;import bean.userbean;/** * @author svitter * */@SuppressWarnings ("Serial") public class Registerservlet Extends HttpServlet {UserBean user = new UserBean (); Connectionbean Connbean = new Connectionbean ();p ublic void DoPost (HttpServletRequest request, HttpServletResponse Response) throws Servletexception, IOException {String username = request.getparameter ("login"); String Password = request.getparameter ("password"); Connbean.adduser (username, password); Getservletconfig (). Getservletcontext (). Getrequestdispatcher ("/login.html"). Forward (request, response);} public void doget (HttpServletRequest request, httpservletresponse response) throws Servletexception, ioexception{ DoPost (request, Response);}} 

It's too much to be posted. See my resources for more details.