uploads.java.back

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

    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=? 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.execute();
                }
            } else
            if(form.getImage12().getFileName() != null && !form.getImage12().getFileName().equals(""))
            {
                sqls = "insert into newspicture(type,acc_picture,innerNewId,imageName,imageparam) 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.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=? 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.execute();
                }
            } else
            if(form.getImage22().getFileName() != null && !form.getImage22().getFileName().equals(""))
            {
                sqls = "insert into newspicture(type,acc_picture,innerNewId,imageName,imageparam) 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.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=? 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.execute();
                }
            } else
            if(form.getImage32().getFileName() != null && !form.getImage32().getFileName().equals(""))
            {
                sqls = "insert into newspicture(type,acc_picture,innerNewId,imageName,imageparam) 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.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=? 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.execute();
                }
            } else
            if(form.getImage42().getFileName() != null && !form.getImage42().getFileName().equals(""))
            {
                sqls = "insert into newspicture(type,acc_picture,innerNewId,imageName,imageparam) 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.execute();
            }
            sql.disconnect();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }

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