留言板开发源代码Word文档下载推荐.docx
- 文档编号:22362859
- 上传时间:2023-02-03
- 格式:DOCX
- 页数:21
- 大小:18.94KB
留言板开发源代码Word文档下载推荐.docx
《留言板开发源代码Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《留言板开发源代码Word文档下载推荐.docx(21页珍藏版)》请在冰豆网上搜索。
publicintcount()throwsException;
//总页数
publicintcountpage()throwsException;
//设置每页显示几条记录
publicvoidpagesize(intpagesize)throwsException;
//分页显示
publicList<
Word>
querypage(intpage)throwsException;
packagecom.litiancms.db;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.SQLException;
publicclassDataBase{
//用户名这里的用户名指:
数据库的用户名
publicfinalStringUNAME="
root"
;
//用户密码这里的密码指:
数据库的密码
publicfinalStringUPWD="
admin"
//驱动程序
publicfinalStringDRIVER="
com.mysql.jdbc.Driver"
//链接地址
publicfinalStringURL="
jdbc:
mysql:
//localhost:
3306/ltcms"
//链接
publicConnectionconn;
//构造方法
publicDataBase(){
try{
//加载驱动程序
Class.forName(DRIVER);
//链接数据库
conn=DriverManager.getConnection(URL,UNAME,UPWD);
}catch(Exceptione){
//TODO:
handleexception
}
}
//链接方法
publicConnectionconn(){
returnthis.conn;
//关闭
publicvoidclose(){
this.conn.close();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
packagecom.litiancms.factory;
importcom.litiancms.dao.WordDao;
importcom.litiancms.impl.Wordimpl;
publicclassWordFactory{
publicstaticWordDaogetword(){
returnnewWordimpl();
packagecom.litiancms.impl;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.util.ArrayList;
importcom.litiancms.db.DataBase;
publicclassWordimplimplementsWordDao{
//分页显示
intpagesize=5;
//定义连接数据库
DataBasedb=null;
//操作数据库
PreparedStatementpstm;
//集合
ResultSetrs;
//sql语句
Stringsql=null;
@Override
publicvoidaddword(Wordw)throwsException{
//TODOAuto-generatedmethodstub
//数据库
db=newDataBase();
sql="
insertintoltcms_word(word_content,word_zuozhe,word_shijian)values(?
?
)"
pstm=db.conn.prepareStatement(sql);
pstm.setString(1,w.getWord_content());
pstm.setString(2,w.getWord_zuozhe());
pstm.setString(3,w.getWord_shijian());
pstm.executeUpdate();
pstm.close();
db.close();
publicvoiddelword(intid)throwsException{
deldetfromltcms_wordwhereid=?
"
pstm.setInt(1,id);
publicintcount()throwsException{
intcount=0;
//连接数据库
db=newDataBase();
//sql语句
sql="
selectcount(*)fromltcms_word"
pstm=db.conn.prepareStatement(sql);
rs=pstm.executeQuery();
if(rs.next()){
count=rs.getInt
(1);
rs.close();
returncount;
//总共有几页
publicintcountpage()throwsException{
intcountpage=0;
//拿到总记录数
intcount=this.count();
if(count%pagesize==0){
countpage=count/pagesize;
}else{
countpage=count/pagesize+1;
}
returncountpage;
//每页显示几条记录
publicvoidpagesize(intpagesize)throwsException{
this.pagesize=pagesize;
querypage(intpage)throwsException{
List<
lst=newArrayList<
();
select*fromltcms_wordorderbyword_shijiandesclimit?
intstart=(page-1)*pagesize;
pstm.setInt(1,start);
pstm.setInt(2,pagesize);
Wordw=null;
while(rs.next()){
w=newWord();
w.setId(rs.getInt
(1));
w.setWord_content(rs.getString
(2));
w.setWord_zuozhe(rs.getString(3));
w.setWord_shijian(rs.getString(4));
lst.add(w);
returnlst;
packagecom.litiancms.servlet;
importjava.io.IOException;
importjava.io.PrintWriter;
importjava.text.SimpleDateFormat;
importjava.util.Date;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.xml.crypto.Data;
importorg.omg.CORBA.Request;
importcom.litiancms.factory.WordFactory;
publicclassWordServletextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
this.doPost(request,response);
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
PrintWriterout=response.getWriter();
Stringstart=request.getParameter("
start"
);
Stringcontent=request.getParameter("
content"
Stringzuozhe=request.getParameter("
zuozhe"
SimpleDateFormatsdf=newSimpleDateFormat("
yyyy年MM月dd日hh时mm分ss秒"
Stringctime=sdf.format(newDate());
Wordw=newWord();
w.setWord_content(content);
w.setWord_zuozhe(zuozhe);
w.setWord_shijian(ctime);
if("
addword"
.equals(start)){
try{
WordFactory.getword().addword(w);
out
.println("
<
script>
alert('
留言成功'
location.href='
../servlet/QueyallServlet'
/script>
}catch(Exceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
//intid=Integer.parseInt(request.getParameter("
id"
));
delword"
.equals(start)){
//WordFactory.getword().delword(id);
//跳转页面
//out.println("
删除成功'
../servlet/QueryallServlet'
publicclassQueyallServletextendsHttpServlet{
this.doPost(request,response);
intpagestart=1;
Integercount=WordFactory.getword().count();
Integercountpage=WordFactory.getword().countpage();
Stringstart=request.getParameter("
if(start!
=null){
try{
pagestart=Integer.parseInt(start);
if(pagestart>
countpage){
pagestart=countpage;
}
}catch(Exceptione){
//TODO:
pagestart=1;
}
//分页
List<
lst=WordFactory.getword().querypage(pagestart);
//当前页数
request.setAttribute("
pagestart"
pagestart);
//记录数
count"
count);
//总页数
countpage"
countpage);
lst"
WordFactory.getword().querypage(pagestart));
request.getRequestDispatcher("
../index.jsp"
).forward(request,response);
添加页面
%@pagecontentType="
text/html;
charset=gb2312"
%>
scripttype="
text/javascript"
src="
js/edit.js"
>
br>
imgsrc="
images/addtitle.jpg"
hrcolor="
#ACCE69"
width="
90%"
style="
border-style:
solid;
margin-top:
-10"
aname="
/a>
formaction="
servlet/WordServlet"
name="
editform"
method="
post"
inputtype="
hidden"
value="
游客"
tablewidth="
border="
0"
cellpadding="
cellspacing="
<
tr>
<
tdwidth="
67%"
<
fontcolor="
#7F7F7F"
最多:
b>
spanid="
ContentAll"
width:
40;
text-align:
center"
500<
/span>
/b>
已用:
ContentUse"
0<
剩余:
ContentRem"
/font>
&
nbsp;
checkmessage"
color:
red"
/td>
tdalign="
right"
/tr>
tdcolspan="
2"
textarearows="
12"
cols="
99"
onpropertychange="
checkLen()"
/textarea>
trheight="
30"
align="
button"
submitb"
onclick="
editformsubmit()"
background:
url('
images/submit.jpg'
97;
height:
26;
border:
reset"
images/reset.jpg'
/table>
/form>
%@pagelanguage="
java"
import="
j
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 留言板 开发 源代码