getString(int columnIndex)
Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
不是指你的那个字段
Gets the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.
不是指你的那个字段
对不起,我不理解。
String a="";
String b="";
try
{
rset=stmt.executeQuery(sStatement);
while(rset.next())
{
a="";
b="";
//a=rset.getString("name");
//b=rset.getString("address");
a=rset.getString(2);
b=rset.getString(3); System.out.print(rset.getInt("int"));
System.out.print(",");
System.out.print(a);
System.out.print("(");
System.out.print(a.length());
System.out.print("),");
System.out.print(b);
System.out.print("(");
System.out.print(b.length());
System.out.println(")");
}
}
catch(SQLException e)
{
return false;
}
结果:
5,abcde (15),1234567890(10)
“int”字段是NUMBER(38),“name”字段是CHAR(5),“address”字段是VARCHAR2(10)。
我刚学java不久,请多指教
能不能说得更清楚一些
另外,将a=rset.getString(2);b=rset.getString(3);中的2和3全部换成对应字段的字段名
其它字段的字段名最好也给出,以便分析,我及其怀疑你取错了字段
==============================
在下所说,也许并非正确,请从建议的角度批判地吸收!
create table mytest (int number(38),name char(5),address varchar2(10))
显示:
SQL> desc mytest;
名称 空? 类型
----------------------------------------- -------- ----------------------------
INT NUMBER(38)
NAME CHAR(5)
ADDRESS VARCHAR2(10)
我的程序:
插入语句:
INSERT INTO mytest (int,name,address) VALUES (5,'ABCDE','1234567890')
显示语句:
String sStatement="SELECT * FROM mytest";
String a="";
String b="";
try
{
rset=stmt.executeQuery(sStatement);
while(rset.next())
{
a="";
b="";
a=rset.getString("name");
b=rset.getString("address");
System.out.print(rset.getInt("int"));
System.out.print(",");
System.out.print(a);
System.out.print("(");
System.out.print(a.length());
System.out.print("),");
System.out.print(b);
System.out.print("(");
System.out.print(b.length());
System.out.println(")");
}
}
catch(SQLException e)
{
return false;
}
结果显示:
5,ABCDE (15),1234567890(10)