Método executaSQL

6 respostas Resolvido
java
C

Ao definir o método gera erro que não estou a conseguir resolve-lo?

public void excutaSQL(String sql) throws SQLException{
   stm= (Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
   rs=stm.executeQuery(sql);
 }

6 Respostas

S

Gera qual erro?

C
error: cannot find symbol
rs = stm.executeQuery(sql);
symbol: method executeQuery(String)
location: variable stm of type Statement
1 error
import java.beans.Statement;

import java.sql.*;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;
M
public void excutaSQL(String sql) throws SQLException{
   Statement stm = (Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
   rs=stm.executeQuery(sql);
 }
C
Solucao aceita

Já descubri era o problema do import java.beans.Statement que esta a usar ao invés de import java.sql.Statement;

S

:astonished:

“ao invés”
:wink::+1:

M

:joy: :joy: :joy:

Criado 1 de fevereiro de 2017
Ultima resposta 4 de fev. de 2017
Respostas 6
Participantes 3