getString(int) in java.sql.ResultSet cannot be applied to (java.lang.String)的错误
下面是一个JAVA片段:
String strsql="";
String strOrderNo="";
String strProjectDesc="";
String strItemNo="";
String strItemDesc="";
strsql = " SELECT C6CVNB,C6AAYC ,ITNBR, ITDSC form MBC6REP order by c6cvnb ";
rs =dbconn.executeQuery(strsql);
if (rs.next())
{
strOrderNo=rs.getString("C6CVNB");
strProjectDesc=rs.getString("C6AAYC");
strItemNo=rs.getString("ITNBR");
strItemDesc=rs.getString("ITDSC");
}
dbconn.CloseConn();
--------------------------------
在Jbuilder 9下Make后出现如下错误:
getString(int) in java.sql.ResultSet cannot be applied to (java.lang.String) at line 92, column 27,也就是说:
strOrderNo=rs.getString("C6CVNB");
strProjectDesc=rs.getString("C6AAYC");
strItemNo=rs.getString("ITNBR");
strItemDesc=rs.getString("ITDSC");
这四行都出错了,但如果改为
strOrderNo=rs.getString(1);
strProjectDesc=rs.getString(2);
strItemNo=rs.getString(3);
strItemDesc=rs.getString(4);
就没问题,这是怎么回事?