JavaWeb_E家园项目_java web e-CSDN博客

本文链接：https://blog.csdn.net/m0_67888923/article/details/124183645

本文档展示了E家园网站的数据库设计，包括用户、文章类型和文章资料的数据表结构，并插入了示例数据。同时，给出了网站主页的HTML源代码，包括登录、注册功能及页面布局。页面采用JSP和JSTL标签库，实现了动态内容展示。

摘要由CSDN通过智能技术生成

文章目录

案例

一、案例

数据库：

--使用者：数据表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
select * from e_users


--文章类型：数据表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;
select * from e_type

--文章资料：数据表
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 --文章日期
);
drop table e_article;
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 , '毛泽东' , 4 , '毛泽东的一生，是伟大的一生。' , '张三' ,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 , '卡耐基' , 4 , '全球石油大王' , '李四' ,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;

select * from e_article

导包：

案例：

<%@ 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>