数据是由excel表导入到sql2000数据库中,一开始使用的是varchar,结果带问号,改为nvarchar后,在数据库中查询不带问号了,但ResultSet rst = smt.executeQuery("select * from hdfx.dbo.洪玉");
While(rst.next()) {
....
out.println("<td>" + rst.getString("otherA") + "</td>");
....
}显示还是带有问号改成
ResultSet rst = smt.executeQuery("select * from hdfx.dbo.洪玉");
String tmpStr = null;
While(rst.next()) {
....
tmpStr = new String(rst.getString("otherA").getBytes("ISO8859_1"),"utf-8");
out.println("<td>" + tmpStr + "</td>");
....
}还是同样问题。怎么解决?
While(rst.next()) {
....
out.println("<td>" + rst.getString("otherA") + "</td>");
....
}显示还是带有问号改成
ResultSet rst = smt.executeQuery("select * from hdfx.dbo.洪玉");
String tmpStr = null;
While(rst.next()) {
....
tmpStr = new String(rst.getString("otherA").getBytes("ISO8859_1"),"utf-8");
out.println("<td>" + tmpStr + "</td>");
....
}还是同样问题。怎么解决?
public static String SQLStr(String str){ if(str != null && str.length()>=1 && str.substring(0,1).equals("?")){
str = str.substring(1);
}
if(str == null || str.equals("") || str.equals(" ")){
str = " ";
}
while (str.indexOf("'") != -1) {
str = str.substring(0, str.indexOf("'")) + "<br>"
+ str.substring(str.indexOf("'") + 1);
}
return str;
}
做一个过滤方法,把 rst.getString("otherA")的值传进去!
你试试