创建表:(用户表+类型表+数据表)
导包:
创包:
主界面:
实现登录注册:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>E家园首页</title>
<!-- 引入index.css -->
<link rel="stylesheet" type="text/css" href="css/index.css" />
<style type="text/css">
.myLogin {
height: 100px;
}
h1 {
color: purple;
}
</style>
<script type="text/javascript">
function register() {
var mycontent = document.getElementById("mycontent");
mycontent.style.display = 'none';
var myRegister = document.getElementById("myRegister");
myRegister.style.display = 'block';
}
</script>
</head>
<body>
<div id="container">
<!-- head -->
<div class="head">
<!-- logo start-->
<div class="logo">
<img src="img/logo.jpg">
</div>
<!-- nav -->
<div class="nav">
<ul>
<li><a href="#"><img src="img/daohan_1.jpg" /></a></li>
<li><a href="#"><img src="img/daohan_2.jpg" /></a></li>
<li><a href="#"><img src="img/daohan_3.jpg" /></a></li>
<li><a href="#"><img src="img/daohan_4.jpg" /></a></li>
<li><a href="#"><img src="img/daohan_5.jpg" /></a></li>
<li><a href="#"><img src="img/daohan_6.jpg" /></a></li>
<li><a href="#"><img src="img/daohan_7.jpg" /></a></li>
</ul>
</div>
</div>
<!-- head END -->
<!-- ====================================================================== -->
<!-- main -->
<div class="main">
<!-- main_left -->
<div class="main_left">
<div class="myForm">
<img src="img/bg06.gif">
<!-- 登录表单 -->
<div class="myLogin">
<c:if test="${empty users }">
<form action="doLogin.jsp" method="post">
账号:<input type="text" name="username" /> 密码:<input
type="password" name="password"> <input type="submit"
value="登录">
</form>
</c:if>
<c:if test="${not empty users }">
欢迎回来!${users.uname }
<button>个人中心</button>
</c:if>
<br> <br>
<button onclick="register()">立即注册</button>
</div>
<!-- 分割线 -->
<div class="division">
<img src="img/line01.gif" /> <img src="img/left01.jpg" />
</div>
<!-- 登录表单 -->
<div class="mysearch"></div>
<img src="img/line02.gif" />
</div>
<!-- myForm END -->
<div class="notice">
<img src="img/left02.gif" />
<div class="notice_content">
站内公告<br> 站内公告<br> 站内公告<br>站内公告<br> 站内公告<br>
站内公告<br>
</div>
<img src="img/line02.gif" />
</div>
</div>
<!-- main_right -->
<div class="main_right">
<div class="carousel">
<img src="img/banner.gif">
</div>
<div class="mtitle">
<img src="img/dot02.gif">栏目分类
</div>
<!-- 注册 -->
<div id="myRegister" style="display: none; background-color: pink">
<center>
<h1>注册界面</h1>
<form>
用户名:<input type="text" /> <br> <br>密码:<input
type="password"> <br> <br> 性别:<input
type="text"> <br> <br> <input type="submit"
value="注册">
</form>
</center>
</div>
<!-- 显示 -->
<div class="contents" id="mycontent">
<div class="item">
<img src="img/cen01.jpg" />
<ul>
<li>aaaaaaa</li>
<li>aaaaaaa</li>
<li>aaaaaaa</li>
</ul>
</div>
<div class="item">
<img src="img/cen01.jpg" />
<ul>
<li>aaaaaaa</li>
<li>aaaaaaa</li>
<li>aaaaaaa</li>
</ul>
</div>
<div class="item">
<img src="img/cen01.jpg" />
<ul>
<li>aaaaaaa</li>
<li>aaaaaaa</li>
<li>aaaaaaa</li>
</ul>
</div>
<div class="item">
<img src="img/cen01.jpg" />
<ul>
<li>aaaaaaa</li>
<li>aaaaaaa</li>
<li>aaaaaaa</li>
</ul>
</div>
</div>
</div>
</div>
<!-- main END -->
<!-- ====================================================================== -->
<!-- footer start -->
<div class="footer">
版权所有 卓京信息<br> 盗版必究
</div>
<!-- footer end -->
</div>
</html>
<%@page import="com.zking.home.biz.impl.UsersBizImpl"%>
<%@page import="com.zking.home.biz.IUsersBiz"%>
<%@page import="com.zking.home.entity.Users"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
//设置编码
request.setCharacterEncoding("utf-8");
//数据获取
String username = request.getParameter("username");
String password = request.getParameter("password");
//数据封装
Users users = new Users(username, password);
//调用业务逻辑层进行数据交互
IUsersBiz iub = new UsersBizImpl();
Users userLogin = iub.userLogin(users);
//判断并进行域对象保存
if (userLogin != null) {
session.setAttribute("users", userLogin);
response.sendRedirect("index.jsp");
} else {
out.println("<script>alert('账号或密码错误!!!');location.href='index.jsp'</script>");
}
%>
package com.zking.home.dao.impl;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.List;
import com.zking.home.dao.IUsersDao;
import com.zking.home.entity.Users;
import com.zking.home.utils.BaseDao;
/**
* 用户接口实现类
*
* @author zjjt
*
*/
public class UsersDaoImpl extends BaseDao implements IUsersDao {
public static void main(String[] args) {
IUsersDao iud = new UsersDaoImpl();
Users userLogin = iud.userLogin(new Users("Lucy", "111"));
System.out.println(userLogin);
}
@Override
public Users userLogin(Users users) {
String sql = "select * from e_users where username = ? and upassword = ?";
ResultSet rs = this.executeQuery(sql, new Object[] { users.getUname(), users.getUpwd() });
try {
if (rs.next()) {
return new Users(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5));
}
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
/**
* 用户注册
*/
@Override
public int userRegister(Users users) {
String sql = "insert into e_users(userid,username,upassword,usex,udate) values(?,?,?,?,sysdate)";
return this.executeUpdate(sql,
new Object[] { users.getUid(), users.getUname(), users.getUpwd(), users.getUsex(), users.getUdate() });
}
}
package com.zking.home.biz.impl;
import com.zking.home.biz.IUsersBiz;
import com.zking.home.dao.IUsersDao;
import com.zking.home.dao.impl.UsersDaoImpl;
import com.zking.home.entity.Users;
public class UsersBizImpl implements IUsersBiz {
IUsersDao iud = new UsersDaoImpl();
@Override
public Users userLogin(Users users) {
return iud.userLogin(users);
}
@Override
public int userRegister(Users users) {
return iud.userRegister(users);
}
}