jsp+servlet+JavaBean+MySQL实现登陆实例
运行环境:
jdk8.0
eclipse4.0
tomcat7.0
Windows2007
需要的jar包是:mysql-connector-java-5.1.28.jar
①:首先创建在MySQL中创建一张tusers表
DROP TABLE IF EXISTS `tusers`;
CREATE TABLE `tusers` (
`username` varchar(20) NOT NULL,
`userid` int(20) NOT NULL AUTO_INCREMENT,
`password` varchar(20) NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
然后在其中插入一个用户:用户名:admin 密码:admin
-- ----------------------------
-- Records of tusers
-- ----------------------------
INSERT INTO `tusers` VALUES ('admin', '1', 'admin');
②、在eclipse中创建一个web工程,其工程目录格式如下图:
1、在WebContent下创建其登陆页面及其相关的登陆成功页面和登陆失败页面:login.jsp、success.jsp、error.jsp
login.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">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>登陆</title>
<script type="text/javascript">
function check(form){
//取得form1中username的值并判断是否为空
if(document.forms.form1.username.value==""){
alert("请输入用户名");
document.forms.form1.username.focus();
return false;
}
if(document.forms.form1.password.value==""){
alert("请输入密码");
document.forms.form1.password.focus();
return false;
}
}
</script>
</head>
<body>
<form action="LoginServlet" method="post" name="form1">
<label>username</label>
<input type="text" name="username" />
<label>password</label>
<input type="password" name="password" />
<input type="submit" name="submit" οnclick="return check(this);" value="登陆" />
<input type="reset" name="reset" value="重置" />
</form>
</body>
</html>
success.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<jsp:useBean id="user" class="model.Tusers" scope="request"/>
<jsp:setProperty name="user" property="*"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>