Web课程设计Word文档格式.docx
- 文档编号:22932778
- 上传时间:2023-02-06
- 格式:DOCX
- 页数:62
- 大小:25.22KB
Web课程设计Word文档格式.docx
《Web课程设计Word文档格式.docx》由会员分享,可在线阅读,更多相关《Web课程设计Word文档格式.docx(62页珍藏版)》请在冰豆网上搜索。
(4)浏览所有用户的微博信息
(5)浏览指定用户的微博信息
(6)查询某些用户或(且)某时间段或(且)某论题的微博信息。
(7)删除某些用户或(且)某时间段或(且)某论题的微博信息。
(8)统计分析某时间段的用户数量,微博数量。
(9)发布重大消息或提示信息
(7-9基于管理员)
2.设计环境:
(1)完整实现设计内容所指定的功能
(2)应用服务器采用Tomcat6.0或以上
(3)基于JSP编程
(4)开发工具采用Eclipse+DreamWeaver
(5)数据库采用ACCESS2003
(6)用户界面友好
3
3.系统流程图:
主界面
会员注册会员登录
管理员登录
输入信息输入密码输入密码
注册成功
微
浏
查
删
询
除
博
览
统
发
计
布
退出
数据库设计
在Microblog信息系统中,共设计3张表。
本系统使用Access来创建数据表。
数据库的名称为WEB.mdb,三张表分别为admin、message、user。
4
表:
admin
message
user
系统实现代码
Login.java
packagemybean.data;
publicclassLogin
{Stringlogname,password,
backNews="
"
;
booleansuccess=false;
publicvoidsetLogname(Stringname)
{logname=name;
}
5
publicStringgetLogname()
{returnlogname;
publicvoidsetPassword(Stringpw)
{password=pw;
publicStringgetPassword()
{returnpassword;
publicStringgetBackNews()
{returnbackNews;
publicvoidsetBackNews(Strings)
{backNews=s;
publicvoidsetSuccess(booleanb)
{success=b;
publicbooleangetSuccess()
{returnsuccess;
Message.java
publicclassMessage{
Stringlogname="
message="
time="
title="
backNews;
publicvoidsetLogname(Stringname)
publicvoidsetTitle(Stringt)
{title=t;
publicStringgetTitle()
{returntitle;
publicvoidsetTime(Stringt)
6
{time=t;
publicStringgetTime()
{returntime;
publicStringgetMessage()
{returnmessage;
publicvoidsetMessage(Stringm)
{message=m;
publicvoidsetBackNews(Strings)
Register.java
publicclassRegister
{Stringlogname="
password="
qq="
email="
phone="
StringbackNews;
publicvoidsetQq(Stringq)
{qq=q;
publicStringgetQq()
{returnqq;
publicvoidsetPassword(Stringpw)
7
publicvoidsetEmail(Stringem)
{email=em;
publicStringgetEmail()
{returnemail;
publicvoidsetPhone(Stringph)
{phone=ph;
publicStringgetPhone()
{returnphone;
ConditionQuery.java
importjava.sql.*;
publicclassConditionQuery
{Stringlogname;
StringBufferqueryResultBylogname;
publicConditionQuery()
{queryResultBylogname=newStringBuffer();
try{Class.forName("
com.microsoft.sqlserver.jdbc.SQLServerDriver"
);
catch(Exceptione){}
publicvoidsetlogname(Strings)
{logname=s.trim();
queryResultBylogname=newStringBuffer();
8
publicStringgetlogname()
publicStringBuffergetQueryResultBylogname()
{Stringcondition="
SELECT*FROMmessageWherelogname='
+logname+"
'
queryResultBylogname=f(condition);
returnqueryResultBylogname;
privateStringBufferf(Stringcondition)
{StringBufferstr=newStringBuffer();
Connectioncon;
Statementsql;
ResultSetrs;
try{String
uri="
jdbc:
sqlserver:
//127.0.0.1:
1433;
DatabaseName=factory"
con=DriverManager.getConnection("
odbc:
4073"
"
sql=con.createStatement();
rs=sql.executeQuery(condition);
str.append("
<
tableborder=1>
thwidth=100>
+"
logname"
title"
message"
time"
while(rs.next())
{str.append("
tr>
td>
+rs.getString
(1)+"
/td>
+rs.getString
(2)+"
+rs.getString(3)+"
+rs.getString(4)+"
/tr>
con.close();
catch(SQLExceptione)
{System.out.println(e);
returnstr;
9
HandleAdmin.java
packagemyservlet.control;
importmybean.data.*;
importjava.io.*;
importjavax.servlet.*;
importjavax.servlet.http.*;
publicclassHandleAdminextendsHttpServlet
{publicvoidinit(ServletConfigconfig)throwsServletException{super.init(config);
try{Class.forName("
sun.jdbc.odbc.JdbcOdbcDriver"
catch(Exceptione){}
publicStringhandleString(Strings)
{try{bytebb[]=s.getBytes("
iso-8859-1"
s=newString(bb);
catch(Exceptionee){}
returns;
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException
{Connectioncon;
PreparedStatementsql;
LoginloginBean=null;
StringbackNews="
HttpSessionsession=request.getSession(true);
try{loginBean=(Login)session.getAttribute("
login"
if(loginBean==null)
{loginBean=newLogin();
session.setAttribute("
loginBean);
catch(Exceptionee)
Stringlogname=request.getParameter("
).trim(),
password=request.getParameter("
password"
).trim();
booleanok=loginBean.getSuccess();
logname=handleString(logname);
10
password=handleString(password);
if(ok==true&
&
logname.equals(loginBean.getLogname()))
{backNews=logname+"
你已经登录了"
loginBean.setBackNews(backNews);
else
{
booleanboo=(logname.length()>
0)&
(password.length()>
0);
try{con=DriverManager.getConnection("
Stringcondition="
select*fromadminwherelogname=?
andpassword=?
sql=con.prepareStatement(condition);
if(boo)
{sql.setString(1,logname);
sql.setString(2,password);
ResultSetrs=sql.executeQuery();
booleanm=rs.next();
if(m==true)
{backNews="
管理员登录成功"
loginBean.setSuccess(true);
loginBean.setLogname(logname);
您登陆的管理员不存在,或密码不对"
loginBean.setSuccess(false);
loginBean.setPassword(password);
您输入的管理员不存在,或密码不对"
catch(SQLExceptionexp)
+exp;
loginBean.setBackNews(backNews);
loginBean.setSuccess(false);
11
RequestDispatcher
dispatcher=request.getRequestDispatcher("
showAdminMess.jsp"
dispatcher.forward(request,response);
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
{doPost(request,response);
HandleLogin.java
publicclassHandleLoginextendsHttpServlet
12
try{loginBean=(Login)session.getAttribute("
session.setAttribute("
select*fromuserwherelogname=?
ResultSetrs=sql.executeQuery();
会员登录成功"
您输入的会员不存在,或密码不对"
13
showLoginMess.jsp"
HandleMessage.java
importmybea
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Web 课程设计