java实现留言板功能实例

2024-02-25 16:19:03 121
JSP+JavaBean的留言板技术
Messages.html
messageboard
留言板


姓名：

E-mail：

主题：

留言：







查看留言


?
MessageData.java
packagemessage;
publicclassMessageData
{privateStringname,email,title,content;
//setter或者getter方法
publicvoidsetName(Stringname){this.name=name;}
publicvoidsetEmail(Stringemail){this.email=email;}
publicvoidsetTitle(Stringtitle){this.title=title;}
publicvoidsetContent(Stringcontent){this.content=content;}
publicStringgetName(){returnthis.name;}
publicStringgetContent(){returnthis.content;}
publicStringgetTitle(){returnthis.title;}
publicStringgetEmail(){returnthis.email;}}
?
viewMessages.jsp
<%@pagecontentType="text/html;charset=GBK"import="message.MessageData"%>
<%@pageimport="java.util.*"%>

showthemessageinthetable
所有留言

<%
intmessage_count=0;
Collectionmessages=myBean.getAllMessage();
Iteratorit=messages.iterator();
while(it.hasNext()){MessageDatamg=(MessageData)it.next();
%>

留言人:
<%=mg.getName()%>
<%out.println(
""+mg.getEmail()+"");
%>

主题:
<%=mg.getTitle()%>


内容:
<%=mg.getContent()%>

<%message_count++;
}
%>

我要留言

?
addMessage.jsp
<%@pagelanguage="java"contentType="text/html;charset=GBK"
pageEncoding="GBK"%>



messageintotable

<%try{myBean.setMessage(Mdata);myBean.addMessage();}
catch(Exceptione){e.printStackTrace();}
%>


?
MessageData.java
packagemessage;
publicclassMessageData
{privateStringname,email,title,content;
//setter或者getter方法
publicvoidsetName(Stringname){this.name=name;}
publicvoidsetEmail(Stringemail){this.email=email;}
publicvoidsetTitle(Stringtitle){this.title=title;}
publicvoidsetContent(Stringcontent){this.content=content;}
publicStringgetName(){returnthis.name;}
publicStringgetContent(){returnthis.content;}
publicStringgetTitle(){returnthis.title;}
publicStringgetEmail(){returnthis.email;}}
?
MessageBean.java
packagemessage;
importjava.sql.*;//引入java.sql包
importjava.util.*;
publicclassMessageBean{
privateConnectioncon;MessageDatamsg;
publicMessageBean()
{StringJDriver="com.mysql.jdbc.Driver";//定义驱动程序对象
StringuserName="root";//定义数据库用户名
StringuserPasswd="";//定义数据库存取密码
StringdbName="message";//定义数据库名
StringconURL="jdbc:mysql://localhost:3306/"+dbName;
try{Class.forName(JDriver).newInstance();//加载JDBC驱动程序
con=DriverManager.getConnection(conURL,userName,userPasswd);
//连接数据库
}
catch(Exceptione){System.err.println(e.getMessage());}
}
publicvoidsetMessage(MessageDatamsg){this.msg=msg;}
//添加一条留言消息
publicvoidaddMessage()throwsException
{try{byteb1[]=msg.getTitle().getBytes("ISO-8859-1");
Stringti=newString(b1);
byteb2[]=msg.getName().getBytes("ISO-8859-1");
Stringna=newString(b2);
byteb3[]=msg.getEmail().getBytes("ISO-8859-1");
Stringem=newString(b3);
byteb4[]=msg.getContent().getBytes("ISO-8859-1");
Stringc=newString(b4);
PreparedStatementstm=con.prepareStatement(
"insertintomessagetablevalues(?,?,?,?)");
stm.setString(1,ti);stm.setString(2,na);
if((msg.getEmail()).length()==0)stm.setString(3,"");
elsestm.setString(3,em);
stm.setString(4,c);
try{stm.execute();stm.close();}
catch(Exceptione){}
con.close();//关闭数据库连接
}
catch(Exceptione){e.printStackTrace();throwe;}
}
//获得所有留言消息，并返回结果到JSP页面
publicCollectiongetAllMessage()throwsException
{Collectionret=newArrayList();
try{Statementstm=con.createStatement();
ResultSetresult=stm.executeQuery(
"selectcount(*)frommessagetable");
intmessage_count=0;
if(result.next()){message_count=result.getInt(1);
result.close();}
if(message_count>0)
{result=stm.executeQuery("select*frommessagetable");
while(result.next())
{Stringtitle=result.getString("title");
Stringname=result.getString("name");
Stringemail=result.getString("email");
Stringcontent=result.getString("content");
MessageDatamessage=newMessageData();
message.setTitle(title);message.setName(name);
message.setEmail(email);message.setContent(content);
ret.add(message);
}
result.close();stm.close();
}
con.close();
}
catch(Exceptione)
{e.printStackTrace();throwe;}
returnret;
}
}
功能简单的留言板，但是清楚的说明了JSP+JavaBean技术的运用，需要的朋友可以参考
java实现留言板功能实例

热门推荐

随机推荐
