17,382
社区成员




try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (ClassNotFoundException e1)
{
e1.printStackTrace();
}
Connection connection = null;
try
{
connection = DriverManager
.getConnection("jdbc:oracle:thin:@192.168.1.147:1521:orcl",
"dbo", "sql2k");
String sql = "select * from item where id=125";
PreparedStatement ps = connection.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while (rs.next())
{
String name =rs.getString("name");
String[] namearray = name.split("\\\\");
String result = "";
if (namearray != null && namearray.length > 0)
{
for (String str : namearray)
{
if (str != null && !"".equals(str.trim()))
{
int sum=0;
if (str.length() <= 4)// 英文字符
{
str=str.substring(1);
sum+=Integer.parseInt(str, 16);
result+=Character.toString((char)sum);
}
else
{// 中文字符
result += decodeUnicode("\\" + str);
}
}
}
}
System.out.println(result);
}
}
catch (Exception e1)
{
// TODO Auto-generated catch block
e1.printStackTrace();
}