JSP_实现Servlet登陆，注册，链接Mysql数据库。_MySQL

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了JSP_实现Servlet登陆，注册，链接Mysql数据库。_MySQL，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4515字，纯文字阅读大概需要7分钟。

内容图文

本文http://blog.csdn.net/svitter

也是一个MVC的实例

源码：http://download.csdn.net/detail/svitter/7532621

user.sql:

-- phpMyAdmin SQL Dump-- version phpStudy 2014-- http://www.phpmyadmin.net---- 主机: localhost-- 生成日期: 2014 年 06 月 21 日 17:42-- 服务器版本: 5.5.38-- PHP 版本: 5.3.28SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;---- 数据库: `users`---- ------------------------------------------------------------ 表的结构 `ur`--CREATE TABLE IF NOT EXISTS `ur` (  `name` varchar(255) NOT NULL,  `passwd` varchar(255) NOT NULL,  `id` bigint(20) NOT NULL AUTO_INCREMENT,  PRIMARY KEY (`id`)) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ;---- 转存表中的数据 `ur`--INSERT INTO `ur` (`name`, `passwd`, `id`) VALUES('a', 'a', 1);/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

web.xml:

<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		<display-name>LoginServlet</display-name>		<servlet-name>LoginServlet</servlet-name>		<servlet-class>LoginServlet</servlet-class>	  	<servlet-mapping>		<servlet-name>LoginServlet</servlet-name>		<url-pattern>/LoginServlet</url-pattern>	</servlet-mapping>			配置用於用戶注册的Servlet		<display-name>RegisterServlet</display-name>		<servlet-name>RegisterServlet</servlet-name>		<servlet-class>RegisterServlet</servlet-class>	  	<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:

loginCheck.jsp:

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%>	<%		String checkLogin = (String)(request.getAttribute("checkLogin"));	%>	

loginsuccess.jsp:

<%@ page contentType="text/html; charset=utf-8"%><%@ page import="bean.userBean"%>	<%		userBean user = (userBean) (request.getAttribute("user"));		session.setAttribute("user", user);	%>	

register.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();	public 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();	public 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);		}}

太多了不贴了。。详见我的资源。。

内容总结

以上是互联网集市为您收集整理的JSP_实现Servlet登陆，注册，链接Mysql数据库。_MySQL全部内容，希望文章能够帮你解决JSP_实现Servlet登陆，注册，链接Mysql数据库。_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---