【Jsp精品源码栏目提醒】:以下是网学会员为您推荐的Jsp精品源码-留言板开发源代码 - 其它资料,希望本篇文章对您学习有所帮助。
package com.litiancms.beanpublic class Word //留言 idprivate int id//留言内容private String word_content//留言作者private String word_zuozhe//留言时间private String word_shijianpublic int getId return idpublic void setIdint id this.id idpublic String getWord_content return word_contentpublic void setWord_contentString wordContent word_content wordContentpublic String getWord_zuozhe return word_zuozhepublic void setWord_zuozheString wordZuozhe word_zuozhe wordZuozhepublic String getWord_shijian return word_shijianpublic void setWord_shijianString wordShijian word_shijian wordShijianpackage com.litiancms.daoimport java.util.Listimport com.litiancms.bean.Wordpublic interface WordDao //留言添加 public void addwordWord wthrows Exception //删除 public void delwordint idthrows Exception // 总共有几条记录 public int count throws Exception // 总页数 public int countpage throws Exception // 设置每页显示几条记录 public void pagesizeint pagesize throws Exception // 分页显示 public ListltWordgt querypageint page throws Exceptionpackage com.litiancms.dbimport java.sql.Connectionimport java.sql.DriverManagerimport java.sql.SQLExceptionpublic class DataBase //用户名 这里的用户名指:数据库的用户名 public final String UNAMEquotrootquot //用户密码 这里的密码指:数据库的密码 public final String UPWDquotadminquot //驱动程序 public final String DRIVERquotcom.mysql.jdbc.Driverquot //链接地址 public final String URLquotjdbc:mysql://localhost:3306/ltcmsquot //链接 public Connection conn //构造方法 public DataBase try //加载驱动程序 Class.forNameDRIVER //链接数据库 connDriverManager.getConnectionURL 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 block e.printStackTrace package com.litiancms.factoryimport com.litiancms.dao.WordDaoimport com.litiancms.impl.Wordimplpublic class WordFactory public static WordDao getword return new Wordimpl package com.litiancms.implimport java.sql.PreparedStatementimport java.sql.ResultSetimport java.util.ArrayListimport java.util.Listimport com.litiancms.bean.Wordimport com.litiancms.dao.WordDaoimport com.litiancms.db.DataBasepublic class Wordimpl implements WordDao //分页显示 int pagesize5 // 定义连接数据库 DataBase db null // 操作数据库 PreparedStatement pstm //集合 ResultSet rs //sql 语句 String sqlnull Override //留言添加 public void addwordWord w throws Exception // TODO Auto-generated method stub //数据库 dbnew DataBase sqlquotinsert into ltcms_wordword_contentword_zuozheword_shijianvaluesquot pstmdb.conn.prepareStatementsql pstm.setString1w.getWord_content pstm.setString2w.getWord_zuozhe pstm.setString3 w.getWord_shijian pstm.executeUpdate pstm.close db.close Override //删除 public void delwordint id throws Exception // TODO Auto-generated method stub //数据库 dbnew DataBase sqlquotdeldet from ltcms_word where idquot pstmdb.conn.prepareStatementsql pstm.setInt1 id pstm.executeUpdate pstm.close db.closeOverridepublic int count throws Exception // TODO Auto-generated method stub int count 0 // 连接数据库 db n