新闻系统项目资源，包含数据库文件、jsp文件、java文件

package com.jjzd.news.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.jjzd.news.dao.BaseDao; import com.jjzd.news.dao.bm_comment; import com.jjzd.news.entity.Comment; public class bm_commentImpl extends BaseDao implements bm_comment { @Override // 是否存在评论表 public boolean isComExist() { String sql = "select * from com limit 1"; Connection con = null; PreparedStatement ps = null; ResultSet rs = null; try { con = getConnection(); ps = con.prepareStatement(sql); rs = ps.executeQuery(); if (rs!=null) { System.out.println("true"); return true; // 表存在 } else { System.out.println("false"); return false; // 表不存在 } } catch (SQLException e) { e.printStackTrace(); System.out.println("异常"); return false; // 出现异常，表不存在 } finally { // 关闭资源 try { if (rs != null) { rs.close(); } if (ps != null) { ps.close(); } if (con != null) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } } @Override //创建评论表(username,ip,comment) public int createCom() { String createTableSql = "create table com (id VARCHAR(50), name VARCHAR(50), content VARCHAR(255))"; Connection con = null; PreparedStatement ps = null; try { con = getConnection(); ps = con.prepareStatement(createTableSql); return ps.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); return 0; } finally { // 关闭资源 try { if (ps != null) { ps.close(); } if (con != null) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } } @Override public List<com.jjzd.news.entity.bm_comment> getallCom() { List<com.jjzd.news.entity.bm_comment> commentList = new ArrayList<>(); String sql = "select * from com"; Connection con = null; PreparedStatement ps = null; ResultSet rs = null; try { con = getConnection(); ps = con.prepareStatement(sql); rs = ps.executeQuery(); while (rs.next()) { String id = rs.getString("id"); String name = rs.getString("name"); String content = rs.getString("content"); com.jjzd.news.entity.bm_comment com = new com.jjzd.news.entity.bm_comment(name, id, content); commentList.add(com); } } catch (SQLException e) { e.printStackTrace(); } finally { // 关闭资源 try { if (rs != null) { rs.close(); } if (ps != null) { ps.close(); } if (con != null) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } System.out.println("yes"); System.out.println(commentList); return commentList; } //添加评论 @Override public int addCom(String id, String name, String content) { String sql = "insert into com(id, name, content) values(?,?,?)"; exceuteUpdate(sql, id, name, content); return 0; } }