[code]package br.com.controllers;
import br.com.frames.CadCliFr;
import br.com.vos.CadCliVO;
import java.sql.;
import java.util.;
import org.openswing.swing.mdi.client.MDIFrame;
import org.openswing.swing.message.receive.java.*;
import org.openswing.swing.message.send.java.FilterWhereClause;
import org.openswing.swing.table.client.GridController;
import org.openswing.swing.table.java.GridDataLocator;
public class CadCliController extends GridController implements GridDataLocator {
private Connection conn = null;
private CadCliFr grid = null;
public CadCliController(Connection conn) {
this.conn = conn;
grid = new CadCliFr(conn, this);
/* FAZER UMA VERIFICAÇÃO
* PARA NÃO DEIXAR ABRIR O MESMO
* FORM MAIS DE UMA VEZ
*/
MDIFrame.add(grid, true);
}
@Override
public Response loadData(
int action,
int startIndex,
Map filteredColumns,
ArrayList currentSortedColumns,
ArrayList currentSortedVersusColumns,
Class valueObjectType,
Map otherGridParams) {
PreparedStatement stmt = null;
try {
String sql = "SELECT c.auto, "
+ " c.razao_social, "
+ " c.cpf_cnpj, "
+ " c.tel_cont1, "
+ " c.tel_cont2, "
+ " c.tel_cont3, "
+ " c.nome_fantasia, "
+ " c.cep, "
+ " c.tipo_logradouro, "
+ " c.logradouro, "
+ " c.complemento, "
+ " c.bairro, "
+ " c.cidade, "
+ " c.email1, "
+ " c.email2, "
+ " c.email3, "
+ " c.insc_estadual_rg, "
+ " c.insc_municipal, "
+ " c.observacao, "
+ " c.uf "
+ " FROM cliente c ;";
Vector vals = new Vector();
Map mapa = new HashMap();
mapa.put("auto", "c.auto");
mapa.put("razao_social", "c.razao_social");
mapa.put("cpf_cnpj", "c.cpf_cnpj");
mapa.put("tel_cont1", "c.tel_cont1");
mapa.put("tel_cont2", "c.tel_cont2");
mapa.put("tel_cont3", "c.tel_cont3");
mapa.put("nome_fantasia", "c.nome_fantasia");
mapa.put("cep", "c.cep");
mapa.put("tipo_logradouro", "c.tipo_logradouro");
mapa.put("logradouro", "c.logradouro");
mapa.put("complemento", "c.complemento");
mapa.put("bairro", "c.bairro");
mapa.put("cidade", "c.cidade");
mapa.put("email1", "c.email1");
mapa.put("email2", "c.email2");
mapa.put("email3", "c.email3");
mapa.put("insc_estadual_rg", "c.insc_estadual_rg");
mapa.put("insc_municipal", "c.insc_municipal");
mapa.put("observacao", "c.observacao");
mapa.put("uf", "c.uf");
if (filteredColumns.size() > 0) {
FilterWhereClause[] filter = (FilterWhereClause[]) filteredColumns.get("razao_social");
sql += " WHERE c.razao_social " + filter[0].getOperator() + "?";
vals.add(filter[0].getValue());
/* if (filter[1] != null) {
sql += " and DEMO2.TEXT " + filter[1].getOperator() + "?";
vals.add(filter[1].getValue());
}*/
vals.add(filter[0].getValue());
}
if (currentSortedColumns.size() > 0) {
sql += " ORDER BY " + mapa.get(currentSortedColumns.get(0).toString() + " " + currentSortedVersusColumns.get(0));
}
stmt = conn.prepareStatement(sql);
for (int i = 0; i < vals.size(); i++) {
stmt.setObject(i + 1, vals.get(i));
}
ResultSet rset = stmt.executeQuery();
// imprime o result set
System.out.println(rset);
ArrayList list = new ArrayList();
CadCliVO vo = null;
while (rset.next()) {
vo = new CadCliVO();
// SETA O CAMPO AUTO DE CLIENRTE VO
vo.setAuto(rset.getInt(1));
vo.setRazao_social(rset.getString(2));
vo.setCpf_cnpj(rset.getString(3));
vo.setTel_cont1(rset.getString(4));
vo.setTel_cont2(rset.getString(5));
vo.setTel_cont3(rset.getString(6));
vo.setNome_fantasia(rset.getString(7));
vo.setCep(rset.getString(8));
vo.setTipo_logradouro(rset.getInt(9));
vo.setLogradouro(rset.getString(10));
vo.setComplemento(rset.getString(11));
vo.setBairro(rset.getString(12));
vo.setCidade(rset.getString(13));
vo.setEmail1(rset.getString(14));
vo.setEmail2(rset.getString(15));
vo.setEmail3(rset.getString(16));
vo.setInsc_estadual_rg(rset.getString(17));
vo.setInsc_municipal(rset.getString(18));
vo.setObservacao(rset.getString(19));
vo.setUf(rset.getInt(20));
list.add(vo);
}
return new VOListResponse(list, false, list.size());
} catch (SQLException ex) {
return new ErrorResponse(ex.getMessage());
} finally {
try {
stmt.close();
} catch (SQLException ex1) {
System.out.print("Erro: " + ex1);
}
}
}
// apagar o registro
public Response deleteRecord(ArrayList persistentObjects) throws Exception {
PreparedStatement stmt = null;
try {
stmt = conn.prepareStatement("delete from CLIENTE where auto=?");
for (int i = 0; i < persistentObjects.size(); i++) {
CadCliVO vo = (CadCliVO) persistentObjects.get(i);
stmt.setString(1, vo.getAuto().toString());
stmt.execute();
}
return new VOResponse(true);
} catch (SQLException ex) {
return new ErrorResponse(ex.getMessage());
} finally {
try {
stmt.close();
conn.commit();
} catch (SQLException ex1) {
}
}
}
}
[/code]
O erro:
[color=red]The resource ‘drag’ is not defined.
The resource ‘Autonumeração’ is not defined.
The resource ‘Razão Social’ is not defined.
The resource ‘CPF/CNPJ’ is not defined.
The resource ‘Tel. 1’ is not defined.
The resource ‘Tel. 2’ is not defined.
The resource ‘Tel. 3’ is not defined.
The resource ‘Nome Fantasia’ is not defined.
The resource ‘CEP’ is not defined.
The resource ‘Tipo Lagradouro’ is not defined.
The resource ‘Logradouro’ is not defined.
The resource ‘Complemento’ is not defined.
The resource ‘Bairro’ is not defined.
The resource ‘Cidade’ is not defined.
The resource ‘E-Mail 1’ is not defined.
The resource ‘E-Mail 2’ is not defined.
The resource ‘E-Mail 3’ is not defined.
The resource ‘Insc. Estad. / RG’ is not defined.
The resource ‘Insc. Municipal’ is not defined.
The resource ‘Observação’ is not defined.
The resource ‘UF’ is not defined.
The resource ‘sorting conditions’ is not defined.
Entrou no cliente Facade
Fri Mar 09 12:32:41 BRT 2012 [ERROR]
in org.openswing.swing.table.client.Grids.loadData():
Error while fetching data.
java.lang.NullPointerException
at br.com.controllers.CadCliController.loadData(CadCliController.java:158)
at org.openswing.swing.table.client.Grids.loadData(Grids.java:1794)
at org.openswing.swing.table.client.Grids.access$800(Grids.java:58)
at org.openswing.swing.table.client.Grids$LoadDataThread.run(Grids.java:4064)
The resource ‘ok’ is not defined.
[/color]