Pessoal estou usando o hibernate para controlar a persistência, mas para acesssa o banco e gerar os relatórios eu estou usando JDBC, alguém sabe como eu faço para usar o hibernate para isso ?
TENHO QUE POR DENTRO DA CONTROLLER O JDBC, e fica meio tosco !
# private Connection getConexao() throws SQLException, ClassNotFoundException{
Connection con = null;
try{
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:5432/nutec";
String usuario = "root";
String senha = "debian23";
con = (Connection) DriverManager.getConnection(url,usuario,senha);
}catch(SQLException sql){
System.out.println("erro ao conectar");
sql.printStackTrace();
}
return con;
}
POR ISTO:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
<property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/nutec</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">debian23</property>
<property name="hibernate.default_schema">sigi</property>
<mapping class="br.gov.nutec.to.Acesso"/>
<mapping class="br.gov.nutec.to.AcompanhamentoPd"/>
<mapping class="br.gov.nutec.to.AmostraDimat"/>
<mapping class="br.gov.nutec.to.AmostraDimee"/>
<mapping class="br.gov.nutec.to.AmostraDitalq"/>
<mapping class="br.gov.nutec.to.AmostraNit"/>
<mapping class="br.gov.nutec.to.ApresentacaoMarca"/>
<mapping class="br.gov.nutec.to.Bancos"/>
<mapping class="br.gov.nutec.to.Caixa"/>
<mapping class="br.gov.nutec.to.CaixaEntradaDivisao"/>
<mapping class="br.gov.nutec.to.CaixaEntradaSaida"/>
<mapping class="br.gov.nutec.to.Carteira"/>
<mapping class="br.gov.nutec.to.Cidade"/>
<mapping class="br.gov.nutec.to.ClienteFisica"/>
<mapping class="br.gov.nutec.to.ClienteJuridica"/>
<mapping class="br.gov.nutec.to.Clientes"/>
<mapping class="br.gov.nutec.to.ContasPagar"/>
<mapping class="br.gov.nutec.to.ContasReceber"/>
<mapping class="br.gov.nutec.to.Contrato"/>
<mapping class="br.gov.nutec.to.Cores"/>
<mapping class="br.gov.nutec.to.DadosMarca"/>
<mapping class="br.gov.nutec.to.DemandaLaboratorio"/>
<mapping class="br.gov.nutec.to.Divisoes"/>
<mapping class="br.gov.nutec.to.EntradaMaterial"/>
<mapping class="br.gov.nutec.to.Equipamentos"/>
<mapping class="br.gov.nutec.to.Especialidade"/>
<mapping class="br.gov.nutec.to.EstadoCivil"/>
<mapping class="br.gov.nutec.to.EstadoUf"/>
<mapping class="br.gov.nutec.to.FormaContato"/>
<mapping class="br.gov.nutec.to.FormaPagamento"/>
<mapping class="br.gov.nutec.to.Funcionario"/>
<mapping class="br.gov.nutec.to.Imagem"/>
<mapping class="br.gov.nutec.to.ItensNotaFiscal"/>
<mapping class="br.gov.nutec.to.ItensPedidoDespesa"/>
<mapping class="br.gov.nutec.to.Laboratorio"/>
<mapping class="br.gov.nutec.to.Laudo"/>
<mapping class="br.gov.nutec.to.LocalColetaAmostra"/>
<mapping class="br.gov.nutec.to.LogAcesso"/>
<mapping class="br.gov.nutec.to.LogAcompanhamentoPd"/>
<mapping class="br.gov.nutec.to.LogAmostraDimat"/>
<mapping class="br.gov.nutec.to.LogAmostraDimee"/>
<mapping class="br.gov.nutec.to.LogAmostraDitalq"/>
<mapping class="br.gov.nutec.to.LogAmostraNit"/>
<mapping class="br.gov.nutec.to.LogApresentacaoMarca"/>
<mapping class="br.gov.nutec.to.LogBancos"/>
<mapping class="br.gov.nutec.to.LogCaixa"/>
<mapping class="br.gov.nutec.to.LogCaixaEntradaDivisao"/>
<mapping class="br.gov.nutec.to.LogCaixaEntradaSaida"/>
<mapping class="br.gov.nutec.to.LogCarteira"/>
<mapping class="br.gov.nutec.to.LogCidade"/>
<mapping class="br.gov.nutec.to.LogClienteFisica"/>
<mapping class="br.gov.nutec.to.LogClienteJuridica"/>
<mapping class="br.gov.nutec.to.LogClientes"/>
<mapping class="br.gov.nutec.to.LogContasPagar"/>
<mapping class="br.gov.nutec.to.LogContasReceber"/>
<mapping class="br.gov.nutec.to.LogContrato"/>
<mapping class="br.gov.nutec.to.LogCores"/>
<mapping class="br.gov.nutec.to.LogDadosMarca"/>
<mapping class="br.gov.nutec.to.LogDemandaLaboratorio"/>
<mapping class="br.gov.nutec.to.LogDivisoes"/>
<mapping class="br.gov.nutec.to.LogEntradaMaterial"/>
<mapping class="br.gov.nutec.to.LogEquipamentos"/>
<mapping class="br.gov.nutec.to.LogEspecialidade"/>
<mapping class="br.gov.nutec.to.LogEstadoCivil"/>
<mapping class="br.gov.nutec.to.LogEstadoUf"/>
<mapping class="br.gov.nutec.to.LogFormaContato"/>
<mapping class="br.gov.nutec.to.LogFormaPagamento"/>
<mapping class="br.gov.nutec.to.LogFuncionario"/>
<mapping class="br.gov.nutec.to.LogImagem"/>
<mapping class="br.gov.nutec.to.LogItemsPedidoDespesa"/>
<mapping class="br.gov.nutec.to.LogItensNotaFiscal"/>
<mapping class="br.gov.nutec.to.LogLaboratorio"/>
<mapping class="br.gov.nutec.to.LogLaudo"/>
<mapping class="br.gov.nutec.to.LogLocalColetaAmostra"/>
<mapping class="br.gov.nutec.to.LogMarca"/>
<mapping class="br.gov.nutec.to.LogMedidas"/>
<mapping class="br.gov.nutec.to.LogNaturezaMarca"/>
<mapping class="br.gov.nutec.to.LogNotaFiscal"/>
<mapping class="br.gov.nutec.to.LogObservacao"/>
<mapping class="br.gov.nutec.to.LogOrigemSolicitacao"/>
<mapping class="br.gov.nutec.to.LogPagamento"/>
<mapping class="br.gov.nutec.to.LogParcela"/>
<mapping class="br.gov.nutec.to.LogPedidoDespesa"/>
<mapping class="br.gov.nutec.to.LogPessoa"/>
<mapping class="br.gov.nutec.to.LogProcessos"/>
<mapping class="br.gov.nutec.to.LogProcuracao"/>
<mapping class="br.gov.nutec.to.LogRamoAtividade"/>
<mapping class="br.gov.nutec.to.LogRequesitoServicosDimat"/>
<mapping class="br.gov.nutec.to.LogRequesitoServicosDimee"/>
<mapping class="br.gov.nutec.to.LogRequesitoServicosDitalq"/>
<mapping class="br.gov.nutec.to.LogSabor"/>
<mapping class="br.gov.nutec.to.LogServicosDimat"/>
<mapping class="br.gov.nutec.to.LogServicosDimee"/>
<mapping class="br.gov.nutec.to.LogServicosDitalq"/>
<mapping class="br.gov.nutec.to.LogSolicitacao"/>
<mapping class="br.gov.nutec.to.LogStatusSolicitacao"/>
<mapping class="br.gov.nutec.to.LogTipoAmostra"/>
<mapping class="br.gov.nutec.to.LogTipoCliente"/>
<mapping class="br.gov.nutec.to.LogTipoServico"/>
<mapping class="br.gov.nutec.to.LogUnidadeProducao"/>
<mapping class="br.gov.nutec.to.LogUsuarios"/>
<mapping class="br.gov.nutec.to.Marca"/>
<mapping class="br.gov.nutec.to.Medidas"/>
<mapping class="br.gov.nutec.to.NaturezaMarca"/>
<mapping class="br.gov.nutec.to.NotaFiscal"/>
<mapping class="br.gov.nutec.to.Observacao"/>
<mapping class="br.gov.nutec.to.OrigemSolicitacao"/>
<mapping class="br.gov.nutec.to.Pagamento"/>
<mapping class="br.gov.nutec.to.Parcela"/>
<mapping class="br.gov.nutec.to.PedidoDespesa"/>
<mapping class="br.gov.nutec.to.Pessoa"/>
<mapping class="br.gov.nutec.to.Processos"/>
<mapping class="br.gov.nutec.to.Procuracao"/>
<mapping class="br.gov.nutec.to.RamoAtividade"/>
<mapping class="br.gov.nutec.to.RequesitosServicosDimat"/>
<mapping class="br.gov.nutec.to.RequesitosServicosDimee"/>
<mapping class="br.gov.nutec.to.RequesitosServicosDitalq"/>
<mapping class="br.gov.nutec.to.Sabor"/>
<mapping class="br.gov.nutec.to.ServicosDimat"/>
<mapping class="br.gov.nutec.to.ServicosDimee"/>
<mapping class="br.gov.nutec.to.ServicosDitalq"/>
<mapping class="br.gov.nutec.to.Solicitacao"/>
<mapping class="br.gov.nutec.to.StatusSolicitacao"/>
<mapping class="br.gov.nutec.to.TipoAmostra"/>
<mapping class="br.gov.nutec.to.TipoCliente"/>
<mapping class="br.gov.nutec.to.TipoServico"/>
<mapping class="br.gov.nutec.to.UnidadeProducao"/>
<mapping class="br.gov.nutec.to.Usuario"/>
<mapping class="br.gov.nutec.to.Usuarios"/>
</session-factory>
</hibernate-configuration>
