try
{
connect1 = DriverManager.getConnection("jdbc:odbc:words");
sql1 = connect1.createStatement();
long i=(int)Math.random()*8845;
rset1 = sql1.executeQuery("SELECT * FROM words where number=i");
while(rset1.next())
tfAnswer.setText(rset1.getString(3));
}catch (SQLException e)
{
tfAnswer.setText("SQLException when open!\n");
}怎么不能正确执行呀
出异常了rset1 = sql1.executeQuery("SELECT * FROM words where number=i");
就这条语句不知道弄了number=i就不对呢
{
connect1 = DriverManager.getConnection("jdbc:odbc:words");
sql1 = connect1.createStatement();
long i=(int)Math.random()*8845;
rset1 = sql1.executeQuery("SELECT * FROM words where number=i");
while(rset1.next())
tfAnswer.setText(rset1.getString(3));
}catch (SQLException e)
{
tfAnswer.setText("SQLException when open!\n");
}怎么不能正确执行呀
出异常了rset1 = sql1.executeQuery("SELECT * FROM words where number=i");
就这条语句不知道弄了number=i就不对呢
rset1 = sql1.executeQuery("SELECT * FROM words where number="+i);
NUMBER是LONG型的呀
rset1 = sql1.executeQuery("SELECT * FROM words where number="+i+");
后面少了个冒号