Heim >Datenbank >MySQL-Tutorial >JSP_实现Servlet登陆,注册,链接Mysql数据库。_MySQL

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

WBOY
WBOYOriginal
2016-06-01 13:08:171459Durchsuche

本文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:

<?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>配置用於用戶登錄的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>配置用於用戶注册的Servlet</description>		<display-name>RegisterServlet</display-name>		<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:

<title>Login.html</title><meta charset="UTF-8"><link rel="stylesheet" href="css/reset.css"><link rel="stylesheet" href="css/style.css" media="screen" type="text/css">	
Login:
Password:
register

loginCheck.jsp:

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title>		<script type="text/javascript">		alert("<%=checkLogin%>!");		window.location.href="login.html"; 	</script>

loginsuccess.jsp:

<title>系统登录成功页面</title>		<script type="text/javascript">		alert("登录成功!")	</script>	欢迎用户:	<div id="box" style="width: 252px; font: 25px/25px 宋体; background: #000; color: #9f9; border: #999 20px ridge; text-shadow: 2px 3px 1px #0f0;"></div>	<script>		var domain = "www.zuidaima.com";		var author = "zuidaima";		var map = eval("[" + Array(23).join("0x801,") + "0xfff]");		var tatris = [ [ 0x6600 ], [ 0x2222, 0xf00 ], [ 0xc600, 0x2640 ],				[ 0x6c00, 0x4620 ], [ 0x4460, 0x2e0, 0x6220, 0x740 ],				[ 0x2260, 0xe20, 0x6440, 0x4700 ],				[ 0x2620, 0x720, 0x2320, 0x2700 ] ];		var keycom = {			"38" : "rotate(1)",			"40" : "down()",			"37" : "move(2,1)",			"39" : "move(0.5,-1)"		};		var dia, pos, bak, run;		function start() {			dia = tatris[~~(Math.random() * 7)];			bak = pos = {				fk : [],				y : 0,				x : 4,				s : ~~(Math.random() * 4)			};			rotate(0);		}		function over() {			document.onkeydown = null;			clearInterval(run);			alert("GAME OVER");		}		function update(t) {			bak = {				fk : pos.fk.slice(0),				y : pos.y,				x : pos.x,				s : pos.s			};			if (t)				return;			for (var i = 0, a2 = ""; i < 22; i++)				a2 += map[i].toString(2).slice(1, -1) + "<br/>";			for (var i = 0, n; i < 4; i++)				if (/([^0]+)/.test(bak.fk[i].toString(2)						.replace(/1/g, "/u25a1")))					a2 = a2.substr(0, n = (bak.y + i + 1) * 15							- RegExp.$_.length - 4)							+ RegExp.$1 + a2.slice(n + RegExp.$1.length);			document.getElementById("box").innerHTML = a2.replace(/1/g,					"/u25a0").replace(/0/g, "/u3000");		}		function is() {			for (var i = 0; i < 4; i++)				if ((pos.fk[i] & map[pos.y + i]) != 0)					return pos = bak;		}		function rotate(r) {			var f = dia[pos.s = (pos.s + r) % dia.length];			for (var i = 0; i < 4; i++)				pos.fk[i] = (f >> (12 - i * 4) & 15) << pos.x;			update(is());		}		function down() {			++pos.y;			if (is()) {				for (var i = 0; i < 4 && pos.y + i < 22; i++)					if ((map[pos.y + i] |= pos.fk[i]) == 0xfff)						map.splice(pos.y + i, 1), map.unshift(0x801);				if (map[1] != 0x801)					return over();				start();			}			update();		}		function move(t, k) {			pos.x += k;			for (var i = 0; i < 4; i++)				pos.fk[i] *= t;			update(is());		}		document.onkeydown = function(e) {			eval(keycom[(e ? e : event).keyCode]);		};		start();		run = setInterval("down()", 400);	</script>

register.html:

<title>register.html</title><meta name="keywords" content="keyword1,keyword2,keyword3"><meta name="description" content="this is my page"><meta name="content-type" content="text/html; charset=UTF-8"><!--<link rel="stylesheet" type="text/css" href="./styles.css">-->	
Login:
Password:

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);		}}

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

Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn