Java 处理 xml BOM头

Jerome Kwok — Mon, 28 Apr 2014 10:19:00 GMT

只有注册用户登录后才能阅读该文。阅读全文

Jerome Kwok 2014-04-28 18:19 发表评论

RMI实例详解

Jerome Kwok — Mon, 10 Feb 2014 09:39:00 GMT

摘要: 1. 功能需求：实现最简单的远程文件访问。Client能够获取在Server上的远程文件信息。实例代码中，客户端获取了服务器端的文件“D:\\test\testDate.java”的内容和文件名。 2. 实现结构： a) Server包含： &nb... 阅读全文

Jerome Kwok 2014-02-10 17:39 发表评论

RMI文件上传例子(转)

Jerome Kwok — Mon, 10 Feb 2014 09:26:00 GMT

只有注册用户登录后才能阅读该文。阅读全文

Jerome Kwok 2014-02-10 17:26 发表评论

java日期操作

Jerome Kwok — Thu, 22 Nov 2012 04:25:00 GMT

只有注册用户登录后才能阅读该文。阅读全文

Jerome Kwok 2012-11-22 12:25 发表评论

Java文件上传下载

Jerome Kwok — Fri, 31 Aug 2012 03:37:00 GMT

多文件上传的jsp页面，UpLoad.jsp
======================================================================

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>


    My JSP 'UpLoad.jsp' starting page

多文件上传的FileUpload.java文件：

==========================================
package load.up;
import javax.servlet.http.HttpServletRequest;
import java.io.File;
import java.util.List;
import java.util.Date;
import java.util.Iterator;
import org.apache.commons.fileupload.DiskFileUpload;
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUploadException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class FileUpload {
    /**
    * 实现文件上传功能
    * @param request HttpServletRequest
    * @param tempPath 临时路径
    * @param uploadPath 上传路径
    * @param newFileName 新文件名称
    * @return boolean 是否成功
    */
    public boolean doFileUpload(HttpServletRequest request, String tempPath, String upLoadPath ,String newFileName, int msgId) {
        /** 成功上传 */
        boolean flag=true;
        try {
            /** 获取当前系统时间对象 */
            Date date = new Date();
            if (!new File(upLoadPath).isDirectory())
                new File(upLoadPath).mkdirs();
//            if (!new File(tempPath).isDirectory())
//                new File(tempPath).mkdirs();
            DiskFileUpload diskFUpload = new DiskFileUpload();
            /** 设置Upload文件大小尺寸 */
            diskFUpload.setSizeMax(5 * 1024 * 1024);
            /** 设置缓冲区大小 */
            diskFUpload.setSizeThreshold(4 * 1024);
//            /** 设置临时存储路径 */
//            diskFUpload.setRepositoryPath(tempPath);
            /** 得到所有上传文件List */
            List fileItems = diskFUpload.parseRequest(request);
            /** 取得上传文件List迭代器 */
            Iterator it = fileItems.iterator();
            /** 遍历迭代器中的对象，进行对象处理 */
            while (it.hasNext()) {
                /** 取得单个文件对象 */
                FileItem fi = (FileItem) it.next();
                /** 获取上传文件文件名,包括文件路径 */
                String filePathName = fi.getName();
                String sysYear = date.getYear() + "";
                String sysMonth = date.getMonth() + "";
                String sysDay = date.getDay() + "";
                String sysHours = date.getHours() + "";
                String sysMin = date.getMinutes() + "";
                String sysSec = date.getSeconds() + "";
                long sys=System.currentTimeMillis();
                /** 取当前系统时间 */
                String sysTime = sysYear + sysMonth + sysDay + sysHours
                        + sysMin + sysSec;
                /** 获取上传文件原文件名 */
                String fileOldName=filePathName.substring(filePathName.lastIndexOf("\\") + 1);
                /** 获取文件名，包括扩展名 */
              String fileName=sysTime+sys+fileOldName;
                /** 上传文件服务器端保存路径 */
                String url=upLoadPath +"\\";
                /** 文件存在性check判断 */
                if (fileName != null) {
                /** 服务器上保存上传文件 */
                    fi.write(new File(url+fileName));
                    /** 保存上传文件信息，更新TBL */
                    this.insertFileMsg(msgId, url, fileName, fileOldName);
                    flag = true;
                } else {
                    flag = false;
                }
            }
        } catch (Exception e) {
            flag=false;
        }
        return flag;
    }
    /**
    * 更新TBL，保存上传文件相关信息
    * @param msgId 用户ID
    * @param fileUrl 服务器端上传文件保存路径
    * @param fileName 服务器端保存上传文件的文件名
    */
    private void insertFileMsg(int msgId,String fileUrl,String fileName,String fileOldName){

        Connection conn=null;

        /** 获取数据库链接Connection */
        conn=this.getConn();

        String sql = "insert into tfile(message_id,file_url,file_name,file_old_name) values("
                + msgId
                + ",'"
                + fileUrl.replace("\\", "/")
                + "','"
                + fileName
                + "','"
                + fileOldName + "')";
//        StringBuffer sb = new StringBuffer();
//        sb.append("insert into tfile(message_id,file_url) values(2)");
        System.out.println(sql);

        try {
            Statement stmt=conn.createStatement();
            stmt.execute(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }

        System.out.println(msgId+"::"+fileUrl+"::"+fileName);

    }

    /**
    * 获取数据库链接Connection
    * @return 数据库链接Connection
    */
    private Connection getConn(){

        Connection conn=null;

        String driver_class="com.mysql.jdbc.Driver";

        String url="jdbc:mysql://192.168.1.19:3306/ctemdidb?useUnicode=true&characterEncoding=utf8";

        String userName="root";

        String password="root123";

        try {
            Class.forName(driver_class);
            conn=DriverManager.getConnection(url,userName,password);
        } catch (Exception e) {
            if(conn!=null){
                try {
                    conn.close();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
        }
        return conn;
    }
}

下面是实现FileDownload的javaclass文件
package load.down;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import load.FileMsg;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.InputStream;
import java.io.FileInputStream;
import java.io.OutputStream;

public class FileDownload {

    public List getFileMsg(int msgId) {

        List fileMsglist = new ArrayList();

        Connection conn = null;

        conn = this.getConn();

        String sql = "select file_url,file_name,file_old_name from tfile where message_id="
                + msgId;

        try {

            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery(sql);

            while (rs.next()) {
                FileMsg fileMsg = new FileMsg();

                int messageId=rs.getInt("message_id");
                String fileUrl = rs.getString("file_url");
                String fileName = rs.getString("file_name");
                String fileOldName = rs.getString("file_old_name");

                fileMsg.setMessageId(messageId);
                fileMsg.setFileUrl(fileUrl);
                fileMsg.setFileName(fileName);
                fileMsg.setFileOldName(fileOldName);

                fileMsglist.add(fileMsg);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return fileMsglist;
    }

    /**
    * 获取数据库链接Connection
    *
    * @return 数据库链接Connection
    */
    private Connection getConn() {

        Connection conn = null;

        String driver_class = "com.mysql.jdbc.Driver";

        String url = "jdbc:mysql://192.168.1.19:3306/ctemdidb?useUnicode=true&characterEncoding=utf8";

        String userName = "root";

        String password = "root123";

        try {
            Class.forName(driver_class);

            conn = DriverManager.getConnection(url, userName, password);
        } catch (Exception e) {
        }
        return conn;
    }

    /**
    * download文件
    *
    * @param request
    * @param response
    * @throws Exception
    */
    public void doFileDownload(String path, String fileName,
            HttpServletResponse response) throws Exception {

        File file = new File(path);
        InputStream in = new FileInputStream(file);
        OutputStream os = response.getOutputStream();
        response.addHeader("Content-Disposition", "attachment;filename="
                + fileName);
        response.addHeader("Content-Length", file.length() + "");
        response.setCharacterEncoding("utf-8");
        response.setContentType("application/octet-stream");
        int data = 0;
        while ((data = in.read()) != -1) {
            os.write(data);
        }
        os.close();
        in.close();
    }
}