这真怪的问题!!!大家看一下吧。跪求大师们了!!!小弟在线急!!!等待!!!!!
环境:weblogic+oracle9i+windows 2000 server
问题:其中:表里zcmc字段为字符型,在oracle +PLSQL Developer 查询得出数据为:5 (如果改为05,就能正确取出数据)
1。如果zcmc字段为一个位数值时,就发出错误(如下异常),如果用rs.getInt(1)取值就得出 为:0
2。如果zcmc字段为两位数值或两个字符串以上时,得出正确的数据
javabean代码:
public String filemc()
{
Connection con = null;
PreparedStatement ps = null;
ResultSet rs=null;
String mc="";
try
{
String strQuery="select zcmc from t_czzc_file where zcid=001";
System.out.println(strQuery);
con=ds.getConnection();
ps = con.prepareStatement(strQuery);
rs=ps.executeQuery();
if(rs.next())
{
mc=rs.String("zcmc");
System.out.println(mc);
}
}
catch(SQLException e){
e.printStackTrace();
}
finally
{
if (rs != null) try {rs.close();}
catch (SQLException ignore) {}
if (ps != null) try {ps.close();}
catch (SQLException ignore) {}
if (con != null) try {con.close();}
catch (SQLException ignore) {}
}
return mc;
}
错误:
java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken()Ljava.lang.String;(StringTokenizer.java:259)
at jsp_servlet._mofdoc._mof._zc.__zhmxlist_tt._jspService(Ljavax.servlet.http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(__zhmxlist_tt.java:197)
at weblogic.servlet.jsp.JspBase.service(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run()Ljava.lang.Object;(ServletStubImpl.java:996)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.FilterChainImpl;)V(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.FilterChainImpl;)V(ServletStubImpl.java:463)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servlet.ServletRequest;Ljavax.servlet.ServletResponse;)V(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run()Ljava.lang.Object;(WebAppServletContext.java:6452)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Lweblogic.security.subject.AbstractSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Lweblogic.security.acl.internal.AuthenticatedSubject;Lweblogic.security.acl.internal.AuthenticatedSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(Lweblogic.servlet.internal.ServletRequestImpl;Lweblogic.servlet.internal.ServletResponseImpl;)V(WebAppServletContext.java:3661)
at weblogic.servlet.internal.ServletRequestImpl.execute(Lweblogic.kernel.ExecuteThread;)V(ServletRequestImpl.java:2630)
at weblogic.kernel.ExecuteThread.execute(Lweblogic.kernel.ExecuteRequest;)V(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run()V(ExecuteThread.java:178)
at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Source)