Eu criei uma classe para pegar os dados de uma tabela e inserir esses registros dentro da tabela no banco de dados pra isso eu ja tentei criar varias classes na verdade, bom mas essa aqui é uma das classes que eu criei:
package aguas.amazonas;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.swing.JButton;
import javax.swing.JScrollPane;
import javax.swing.table.DefaultTableModel;
public class EnviaBanco implements ActionListener{
private String Drive = "oracle.jdbc.OracleDriver";
private String URL= "endereco do banco de dados";
private String USARNAME = "usuario";
private String PASSWORD = "senha";
private Connection conn;
private JScrollPane js;
public static DefaultTableModel recebeTestec;
public static ArrayList<cliente> listacliente;
public EnviaBanco(){
try{
Class.forName(this.Drive);
this.conn = DriverManager.getConnection(URL, USARNAME, PASSWORD);
} catch (ClassNotFoundException e){
System.out.println("Não foi possivel encontrar o driver de banco: " + e.getMessage());
} catch(SQLException e){
System.out.println("Erro ao conectar com o banco: " + e.getMessage());
}
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url = "endereco do banco";
this.conn = DriverManager.getConnection (url, "usuario", "senha");
Statement st = conn.createStatement();
System.out.println("Conectado");
System.out.println("Consultando");
List listacliente = new ArrayList<cliente>(); // Lista de conjunto de clientes que vai receber o resultado da sua consulta.
clienteDepoisConsulta c = new clienteDepoisConsulta();
Principal p = new Principal();
System.out.println(c.getNome());
for (int i=0; i < Principal.table.getColumnCount(); i++){
System.out.println("teste");
String sql = "INSERT INTO SAMEA_SPC (SPC_NOME_CLIENTE,SPC_ENDERECO_CLIENTE,SPC_CPF, SPC_CGC, SPC_BAIRRO, SPC_CEP, SPC_TELEFONE, SPC_DATA_VENCIMENTO, SPC_DATA_COMPRA, SPC_VALOR_DEBITO, SPC_CODIGO_PROGRAMA, SPC_NUM_LIGACAO)"+" VALUES ('"+p.table.getColumnName(0).toString()+"',"+p.table.getColumnName(1).toString()+",'"+p.table.getColumnName(2).toString()+"',"+p.table.getColumnName(3).toString()+"',"+p.table.getColumnName(4).toString()+"',"+p.table.getColumnName(5).toString()+"',"+p.table.getColumnName(6).toString()+"',"+p.table.getColumnName(7).toString()+"',"+p.table.getColumnName(8).toString()+","+p.table.getColumnName(9).toString()+"',"+p.table.getColumnName(10).toString()+"',"+p.table.getColumnName(11).toString()+"'"; // ja tentei desse jeito e do jeito da linha abaixo
//String sql = "INSERT INTO SAMEA_SPC (SPC_NOME_CLIENTE,SPC_ENDERECO_CLIENTE,SPC_CPF, SPC_CGC, SPC_BAIRRO, SPC_CEP, SPC_TELEFONE, SPC_DATA_VENCIMENTO, SPC_DATA_COMPRA, SPC_VALOR_DEBITO, SPC_CODIGO_PROGRAMA, SPC_NUM_LIGACAO)"+" VALUES ('"+p.table.getValueAt(0,0).toString()+"',"+p.table.getValueAt(1, 1).toString()+",'"+p.table.getValueAt(2, 2).toString()+"',"+p.table.getValueAt(3, 3).toString()+"',"+p.table.getValueAt(4, 4).toString()+"',"+p.table.getValueAt(5, 5).toString()+"',"+p.table.getValueAt(6,6).toString()+"',"+p.table.getValueAt(7,7).toString()+"',"+p.table.getValueAt(8, 8).toString()+","+p.table.getValueAt(9, 9).toString()+"',"+p.table.getValueAt(10, 10).toString()+"',"+p.table.getValueAt(11,11).toString()+"'";
System.out.println("teste2");
st.executeQuery( sql );
System.out.println("teste3");
st.close();
conn.close();
// Tira todas as linhas da tabela.
}
//mensagem de erro para quando ocorrer problemas na conexao com o banco de dados
}catch(SQLException e1){
System.out.println("Erro ao conectar ao banco");
e1.printStackTrace();
}finally{ // Finalizando a conexão
System.out.println("Encerrando a conexão");
}
}
public static JButton main(String[] args) {
EnviaBanco app = new EnviaBanco();
String url = "endereco do banco";
//app.show();
return null;
}
public void actionPerformed(ActionEvent arg0) {
// TODO Auto-generated method stub
}
}
Erro ao conectar ao banco
java.sql.SQLException: ORA-00917: missing comma
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
at aguas.amazonas.EnviaBanco.<init>(EnviaBanco.java:67)
at aguas.amazonas.EnviaBanco.main(EnviaBanco.java:94)
at aguas.amazonas.Principal.actionPerformed(Principal.java:226)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Encerrando a conexão
Alguem sabe me dizer o que esta errado na minha classe por que eu não sei se é isso aqui :
st.executeQuery( sql );
que eu tenho que mandar execultar, por favor me ajudem! :oops:
