请教各位高手,我在sql server 2000里的表中有一binary类型的字段,现想读取出来,可读出来时,只有txt文件是正常显示的,其它文件,如word则显示乱码。请问该怎么处理?
(小弟分少,所以只能给这么多,抱歉!)
我的java代码如下:String sql = "select filebody from index_test where id ='9'";
String result = null;
try {
pstmt = conn.prepareStatement(sql);
} catch (SQLException e) {
System.err.println(e.getMessage());
}
try {
rs = pstmt.executeQuery();
} catch (SQLException e) {
System.err.println(e.getMessage());
}
try {
while(rs.next())
{
byte[] content = rs.getBytes(1);
BufferedReader br = new BufferedReader(new InputStreamReader(
new ByteArrayInputStream(content)));
try {
while((result = br.readLine())!=null)
{
System.out.println(result.toString());
}
} catch (IOException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
rs.close();
pstmt.close();
conn.close();
} catch (SQLException e) {
System.err.println(e.getMessage());
}
(小弟分少,所以只能给这么多,抱歉!)
我的java代码如下:String sql = "select filebody from index_test where id ='9'";
String result = null;
try {
pstmt = conn.prepareStatement(sql);
} catch (SQLException e) {
System.err.println(e.getMessage());
}
try {
rs = pstmt.executeQuery();
} catch (SQLException e) {
System.err.println(e.getMessage());
}
try {
while(rs.next())
{
byte[] content = rs.getBytes(1);
BufferedReader br = new BufferedReader(new InputStreamReader(
new ByteArrayInputStream(content)));
try {
while((result = br.readLine())!=null)
{
System.out.println(result.toString());
}
} catch (IOException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
rs.close();
pstmt.close();
conn.close();
} catch (SQLException e) {
System.err.println(e.getMessage());
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货