留言板开发源代码.doc

package com.litiancms.bean;public class Word /留言idprivate int id;/留言内容private String word_content;/留言作者private String word_zuozhe;/留言时间private String word_shijian;public int getId() return id;public void setId(int id) this.id = id;public String getWord_content() return word_content;public void setWord_content(String wordContent) word_content = wordContent;public String getWord_zuozhe() return word_zuozhe;public void setWord_zuozhe(String wordZuozhe) word_zuozhe = wordZuozhe;public String getWord_shijian() return word_shijian;public void setWord_shijian(String wordShijian) word_shijian = wordShijian;package com.litiancms.dao;import java.util.List;import com.litiancms.bean.Word;public interface WordDao /留言添加public void addword(Word w)throws Exception;/删除public void delword(int id)throws Exception;/ 总共有几条记录public int count() throws Exception;/ 总页数public int countpage() throws Exception;/ 设置每页显示几条记录public void pagesize(int pagesize) throws Exception;/ 分页显示public List querypage(int page) throws Exception;package com.litiancms.db;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class DataBase /用户名 这里的用户名指：数据库的用户名public final String UNAME=root;/用户密码 这里的密码指：数据库的密码public final String UPWD=admin;/驱动程序public final String DRIVER=com.mysql.jdbc.Driver;/链接地址public final String URL=jdbc:mysql:/localhost:3306/ltcms;/链接public Connection conn;/构造方法public DataBase()try /加载驱动程序Class.forName(DRIVER);/链接数据库conn=DriverManager.getConnection(URL, UNAME, UPWD); catch (Exception e) / TODO: handle exception/链接方法public Connection conn()return this.conn;/关闭public void close()try this.conn.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();package com.litiancms.factory;import com.litiancms.dao.WordDao;import com.litiancms.impl.Wordimpl;public class WordFactory public static WordDao getword()return new Wordimpl();package com.litiancms.impl;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;import com.litiancms.bean.Word;import com.litiancms.dao.WordDao;import com.litiancms.db.DataBase;public class Wordimpl implements WordDao /分页显示int pagesize=5;/ 定义连接数据库DataBase db = null;/ 操作数据库PreparedStatement pstm;/集合ResultSet rs;/sql语句String sql=null;Override/留言添加public void addword(Word w) throws Exception / TODO Auto-generated method stub/数据库db=new DataBase();sql=insert into ltcms_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();Override/删除public void delword(int id) throws Exception / TODO Auto-generated method stub/数据库db=new DataBase();sql=deldet from ltcms_word where id=?;pstm=db.conn.prepareStatement(sql);pstm.setInt(1, id);pstm.executeUpdate();pstm.close();db.close();Overridepublic int count() throws Exception / TODO Auto-generated method stubint count = 0;/ 连接数据库db = new DataBase();/ sql语句sql = select count(*)from ltcms_word;pstm = db.conn.prepareStatement(sql);rs = pstm.executeQuery();if (rs.next() count = rs.getInt(1);rs.close();pstm.close();db.close();return count;Override/ 总共有几页public int countpage() throws Exception int countpage=0; /拿到总记录数 int count=this .count(); if (count%pagesize=0) countpage=count/pagesize; else countpage=count/pagesize+1; return countpage; Override/ 每页显示几条记录public void pagesize(int pagesize) throws Exception this.pagesize=pagesize;Overridepublic List querypage(int page) throws Exception / TODO Auto-generated method stubList lst=new ArrayList();db=new DataBase();sql=select * from ltcms_word order by word_shijian desc limit ?,?;int start = (page - 1) * pagesize;pstm = db.conn.prepareStatement(sql);pstm.setInt(1, start);pstm.setInt(2, pagesize);rs = pstm.executeQuery();Word w=null;while (rs.next() w=new Word();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);rs.close();pstm.close();db.close();return lst;package com.litiancms.servlet;import java.io.IOException;import java.io.PrintWriter;import java.text.SimpleDateFormat;import java.util.Date;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.xml.crypto.Data;import org.omg.CORBA.Request;import com.litiancms.bean.Word;import com.litiancms.factory.WordFactory;import com.litiancms.impl.Wordimpl;public class WordServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException PrintWriter out = response.getWriter();String start = request.getParameter(start);String content = request.getParameter(content);String zuozhe = request.getParameter(zuozhe);SimpleDateFormat sdf = new SimpleDateFormat(yyyy年MM月dd日hh时mm分ss秒);String ctime = sdf.format(new Date();Word w = new Word();w.setWord_content(content);w.setWord_zuozhe(zuozhe);w.setWord_shijian(ctime);if (addword.equals(start) try WordFactory.getword().addword(w);out.println(alert(留言成功);location.href=./servlet/QueyallServlet); catch (Exception e) / TODO Auto-generated catch blocke.printStackTrace();/int id = Integer.parseInt(request.getParameter(id);if (delword.equals(start) try /WordFactory.getword().delword(id);/ 跳转页面/ out.println(alert(删除成功);location.href=./servlet/QueryallServlet;); catch (Exception e) / TODO Auto-generated catch blocke.printStackTrace();package com.litiancms.servlet;import java.io.IOException;import java.io.PrintWriter;import java.util.ArrayList;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.litiancms.bean.Word;import com.litiancms.factory.WordFactory;public class QueyallServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException PrintWriter out = response.getWriter();int pagestart=1;try Integer count=WordFactory.getword().count();Integer countpage=WordFactory.getword().countpage();String start = request.getParameter(start);if (start != null) try pagestart = Integer.parseInt(start);if (pagestart countpage) pagestart = countpage; catch (Exception e) / TODO: handle exceptionpagestart = 1;/ 分页List lst=new ArrayList();lst=WordFactory.getword().querypage(pagestart);/ 当前页数request.setAttribute(pagestart, pagestart);/ 记录数request.setAttribute(count, count);/ 总页数request.setAttribute(countpage, countpage);request.setAttribute