问个上传文件并保存到数据库的问题

daocha 2008-06-05 08:16:34

我用SMARTUPLOAD上传一个WORD 并在响应页面将上传的附件写入数据库中
可是有的时候上传的页面无法响应当我关闭IE的时候发现数据库链接没有关闭我是在try{}中建立连接的
try{
conn=ConnectDB.connect();
}catch(){}
finally{
if(conn!=null)
conn.close();
}

简略的这么写强制关闭页面为什么不执行finally呢？

...全文

203 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

daocha 2008-06-06

打赏
举报

没有我上传的文件才几十KB 有的时候成功有的时候上传就没响应被迫关闭显示器然后再登录进去就进不去那个页面了因为那个连接没断开
我想完成从A页面提交附件 B页面接收附件然后在B页面将文件上传并且将这个文件写入数据库然后关闭数据库连接把文件删除就是这么一个操作流程

<%!

  //这儿需要修改成您的数据库连接信息

  public Connection conn = null;

  public String docid = "";

  public String filename = "";

  public int filesize = 0;

%>

<%

  String js = null;

  Userinfo userinfo = null;

  String stu_id = null;

  String tch_id = null;

  stu_id = request.getParameter("stuid");

  int xtzl = 0;

  int wxzs = 0;

  int zy = 0;

  int bysjzl = 0;

  try {

    xtzl = Integer.parseInt(request.getParameter("xtzl"));

  }

  catch (Exception e) {

    xtzl = 0;

  }

  try {

    wxzs = Integer.parseInt(request.getParameter("wxzs"));

  }

  catch (Exception e) {

    wxzs = 0;

  }

  try {

    zy = Integer.parseInt(request.getParameter("zy"));

  }

  catch (Exception e) {

    zy = 0;

  }

  try {

    bysjzl = Integer.parseInt(request.getParameter("bysjzl"));

  }

  catch (Exception e) {

    bysjzl = 0;

  }

  int op = -1;

  if (request.getParameter("op") != null)

    op = Integer.parseInt(request.getParameter("op"));

  mySmartUpload.initialize(pageContext);

  try {

    mySmartUpload.upload();

    mySmartUpload.save("/thesisdocuments/bysjpyjs");

  }

  catch (SmartUploadException e) {

    out.println(MsgLang.uploaderr());

  }

  coghatool.wordprocess.File myFile = null;

  docid = mySmartUpload.getRequest().getParameter("docid");

  for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) {

    myFile = mySmartUpload.getFiles().getFile(i);

    if (!myFile.isMissing()) {

      filename = myFile.getFileName();

      filesize = myFile.getSize();

      if (myFile.getFieldName().equalsIgnoreCase("EDITFILE")) { //正文文件

        /*System.out.println("处理正文文件");

                 System.out.println("filename=" + filename);

                 System.out.println("filesize=" + filesize);

                 System.out.println("myFile.getFieldName()=" + myFile.getFieldName());*/

        String filename_path = application.getRealPath("/") + "thesisdocuments\\bysjpyjs\\" + filename;

        java.io.File tfile = null;

        java.io.InputStream inStream = null;

        PreparedStatement ps = null;

        Statement stmt = null;

        try {

          int count = 0;

          tfile = new java.io.File(filename_path);

          inStream = new java.io.FileInputStream(tfile);

          conn = ConnectDB.ReturnConnection();

          if (op == 1) { //另存

            String sql = "insert into t_bysjpyjs(stu_id,filename,filesize,filedata,xtzl,wxzs,zy,bysjzl,date) values(?,?,?,?,?,?,?,?,getdate())";

            int total = xtzl + wxzs + zy + bysjzl;

            String str2 = "update t_stuinfo set py_thesis_score=" + total + " where stu_id='" + stu_id + "';";

            ps = conn.prepareStatement(sql);

            stmt = conn.createStatement();

            ps.setString(1, stu_id);

            ps.setString(2, filename);

            ps.setInt(3, filesize);

            ps.setBinaryStream(4, inStream, inStream.available());

            ps.setInt(5, xtzl);

            ps.setInt(6, wxzs);

            ps.setInt(7, zy);

            ps.setInt(8, bysjzl);

            count = ps.executeUpdate();

            stmt.executeUpdate(str2);

          }

          else if (op == 0) { //保存

            String strSql = "";

            strSql = "update t_bysjpyjs set filename=?,filesize=?,filedata=?,xtzl=?,wxzs=?,zy=?,bysjzl=?,date=getdate() where stu_id='" + stu_id + "'";

            int total = xtzl + wxzs + zy + bysjzl;

            String str2 = "update t_stuinfo set py_thesis_score=" + total + " where stu_id='" + stu_id + "';";

            ps = conn.prepareStatement(strSql);

            stmt = conn.createStatement();

            ps.setString(1, filename);

            ps.setInt(2, filesize);

            ps.setBinaryStream(3, inStream, inStream.available());

            ps.setInt(4, xtzl);

            ps.setInt(5, wxzs);

            ps.setInt(6, zy);

            ps.setInt(7, bysjzl);

            count = ps.executeUpdate();

            stmt.executeUpdate(str2);

          }

          if (count > 0) {

            out.println(MsgLang.uploadsuccess(filename, filesize));

          }

          else {

            out.println(MsgLang.uploadfailed2());

          }

        }

        catch (Exception e) {

          e.printStackTrace();

          out.println("发生错误: " + e.toString());

        }

        finally {

          try {

            if (stmt != null)

              stmt.close();

            if (ps != null)

              ps.close();

            if (conn != null)

              conn.close();

            if (inStream != null)

              inStream.close();

            if (tfile != null)

              tfile.delete();

          }

          catch (SQLException e) {

            e.printStackTrace();

          }

        }

      }

    }

  }

%>