关于安卓mysql数据库

[fkdjfkdjfkdjfk]

SELECT c.cid,c.cityid,c.cityname,
ELT(INTERVAL(CONV(HEX(LEFT(CONVERT(c.cityname USING gbk),1)),16,10),
0xb0a1,0xb0c5,0xb2c1,0xb4ee,0xb6ea,0xb7a2,0xb8c1,0xb9fe,0xbbf7,
0xbfa6,0xc0ac,0xc2e8,0xc4c3,0xc5b6,0xc5be,0xc6da,0xc8bb,0xc8f6,
0xcbfa,0xcdda,0xcef4,0xd1b9,0xd4d1),
'A','B','C','D','E','F','G','H','J','K','L','M','N','O','P',
'Q','R','S','T','W','X','Y','Z')AS PY
FROM city c ORDER BY c.cid

例如我很好三个字，我现在只能拿到我字的首字母，拿不到很好汉字的首字母，该如何更改代码
拿到

[s478853630]

你是不是想要得到汉字的拼音首字母，有一个专门的jar包的呀 引入这个jar包，写段代码就好了呀：

/**
	 * 获得字符串中汉字的首拼音,如果不是汉字就原样返回, 如果有符号就去掉
	 * @param src 
	 * @return String
	 * */
	public static String getFirstPinyin(String src) {
		return getFirstPy(src).replaceAll("[^a-z0-9]+", "");
	}
	
	/**
	 * 获得字符串中汉字的首拼音,如果不是汉字就原样返回, 保留符号
	 * @param src 
	 * @return String
	 * */
	public static String getFirstPy(String src) {
		if (isBlank(src)) {return "";}
		char[] t1 = null;
		t1 = src.toCharArray();
		String[] t2 = new String[t1.length];
		HanyuPinyinOutputFormat t3 = new HanyuPinyinOutputFormat();
		t3.setCaseType(HanyuPinyinCaseType.LOWERCASE);
		t3.setToneType(HanyuPinyinToneType.WITHOUT_TONE);
		t3.setVCharType(HanyuPinyinVCharType.WITH_V);
		String t4 = "";
		int t0 = t1.length;
		try {
			for (int i = 0; i < t0; i++) {
				// 判断是否为汉字字符
				if (Character.toString(t1[i]).matches("[\\u4E00-\\u9FA5]+")) {
					t2 = PinyinHelper.toHanyuPinyinStringArray(t1[i], t3);
					t4 += t2[0].substring(0, 1);
				} else {
					t4 += Character.toString(t1[i]);
				}
			}
		} catch (BadHanyuPinyinOutputFormatCombination e1) {
			log.error("获得字符串中汉字的首拼音", e1);
		}
		return t4;
	}
	
	/**
	 * 获得字符串中汉字的全拼,如果不是汉字就原样返回
	 * @param src 
	 * @return String
	 * */
	public static String getFullPinyin(String src) {
		if (isBlank(src)) {return "";}
		char[] t1 = null;
		t1 = src.toCharArray();
		String[] t2 = new String[t1.length];
		HanyuPinyinOutputFormat t3 = new HanyuPinyinOutputFormat();
		t3.setCaseType(HanyuPinyinCaseType.LOWERCASE);
		t3.setToneType(HanyuPinyinToneType.WITHOUT_TONE);
		t3.setVCharType(HanyuPinyinVCharType.WITH_V);
		String t4 = "";
		int t0 = t1.length;
		try {
			for (int i = 0; i < t0; i++) {
				// 判断是否为汉字字符
				if (Character.toString(t1[i]).matches("[\\u4E00-\\u9FA5]+")) {
					t2 = PinyinHelper.toHanyuPinyinStringArray(t1[i], t3);
					t4 += t2[0];
				} else {
					t4 += Character.toString(t1[i]);
				}
			}
		} catch (BadHanyuPinyinOutputFormatCombination e1) {
			log.error("获得字符串中汉字的全拼", e1);
		}
		return t4.replaceAll("[^a-z0-9]+", "");
	}

[s478853630]

import net.sourceforge.pinyin4j.PinyinHelper;
import net.sourceforge.pinyin4j.format.HanyuPinyinCaseType;
import net.sourceforge.pinyin4j.format.HanyuPinyinOutputFormat;
import net.sourceforge.pinyin4j.format.HanyuPinyinToneType;
import net.sourceforge.pinyin4j.format.HanyuPinyinVCharType;
import net.sourceforge.pinyin4j.format.exception.BadHanyuPinyinOutputFormatCombination;

[u013568162]

这丫头厉害。。