樹結(jié)構(gòu)圖
您現(xiàn)在的位置： > 技術(shù)沙龍 > EDN系統(tǒng) > END開發(fā)文檔 > 光盤檢索導(dǎo)出數(shù)據(jù) 前 編碼轉(zhuǎn)換(UTF-8 to GBK)
- 相關(guān)軟件
>光盤檢索導(dǎo)出數(shù)據(jù) 前 編碼轉(zhuǎn)換(UTF-8 to GBK) 創(chuàng)建者：webmaster 更新時(shí)間：2006-02-20 15:49
光盤檢索導(dǎo)出數(shù)據(jù) 前 編碼轉(zhuǎn)換(UTF-8 to GBK)
環(huán)境: 數(shù)據(jù)庫: MS SQL Server 2000 排序規(guī)則名稱:Latin1_General_BIN (二進(jìn)制)
<%@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();
}
%>相關(guān)文章- 前一則: EDN 打包