数据库表
--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;
登入
<!-- 注册 --> <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>");
}
%>
注册
<!-- 注册 --> <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>");
}
%>