Messege资料.doc

addMessege.jsp 0) % alert(添加成功！); alert(添加失败！); 添加留言板信息 添加留言板信息 标题：input name=topic type=text class=text1 value= 作者：input name=author type=text class=text1 value= 栏目类型： option id=1 value=1 校办专栏 option id=2 value=2 后勤管理专栏 option id=3 value=3 教务处专栏 option id=4 value=4 计算机中心专栏 option id=5 value=5 招生就业专栏 option id=6 value=6 其他专栏 内容：   添加留言板信息窗体顶端标题：作者：栏目类型：内容：content 窗体底端messegeBoardHead.jsp留言板 信息平台 留言板系统   浏览留言板信息 添加留言板信息 messegeBoardHome.jsp留言板信息 messegeDetail.jsp查看留言板信息 留言信息 主题： 加入时间: 作者: 浏览次数: 内容： 回复信息 回复时间： 部门： 内容： 评论信息 0) commentNum = aList.size(); % 最新评论共条 作者 发表时间 0) for(int i = 0 ;i 参加评论 input type=hidden name=messegeId value= 差 1 2 3 4 5 6 7 8 9 10 好     共有人评分，得分为： 评论： 作者：   MessegeBean.javapackage sms.bean;import java.util.*;import java.io.Serializable;public class MessegeBean implements Serializable private ArrayList answerList; private String browseNum; private String columnName; private ArrayList commentList; private String commentNum; private String content; private String topic; private float totalScore; private String author; private String messegeId; private String addTime; public void setAddTime(String addTime) this.addTime = addTime; public ArrayList getAnswerList() return answerList; public void setAnswerList(ArrayList answerList) this.answerList = answerList; public void setTotalScore(float totalScore) this.totalScore = totalScore; public void setTopic(String topic) this.topic = topic; public void setContent(String content) this.content = content; public void setCommentNum(String commentNum) mentNum = commentNum; public void setCommentList(ArrayList commentList) mentList = commentList; public void setColumnName(String columnName) this.columnName = columnName; public void setBrowseNum(String browseNum) this.browseNum = browseNum; public void setAuthor(String author) this.author = author; public void setMessegeId(String messegeId) this.messegeId = messegeId; public String getBrowseNum() return browseNum; public String getColumnName() return columnName; public ArrayList getCommentList() return commentList; public String getCommentNum() return commentNum; public String getContent() return content; public String getTopic() return topic; public float getTotalScore() return totalScore; public String getAuthor() return author; public String getMessegeId() return messegeId; public String getAddTime() return addTime; MessegeDetailBean.javapackage sms.bean;import java.util.*;import java.io.Serializable;public class MessegeDetailBean implements Serializable private String answerTime; private String answerDepartment; private String answerContent; private AnswerBean answerBean ; private int browseNum; private String columnName; private ArrayList commentList; private int scoreNum; private String content; private String topic; private float totalScore; private String author; private String messegeId; private String addTime; public String getAddTime() return addTime; public void setAddTime(String addTime) this.addTime = addTime; public AnswerBean getAnswerBean() return answerBean; public void setAnswerBean(AnswerBean answerBean) this.answerBean = answerBean; public String getAnswerTime() return answerTime; public void setAnswerTime(String answerTime) this.answerTime = answerTime; public void setAnswerDepartment(String answerDepartment) this.answerDepartment = answerDepartment; public String getAnswerDepartment() return answerDepartment; public void setAnswerContent(String answerContent) this.answerContent = answerContent; public String getAnswerContent() return answerContent; public void setTotalScore(float totalScore) this.totalScore = totalScore; public void setTopic(String topic) this.topic = topic; public void setContent(String content) this.content = content; public void setScoreNum(int scoreNum) this.scoreNum = scoreNum; public void setCommentList(ArrayList commentList) mentList = commentList; public void setColumnName(String columnName) this.columnName = columnName; public void setBrowseNum(int browseNum) this.browseNum = browseNum; public void setAuthor(String author) this.author = author; public void setMessegeId(String messegeId) this.messegeId = messegeId; public int getBrowseNum() return browseNum; public String getColumnName() return columnName; public ArrayList getCommentList() return commentList; public int getScoreNum() return scoreNum; public String getContent() return content; public String getTopic() return topic; public float getTotalScore() return totalScore; public String getAuthor() return author; public String getMessegeId() return messegeId; MessegeDetailServlet.javapackage sms.servlet;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import sms.db.*;import java.sql.*;import sms.bean.*;public class MessegeDetailServlet extends HttpServlet private static final String CONTENT_TYPE = text/html; charset=GBK; public void init() throws ServletException public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException response.setContentType(CONTENT_TYPE); request.setCharacterEncoding(gb2312); String messegeId = request.getParameter(messegeId); String sql0 = update messege_info set browse_num = browse_num+1 where id = + messegeId + ; String sql1 = select * from messege_info where id= +messegeId +; String sql2 = select * from messege_answer_info where messege_id= + messegeId + ; String sql3 = select * from comment_info where messege_id= + messegeId + order by add_time desc;