精品精品国产三级a∨在线,久久69成人,视频一区视频二区国产精品

jumliang — Fri, 24 Jul 2009 08:25:00 GMT

jumliang 2009-07-24 16:25 发表评论

jumliang — Tue, 10 Mar 2009 02:58:00 GMT

摘要: Spring中常用的hql查询�Ҏ(gu��)��(getHibernateTemplate()) �Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q�－�Q?一、find(String queryString); �C�Z��Q�this.getHibernateTemplate().find("from bean.User");... 阅读全文

jumliang 2009-03-10 10:58 发表评论

文�g下蝲中文文�g名�ؕ码（转）

jumliang — Thu, 22 Jan 2009 07:15:00 GMT

B/S应用�?下蝲一个附件保存时,中文文�g名会��q��,在实际开发中�l�常遇到,现脓(chu��ng)出C#和JAVA的解��x��?

C#:

Response.AppendHeader("Content-Disposition", "attachment;filename=" + Tools.toUtf8String(result));

其中用到的�{换方�?

1public static String toUtf8String(String s)
2        {
3            StringBuilder sb = new StringBuilder();
4            for (int i=0;i<s.Length;i++)
5            {
6                char c = s[i];
7                if (c >= 0 && c <= 255)
8                {
9                    sb.Append(c);
10                }
11                else
12                {
13                    byte[] b;
14                    try
15                    {
16                     b = Encoding.UTF8.GetBytes(c.ToString());
17                    }
18                    catch (Exception ex)
19                    {
20                        b = new byte[0];
21                    }
22                    for (int j = 0; j < b.Length; j++)
23                    {
24                        int k = b[j];
25                        if (k < 0) k += 256;
26
27                        sb.Append("%" + Convert.ToString(k,16).ToUpper());
28                    }
29                }
30            }
31            return sb.ToString();
32        }
33
34

JAVA:

resp.addHeader("Content-Disposition","attachment;filename=" + Tools.toUtf8String(m_entityIndex.m_sName) + ".xls");

其中用到的�{换方�?

public static String toUtf8String(String s) {
        StringBuffer sb = new StringBuffer();
        for (int i=0;i<s.length();i++) {
            char c = s.charAt(i);
            if (c >= 0 && c <= 255) {
                sb.append(c);
            } else {
                byte[] b;
                try {
                 b = new Character(c).toString().getBytes("utf-8");
                    //b = Character.toString(c).getBytes("utf-8");
                } catch (Exception ex) {
                    System.out.println(ex);
                    b = new byte[0];
                }
                for (int j = 0; j < b.length; j++) {
                    int k = b[j];
                    if (k < 0) k += 256;
                    sb.append("%" + Integer.toHexString(k).
                    toUpperCase());
                }
            }
        }
        return sb.toString();
    }

jumliang 2009-01-22 15:15 发表评论

jumliang — Mon, 12 Jan 2009 13:30:00 GMT

我做的项目原来是先在服务器上生成一个excel文�g�Q�然后用jspsmartupload下蝲的，可是�׃��用jspsmartupload下蝲的excel文�g�׃��~�码问题会有损坏�Q�而且服务器的压力也太大，所以改为在Action中生成excel文�g�Q�然后下载，方便多了。由于项目的原因�Q�excel文�g是实时生成的�Q�对于jxl的��用，大家可以参考jxl相关的文章�?br /> 有什么问题可以和我联�p�R�?br /> MSN:whw_dream(AT)hotmail.com
代码如下�Q?br /> test.jsp

1<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
2<html:html>
3<html:button property="button" onclick="printAll()">
4DownLoad
5html:button>
6html:html>
7<script language='javascript'>
8function printAll(){ location.href="<%=request.getContextPath()%>/download.do"; }
9script>

DownloadAction.java

1import org.apache.struts.action.*;
2import javax.servlet.http.*;
3import java.io.OutputStream;
4import test.whw.upload.ExcelBean;
5/**
6 *

Title:DownloadAction

7 *

Description: QRRSMMS

8 *

9 *

Company: jiahansoft

10 * @author wanghw
11 * @version 1.0
12 */
13
14public class DownloadAction extends Action {
15  public ActionForward execute(ActionMapping mapping,
16                               ActionForm form,
17                               HttpServletRequest request,
18                               HttpServletResponse response)
19      throws Exception {
20    try{
21      String fname = "test";//Excel文�g�?/span>
22      OutputStream os = response.getOutputStream();//取得输出��?/span>
23      response.reset();//清空输出��?/span>
24      response.setHeader("Content-disposition", "attachment; filename=" + fname + ".xls");//讑֮�输出文�g�?/span>
25      response.setContentType("application/msexcel");//定义输出�c�d��
26      ExcelBean eb = new ExcelBean();
27      eb.expordExcel(os);//调用生成excel文�gbean
28    }catch(Exception e){
29      System.out.println(e);
30    }
31
32    return mapping.findForward("display");
33  }
34}
35

ExcelBean.java

1package test.whw.upload;
2import java.io.*;
3import jxl.*;
4import jxl.write.*;
5import jxl.format.*;
6import java.util.*;
7import java.awt.Color;
8
9public class ExcelBean {
10  public ExcelBean(){}
11  public String expordExcel(OutputStream os)throws Exception{
12    jxl.write.WritableWorkbook wbook = Workbook.createWorkbook(os); //建立excel文�g
13    String tmptitle = "��试文�g"; //标题
14    jxl.write.WritableSheet wsheet = wbook.createSheet("�W�一��?/span>", 0); //sheet名称
15    //讄��excel标题
16    jxl.write.WritableFont wfont = new jxl.write.WritableFont(
17        WritableFont.ARIAL, 16,
18        WritableFont.BOLD, false, jxl.format.UnderlineStyle.NO_UNDERLINE,
19        jxl.format.Colour.BLACK);
20    jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(
21        wfont);
22    jxl.write.Label wlabel1;
23    wlabel1 = new jxl.write.Label(5, 0, tmptitle, wcfFC);
24    wsheet.addCell(wlabel1);
25    wfont = new jxl.write.WritableFont(
26        WritableFont.ARIAL, 14,
27        WritableFont.BOLD, false, jxl.format.UnderlineStyle.NO_UNDERLINE,
28        jxl.format.Colour.BLACK);
29    wcfFC = new jxl.write.WritableCellFormat(
30        wfont);
31    jxl.write.Label wlabel;
32    wlabel = new jxl.write.Label(0, 0, "写入内容");
33    wsheet.addCell(wlabel); //
34    wbook.write(); //写入文�g
35    wbook.close();
36    os.close();
37    return "success";
38  }
39}
40

struts-config.xml

1xml version="1.0" encoding="UTF-8"?>
2DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd">
3<struts-config>
4  <action-mappings>
5    <action type="test.whw.upload.DownloadAction" path="/download">
6      <forward name="display" path="/display.jsp" />
7    action>
8  action-mappings>
9struts-config>
10

jumliang 2009-01-12 21:30 发表评论