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

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

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