在SYBASE下如何解决中文问题?
我的链接数据库的类如下:
/*
* DBBean.java
*
* Created on 2002年4月27日, 下午3:50
*/
package DBBean;
import java.sql.*;
import com.sybase.jdbcx.*;
import java.util.*;
public class DBBean{
public String driver_name;
public String con_url;
public String login_user;
public String login_password;
public String query_statement;
public String param[];
public ResultSet result=null;
public Connection con=null;
public PreparedStatement select_stm=null;
public void setDriverName(String driver_name){
this.driver_name=driver_name;
}
public void setConUrl(String con_url){
this.con_url=con_url;
}
public void setLoginUser(String login_user){
this.login_user=login_user;
}
public void setLoginPassword(String login_password){
this.login_password=login_password;
}
public void setQueryStatement(String query_statement){
this.query_statement=query_statement;
}
public void query_result()
{
try{
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
String url=con_url;
con = DriverManager.getConnection("jdbc:sybase:Tds:192.0.0.9:5000/finance","sa","purchasemis");
select_stm=con.prepareStatement(query_statement);
if(param!=null)
for(int i=0;i<param.length;i++)
select_stm.setString(i+1,param[i]);
result=select_stm.executeQuery();
}catch(Exception e){
}
}
public void insertDB()
{
try{
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
con = DriverManager.getConnection("jdbc:sybase:Tds:192.0.0.9:5000/finance","sa","purchasemis");
PreparedStatement select_stm=con.prepareStatement(query_statement);
if(param!=null)
for(int i=0;i<param.length;i++)
select_stm.setString(i+1,param[i]);
select_stm.executeQuery();
}catch(Exception e){
}
}
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859_1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
}
return "null";
}
public void close() throws SQLException{
if (con!=null) con.close();
if (result!=null) result.close();
if (select_stm!=null) select_stm.close();
}
/*回收资源*/
protected void finalize() throws Throwable
{
this.close();
}
}
其中的GETSTR就是转换中文的,但在SYBASE下不行。
原来在JDBC-ODBC下就可以的,一但把类写成纯JAVA链接数据库就不行了。可以告诉我为什么吗