Oracle10g实现把汉字转换成汉语拼音首字母
来源:互联网 发布:angularjs 数组长度 编辑:程序博客网 时间:2024/05/18 03:59
第一步、创建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
对象一样。
- Oracle10g实现把汉字转换成汉语拼音首字母
- 将汉字转换为汉语拼音java实现
- 一个sql函数,把汉字首字母转换成拼音,
- excel中把汉字转换成拼音--首字母
- 汉字转换汉语拼音
- 工具类-汉字转为汉语拼音首字母
- 汉字转换成拼音首字母
- 将汉字转换成汉语拼音的一段代码
- JS_将汉字转换成汉语拼音JS版
- 将汉字转换成汉语拼音方法,Pinyin4j入门教程
- 将汉字转换成汉语拼音的工具代码
- IOS开发把汉字转换成拼音的两种方法和返回拼音首字母
- sql函数-把汉字首字母转换为拼音
- sql函数-把汉字首字母转换为拼音
- Java_获取汉字的汉语拼音首字母Java版
- Java_获取汉字的汉语拼音首字母Java版
- 汉字姓名怎么取到姓名的汉语拼音首字母
- javascript汉字转换成首字母拼音
- 听说Google的在线演示功能上线了,作为一个Gfans自然要去捧捧场
- something we should know
- 人生哲理
- 初来乍到
- JSF自定义组件(1)
- Oracle10g实现把汉字转换成汉语拼音首字母
- 存储过程,无限级分类
- 考察ASP.NET 2.0的Membership, Roles和Profile - Part 9
- 浪淘沙
- 关于AVG anti-spyware的破解(无解)
- SMIL应用教程
- linux学习日记(1)-Linux的良好特性
- SNMP Informant How-To
- OpenNMS配置目录的位置