Friends the make Reegineer of My code Java occorrer the error in
qualification Connection.
My Java is ok and runing.
import java.sql.*; // pacote para trabalhar com Banco de Dados.
import java.util.*; // pacote utilitario java.
/**
* Esta classe Implementa o metodo Insert definido no arquivo
<I>Client.idl</I>.
* @see java.lang.Object
* @author Eduardo Santana de Almeida
*/
public class ServerImpl extends Clienter._ClientImplBase{
private Connection conexao; // Atributo para criar conexao com BD.
/**
* ServerImpl construtor para a classe ServerImpl. Este metodo chama o
construtor da classe pai <I>Clienter._ClientImplBase</I>.
* @param Nome do Objeto.
*/
public ServerImpl(String name){
super(name);
System.out.println("Objeto My Client Criado");
}
/**
* Realiza a Conexao com o Banco de Dados e Inseri o Registro caso nao
ocorra falha.
* @param CPF do Cliente
* @param Nome nome do Cliente
* @param Endereco do Cliente
* @param Telefone do Cliente
* @param Divida do Cliente
*/
public void Insert(String CPF,String Nome,String Endereco,String
Telefone,String Divida){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conexao =
DriverManager.getConnection("jdbc:odbc:locadora","dba","sql");
}
catch(ClassNotFoundException cnfex){
System.err.println("Falha para carregar Driver.");
cnfex.printStackTrace();
System.exit(1);
}
catch(SQLException sqlex){
System.err.println("Inabilitado para conectar.");
sqlex.printStackTrace();
}
try{
Statement statement = conexao.createStatement();
String query = "INSERT INTO
CLIENTE(CPF,Nome,Telefone,Endereco,Divida) " +
"VALUES ('" + CPF + "', '" + Nome + "', '" + Telefone
+ "', '" + Endereco + "', '" + Divida + "')";
int result = statement.executeUpdate(query);
if (result ==1)
System.out.println("\n Registro incluido com Sucesso.");
else{
System.err.println("\n Falha na Insercao.");
}
statement.close();
}
catch (SQLException sqlex){
sqlex.printStackTrace();
System.out.println(sqlex.toString());
}
}
}
Whats the problem ?
--
=============================================
Eduardo Santana de Almeida
Mestrando em Ci�ncia da Computa��o
Engenharia de Software
Universidade Federal de S�o Carlos - UFSCar
www.dc.ufscar.br/~ealmeida
=============================================
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
