JSP-Servlet实现网上BBS项目小案例

来源：互联网发布：css源码编辑：程序博客网时间：2024/04/30 05:44

项目功能：实现一般bbs论坛项目的功能，发表说说其他好友可以评论

一、数据库的创建：
这里写图片描述
sql语句如下：

    create table `bbs`.`user`(        `userid` INT not null auto_increment,       `username` CHAR(20) not null,       `userpassword` CHAR(20) not null,        primary key (`userid`)    );    create unique index `PRIMARY` on `bbs`.`user`(`userid`);

    create table `bbs`.`article`(        `articleid` INT not null auto_increment,       `title` CHAR(50) not null,       `context` CHAR(200) not null,       `articletime` TIME not null,       `userid` INT not null,        primary key (`articleid`)    );    alter table `bbs`.`article`          add index `article_user_fk`(`userid`),         add constraint `article_user_fk`         foreign key (`userid`)         references `bbs`.`user`(`userid`);    create unique index `PRIMARY` on `bbs`.`article`(`articleid`);    create index `article_user_fk` on `bbs`.`article`(`userid`);

    create table `bbs`.`comment`(        `commentid` INT not null auto_increment,       `commenttext` CHAR(200) not null,       `commenttime` TIME not null,       `userid` INT not null,       `articleid` INT not null,        primary key (`commentid`)    );    alter table `bbs`.`comment`          add index `comment_article_fk`(`articleid`),         add constraint `comment_article_fk`         foreign key (`articleid`)         references `bbs`.`article`(`articleid`);    alter table `bbs`.`comment`          add index `comment_user_fk`(`userid`),         add constraint `comment_user_fk`         foreign key (`userid`)         references `bbs`.`user`(`userid`);    create unique index `PRIMARY` on `bbs`.`comment`(`commentid`);    create index `comment_user_fk` on `bbs`.`comment`(`userid`);    create index `comment_article_fk` on `bbs`.`comment`(`articleid`);

二、项目代码如下：
这里写图片描述

代码的主要实现：解决中文乱码的问题：

public class MyFilter implements Filter {    private String encoding=null;      public void doFilter(ServletRequest arg0, ServletResponse arg1,            FilterChain arg2) throws IOException, ServletException {        arg0.setCharacterEncoding(encoding);           arg2.doFilter(arg0, arg1);      }    public void init(FilterConfig arg0) throws ServletException {        encoding = arg0.getInitParameter("encoding"); //获得配置文件中的encoding    }    public void destroy() {    }}

在web.xml文件中配置

<!-- 过滤中文乱码的问题 -->    <filter>        <filter-name>MyFilter</filter-name>        <filter-class>com.xuliugen.util.MyFilter</filter-class>        <init-param>            <param-name>encoding</param-name>            <param-value>utf-8</param-value>        </init-param>    </filter>    <filter-mapping>        <filter-name>MyFilter</filter-name>        <url-pattern>/*</url-pattern>    </filter-mapping>

全部代码在这里：http://download.csdn.net/detail/u010870518/8570147

4 0