UC知道java 数据库 为什么getString(Cid)这句不行
来源：百度知道 编辑：UC知道 时间：2024/06/19 15:58:02
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bank","moon1986","123456");
Statement stmt =con.createStatement();
String sql1="use bank select * from custminf where CFid='"+getid+"'";
String sql2="select * from custmfund where CFid='"+getid+"'";
ResultSet result1= stmt.executeQuery(sql1);
ResultSet result2= stmt.executeQuery(sql2);
String a=new String();
a=result1.getString(Cid);
//show.append(getString(Cid));
result1.close();
result2.close();
stmt.close();
con.close();
}catch(Exception fd){fd.printStackTrace();};
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bank","moon1986","123456");
Statement stmt =con.createStatement();
String sql1="use bank select * from custminf where CFid='"+getid+"'";
String sql2="select * from custmfund where CFid='"+getid+"'";
ResultSet result1= stmt.executeQuery(sql1);
ResultSet result2= stmt.executeQuery(sql2);
String a=new String();
a=result1.getString(Cid);
//show.append(getString(Cid));
result1.close();
result2.close();
stmt.close();
con.close();
}catch(Exception fd){fd.printStackTrace();};
String a=new String();
a=result1.getString(Cid);
应该是这里出错了!
这里要对ResultSet的结果集合进行遍历结果!
while(result1.next){
system.out.println(result1.getsting(str));
}
这样应该就可以了!
如果Cid是字段名 则因该是a=result1.getString("Cid");前面还要有一句result1.next();
需要result1.next();
缺少集合遍历，另外String a=new String();这句虽然对，但是不赞成这样用，只要String a=""，就可以。
首先,楼主需要
while(result1.next()){
..........
}
其次result1.getString(Cid)
这里的getString(Cid)应该是getString("Cid")