Oracle10g实现把汉字转换成汉语拼音首字母

原创 2007年09月19日 18:36:00

第一步、创建java源

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "HZ2PY"
AS public class HZ2PY {
    public static int compare(String str1, String str2)
     {
         int result = 0;
         String m_s1 = null;
         String m_s2 = null;
         try
         {
             m_s1 = new String(str1.getBytes(_FromEncode_), _ToEncode_);
             m_s2 = new String(str2.getBytes(_FromEncode_), _ToEncode_);
         }
         catch(Exception e)
         {
             return str1.compareTo(str2);
         }
         result = chineseCompareTo(m_s1, m_s2);
         return result;
     }
     public static int getCharCode(String s)
     {
         if(s == null && s.equals(""))
             return -1;
         byte b[] = s.getBytes();
         int value = 0;
         for(int i = 0; i < b.length && i <= 2; i++)
             value = value * 100 + b[i];
         return value;
     }
     public static int chineseCompareTo(String s1, String s2)
     {
         int len1 = s1.length();
         int len2 = s2.length();
         int n = Math.min(len1, len2);
         for(int i = 0; i < n; i++)
         {
             int s1_code = getCharCode(s1.charAt(i) + "");
             int s2_code = getCharCode(s2.charAt(i) + "");
             if(s1_code * s2_code < 0)
                 return Math.min(s1_code, s2_code);
             if(s1_code != s2_code)
                 return s1_code - s2_code;
         }
         return len1 - len2;
     }
    
    
     public static String getBeginCharacter(String res)
     {
         String a = res;
         String result = "";
         for(int i = 0; i < a.length(); i++)
         {
             String current = a.substring(i, i + 1);
             if(compare(current, "/u554A") < 0)
                 result = result + current;
             else
             if(compare(current, "/u554A") >= 0 && compare(current, "/u5EA7") <= 0)
                 if(compare(current, "/u531D") >= 0)
                     result = result + "z";
                 else
                 if(compare(current, "/u538B") >= 0)
                     result = result + "y";
                 else
                 if(compare(current, "/u6614") >= 0)
                     result = result + "x";
                 else
                 if(compare(current, "/u6316") >= 0)
                     result = result + "w";
                 else
                 if(compare(current, "/u584C") >= 0)
                     result = result + "t";
                 else
                 if(compare(current, "/u6492") >= 0)
                     result = result + "s";
                 else
                 if(compare(current, "/u7136") >= 0)
                     result = result + "r";
                 else
                 if(compare(current, "/u671F") >= 0)
                     result = result + "q";
                 else
                 if(compare(current, "/u556A") >= 0)
                     result = result + "p";
                 else
                 if(compare(current, "/u54E6") >= 0)
                     result = result + "o";
                 else
                 if(compare(current, "/u62FF") >= 0)
                     result = result + "n";
                 else
                 if(compare(current, "/u5988") >= 0)
                     result = result + "m";
                 else
                 if(compare(current, "/u5783") >= 0)
                     result = result + "l";
                 else
                 if(compare(current, "/u5580") >= 0)
                     result = result + "k";
                 else
                 if(compare(current, "/u51FB") > 0)
                     result = result + "j";
                 else
                 if(compare(current, "/u54C8") >= 0)
                     result = result + "h";
                 else
                 if(compare(current, "/u5676") >= 0)
                     result = result + "g";
                 else
                 if(compare(current, "/u53D1") >= 0)
                     result = result + "f";
                 else
                 if(compare(current, "/u86FE") >= 0)
                     result = result + "e";
                 else
                 if(compare(current, "/u642D") >= 0)
                     result = result + "d";
                 else
                 if(compare(current, "/u64E6") >= 0)
                     result = result + "c";
                 else
                 if(compare(current, "/u82AD") >= 0)
                     result = result + "b";
                 else
                 if(compare(current, "/u554A") >= 0)
                     result = result + "a";
         }

         return result;
     }
    
     private static String _FromEncode_ = "GBK";
     private static String _ToEncode_ = "GBK";
    
    
    
}
/

第二步、创建函数使用java类

CREATE OR REPLACE
function F_HZ2PY(name varchar2) return varchar2
as language java name 
'HZ2PY.getBeginCharacter(java.lang.String) return java.lang.String';
/


select f_hz2py('美国鬼子,小日本') from dual;

返回mggz,xrb

 以上给出了扩展Oracle自身提供功能的一种方法。同行们可以把Java类转化为函数函数,供PL/SQL调用。

Java源被Oracle8i以上版本支持。Oracle8i以上版本,可以把Java源看作View、Proc、Table等对Oracle

对象一样。

 

根据汉字的首字母转换成拼音(oracle)

--创建函数 create function fun_getPY(@str nvarchar(4000)) returns nvarchar(4000) as begin declare @w...

c#将中文转换成拼音,以空格隔开,全拼,获取汉字首字母,PinyinHelper

将中文转换成拼音: 。支持以空格隔开 。支持全拼 。支持获取汉字首字母 using System; using System.Collections.Generic; using System.Tex...
  • dhfekl
  • dhfekl
  • 2013年09月01日 15:54
  • 1855

汉字转换成拼音和获取汉字的首字母及ASSCI码的转换

注意:首先下载pinyin4j-2.5.0.jar 并导入; public class HzToPinyin { public static String getPingYin(Strin...

将汉字转换成汉语拼音的工具代码

这个代码是在上家公司做项目时使用到的, 现在的一个同事要完成类似这样的功能, 所以整理出来, 其实这个是可以在网上找到的, 不知原作者是谁, 如果有不妥之处, 请见谅, 都是为了项目吗! packa...
  • wxcking
  • wxcking
  • 2012年04月17日 13:30
  • 1780

java将汉字转换成汉语拼音(pinyin4j.jar的使用及原理)

一、思路介绍 见汉字的unicode码和汉语拼音对应,这也是pinyin4j的思路 二、pinyin4j介绍 pinyin4j是sourceforge.net上的一个开源项目,用来处理讲中文转换成...

Oracle 10g如何对用户姓名,按首字母排序、查询

首先介绍Oracle 9i新增加的一个系统自带的排序函数  1、按首字母排序  在oracle9i中新增了按照拼音、部首、笔画排序功能。设置NLS_SORT值      SCHINESE_RAD...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Oracle10g实现把汉字转换成汉语拼音首字母
举报原因:
原因补充:

(最多只允许输入30个字)