managernews.java

jsp开发常用信息管理系统适合初学者学习 新闻管理

            newsbean.setLight(resultset.getString("light"));
        } catch (SQLException sqlexception) {
            System.err.println("DetailNews():" + sqlexception.getMessage());
        }
        if (!resultset.getString("pagination").equals(""))
            try {
                String s4 = "SELECT * FROM " + s + " WHERE pagination = '"
                        + resultset.getString("pagination")
                        + "' ORDER BY id ASC";
                for (ResultSet resultset1 = dbConn.ExeQuery(s4); resultset1
                        .next();) {
                    j++;
                    String s7 = handle.Convert2Path(resultset1.getInt("id"),
                            resultset1.getString("date_time"));
                    if (i == resultset1.getInt("id"))
                        s5 = s5 + "[<font color=red>" + j + "</font>] ";
                    else
                        s5 = s5 + "[<a href=" + systemURL + "htmlnews/" + s7
                                + ">" + j + "</a>] ";
                }

            } catch (SQLException sqlexception1) {
                System.err
                        .println("DetailNews():" + sqlexception1.getMessage());
            }
        s5 = s5 + "<script src=" + systemURL + "add_click.jsp?Nid=" + i
                + "></script>";
        newsbean.setSplitNum(s5);
        dbConn.CloseConn();
        return newsbean;
    }

    public String HotTopNews(String s, int i) throws Exception {
        String s1 = "";
        String s3 = "";
        String s4 = "";
        String as[] = new String[3];
        int j = 0;
        try {
            String s2 = "SELECT * FROM "
                    + s
                    + " WHERE date_time >= '2002-11-30 16:15:09' ORDER BY click DESC";
            ResultSet resultset = dbConn.ExeQuery(s2);
            s3 = s3 + "<table width=100% border=0 cellspacing=0 cellpadding=4>";
            while (resultset.next()) {
                if (j == i)
                    break;
                String as1[] = CheckSplit(s, resultset.getString("pagination"),
                        resultset.getString("id"),
                        resultset.getString("topic"), resultset
                                .getString("date_time"));
                if (!as1[1].equals(s4)) {
                    String s5 = handle.Convert2Path(Integer.parseInt(as1[0]),
                            as1[2]);
                    s3 = s3 + "<tr>";
                    s3 = s3 + "<td><a href=news_system/htmlnews/" + s5 + ">"
                            + as1[1] + "</a></td>";
                    s3 = s3 + "</tr>";
                    s4 = as1[1];
                    j++;
                }
            }
            dbConn.CloseConn();
            s3 = s3 + "</table>";
        } catch (SQLException sqlexception) {
            System.err.println("HotTopNews():" + sqlexception.getMessage());
        }
        return s3;
    }

    public String ListNewsType(HttpServletRequest httpservletrequest, String s,
            String s1) throws Exception {
        String s4 = "";
        String s5 = getVisitorConditionStr(httpservletrequest, s1);
        s5 = handle.Replace("type_id", "id", s5);
        try {
            String s2 = "SELECT * FROM " + s + " WHERE " + s5
                    + "=0 ORDER BY id DESC";
            for (ResultSet resultset = dbConn.ExeQuery(s2); resultset.next();) {
                int i = resultset.getInt("id");
                String s3 = resultset.getString("title");
                s4 = s4 + "<option value=" + i + ">" + s3 + "</option>\n";
            }

            dbConn.CloseConn();
        } catch (SQLException sqlexception) {
            System.err.println("ListNewsType1():" + sqlexception.getMessage());
        }
        return s4;
    }

    public String ListNewsType(HttpServletRequest httpservletrequest, String s,
            String s1, int i) throws Exception {
        String s4 = "";
        String s5 = getVisitorConditionStr(httpservletrequest, s1);
        s5 = handle.Replace("type_id", "id", s5);
        try {
            String s2 = "SELECT * FROM " + s + " WHERE " + s5
                    + " ORDER BY id DESC";
            for (ResultSet resultset = dbConn.ExeQuery(s2); resultset.next();) {
                int j = resultset.getInt("id");
                String s3 = resultset.getString("title");
                if (i == j)
                    s4 = s4 + "<option value=" + j + " selected>" + s3
                            + "</option>\n";
                else
                    s4 = s4 + "<option value=" + j + ">" + s3 + "</option>\n";
            }

            dbConn.CloseConn();
        } catch (SQLException sqlexception) {
            System.err.println("ListNewsType2():" + sqlexception.getMessage());
        }
        return s4;
    }

    public void ModNews(String s, HttpServletRequest httpservletrequest)
            throws Exception {
        String s1 = handle.GBK2ISO(httpservletrequest.getParameter("topic"));
        String s2 = handle.GBK2ISO(httpservletrequest.getParameter("content"));
        s2 = filter.dealWithURLFilte(s2);
        String s3 = handle.GBK2ISO(httpservletrequest.getParameter("keywords"));
        String s4 = handle.GBK2ISO(httpservletrequest.getParameter("source"));
        String s5 = handle.getString(httpservletrequest, "light");
        int i = handle.getInt(httpservletrequest, "Nid");
        int j = handle.getInt(httpservletrequest, "type_id");
        int k = handle.getInt(httpservletrequest, "content_type");
        HttpSession httpsession = httpservletrequest.getSession(true);
        if (httpsession.getAttribute("ImgsName") != null)
            handle.DestroyOneSession(httpsession, "ImgsName");
        String s6 = "UPDATE "
                + s
                + " SET topic=?,content=?,keywords=?,source=?,type_id=?,content_type=?,light=?,publish_html=0 WHERE id=?";
        dbConn.getPreparedStatement(s6);
        dbConn.setString(1, s1);
        dbConn.setString(2, s2);
        dbConn.setString(3, s3);
        dbConn.setString(4, s4);
        dbConn.setInt(5, j);
        dbConn.setInt(6, k);
        dbConn.setString(7, s5);
        dbConn.setInt(8, i);
        dbConn.ExeUpdate();
    }

    public void ModType(HttpServletRequest httpservletrequest, String s)
            throws Exception {
        String s1 = handle.GBK2ISO(httpservletrequest.getParameter("title"));
        int i = handle.getInt(httpservletrequest, "type_id");
        String s2 = "UPDATE " + s + " SET title='" + s1 + "' WHERE id=" + i;
        dbConn.ExeUpdate(s2);
        dbConn.CloseConn();
    }

    public Hashtable PrintAllNews(HttpServletRequest httpservletrequest, int i,
            int j, String s, String s1, String s2) throws Exception {
        int k = 0;
        boolean flag = false;
        Hashtable hashtable = new Hashtable();
        Hashtable hashtable1 = new Hashtable();
        String as[] = new String[3];
        String s4 = "";
        String s5 = handle.getString(httpservletrequest, "CurrentPage", "0");
        String s6 = handle.getString(httpservletrequest, "type_name");
        Vector vector = new Vector();
        try {
            s6 = handle.GBK2ISO(s6);
            String s3 = "SELECT * FROM " + s2 + " WHERE title = '" + s6 + "'";
            ResultSet resultset = dbConn.ExeQuery(s3);
            resultset.next();
            int i1 = resultset.getInt("id");
            s3 = "SELECT *,a.id AS news_id FROM "
                    + s1
                    + " AS a,"
                    + s2
                    + " AS b WHERE b.id="
                    + i1
                    + " AND a.type_id=b.id  AND a.publish_html != 0 ORDER BY a.id DESC";
            resultset = dbConn.ExeQuery(s3);
            resultset.last();
            k = resultset.getRow();
            hashtable = turn_page(s5, i, k);
            int j1 = Integer.parseInt(String.valueOf(hashtable.get("pt_st"))) + 1;
            int k1 = Integer.parseInt(String.valueOf(hashtable.get("pt_en"))) + 1;
            resultset.absolute(j1);
            for (int l = j1; l < k1 && k != 0; l++) {
                String as1[] = CheckSplit(s1,
                        resultset.getString("pagination"), resultset
                                .getString("news_id"), resultset
                                .getString("topic"), resultset
                                .getString("date_time"));
                if (as1[1].equals(s4)) {
                    if (!resultset.next())
                        break;
                    continue;
                }
                String s7 = handle.Convert2Path(Integer.parseInt(as1[0]),
                        as1[2]);
                if (as1[1].length() > j)
                    as1[1] = as1[1].substring(0, j) + "...";
                newsBean newsbean = new newsBean();
                newsbean.setTopic(as1[1]);
                newsbean.setHtmlFileName(handle.Convert2Path(Integer
                        .parseInt(as1[0]), as1[2]));
                newsbean.setDateTime(handle.Split(" ", as1[2])[0]);
                vector.addElement(newsbean);
                s4 = as1[1];
                if (!resultset.next())
                    break;
            }

            dbConn.CloseConn();
        } catch (SQLException sqlexception) {
            System.err.println("PrintAllNews():" + sqlexception.getMessage());
        }
        Hashtable hashtable2 = search_turn_print_all_news(hashtable, s, s6);
        hashtable1.put("RecordCount", String.valueOf(k));
        hashtable1.put("newsBeanVector", vector);
        hashtable1.put("navigationInfoHashtable", hashtable2);
        return hashtable1;
    }

    public Vector PrintNTitle(String s, String s1, String s2, int i, int j)
            throws Exception {
        String s3 = "";
        String s5 = "";
        String s6 = "";
        String as[] = new String[3];
        Vector vector = new Vector();
        boolean flag = false;
        s2 = handle.GBK2ISO(s2);
        try {
            String s4 = "SELECT * FROM " + s + " WHERE title = '" + s2 + "'";
            ResultSet resultset = dbConn.ExeQuery(s4);
            resultset.next();
            int k = resultset.getInt("id");
            s4 = "SELECT * FROM "
                    + s1
                    + " WHERE type_id = ? AND publish_html != 0 ORDER BY id DESC";
            dbConn.getPreparedStatement(s4);
            dbConn.setInt(1, k);
            for (ResultSet resultset1 = dbConn.ExeQuery(); resultset1.next()
                    && vector.size() != i;) {
                String as1[] = CheckSplit(s1, resultset1
                        .getString("pagination"), resultset1.getString("id"),
                        resultset1.getString("topic"), resultset1
                                .getString("date_time"));
                if (!as1[1].equals(s6)) {
                    String s8 = handle.Convert2Path(Integer.parseInt(as1[0]),
                            as1[2]);
                    newsBean newsbean = new newsBean();
                    newsbean.setHtmlFileName(s8);
                    String s7;
                    if (as1[1].length() > 24) {
                        s7 = as1[1].substring(0, 24);
                        s7 = s7 + "...";
                    } else {
                        s7 = as1[1];
                    }
                    if (resultset1.getString("light") == null)
                        newsbean.setTopic(s7);
                    else
                        newsbean.setTopic("<font color="
                                + resultset1.getString("light") + ">" + s7
                                + "</font>");
                    newsbean.setDateTime(handle.Split(" ", as1[2])[0]);
                    vector.addElement(newsbean);
                    s6 = as1[1];
                }
            }

            dbConn.CloseConn();
        } catch (SQLException sqlexception) {
            System.err.println("PrintNTitle():" + sqlexception.getMessage());
        }
        return vector;
    }

    public Hashtable PrintNTitlePreView(String s, String s1, String s2, int i)
            throws Exception {
        String s3 = "";
        String s5 = "";
        String s6 = "";
        String as[] = new String[3];
        String as2[] = new String[i];
        String as3[] = new String[i];
        String as4[] = new String[i];
        Hashtable hashtable = new Hashtable();
        int j = 0;
        boolean flag = false;
        s2 = handle.GBK2ISO(s2);
        try {
            String s4 = "SELECT * FROM " + s + " WHERE title = '" + s2 + "'";
            System.out.println(s4);
            ResultSet resultset = dbConn.ExeQuery(s4);
            resultset.next();
            int k = resultset.getInt("id");
            s4 = "SELECT * FROM " + s1 + " WHERE type_id = " + k
                    + " ORDER BY id DESC";