uploads.java

jdo开发实例,一个功能全面的oa系统

      for (ResultSet rs = sql.query(
          "select * from newspicture ORDER  BY id desc");
           rs.next();) {
        ha1 = new Hashtable();
        String idesc = rs.getString("idesc");
        System.out.print(idesc);
        ha1.put("idesc", idesc);
        tempbyte=rs.getBytes("acc_picture");
        if(tempbyte.length>0)
        {out = response.getOutputStream();

        out.write(tempbyte);
        out.flush();


        }else{response.getWriter().print("没有新闻图片");}

      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public boolean ispicture(String id) {
    boolean result = true;
    try {
      sql.connect();
      ResultSet rs = sql.query("select * from newspicture where innerNewId=" +
                               id);
      if (!rs.next())
        result = false;
      else
        result = true;
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    return result;
  }

  public void del(String ID) {
    try {
      sql.commit();
      String sql1 = "delete from innernews  where  id=" + ID;
      sql.execute(sql1);
      sql.disconnect();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public void updateNews(String ID, UploadForm form) {
    UserMgr um = new UserMgr();
    try {
      String filename = um.getname(ID);
      String flashname = um.getflashname(ID);
      String sqls = "";
      sql.connect();
      Connection conn = sql.getConnection();
      String topic = form.getTopic();
      String content = form.getContent();
      String limitime = form.getEnd_time();
      String doctype = form.getDoc_fujian().getContentType();
      byte docdate[] = form.getDoc_fujian().getFileData();
      String docname = form.getDoc_fujian().getFileName();
      String falshname = form.getSwf_flash().getFileName();
      byte flashdate[] = form.getSwf_flash().getFileData();
      String filechange = form.getFilechange().trim();
      String flashchange = form.getFalshchange().trim();

      if (filename.length() > 0 && filename != "") {
        if (filechange.equals("del") || filechange.equals("change")) {
          sqls = "update innernews set topic=?,content=?,end_time=?,accfile=?,filename=?,filetype=? where id=" +
              ID;
          PreparedStatement ps = conn.prepareStatement(sqls);
          ps.setString(1, topic);
          ps.setString(2, content);
          ps.setString(3, limitime);
          ps.setBytes(4, docdate);
          ps.setString(5, docname);
          ps.setString(6, doctype);
          ps.execute();
        }
      }
      else {
        sqls = "update innernews set topic=?,content=?,end_time=?,accfile=?,filename=?,filetype=? where id=" +
            ID;
        PreparedStatement ps = conn.prepareStatement(sqls);
        ps.setString(1, topic);
        ps.setString(2, content);
        ps.setString(3, limitime);
        ps.setBytes(4, form.getDoc_fujian2().getFileData());
        ps.setString(5, form.getDoc_fujian2().getFileName());
        ps.setString(6, form.getDoc_fujian2().getContentType());
        ps.execute();
      }
      if (flashname.length() > 0 && flashname != "") {
        if (flashchange.equals("del") || flashchange.equals("change")) {
          sqls =
              "update innernews set topic=?,content=?,end_time=?,acc=?,flashname=? where id=" +
              ID;
          PreparedStatement ps = conn.prepareStatement(sqls);
          ps.setString(1, topic);
          ps.setString(2, content);
          ps.setString(3, limitime);
          ps.setBytes(4, flashdate);
          ps.setString(5, falshname);
          ps.execute();
        }
      }
      else {
        sqls =
            "update innernews set topic=?,content=?,end_time=?,acc=?,flashname=? where id=" +
            ID;
        System.out.println("开始没有相关的flash.");
        PreparedStatement ps = conn.prepareStatement(sqls);
        ps.setString(1, topic);
        ps.setString(2, content);
        ps.setString(3, limitime);
        ps.setBytes(4, form.getSwf_flash2().getFileData());
        ps.setString(5, form.getSwf_flash2().getFileName());
        ps.execute();
      }
      if (flashchange.equals("nochange") || filechange.equals("nochange")) {
        sqls = "update innernews set topic=?,content=?,end_time=? where id=" +
            ID;
        PreparedStatement ps = conn.prepareStatement(sqls);
        ps.setString(1, topic);
        ps.setString(2, content);
        ps.setString(3, limitime);
        ps.execute();
      }
      sql.disconnect();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public void updatenewpic(String ID, UploadForm form) {
    UserMgr um = new UserMgr();
    try {
      sql.connect();
      String img1 = form.getIschange1().trim();
      String img2 = form.getIschange2().trim();
      String img3 = form.getIschange3().trim();
      String img4 = form.getIschange4().trim();
      Connection conn = sql.getConnection();
      String sqls = "";
      String ids[] = um.getContent(ID);
      if (ids[0] != null && ids[0] != "") {
        if (img1.equals("del") || img1 == "del") {
          sqls = "delete from newspicture where id=" + ids[0];
          sql.execute(sqls);
        }
        else
        if (img1.equals("change") || img1 == "change") {
          sqls =
              "update newspicture set type=?,acc_picture=?,imageName=?,imageparam=?,idesc=?  where id=" +
              ids[0];
          PreparedStatement ps = conn.prepareStatement(sqls);
          ps.setString(1, form.getImage1().getContentType());
          ps.setBytes(2, form.getImage1().getFileData());
          ps.setString(3, form.getImage1().getFileName());
          ps.setString(4, form.getImagesize1());
          ps.setString(5, form.getDesc1());

          ps.execute();
        }
      }
      else
      if (form.getImage12().getFileName() != null &&
          !form.getImage12().getFileName().equals("")) {
        sqls = "insert into newspicture(type,acc_picture,innerNewId,imageName,imageparam,idesc) values(?,?,?,?,?,?)";
        int id = Integer.parseInt(ID);
        PreparedStatement ps = conn.prepareStatement(sqls);
        ps.setString(1, form.getImage12().getContentType());
        ps.setBytes(2, form.getImage12().getFileData());
        ps.setInt(3, id);
        ps.setString(4, form.getImage12().getFileName());
        ps.setString(5, form.getImagesize1());
        ps.setString(6, form.getDesc2());
        ps.execute();
      }
      if (ids[1] != null && ids[1] != "") {
        if (img2.equals("del") || img2 == "del") {
          sqls = "delete from newspicture where id=" + ids[1];
          sql.execute(sqls);
        }
        else
        if (img2.equals("change") || img2 == "change") {
          sqls =
              "update newspicture set type=?,acc_picture=?,imageName=?,imageparam=?, idesc=? where id=" +
              ids[1];
          PreparedStatement ps = conn.prepareStatement(sqls);
          ps.setString(1, form.getImage2().getContentType());
          ps.setBytes(2, form.getImage2().getFileData());
          ps.setString(3, form.getImage2().getFileName());
          ps.setString(4, form.getImagesize2());
          ps.setString(5, form.getDesc2());

          ps.execute();
        }
      }
      else
      if (form.getImage22().getFileName() != null &&
          !form.getImage22().getFileName().equals("")) {
        sqls = "insert into newspicture(type,acc_picture,innerNewId,imageName,imageparam ,idesc=?) values(?,?,?,?,?,?)";
        int id = Integer.parseInt(ID);
        PreparedStatement ps = conn.prepareStatement(sqls);
        ps.setString(1, form.getImage22().getContentType());
        ps.setBytes(2, form.getImage22().getFileData());
        ps.setInt(3, id);
        ps.setString(4, form.getImage22().getFileName());
        ps.setString(5, form.getImagesize2());
        ps.setString(6, form.getDesc2());

        ps.execute();
      }
      if (ids[2] != null && ids[2] != "") {
        if (img3.equals("del") || img3 == "del") {
          sqls = "delete from newspicture where id=" + ids[2];
          sql.execute(sqls);
        }
        else
        if (img3.equals("change") || img3 == "change") {
          sqls =
              "update newspicture set type=?,acc_picture=?,imageName=?,imageparam=? , idesc=? where id=" +
              ids[2];
          PreparedStatement ps = conn.prepareStatement(sqls);
          ps.setString(1, form.getImage3().getContentType());
          ps.setBytes(2, form.getImage3().getFileData());
          ps.setString(3, form.getImage3().getFileName());
          ps.setString(4, form.getImagesize3());
          ps.setString(5, form.getDesc3());

          ps.execute();
        }
      }
      else
      if (form.getImage32().getFileName() != null &&
          !form.getImage32().getFileName().equals("")) {
        sqls = "insert into newspicture(type,acc_picture,innerNewId,imageName,imageparam,idesc ) values(?,?,?,?,?,?)";
        int id = Integer.parseInt(ID);
        PreparedStatement ps = conn.prepareStatement(sqls);
        ps.setString(1, form.getImage32().getContentType());
        ps.setBytes(2, form.getImage32().getFileData());
        ps.setInt(3, id);
        ps.setString(4, form.getImage32().getFileName());
        ps.setString(5, form.getImagesize3());
        ps.setString(6, form.getDesc3());

        ps.execute();
      }
      if (ids[3] != null && ids[3] != "") {
        if (img4.equals("del") || img4 == "del") {
          sqls = "delete from newspicture where id=" + ids[3];
          sql.execute(sqls);
        }
        else
        if (img4.equals("change") || img4 == "change") {
          sqls =
              "update newspicture set type=?,acc_picture=?,imageName=?,imageparam=?,   idesc=? where id=" +
              ids[3];
          PreparedStatement ps = conn.prepareStatement(sqls);
          ps.setString(1, form.getImage4().getContentType());
          ps.setBytes(2, form.getImage4().getFileData());
          ps.setString(3, form.getImage4().getFileName());
          ps.setString(4, form.getImagesize4());
          ps.setString(5, form.getDesc4());

          ps.execute();
        }
      }
      else
      if (form.getImage42().getFileName() != null &&
          !form.getImage42().getFileName().equals("")) {
        sqls = "insert into newspicture(type,acc_picture,innerNewId,imageName,imageparam ,idesc) values(?,?,?,?,?,?)";
        int id = Integer.parseInt(ID);
        PreparedStatement ps = conn.prepareStatement(sqls);
        ps.setString(1, form.getImage42().getContentType());
        ps.setBytes(2, form.getImage42().getFileData());
        ps.setInt(3, id);
        ps.setString(4, form.getImage42().getFileName());
        ps.setString(5, form.getImagesize4());
        ps.setString(6, form.getDesc4());
        ps.execute();
      }
      sql.disconnect();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public static void main(String args1[]) {
  }
}