Fejl i sql? why?
jeg får denne fejljava.sql.SQLException: [Microsoft][ODBC Microsoft Access-driver]Deskriptorindekset er ugyldigt.
I denne kode
private void jButton2_actionPerformed(ActionEvent e)
{
try
{
String key = jTextField1.getText();
String indhold = "Søge resultater for " + key + "\n\n\n*******************************\n\n";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection("jdbc:odbc:;Driver={Microsoft Access Driver (*.mdb)};Dbq=c://database.mdb");
Statement statement = connection.createStatement();
String query = "Select dkord From ord WHERE dkord = 'hund' ";
//String query = "Select dkord, abord From ord WHERE dkord = '"+key+"' ";
ResultSet result = statement.executeQuery(query);
while(result.next())
{
indhold += result.getString(2) + "\n*****************************\n";
}
if(indhold.equalsIgnoreCase("Søge resultater for " + key + "\n\n\n*******************************\n\n"))
jTextArea3.setText("Der blev ikke fundet noget");
else
jTextArea3.setText(indhold);
} catch(Exception ax)
{
jTextArea3.setText(ax.toString());
}
}
