Caros amigos,
Sei que deve ser algo bem fácil pra vcs, porém estou iniciando e tenho dificuldades…
Estou tentando gravar uma data no banco de dados e está dando o seguinte erro…
“j_id_jsp_1280720231_1:j_id_jsp_1280720231_8: An error occurred when processing your submitted information”
então fiz o teste com Junit e funcionou enviando a data do sistema, fui no meu banco e modifiquei a propriedade do meu atributo com date, deixei ele como não requerido, então o Dao faz a inserção sem problemas…
Aqui vão meus códigos veja se alguém me ajuda!!!
MeuBean:
public class NotaFiscal implements Serializable {
private static final long serialVersionUID =1L;
private Integer nota_id;
private Integer nota_serie;
private Date nota_dt_emissao;
private Fornecedor forn_id;
...
MeuDao:
public class NotaFiscalDao extends DataUtil {
private static final long serialVersionUID = 1L;
private FornecedorDao forn = new FornecedorDao();
public NotaFiscalDao() {
super();
}
public boolean add(NotaFiscal nota) throws ClassNotFoundException, SQLException {
PreparedStatement ps = getPreparedStatement("INSERT INTO " +
" gerenciamento.nota_fiscal(nota_id, nota_serie, nota_dt_emissao, forn_id) "+
" VALUES (?,?,?,?);");
ps.setInt(1, nota.getNota_id());
ps.setInt(2, nota.getNota_serie());
ps.setDate(3,nota.getNota_dt_emissao());
ps.setInt(4, nota.getForn_id().getForn_id());
int toReturn = ps.executeUpdate();
ps.close();
return toReturn > 0;
}
private void populateNotaFiscal(NotaFiscal nota, ResultSet rs) throws SQLException, ClassNotFoundException {
nota.setNota_id(rs.getInt("nota_id"));
nota.setNota_serie(rs.getInt("nota_serie"));
nota.setNota_dt_emissao(rs.getDate("nota_dt_emissao"));
nota.setForn_id(forn.getById(rs.getInt("forn_id")));
}
public boolean set(NotaFiscal nota) throws ClassNotFoundException, SQLException {
PreparedStatement ps = getPreparedStatement(
"UPDATE gerenciamento.nota_fiscal " +
"SET nota_serie = ?, nota_dt_emissao = ?," +
"forn_id = ? " +
"WHERE nota_id = ?;");
ps.setInt(1, nota.getNota_serie());
ps.setDate(2, (Date)nota.getNota_dt_emissao());
ps.setInt(3, nota.getForn_id().getForn_id());
ps.setInt(4, nota.getNota_id());
int toReturn = ps.executeUpdate();
ps.close();
return toReturn > 0;
}
public NotaFiscal getById(int idnotafiscal) throws ClassNotFoundException, SQLException {
PreparedStatement ps = getPreparedStatement("SELECT * FROM gerenciamento.nota_fiscal where nota_id = ?;");
ps.setInt(1, idnotafiscal);
ResultSet rs = ps.executeQuery();
if (!rs.next()) {
return null;
}
NotaFiscal toReturn = new NotaFiscal();
populateNotaFiscal(toReturn, rs);
rs.close();
ps.close();
return toReturn;
}
public List<NotaFiscal> getNotaFiscal() throws ClassNotFoundException, SQLException {
{
List<NotaFiscal> toReturn = new LinkedList<NotaFiscal>();
ResultSet rs = getStatement().executeQuery("SELECT * FROM gerenciamento.nota_fiscal order by nota_id;");
while (rs.next()) {
NotaFiscal nota = new NotaFiscal();
populateNotaFiscal(nota, rs);
toReturn.add(nota);
}
return toReturn;
}
}
}
MeuBenGerenciado:
public class NotaFiscalFace {
private FornecedorDao forn = new FornecedorDao();
private NotaFiscalDao nota = new NotaFiscalDao();
private NotaFiscal selectNotaFiscal;
private List<NotaFiscal> notaFiscal;
public NotaFiscalFace() {
}
public String StartAddNotaFiscal(){
selectNotaFiscal = new NotaFiscal();
return "gotoAddNewNotaFiscal";
}
public String FinishAddNotaFiscal() throws ClassNotFoundException, SQLException{
nota.add(selectNotaFiscal);
notaFiscal = null;
return "gotoReturnInicio";
}
public List<NotaFiscal> getNotaFiscal() throws ClassNotFoundException, SQLException{
if (notaFiscal == null){
notaFiscal = nota.getNotaFiscal();
}
return notaFiscal;
}
public List<SelectItem> getFornecedor() throws ClassNotFoundException, SQLException{
List<SelectItem> toReturn = new LinkedList<SelectItem>();
for (Fornecedor forne : forn.getAllFornecedor()){
toReturn.add(new SelectItem(forne, forne.getForn_nome()));
}
return toReturn;
}
public String StartEditNotaFiscal() throws ClassNotFoundException, SQLException{
return "gotoEditNotaFiscal";
}
public String FinishEditNotaFiscal() throws ClassNotFoundException, SQLException{
nota.set(selectNotaFiscal);
notaFiscal = null;
return "gotoListNotaFiscal";
}
public String CancelEditNotaFiscal() throws ClassNotFoundException, SQLException{
notaFiscal = null ;
return "gotoListNotaFiscal";
}
public String RetornarInicio()throws ClassNotFoundException, SQLException{
return"gotoReturnInicio";
}
public NotaFiscal getSelectNotaFiscal() {
return selectNotaFiscal;
}
public void setSelectNotaFiscal(NotaFiscal selectNotaFiscal) {
this.selectNotaFiscal = selectNotaFiscal;
}
}
Minha Pagina:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>INCLUIR GUIA</title>
</head>
<body>
<f:view>
<h1>Incluindo uma nova Guia</h1>
<h:form >
<h:messages style="left: 200px; top: 330px; position: absolute" />
<h:outputLabel style="left: 20px; top: 80px; position: absolute" value ="Nota Fiscal" />
<h:inputText size="100" style="left: 100px; top: 80px; position: absolute" value = "#{NotaFiscalFace.selectNotaFiscal.nota_id}"/>
<br>
<h:outputLabel style="left: 20px; top: 110px; position: absolute" value ="Série" />
<h:inputText size="100" style="left: 100px; top: 110px; position: absolute" value = "#{NotaFiscalFace.selectNotaFiscal.nota_serie}"/>
<br>
<h:outputLabel style="left: 20px; top: 140px; position: absolute" value ="Data de Emissão" />
<h:inputText size="100" style="left: 100px; top: 140px; position: absolute" value = "#{NotaFiscalFace.selectNotaFiscal.nota_dt_emissao}">
<f:convertDateTime type="date" pattern="dd/MM/yyyy"/>
</h:inputText>
<br>
<h:outputLabel style="left: 20px; top: 170px; position: absolute" value = "Fornecedor:"/>
<h:selectOneMenu style="left: 100px; top: 170px; position: absolute" value="#{NotaFiscalFace.selectNotaFiscal.forn_id}">
<f:selectItems value="#{NotaFiscalFace.fornecedor}"/>
<f:converter converterId="FornecedorConverter"/>
</h:selectOneMenu>
<br>
<h:commandButton style="left: 20px; top: 310px; position: absolute" action="#{NotaFiscalFace.FinishAddNotaFiscal}" value="Incluir Guia"/>
<h:commandButton style="left: 140px; top: 310px; position: absolute" action="gotoReturnInicio" value="Cancel"/>
</h:form>
</f:view>
</body>
</html>
Se alguém puder me ajudar…ficarei grato… Meu Gerenciador de Banco de Dados é o POSTGRES 8.3.1!!!
