//查询单词
public void query()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e)
{
tfAnswer.setText("sun.jdbc.odbc.JdbcOdbcDriver not found!\n");
}
catch(LinkageError e){
tfAnswer.setText("sun.jdbc.odbc.JdbcOdbcDriver not found!\n");
}
try
{
connect = DriverManager.getConnection("jdbc:odbc:words");
sql = connect.createStatement();
}
catch (SQLException e)
{
tfAnswer.setText("SQLException when open!\n");
}
try
{
String word = (tfAnswer.getText()).trim();
rset = sql.executeQuery("SELECT * FROM words WHERE english='" + word.toLowerCase() + "'");
if (rset.next())
{
tfAnswer.setText(rset.getString(1) + " : " + rset.getString(2) + "\n");
}
else
{
tfAnswer.setText(word + " is not found!\n");
}
connect.close();
}
catch (SQLException e)
{
tfAnswer.setText("SQLException when query!\n");
}
}
可是执行到Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
就不执行了
我是调用if(e.target==bEnter){
query();
}
怎么回事呀
还请高手赐教;不胜感激
public void query()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e)
{
tfAnswer.setText("sun.jdbc.odbc.JdbcOdbcDriver not found!\n");
}
catch(LinkageError e){
tfAnswer.setText("sun.jdbc.odbc.JdbcOdbcDriver not found!\n");
}
try
{
connect = DriverManager.getConnection("jdbc:odbc:words");
sql = connect.createStatement();
}
catch (SQLException e)
{
tfAnswer.setText("SQLException when open!\n");
}
try
{
String word = (tfAnswer.getText()).trim();
rset = sql.executeQuery("SELECT * FROM words WHERE english='" + word.toLowerCase() + "'");
if (rset.next())
{
tfAnswer.setText(rset.getString(1) + " : " + rset.getString(2) + "\n");
}
else
{
tfAnswer.setText(word + " is not found!\n");
}
connect.close();
}
catch (SQLException e)
{
tfAnswer.setText("SQLException when query!\n");
}
}
可是执行到Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
就不执行了
我是调用if(e.target==bEnter){
query();
}
怎么回事呀
还请高手赐教;不胜感激
或者ODBC数据源配置好了么
你应该是用odbc来连接数据库的吧?
数据源呢?