Pessoal estou fazendo uns testes mais nao esta dando certo:
Minha Entidade de Usuarios do Sistema:
public class EntUs_Usuarios implements Serializable {
private static final long serialVersionUID = 1L;
private Integer usu_codigo;
private String usu_nome;
private String usu_senha;
private String usu_login;
private Date usu_dtcadastro;
private Date usu_dtalteracao;
private EntUs_Nivel usu_cod_nivel;
public EntUs_Usuarios(){
}
Minha Entidade de Nivel de Acesso de Usuarios do Sistema.
public class EntUs_Nivel implements Serializable {
private static final long serialVersionUID = 1L;
private Integer niv_codigo;
private String niv_descricao;
public EntUs_Nivel(){
}
Meu Dao Generico :
public abstract class GenericDAO {
private static final long serialVersionUID = 1L;
// Metodo Utilizado para a Conexao com a Base de Dados.
public Connection getConnection(){
try
{
Class.forName("org.postgresql.Driver");
Connection cx = DriverManager.getConnection("jdbc:postgresql://localhost:5432/DBTimerSheet","postgres", "adm");
return cx;
} catch(Exception Ex)
{
JOptionPane.showMessageDialog(null, "Erro ao Conectar o Banco de Dados /n " + Ex);
Ex.printStackTrace();
return null;
}
}
public Statement getStatement() throws SQLException{
return getConnection().createStatement();
}
public PreparedStatement getStatement(String st) throws SQLException{
return getConnection().prepareStatement(st);
}
public ResultSet executeQuery(String query, Object ... params) throws SQLException{
PreparedStatement ps = getStatement(query);
for(int i = 0; i < params.length; i++){
ps.setObject(i+1, params[i]);
}
return ps.executeQuery();
}
public int executeCommand(String query, Object... params) throws SQLException{
PreparedStatement ps = getStatement(query);
for(int i = 0; i < params.length; i++){
ps.setObject(i+1, params[i]);
}
int result = ps.executeUpdate();
ps.close();
return result;
}
public Integer getNextId(String tableName, String coluna) throws SQLException{
ResultSet rs = executeQuery("select MAX(" + coluna + ") from " + tableName);
rs.next();
Object result = rs.getObject(1);
if(result == null){
rs.close();
return 1;
}else {
return ((Integer) result )+ 1;
}
}
}
Ao Salvar os Dados em um botal esta dando o seguinte Erro :
run:
org.postgresql.util.PSQLException: ERROR: relation "usu_usuarios" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at com.TimeSheet.DAOs.GenericDAO.executeQuery(GenericDAO.java:65)
at com.TimeSheet.DAOs.GenericDAO.getNextId(GenericDAO.java:85)
at com.TimeSheet.DAOs.us_UsuariosDAO.IncluiUsuario(us_UsuariosDAO.java:45)
at com.TimeSheet.Formularios.FCadUsuarios.jButton2ActionPerformed(FCadUsuarios.java:232)
at com.TimeSheet.Formularios.FCadUsuarios.access$100(FCadUsuarios.java:22)
at com.TimeSheet.Formularios.FCadUsuarios$2.actionPerformed(FCadUsuarios.java:109)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6504)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
at java.awt.Component.processEvent(Component.java:6269)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4860)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4686)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2713)
at java.awt.Component.dispatchEvent(Component.java:4686)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
at java.awt.EventQueue.access$000(EventQueue.java:101)
at java.awt.EventQueue$3.run(EventQueue.java:666)
at java.awt.EventQueue$3.run(EventQueue.java:664)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:680)
at java.awt.EventQueue$4.run(EventQueue.java:678)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
BUILD SUCCESSFUL (total time: 31 seconds)
Onde esta o Erro pessoal ?
Agradeco a Todos pela ajuda um Forte Abraco.
