您现在的位置： > 技术沙龙 > EDN系统 > END开发文档 > 光盘检索导出数据 前 编码转换(UTF-8 to GBK)
- 相关软件
>光盘检索导出数据 前 编码转换(UTF-8 to GBK) 创建者：webmaster 更新时间：2006-02-20 15:49
光盘检索导出数据 前 编码转换(UTF-8 to GBK)
环境: 数据库: MS SQL Server 2000 排序规则名称:Latin1_General_BIN (二进制)
<%@page contentType="text/html;charset=UTF-8" %>
<%!
public String ec(String str)throws java.io.UnsupportedEncodingException
{
return new String(new String(str.getBytes("ISO-8859-1"), "UTF-8").getBytes("GBK"), "ISO-8859-1");
}
%>
<%
tea.db.DbAdapter dbadapter=new tea.db.DbAdapter();
tea.db.DbAdapter dbadapter2=new tea.db.DbAdapter();
try
{
dbadapter.executeQuery("SELECT Node.node ,NodeLayer.language,subject,keywords,text "+
" FROM Node,NodeLayer,Report "+
" WHERE Node.node=NodeLayer.node AND Node.node=Report.node AND Node.type=39 AND Node.community = 'cnoocinfo' "+
" AND (Report.issuetime >= CONVERT(DATETIME, '2005-01-01 00:00:00', 102)) "+
" AND (dbo.Report.issuetime <= CONVERT(DATETIME, '2005-12-31 00:00:00', 102))");
while(dbadapter.next())
{
int node=dbadapter.getInt(1);
int language=dbadapter.getInt(2);
String subject=ec(dbadapter.getString(3));
String keywords=ec(dbadapter.getString(4));
String text=ec(dbadapter.getString(5));
dbadapter2.executeUpdate("UPDATE NodeLayer SET subject="+dbadapter.cite(subject)+
",keywords="+dbadapter.cite(keywords)+",text="+dbadapter.cite(text)+" WHERE node="+node+" AND language="+language);
System.out.println(node);
}
}catch(Exception e)
{
e.printStackTrace();
}finally
{
dbadapter.close();
dbadapter2.close();
}
%>相关文章- 前一则: EDN 打包