问一个和数据库交互的问题，汉字乱码

laokaikiller

如题，我使用的数据库是Oracle，userenv('language') 是SIMPLIFIED CHINESE_CHINA.ZHS16GBK
我在vo中setwhereclause的时候想写：            
setWhereClause("user_id = " + currentUser + " and budget_item= " + "维修费");
这样会报错，请问如何解决
Exception Details.  Oracle.apps.fnd.framework.OAException: Oracle.jbo.SQLStmtException: JBO-27122: ??????? SQL ?????: SELECT BudgetAdjEO.BUDGET_ITEM,         BudgetAdjEO.DIST_ID,         BudgetAdjEO.BUDGET_AMOUNT,         BudgetAdjEO.DESCRIPTION FROM CUX_BUDGET_ADJ_TB BudgetAdjEO WHERE (User_id = 39218 and budget_item= άDT·Ñ)        at Oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)        at Oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)        at Oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(Unknown Source)        at Oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)        at Oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)        at Oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(Unknown Source)        at cust.Oracle.apps.ak.budgetadj.webui.BudgetDetailCO.processRequest(BudgetDetailCO.java:89)        at Oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)        at Oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)        at _OA._jspService(_OA.java:71)        at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)        at Oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)        at Oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)        at Oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)        at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)        at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)        at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)        at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)        at Oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)        at java.lang.Thread.run(Thread.java:595)

sumury

在Jdevelop中选择中文的java文件编译编码。

微蜘蛛

路过，应该是sql编码问题

微蜘蛛

字符的单引号每加setWhereClause("user_id = " + currentUser + " and budget_item= " + "‘维修费’");

shenen

我这边只要调用这个函数进行转换就正常了。
--====================
public class encode
{

    public encode()
    {
    }

    public static String toGBK(String s)
    {
        byte bs[] = s.getBytes();
        String b;
        try
        {
            b = new String(bs, "GBK");
        }
        catch(UnsupportedEncodingException e)
        {
            b = new String("to GBK failed");
        }
        return b;
    }
}

zero310

在JDEV 项目属性里改一下encoding试试

liutb4210

可以先从数字库中取“维修费”转化成字节
然后查询时，再将字节转化成字符串，