基于javaweb+JSP+Servlet个人博客系统
开发工具:eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
ResultSet rs = null;// 记录集对象
try {
//
// 创建发送 sql语句的对象Statement
stmt = connection.createStatement();
String sql = "select * from tbl_article where article_id=" + articleId;
// 执行插入的sql语句,并返回成功操作的记录数
rs = stmt.executeQuery(sql);
while (rs.next()) {
int articlelId = rs.getInt("article_id");
int blogId = rs.getInt("blob_id");
int categroyId = rs.getInt("category_id");
String articleTitle = rs.getString("article_title");
String articleContent = rs.getString("article_content");
Date articleDateTime = rs.getDate("article_datetime");
int articleAccessNum = rs.getInt("article_accessNum");
int articleReviewNum = rs.getInt("article_reviewNum");
// //request.getRequestDispatcher("/loginMessage.jsp").forward(request, response);
// //重定向
// response.sendRedirect("/myblog/loginMessage.jsp");
// }else{
// request.getRequestDispatcher("login.jsp").forward(request, response);
// }
// response.setCharacterEncoding("UTF-8");
// response.setContentType("text/html;charset=UTF-8");
// PrintWriter out = response.getWriter();
// if(result>0){
// out.println("注册成功!");
// }else{
// out.println("注册失败!");
// }
}
public void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//request.setCharacterEncoding("UTF-8");
String username = request.getParameter("uname");
String pwd = request.getParameter("pwd");
//输出流对象
PrintWriter out = response.getWriter();
// PrintWriter out = null;
// String[] s = {"hello","world"};
// out.println(s[2]);
out.println("你好,世界");
out.flush();//清空缓存数据
out.close();//关闭流
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
@Override
public void init(ServletConfig config) throws ServletException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String method = request.getParameter("method");
if("list".equals(method)){
listUserArticle(request,response);
}
if("add".equals(method)){
addArticle(request,response);
}
if("showPage".equals(method)){
listUserPageArticle(request,response);
}
if("get".equals(method)){
getArticle(request,response);
}
if("update".equals(method)){
updateArticle(request,response);
}
if(result>0){
searchCategroy(request,response);
request.getRequestDispatcher("CategroyServlet?method=showPage&pageNo=1").forward(request, response);
}
}
public void searchCategroy(HttpServletRequest request, HttpServletResponse response){
HttpSession session = request.getSession();
User user = (User)session.getAttribute("USER");
List categroys = categroyDao.searchCategroy(user.getBlog().getBlogId());
if(categroys!=null&&categroys.size()>0){
session.setAttribute("CATEGROYS", categroys);
}
}
}
package com.demo.dao;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
<body>
<div id="container">
<div id="header">
<div id="title"><img src="<%=basePath %>/images/<%=user!=null?user.getBlog().getBlogLogo():"logo.jpg"%>" width="180" height="80" alt="logo" /><div><%=user!=null?user.getBlog().getBlogTitle():"未定议博客名" %></div></div>
<div id="menu">
<ul id="nav">
<li><a href="VisitorServlet?method=visit&userid=<%=user.getUserId() %>&query=true">首页</a> |</li>
<li><a href="javascript:alert('请登录查看');return;">目录</a> |</li>
<li><a href="javascript:alert('请登录查看');return;">写博客</a> |</li>
<li> <a href="<%=basePath %>/login.jsp">登录</a> |</li>
<li><a href="<%=basePath %>/register.jsp">注册</a> |</li>
<li><a href="javascript:alert('请登录查看');return;">管理</a> |</li>
<li><a href="javascript:alert('您还未登录无法注销');return;">注销</a></li>
</ul>
</div>
</div>
<div class="clear"></div>
<div id="banner"></div>
<div id="left">
<h1>个人头像</h1>
<div class="leftbox"><img src="<%=basePath %>/upload/<%=user!=null&&user.getUserPic()!=null?user.getUserPic():"tp.jpg" %>" width="98%" height="180"/></div>
<h1>分类目录</h1>
<div class="leftbox">
<ul>
<%
String blogTitle = rs.getString("blog_title");
String blogLogo = rs.getString("blog_logo");
Blog blog = new Blog(blogid,blogTitle, blogLogo);
String username = rs.getString("user_name");
String password = rs.getString("user_pwd");
String sex = rs.getString("user_sex");
String email = rs.getString("user_email");
String userInfo = rs.getString("user_info");
String userPic = rs.getString("user_pic");
user = new User(userId,blog,username,password,sex,email,userInfo,userPic);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBUtil.closeResultSet(rs);
DBUtil.closeStatement(stmt);
DBUtil.closeConnection(connection);
}
return user;
}
/**
* Servlet implementation class UserArticleServlet
*/
public class UserArticleServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
private ArticleDao articleDao = new ArticleDao();
/**
* @see HttpServlet#HttpServlet()
*/
public UserArticleServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String method = request.getParameter("method");
if("list".equals(method)){
listUserArticle(request,response);
}
if("add".equals(method)){
}
package com.demo.web;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.demo.dao.CategroyDao;
import com.demo.entity.Categroy;
import com.demo.entity.User;
import com.demo.util.PageUtil;
/**
* Servlet implementation class CategroyServlet
*/
public class CategroyServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
int result = 0;
try {
// 创建发送 sql语句的对象Statement
String sql = "delete from tbl_article where article_id=" + articleId;
stmt = connection.createStatement();
result = stmt.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
DBUtil.closeStatement(stmt);
DBUtil.closeConnection(connection);
}
return result;
}
public List<Article> searchCateArticle(int blogId, int categroyId) {
List<Article> articleList = new ArrayList<Article>();
运行环境
Java≥6、Tomcat≥7.0、MySQL≥5.5
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
技术框架
JSP Servlet MySQL
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明