《新闻发布系统》设计报告

和修改等操作,其数据流图如下Р图4-6文章管理的数据流图Р新闻的添加Р新闻添加页面如下:Р图4-7 新闻添加界面Р添加一条新闻的相关代码为:Р?public static boolean insert(News news) {Р boolean flag = false;Р DBConnectPool dbp = DBConnectPool.getInstance();Р Connection conn = dbp.getConnection();Р PreparedStatement pstmt = null;Р try {Р pstmt = conn.prepareStatement(Р "insert into newsinfo(" +Р "biaoti,gabushijian,pinglun," +Р "laiyuan,tupian,zhaiyao,guanjiainzi," +Р "classid,fabiaozhe,banquanxinxi,dianjilv" +Р ")" +Р " value(?,?,?,?,?,?,?,?,?,?,?);");Р pstmt.setString(2,news.getBiaoti());Р pstmt.setDate(3, news.getFabushijian());Р pstmt.setInt(4,news.getPinglun());Р pstmt.setString(5, news.getLaiyuan());Р pstmt.setString(6,news.getTupian());Р pstmt.setString(7, news.getZhaiyao());Р pstmt.setString(8,news.getGuanjianzi());Р pstmt.setInt(9, news.getClassid());