JSP-Servlet实现网上BBS项目小案例
项目功能:实现一般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>
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。