问征夫以前路
感谢所有关心过支持过我的人, 感谢所有恨过我嘲笑过我的人 !
posts - 23,comments - 65,trackbacks - 0

          textarea中特殊字符回车换行存入数据库丢失数据的问题已解决,现把解决方法昭告天下:)
          解决这两类问题的时候,必不可少的就是要有一个java类。
         

  1/*
  2 * Escape.java
  3 *
  4 * Created on 2007年11月19日, 下午1:41
  5 *
  6 * To change this template, choose Tools | Template Manager
  7 * and open the template in the editor.
  8 */

  9
 10package com.bjnni.cims.common;
 11
 12/**
 13 * 处理特殊字符,如:(!@#$%^&*=)的编码和解码类
 14 * @author ken  <zhanghhui@126.com>
 15 */

 16public class Escape {
 17    private final static String[] hex = {
 18        "00","01","02","03","04","05","06","07","08","09","0A","0B","0C","0D","0E","0F",
 19        "10","11","12","13","14","15","16","17","18","19","1A","1B","1C","1D","1E","1F",
 20        "20","21","22","23","24","25","26","27","28","29","2A","2B","2C","2D","2E","2F",
 21        "30","31","32","33","34","35","36","37","38","39","3A","3B","3C","3D","3E","3F",
 22        "40","41","42","43","44","45","46","47","48","49","4A","4B","4C","4D","4E","4F",
 23        "50","51","52","53","54","55","56","57","58","59","5A","5B","5C","5D","5E","5F",
 24        "60","61","62","63","64","65","66","67","68","69","6A","6B","6C","6D","6E","6F",
 25        "70","71","72","73","74","75","76","77","78","79","7A","7B","7C","7D","7E","7F",
 26        "80","81","82","83","84","85","86","87","88","89","8A","8B","8C","8D","8E","8F",
 27        "90","91","92","93","94","95","96","97","98","99","9A","9B","9C","9D","9E","9F",
 28        "A0","A1","A2","A3","A4","A5","A6","A7","A8","A9","AA","AB","AC","AD","AE","AF",
 29        "B0","B1","B2","B3","B4","B5","B6","B7","B8","B9","BA","BB","BC","BD","BE","BF",
 30        "C0","C1","C2","C3","C4","C5","C6","C7","C8","C9","CA","CB","CC","CD","CE","CF",
 31        "D0","D1","D2","D3","D4","D5","D6","D7","D8","D9","DA","DB","DC","DD","DE","DF",
 32        "E0","E1","E2","E3","E4","E5","E6","E7","E8","E9","EA","EB","EC","ED","EE","EF",
 33        "F0","F1","F2","F3","F4","F5","F6","F7","F8","F9","FA","FB","FC","FD","FE","FF"
 34    }
;
 35    private final static byte[] val = {
 36        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 37        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 38        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 39        0x00,0x01,0x02,0x03,0x04,0x05,0x06,0x07,0x08,0x09,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 40        0x3F,0x0A,0x0B,0x0C,0x0D,0x0E,0x0F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 41        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 42        0x3F,0x0A,0x0B,0x0C,0x0D,0x0E,0x0F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 43        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 44        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 45        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 46        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 47        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 48        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 49        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 50        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,
 51        0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F,0x3F
 52    }
;
 53    public static String escape(String s) {
 54        StringBuffer sbuf = new StringBuffer();
 55        int len = s.length();
 56        for (int i = 0; i < len; i++{
 57            int ch = s.charAt(i);
 58            if (ch == ' '{                        // space : map to '+'
 59                sbuf.append('+');
 60            }
 else if ('A' <= ch && ch <= 'Z'{    // 'A'..'Z' : as it was
 61                sbuf.append((char)ch);
 62            }
 else if ('a' <= ch && ch <= 'z'{    // 'a'..'z' : as it was
 63                sbuf.append((char)ch);
 64            }
 else if ('0' <= ch && ch <= '9'{    // '0'..'9' : as it was
 65                sbuf.append((char)ch);
 66            }
 else if (ch == '-' || ch == '_'       // unreserved : as it was
 67                    || ch == '.' || ch == '!'
 68                    || ch == '~' || ch == '*'
 69                    || ch == '\'' || ch == '('
 70                    || ch == ')'{
 71                sbuf.append((char)ch);
 72            }
 else if (ch <= 0x007F{              // other ASCII : map to %XX
 73                sbuf.append('%');
 74                sbuf.append(hex[ch]);
 75            }
 else {                                // unicode : map to %uXXXX
 76                sbuf.append('%');
 77                sbuf.append('u');
 78                sbuf.append(hex[(ch >>> 8)]);
 79                sbuf.append(hex[(0x00FF & ch)]);
 80            }

 81        }

 82        return sbuf.toString();
 83    }

 84    public static String unescape(String s) {
 85        StringBuffer sbuf = new StringBuffer();
 86        int i = 0;
 87        int len = s.length();
 88        while (i < len) {
 89            int ch = s.charAt(i);
 90            if (ch == '+'{                        // + : map to ' '
 91                sbuf.append(' ');
 92            }
 else if ('A' <= ch && ch <=