Java开发网 - 请教:数据库查询-非法游标(在线等待)

Topic: 请教:数据库查询-非法游标(在线等待)

1.请教:数据库查询-非法游标(在线等待)

Posted by: ruijie_zhao
Posted on: 2005-10-09 21:59

stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY );
rs = stmt.executeQuery("select * from information where 姓名 like '*a*'" );
rs.first() ;
System.out.print(rs.getString("姓名")) ;

我用的是ACCESS数据库
,当运行模糊查询的时候,提示错误: [Microsoft][ODBC 驱动程序管理器] 非法的游标状态，这段代码如果不是LIKE,而是等号就没有问题
请高手帮帮忙

2.Re:请教:数据库查询-非法游标(在线等待) [Re: ruijie_zhao]	Copy to clipboard
Posted by: why Posted on: 2005-10-09 23:45 rs.first() ; // what is this for? Think about the case when no row is returned Which version of M$ Access are you using, please check whether * is used as wildcard.