一.数据库表
--E家园 --使用者：数据表scott create table e_users ( userId number(4) primary key,--用户编号 username varchar2(20) not null,--用户名 password varchar2(20) not null,--用户密码 realName varchar2(20),--真实姓名 sex varchar2(2)--性别 )
insert into e_users(userId,username,password,realname,sex) values(1,'admin','123','张三','男'); insert into e_users(userId,username,password,realname,sex) values(2,'zz','123','李四','男'); commit
--文章类型：数据表TYPE create table e_type ( typeId number(4) primary key,--类型编号 typeName varchar2(20)--类型名称 );
insert into e_type(typeId,typeName)values(1,'Java学习笔记'); insert into e_type(typeId,typeName)values( 2 , '#.NET学习笔记' ); insert into e_type(typeId,typeName)values( 3 , '心情日记' ); insert into e_type(typeId,typeName)values( 4 , '伟人传记' );
commit;
--文章资料：数据表 create table e_article ( articleId number（4） primary key,--文章编号 title varchar2(20),--文章标题 typeId number(4) references e_type(typeId),--文章类型编号 content varchar2(2000),--文章内容 writer varchar2(50),--作者 writeDate date --文章日期 );
insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 1, '面向对象的理解' , 1 , '面向对象可以理解为，世界万物皆对象。也就是说，每一种事物都具有自己的属性和行为。' , '张三' , to_date('2007-09-23 08:08:08','yyyy-mm-dd HH24:mi:ss')); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 2 , 'JAVA编程思想' , 1 , 'Java编程思想' , '李四' ,to_date('2007-09-23 09:08:08','yyyy-mm-dd HH24:mi:ss')); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 3 , 'C#编程' , 2 , 'C#编程' , '张三' ,to_date('2019-01-21 10:08:22','yyyy-mm-dd HH24:mi:ss') ); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 4 , 'asp.net编程思想' , 2 , 'asp编程' , '李四' , to_date('2017-03-11 12:08:11','yyyy-mm-dd HH24:mi:ss') ); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 5 , 'JavaEE相关技术' , 1 , 'JavaEE的相关技术包括：' , '张三' ,to_date('2010-11-11 11:11:11','yyyy-mm-dd HH24:mi:ss') ); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 6 , '阴雨心情' , 3 , '我的心，就象似窗外那下着绵绵细雨的天一样，没有丝毫的阳光' , '李四' ,to_date('2012-12-12 12:12:12','yyyy-mm-dd HH24:mi:ss') ); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 7 , '快乐而来' , 3 , '今天的心情格外的好，格外的爽' , '李四' ,to_date('2013-03-03 03:03:03','yyyy-mm-dd HH24:mi:ss')); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 8 , 'a' , 4 , 'aa' , '张三' ,to_date('2017-05-20 08:08:08','yyyy-mm-dd HH24:mi:ss') ); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 9 , 'a' , 4 , 'b' , '李四' ,to_date('2017-08-23 08:08:08','yyyy-mm-dd HH24:mi:ss') ); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 10 , 'JAVA编程思想(第二版)' , 1 , 'Java编程思想' , '李四' ,to_date('2015-09-10 08:08:08','yyyy-mm-dd HH24:mi:ss') ); insert into e_article(articleId,title,typeId,content,writer,writeDate)values( 11 , 'JAVA编程思想(第三版)' , 1 , 'Java编程思想' , '张三' ,to_date('2018-09-29 08:08:08','yyyy-mm-dd HH24:mi:ss') );
commit;
二.登录
<!-- 登陆表单 --> <c:if test="${empty use }"> <form action="doLogin.jsp" method="post"> <table style="margin-left: 5px;" align="center"> <tr> <td></td> </tr> <tr> <td> 用户：<input type="text" style="width: 100px;" name="username" /> </tr> <tr> <td> 密码：<input type="password" style="width: 100px;" name="password" /></td> </tr> <tr> <td> <input type="submit" value="登录" /> </td> </tr> </table> </form> <hr> <input onclick="register()" type="submit" value="立即注册"> /c:if
//doLogin.jsp
<%@page import="com.EHome.entity.Users"%> <%@page import="com.EHome.biz.impl.UsersBizImpl"%> <%@page import="com.EHome.biz.IUsersBiz"%> <%@ 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 use=new Users(username,password);
//调用业务逻辑层进行交互 IUsersBiz iub=new UsersBizImpl(); Users usersFlag=iub.userLogin(use);
//判断并进行域对象保存 if(usersFlag != null){//说明可以登录 //session session.setAttribute("Users", usersFlag); response.sendRedirect("index.jsp"); }else{//登录失败 out.println("<script>alert('账号或密码错误');location.href='index.jsp'</script>"); }
%>
三.注册
<!-- 注册 --> <div id="myRegister" style="display: none"> <form action="doRegister.jsp" method="post"> <table align="center"> <tr> <td colspan="2"> <h2 style="text-align: center;">用户注册</h2> </td> </tr> <tr> <td>用户名:</td> <td><input type="text" name="uname"></td> </tr> <tr> <td>密码:</td> <td><input type="password" name="pwd"></td> </tr> <tr> <td>真实姓名:</td> <td><input type="text" name="usename"></td> </tr> <tr> <td>性别:</td> <td><input type="radio" name="sex">男 <input type="radio" name="sex">女</td> </tr> <tr> <td colspan="2"><input type="submit" value="注册"></td> </tr> </table> </form> </div>
//doRegister.jsp
<%@page import="com.EHome.biz.impl.UsersBizImpl"%> <%@page import="com.EHome.biz.IUsersBiz"%> <%@page import="com.EHome.entity.Users"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<% //设置编码 request.setCharacterEncoding("utf-8"); //数据获取 String id=request.getParameter("uid"); int uid = 0; if (id != null) { uid = Integer.valueOf(id); } String uname=request.getParameter("uname"); String pwd=request.getParameter("pwd"); String usename=request.getParameter("usename"); String sex=request.getParameter("sex");
//数据封装
Users use=new Users(uid,uname,pwd,usename,sex);
//调用业务逻辑层进行交互
IUsersBiz iub=new UsersBizImpl();
int n=iub.userRegister(use);
//判断并进行域对象保存
if(n > 0){//说明可以登录
//session
session.setAttribute("use", n);
response.sendRedirect("index.jsp");
}else{//登录失败
out.println("<script>alert('注册失败,请重新注册');location.href='index.jsp'</script>");
}
%>
220
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
