/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package br.com.ddns.grupotsergio;

import java.sql.*;

/**
 *
 * @author Edson
 */
public class usuariosGS {
    int chave = 0;
    String nome = null;
    String senha = null;
            String nomecompleto = null;
            String assinatura = null;
            String fundofixo = null;
            String geral = null;
            String gecadempre = null;
            String gecadfili = null;
            String gecadusu = null;
            String gecadcid = null;
    String geparams = null;
            String gecc = null;
            String geclifor = null;
            String genatfiscal = null;
            String gerepres = null;
            String getransp = null;
            String contabil = null;
            String cbcadpc = null;
            String cbcadhist = null;
            String cblancontab = null;
            String cbabreper = null;
    String cbfechaper = null;
            String cbconsist = null;
            String cbencmovi = null;
            String cblimpalanca = null;
            String cbrelcontab = null;
            String cblalura = null;
            String cblalurb = null;
            String cblalurbcont = null;
            String estoque = null;
            String escompras = null;
    String esvendas = null;
            String esfaturas = null;
            String esgrupos = null;
            String esmarcas = null;
            String esorcavendas = null;
            String esprodutos = null;
            String esreldesp = null;
            String esreqcompras = null;
            String essubgrupo = null;
            String financeiro = null;
    String fncartorio = null;
            String fncondicoes = null;
            String fnindices = null;
            String fnfincompras = null;
            String fnpgtos = null;
            String fnfinvendas = null;
            String fnrecebs = null;
            String fnborderos = null;
            String fnchpre = null;
            String fnlancacc = null;
    String fnextratos = null;
            String fnfluxo = null;
            String fnrelat = null;
            String fnvlrind = null;
            String fncheque = null;
            String fncttolongo = null;
            String fncadcusto = null;
            String fnlanccusto = null;
            String fiscal = null;
            String fslanca = null;
            String fslanrubri = null;
    String fsrubricas = null;
            String folhapgto = null;
            String fpcategoria = null;
            String fpcausaresc = null;
            String fpcbo = null;
            String fpdepend = null;
            String fpdeptos = null;
            String fpeventos = null;
            String fpferias = null;
            String fpfuncs = null;
            String fpgrauins = null;
    String fphortrab = null;
            String fplancaconta = null;
            String fplancafolha = null;
            String fpnacional = null;
            String fpresc = null;
            String fpsalbase = null;
            String fpsessoes = null;
            String fpsetor = null;
            String fpsindicato = null;
            String fpsituacao = null;
    String fptabinss = null;
            String fptabirrf = null;
            String fptpadm = null;
            String fptpafasta = null;
            String fptpreceb = null;
            String fptpsalario = null;
            String fptpsangue = null;
            String fpvinculo = null;
            String patrimon = null;
            String ptapol = null;
            String ptbens = null;
    String ptconfcontab = null;
            String ptdeptos = null;
            String ptgrupos = null;
            String ptlancapatri = null;
            String ptlocais = null;
            String protoc = null;
            String pritens = null;
            String pritensproto = null;
            String prprotocolo = null;
            String status = null;

    private static PreparedStatement stm = null;
    private static ResultSet rs = null;
    private static Statement stmt;

    public usuariosGS(){
    }

    public String getAssinatura() {
        return assinatura;
    }

    public void setAssinatura(String assinatura) {
        this.assinatura = assinatura;
    }

    public String getCbabreper() {
        return cbabreper;
    }

    public void setCbabreper(String cbabreper) {
        this.cbabreper = cbabreper;
    }

    public String getCbcadhist() {
        return cbcadhist;
    }

    public void setCbcadhist(String cbcadhist) {
        this.cbcadhist = cbcadhist;
    }

    public String getCbcadpc() {
        return cbcadpc;
    }

    public void setCbcadpc(String cbcadpc) {
        this.cbcadpc = cbcadpc;
    }

    public String getCbconsist() {
        return cbconsist;
    }

    public void setCbconsist(String cbconsist) {
        this.cbconsist = cbconsist;
    }

    public String getCbencmovi() {
        return cbencmovi;
    }

    public void setCbencmovi(String cbencmovi) {
        this.cbencmovi = cbencmovi;
    }

    public String getCbfechaper() {
        return cbfechaper;
    }

    public void setCbfechaper(String cbfechaper) {
        this.cbfechaper = cbfechaper;
    }

    public String getCblalura() {
        return cblalura;
    }

    public void setCblalura(String cblalura) {
        this.cblalura = cblalura;
    }

    public String getCblalurb() {
        return cblalurb;
    }

    public void setCblalurb(String cblalurb) {
        this.cblalurb = cblalurb;
    }

    public String getCblalurbcont() {
        return cblalurbcont;
    }

    public void setCblalurbcont(String cblalurbcont) {
        this.cblalurbcont = cblalurbcont;
    }

    public String getCblancontab() {
        return cblancontab;
    }

    public void setCblancontab(String cblancontab) {
        this.cblancontab = cblancontab;
    }

    public String getCblimpalanca() {
        return cblimpalanca;
    }

    public void setCblimpalanca(String cblimpalanca) {
        this.cblimpalanca = cblimpalanca;
    }

    public String getCbrelcontab() {
        return cbrelcontab;
    }

    public void setCbrelcontab(String cbrelcontab) {
        this.cbrelcontab = cbrelcontab;
    }

    public int getChave() {
        return chave;
    }

    public void setChave(int chave) {
        this.chave = chave;
    }

    public String getContabil() {
        return contabil;
    }

    public void setContabil(String contabil) {
        this.contabil = contabil;
    }

    public String getEscompras() {
        return escompras;
    }

    public void setEscompras(String escompras) {
        this.escompras = escompras;
    }

    public String getEsfaturas() {
        return esfaturas;
    }

    public void setEsfaturas(String esfaturas) {
        this.esfaturas = esfaturas;
    }

    public String getEsgrupos() {
        return esgrupos;
    }

    public void setEsgrupos(String esgrupos) {
        this.esgrupos = esgrupos;
    }

    public String getEsmarcas() {
        return esmarcas;
    }

    public void setEsmarcas(String esmarcas) {
        this.esmarcas = esmarcas;
    }

    public String getEsorcavendas() {
        return esorcavendas;
    }

    public void setEsorcavendas(String esorcavendas) {
        this.esorcavendas = esorcavendas;
    }

    public String getEsprodutos() {
        return esprodutos;
    }

    public void setEsprodutos(String esprodutos) {
        this.esprodutos = esprodutos;
    }

    public String getEsreldesp() {
        return esreldesp;
    }

    public void setEsreldesp(String esreldesp) {
        this.esreldesp = esreldesp;
    }

    public String getEsreqcompras() {
        return esreqcompras;
    }

    public void setEsreqcompras(String esreqcompras) {
        this.esreqcompras = esreqcompras;
    }

    public String getEssubgrupo() {
        return essubgrupo;
    }

    public void setEssubgrupo(String essubgrupo) {
        this.essubgrupo = essubgrupo;
    }

    public String getEstoque() {
        return estoque;
    }

    public void setEstoque(String estoque) {
        this.estoque = estoque;
    }

    public String getEsvendas() {
        return esvendas;
    }

    public void setEsvendas(String esvendas) {
        this.esvendas = esvendas;
    }

    public String getFinanceiro() {
        return financeiro;
    }

    public void setFinanceiro(String financeiro) {
        this.financeiro = financeiro;
    }

    public String getFiscal() {
        return fiscal;
    }

    public void setFiscal(String fiscal) {
        this.fiscal = fiscal;
    }

    public String getFnborderos() {
        return fnborderos;
    }

    public void setFnborderos(String fnborderos) {
        this.fnborderos = fnborderos;
    }

    public String getFncadcusto() {
        return fncadcusto;
    }

    public void setFncadcusto(String fncadcusto) {
        this.fncadcusto = fncadcusto;
    }

    public String getFncartorio() {
        return fncartorio;
    }

    public void setFncartorio(String fncartorio) {
        this.fncartorio = fncartorio;
    }

    public String getFncheque() {
        return fncheque;
    }

    public void setFncheque(String fncheque) {
        this.fncheque = fncheque;
    }

    public String getFnchpre() {
        return fnchpre;
    }

    public void setFnchpre(String fnchpre) {
        this.fnchpre = fnchpre;
    }

    public String getFncondicoes() {
        return fncondicoes;
    }

    public void setFncondicoes(String fncondicoes) {
        this.fncondicoes = fncondicoes;
    }

    public String getFncttolongo() {
        return fncttolongo;
    }

    public void setFncttolongo(String fncttolongo) {
        this.fncttolongo = fncttolongo;
    }

    public String getFnextratos() {
        return fnextratos;
    }

    public void setFnextratos(String fnextratos) {
        this.fnextratos = fnextratos;
    }

    public String getFnfincompras() {
        return fnfincompras;
    }

    public void setFnfincompras(String fnfincompras) {
        this.fnfincompras = fnfincompras;
    }

    public String getFnfinvendas() {
        return fnfinvendas;
    }

    public void setFnfinvendas(String fnfinvendas) {
        this.fnfinvendas = fnfinvendas;
    }

    public String getFnfluxo() {
        return fnfluxo;
    }

    public void setFnfluxo(String fnfluxo) {
        this.fnfluxo = fnfluxo;
    }

    public String getFnindices() {
        return fnindices;
    }

    public void setFnindices(String fnindices) {
        this.fnindices = fnindices;
    }

    public String getFnlancacc() {
        return fnlancacc;
    }

    public void setFnlancacc(String fnlancacc) {
        this.fnlancacc = fnlancacc;
    }

    public String getFnlanccusto() {
        return fnlanccusto;
    }

    public void setFnlanccusto(String fnlanccusto) {
        this.fnlanccusto = fnlanccusto;
    }

    public String getFnpgtos() {
        return fnpgtos;
    }

    public void setFnpgtos(String fnpgtos) {
        this.fnpgtos = fnpgtos;
    }

    public String getFnrecebs() {
        return fnrecebs;
    }

    public void setFnrecebs(String fnrecebs) {
        this.fnrecebs = fnrecebs;
    }

    public String getFnrelat() {
        return fnrelat;
    }

    public void setFnrelat(String fnrelat) {
        this.fnrelat = fnrelat;
    }

    public String getFnvlrind() {
        return fnvlrind;
    }

    public void setFnvlrind(String fnvlrind) {
        this.fnvlrind = fnvlrind;
    }

    public String getFolhapgto() {
        return folhapgto;
    }

    public void setFolhapgto(String folhapgto) {
        this.folhapgto = folhapgto;
    }

    public String getFpcategoria() {
        return fpcategoria;
    }

    public void setFpcategoria(String fpcategoria) {
        this.fpcategoria = fpcategoria;
    }

    public String getFpcausaresc() {
        return fpcausaresc;
    }

    public void setFpcausaresc(String fpcausaresc) {
        this.fpcausaresc = fpcausaresc;
    }

    public String getFpcbo() {
        return fpcbo;
    }

    public void setFpcbo(String fpcbo) {
        this.fpcbo = fpcbo;
    }

    public String getFpdepend() {
        return fpdepend;
    }

    public void setFpdepend(String fpdepend) {
        this.fpdepend = fpdepend;
    }

    public String getFpdeptos() {
        return fpdeptos;
    }

    public void setFpdeptos(String fpdeptos) {
        this.fpdeptos = fpdeptos;
    }

    public String getFpeventos() {
        return fpeventos;
    }

    public void setFpeventos(String fpeventos) {
        this.fpeventos = fpeventos;
    }

    public String getFpferias() {
        return fpferias;
    }

    public void setFpferias(String fpferias) {
        this.fpferias = fpferias;
    }

    public String getFpfuncs() {
        return fpfuncs;
    }

    public void setFpfuncs(String fpfuncs) {
        this.fpfuncs = fpfuncs;
    }

    public String getFpgrauins() {
        return fpgrauins;
    }

    public void setFpgrauins(String fpgrauins) {
        this.fpgrauins = fpgrauins;
    }

    public String getFphortrab() {
        return fphortrab;
    }

    public void setFphortrab(String fphortrab) {
        this.fphortrab = fphortrab;
    }

    public String getFplancaconta() {
        return fplancaconta;
    }

    public void setFplancaconta(String fplancaconta) {
        this.fplancaconta = fplancaconta;
    }

    public String getFplancafolha() {
        return fplancafolha;
    }

    public void setFplancafolha(String fplancafolha) {
        this.fplancafolha = fplancafolha;
    }

    public String getFpnacional() {
        return fpnacional;
    }

    public void setFpnacional(String fpnacional) {
        this.fpnacional = fpnacional;
    }

    public String getFpresc() {
        return fpresc;
    }

    public void setFpresc(String fpresc) {
        this.fpresc = fpresc;
    }

    public String getFpsalbase() {
        return fpsalbase;
    }

    public void setFpsalbase(String fpsalbase) {
        this.fpsalbase = fpsalbase;
    }

    public String getFpsessoes() {
        return fpsessoes;
    }

    public void setFpsessoes(String fpsessoes) {
        this.fpsessoes = fpsessoes;
    }

    public String getFpsetor() {
        return fpsetor;
    }

    public void setFpsetor(String fpsetor) {
        this.fpsetor = fpsetor;
    }

    public String getFpsindicato() {
        return fpsindicato;
    }

    public void setFpsindicato(String fpsindicato) {
        this.fpsindicato = fpsindicato;
    }

    public String getFpsituacao() {
        return fpsituacao;
    }

    public void setFpsituacao(String fpsituacao) {
        this.fpsituacao = fpsituacao;
    }

    public String getFptabinss() {
        return fptabinss;
    }

    public void setFptabinss(String fptabinss) {
        this.fptabinss = fptabinss;
    }

    public String getFptabirrf() {
        return fptabirrf;
    }

    public void setFptabirrf(String fptabirrf) {
        this.fptabirrf = fptabirrf;
    }

    public String getFptpadm() {
        return fptpadm;
    }

    public void setFptpadm(String fptpadm) {
        this.fptpadm = fptpadm;
    }

    public String getFptpafasta() {
        return fptpafasta;
    }

    public void setFptpafasta(String fptpafasta) {
        this.fptpafasta = fptpafasta;
    }

    public String getFptpreceb() {
        return fptpreceb;
    }

    public void setFptpreceb(String fptpreceb) {
        this.fptpreceb = fptpreceb;
    }

    public String getFptpsalario() {
        return fptpsalario;
    }

    public void setFptpsalario(String fptpsalario) {
        this.fptpsalario = fptpsalario;
    }

    public String getFptpsangue() {
        return fptpsangue;
    }

    public void setFptpsangue(String fptpsangue) {
        this.fptpsangue = fptpsangue;
    }

    public String getFpvinculo() {
        return fpvinculo;
    }

    public void setFpvinculo(String fpvinculo) {
        this.fpvinculo = fpvinculo;
    }

    public String getFslanca() {
        return fslanca;
    }

    public void setFslanca(String fslanca) {
        this.fslanca = fslanca;
    }

    public String getFslanrubri() {
        return fslanrubri;
    }

    public void setFslanrubri(String fslanrubri) {
        this.fslanrubri = fslanrubri;
    }

    public String getFsrubricas() {
        return fsrubricas;
    }

    public void setFsrubricas(String fsrubricas) {
        this.fsrubricas = fsrubricas;
    }

    public String getFundofixo() {
        return fundofixo;
    }

    public void setFundofixo(String fundofixo) {
        this.fundofixo = fundofixo;
    }

    public String getGecadcid() {
        return gecadcid;
    }

    public void setGecadcid(String gecadcid) {
        this.gecadcid = gecadcid;
    }

    public String getGecadempre() {
        return gecadempre;
    }

    public void setGecadempre(String gecadempre) {
        this.gecadempre = gecadempre;
    }

    public String getGecadfili() {
        return gecadfili;
    }

    public void setGecadfili(String gecadfili) {
        this.gecadfili = gecadfili;
    }

    public String getGecadusu() {
        return gecadusu;
    }

    public void setGecadusu(String gecadusu) {
        this.gecadusu = gecadusu;
    }

    public String getGecc() {
        return gecc;
    }

    public void setGecc(String gecc) {
        this.gecc = gecc;
    }

    public String getGeclifor() {
        return geclifor;
    }

    public void setGeclifor(String geclifor) {
        this.geclifor = geclifor;
    }

    public String getGenatfiscal() {
        return genatfiscal;
    }

    public void setGenatfiscal(String genatfiscal) {
        this.genatfiscal = genatfiscal;
    }

    public String getGeparams() {
        return geparams;
    }

    public void setGeparams(String geparams) {
        this.geparams = geparams;
    }

    public String getGeral() {
        return geral;
    }

    public void setGeral(String geral) {
        this.geral = geral;
    }

    public String getGerepres() {
        return gerepres;
    }

    public void setGerepres(String gerepres) {
        this.gerepres = gerepres;
    }

    public String getGetransp() {
        return getransp;
    }

    public void setGetransp(String getransp) {
        this.getransp = getransp;
    }

    public String getNome() {
        return nome;
    }

    public void setNome(String nome) {
        this.nome = nome;
    }

    public String getNomecompleto() {
        return nomecompleto;
    }

    public void setNomecompleto(String nomecompleto) {
        this.nomecompleto = nomecompleto;
    }

    public String getPatrimon() {
        return patrimon;
    }

    public void setPatrimon(String patrimon) {
        this.patrimon = patrimon;
    }

    public String getPritens() {
        return pritens;
    }

    public void setPritens(String pritens) {
        this.pritens = pritens;
    }

    public String getPritensproto() {
        return pritensproto;
    }

    public void setPritensproto(String pritensproto) {
        this.pritensproto = pritensproto;
    }

    public String getProtoc() {
        return protoc;
    }

    public void setProtoc(String protoc) {
        this.protoc = protoc;
    }

    public String getPrprotocolo() {
        return prprotocolo;
    }

    public void setPrprotocolo(String prprotocolo) {
        this.prprotocolo = prprotocolo;
    }

    public String getPtapol() {
        return ptapol;
    }

    public void setPtapol(String ptapol) {
        this.ptapol = ptapol;
    }

    public String getPtbens() {
        return ptbens;
    }

    public void setPtbens(String ptbens) {
        this.ptbens = ptbens;
    }

    public String getPtconfcontab() {
        return ptconfcontab;
    }

    public void setPtconfcontab(String ptconfcontab) {
        this.ptconfcontab = ptconfcontab;
    }

    public String getPtdeptos() {
        return ptdeptos;
    }

    public void setPtdeptos(String ptdeptos) {
        this.ptdeptos = ptdeptos;
    }

    public String getPtgrupos() {
        return ptgrupos;
    }

    public void setPtgrupos(String ptgrupos) {
        this.ptgrupos = ptgrupos;
    }

    public String getPtlancapatri() {
        return ptlancapatri;
    }

    public void setPtlancapatri(String ptlancapatri) {
        this.ptlancapatri = ptlancapatri;
    }

    public String getPtlocais() {
        return ptlocais;
    }

    public void setPtlocais(String ptlocais) {
        this.ptlocais = ptlocais;
    }

    public String getSenha() {
        return senha;
    }

    public void setSenha(String senha) {
        this.senha = senha;
    }

    public String getStatus() {
        return status;
    }

    public void setStatus(String status) {
        this.status = status;
    }

    public static boolean inserirUsuario (usuariosGS tipi){
        try{
            stm = Conexao.conectar().prepareStatement("insert into usuarios(idusuarios,nome,"
            + "senha,nomecompleto,assinatura,fundofixo,geral,gecadempre,"
            + "gecadfili,gecadusu,gecadcid,geparams,gecc,geclifor,genatfiscal,"
            + "gerepres,getransp,contabil,cbcadpc,cbcadhist,cblancontab,"
            + "cbabreper,cbfechaper,cbconsist,cbencmovi,cblimpalanca,cbrelcontab,"
            + "cblalura,cblalurb,cblalurbcont,estoque,escompras,esvendas,"
            + "esfaturas,esgrupos,esmarcas,esorcavendas,esprodutos,esreldesp,"
            + "esreqcompras,essubgrupo,financeiro,fncartorio,fncondicoes,"
            + "fnindices,fnfincompras,fnpgtos,fnfinvendas,fnrecebs,fnborderos,"
            + "fnchpre,fnlancacc,fnextratos,fnfluxo,fnrelat,fnvlrind,fncheque,"
            + "fncttolongo,fncadcusto,fnlanccusto,fiscal,fslanca,fslanrubri,"
            + "fsrubricas,folhapgto,fpcategoria,fpcausaresc,fpcbo,fpdepend,"
            + "fpdeptos,fpeventos,fpferias,fpfuncs,fpgrauins,fphortrab,"
            + "fplancaconta,fplancafolha,fpnacional,fpresc,fpsalbase,fpsessoes,"
            + "fpsetor,fpsindicato,fpsituacao,fptabinss,fptabirrf,fptpadm,"
            + "fptpafasta,fptpreceb,fptpsalario,fptpsangue,fpvinculo,patrimon,"
            + "ptapol,ptbens,ptconfcontab,ptdeptos,ptgrupos,ptlancapatri,"
            + "ptlocais,protoc,pritens,pritensproto,prprotocolo) values "
            + "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"
            + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"
            + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"
            + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"
            + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
            stm.setInt(1, tipi.getChave());
            stm.setString(2, tipi.getNome());
            stm.setString(3, tipi.getSenha());
            stm.setString(4, tipi.getNomecompleto());
            stm.setString(5, tipi.getAssinatura());
            stm.setString(6, tipi.getFundofixo());
            stm.setString(7, tipi.getGeral());
            stm.setString(8, tipi.getGecadempre());
            stm.setString(9, tipi.getGecadfili());
            stm.setString(10, tipi.getGecadusu());
            stm.setString(11, tipi.getGecadcid());
            stm.setString(12, tipi.getGeparams());
            stm.setString(13, tipi.getGecc());
            stm.setString(14, tipi.getGeclifor());
            stm.setString(15, tipi.getGenatfiscal());
            stm.setString(16, tipi.getGerepres());
            stm.setString(17, tipi.getGetransp());
            stm.setString(18, tipi.getContabil());
            stm.setString(19, tipi.getCbcadpc());
            stm.setString(20, tipi.getCbcadhist());
            stm.setString(21, tipi.getCblancontab());
            stm.setString(22, tipi.getCbabreper());
            stm.setString(23, tipi.getCbfechaper());
            stm.setString(24, tipi.getCbconsist());
            stm.setString(25, tipi.getCbencmovi());
            stm.setString(26, tipi.getCblimpalanca());
            stm.setString(27, tipi.getCbrelcontab());
            stm.setString(28, tipi.getCblalura());
            stm.setString(29, tipi.getCblalurb());
            stm.setString(30, tipi.getCblalurbcont());
            stm.setString(31, tipi.getEstoque());
            stm.setString(32, tipi.getEscompras());
            stm.setString(33, tipi.getEsvendas());
            stm.setString(34, tipi.getEsfaturas());
            stm.setString(35, tipi.getEsgrupos());
            stm.setString(36, tipi.getEsmarcas());
            stm.setString(37, tipi.getEsorcavendas());
            stm.setString(38, tipi.getEsprodutos());
            stm.setString(39, tipi.getEsreldesp());
            stm.setString(40, tipi.getEsreqcompras());
            stm.setString(41, tipi.getEssubgrupo());
            stm.setString(42, tipi.getFinanceiro());
            stm.setString(43, tipi.getFncartorio());
            stm.setString(44, tipi.getFncondicoes());
            stm.setString(45, tipi.getFnindices());
            stm.setString(46, tipi.getFnfincompras());
            stm.setString(47, tipi.getFnpgtos());
            stm.setString(48, tipi.getFnfinvendas());
            stm.setString(49, tipi.getFnrecebs());
            stm.setString(50, tipi.getFnborderos());
            stm.setString(51, tipi.getFnchpre());
            stm.setString(52, tipi.getFnlancacc());
            stm.setString(53, tipi.getFnextratos());
            stm.setString(54, tipi.getFnfluxo());
            stm.setString(55, tipi.getFnrelat());
            stm.setString(56, tipi.getFnvlrind());
            stm.setString(57, tipi.getFncheque());
            stm.setString(58, tipi.getFncttolongo());
            stm.setString(59, tipi.getFncadcusto());
            stm.setString(60, tipi.getFnlanccusto());
            stm.setString(61, tipi.getFiscal());
            stm.setString(62, tipi.getFslanca());
            stm.setString(63, tipi.getFslanrubri());
            stm.setString(64, tipi.getFsrubricas());
            stm.setString(65, tipi.getFolhapgto());
            stm.setString(66, tipi.getFpcategoria());
            stm.setString(67, tipi.getFpcausaresc());
            stm.setString(68, tipi.getFpcbo());
            stm.setString(69, tipi.getFpdepend());
            stm.setString(70, tipi.getFpdeptos());
            stm.setString(71, tipi.getFpeventos());
            stm.setString(72, tipi.getFpferias());
            stm.setString(73, tipi.getFpfuncs());
            stm.setString(74, tipi.getFpgrauins());
            stm.setString(75, tipi.getFphortrab());
            stm.setString(76, tipi.getFplancaconta());
            stm.setString(77, tipi.getFplancafolha());
            stm.setString(78, tipi.getFpnacional());
            stm.setString(79, tipi.getFpresc());
            stm.setString(80, tipi.getFpsalbase());
            stm.setString(81, tipi.getFpsessoes());
            stm.setString(82, tipi.getFpsetor());
            stm.setString(83, tipi.getFpsindicato());
            stm.setString(84, tipi.getFpsituacao());
            stm.setString(85, tipi.getFptabinss());
            stm.setString(86, tipi.getFptabirrf());
            stm.setString(87, tipi.getFptpadm());
            stm.setString(88, tipi.getFptpafasta());
            stm.setString(89, tipi.getFptpreceb());
            stm.setString(90, tipi.getFptpsalario());
            stm.setString(91, tipi.getFptpsangue());
            stm.setString(92, tipi.getFpvinculo());
            stm.setString(93, tipi.getPatrimon());
            stm.setString(94, tipi.getPtapol());
            stm.setString(95, tipi.getPtbens());
            stm.setString(96, tipi.getPtconfcontab());
            stm.setString(97, tipi.getPtdeptos());
            stm.setString(98, tipi.getPtgrupos());
            stm.setString(99, tipi.getPtlancapatri());
            stm.setString(100, tipi.getPtlocais());
            stm.setString(101, tipi.getProtoc());
            stm.setString(102, tipi.getPritens());
            stm.setString(103, tipi.getPritensproto());
            stm.setString(104, tipi.getPrprotocolo());

            stm.executeUpdate();
            stm.close();
            return true;
        }catch(Exception e){
            System.out.println("Erro ao inserir");
            return false;
        }
    }

    public static boolean alterarUsuario (usuariosGS tipi){
        boolean testa = false;
        try{
            stm = Conexao.conectar().prepareStatement("update usuarios set "
            + "nome = ?,senha = ?,nomecompleto = ?,assinatura = ?,fundofixo = ?,"
            + "geral = ?,gecadempre = ?, gecadfili = ?,gecadusu = ?,gecadcid = ?,"
            + "geparams = ?,gecc = ?,geclifor = ?,genatfiscal = ?, gerepres = ?,"
            + "getransp = ?,contabil = ?,cbcadpc = ?,cbcadhist = ?,cblancontab = ?,"
            + "cbabreper = ?,cbfechaper = ?,cbconsist = ?,cbencmovi = ?,"
            + "cblimpalanca = ?,cbrelcontab = ?, cblalura = ?,cblalurb = ?,"
            + "cblalurbcont = ?,estoque = ?,escompras = ?,esvendas = ?,"
            + "esfaturas = ?,esgrupos = ?,esmarcas = ?,esorcavendas = ?,"
            + "esprodutos = ?,esreldesp = ?, esreqcompras = ?,essubgrupo = ?,"
            + "financeiro = ?,fncartorio = ?,fncondicoes = ?, fnindices = ?,"
            + "fnfincompras = ?,fnpgtos = ?,fnfinvendas = ?,fnrecebs = ?,"
            + "fnborderos = ?,fnchpre = ?,fnlancacc = ?,fnextratos = ?,"
            + "fnfluxo = ?,fnrelat = ?,fnvlrind = ?,fncheque = ?,"
            + "fncttolongo = ?,fncadcusto = ?,fnlanccusto = ?,fiscal = ?,"
            + "fslanca = ?,fslanrubri = ?, fsrubricas = ?,folhapgto = ?,"
            + "fpcategoria = ?,fpcausaresc = ?,fpcbo = ?,fpdepend = ?,"
            + "fpdeptos = ?,fpeventos = ?,fpferias = ?,fpfuncs = ?,fpgrauins = ?,"
            + "fphortrab = ?,fplancaconta = ?,fplancafolha = ?,fpnacional = ?,"
            + "fpresc = ?,fpsalbase = ?,fpsessoes = ?, fpsetor = ?,fpsindicato = ?,"
            + "fpsituacao = ?,fptabinss = ?,fptabirrf = ?,fptpadm = ?,"
            + "fptpafasta = ?,fptpreceb = ?,fptpsalario = ?,fptpsangue = ?,"
            + "fpvinculo = ?,patrimon = ?,ptapol = ?,ptbens = ?,ptconfcontab = ?,"
            + "ptdeptos = ?,ptgrupos = ?,ptlancapatri = ?,ptlocais = ?,protoc = ?,"
            + "pritens = ?,pritensproto = ?,prprotocolo = ? where idusuarios = ?");
            stm.setString(1, tipi.getNome());
            stm.setString(2, tipi.getSenha());
            stm.setString(3, tipi.getNomecompleto());
            stm.setString(4, tipi.getAssinatura());
            stm.setString(5, tipi.getFundofixo());
            stm.setString(6, tipi.getGeral());
            stm.setString(7, tipi.getGecadempre());
            stm.setString(8, tipi.getGecadfili());
            stm.setString(9, tipi.getGecadusu());
            stm.setString(10, tipi.getGecadcid());
            stm.setString(11, tipi.getGeparams());
            stm.setString(12, tipi.getGecc());
            stm.setString(13, tipi.getGeclifor());
            stm.setString(14, tipi.getGenatfiscal());
            stm.setString(15, tipi.getGerepres());
            stm.setString(16, tipi.getGetransp());
            stm.setString(17, tipi.getContabil());
            stm.setString(18, tipi.getCbcadpc());
            stm.setString(19, tipi.getCbcadhist());
            stm.setString(20, tipi.getCblancontab());
            stm.setString(21, tipi.getCbabreper());
            stm.setString(22, tipi.getCbfechaper());
            stm.setString(23, tipi.getCbconsist());
            stm.setString(24, tipi.getCbencmovi());
            stm.setString(25, tipi.getCblimpalanca());
            stm.setString(26, tipi.getCbrelcontab());
            stm.setString(27, tipi.getCblalura());
            stm.setString(28, tipi.getCblalurb());
            stm.setString(29, tipi.getCblalurbcont());
            stm.setString(30, tipi.getEstoque());
            stm.setString(31, tipi.getEscompras());
            stm.setString(32, tipi.getEsvendas());
            stm.setString(33, tipi.getEsfaturas());
            stm.setString(34, tipi.getEsgrupos());
            stm.setString(35, tipi.getEsmarcas());
            stm.setString(36, tipi.getEsorcavendas());
            stm.setString(37, tipi.getEsprodutos());
            stm.setString(38, tipi.getEsreldesp());
            stm.setString(39, tipi.getEsreqcompras());
            stm.setString(40, tipi.getEssubgrupo());
            stm.setString(41, tipi.getFinanceiro());
            stm.setString(42, tipi.getFncartorio());
            stm.setString(43, tipi.getFncondicoes());
            stm.setString(44, tipi.getFnindices());
            stm.setString(45, tipi.getFnfincompras());
            stm.setString(46, tipi.getFnpgtos());
            stm.setString(47, tipi.getFnfinvendas());
            stm.setString(48, tipi.getFnrecebs());
            stm.setString(49, tipi.getFnborderos());
            stm.setString(50, tipi.getFnchpre());
            stm.setString(51, tipi.getFnlancacc());
            stm.setString(52, tipi.getFnextratos());
            stm.setString(53, tipi.getFnfluxo());
            stm.setString(54, tipi.getFnrelat());
            stm.setString(55, tipi.getFnvlrind());
            stm.setString(56, tipi.getFncheque());
            stm.setString(57, tipi.getFncttolongo());
            stm.setString(58, tipi.getFncadcusto());
            stm.setString(59, tipi.getFnlanccusto());
            stm.setString(60, tipi.getFiscal());
            stm.setString(61, tipi.getFslanca());
            stm.setString(62, tipi.getFslanrubri());
            stm.setString(63, tipi.getFsrubricas());
            stm.setString(64, tipi.getFolhapgto());
            stm.setString(65, tipi.getFpcategoria());
            stm.setString(66, tipi.getFpcausaresc());
            stm.setString(67, tipi.getFpcbo());
            stm.setString(68, tipi.getFpdepend());
            stm.setString(69, tipi.getFpdeptos());
            stm.setString(70, tipi.getFpeventos());
            stm.setString(71, tipi.getFpferias());
            stm.setString(72, tipi.getFpfuncs());
            stm.setString(73, tipi.getFpgrauins());
            stm.setString(74, tipi.getFphortrab());
            stm.setString(75, tipi.getFplancaconta());
            stm.setString(76, tipi.getFplancafolha());
            stm.setString(77, tipi.getFpnacional());
            stm.setString(78, tipi.getFpresc());
            stm.setString(79, tipi.getFpsalbase());
            stm.setString(80, tipi.getFpsessoes());
            stm.setString(81, tipi.getFpsetor());
            stm.setString(82, tipi.getFpsindicato());
            stm.setString(83, tipi.getFpsituacao());
            stm.setString(84, tipi.getFptabinss());
            stm.setString(85, tipi.getFptabirrf());
            stm.setString(86, tipi.getFptpadm());
            stm.setString(87, tipi.getFptpafasta());
            stm.setString(88, tipi.getFptpreceb());
            stm.setString(89, tipi.getFptpsalario());
            stm.setString(90, tipi.getFptpsangue());
            stm.setString(91, tipi.getFpvinculo());
            stm.setString(92, tipi.getPatrimon());
            stm.setString(93, tipi.getPtapol());
            stm.setString(94, tipi.getPtbens());
            stm.setString(95, tipi.getPtconfcontab());
            stm.setString(96, tipi.getPtdeptos());
            stm.setString(97, tipi.getPtgrupos());
            stm.setString(98, tipi.getPtlancapatri());
            stm.setString(99, tipi.getPtlocais());
            stm.setString(100, tipi.getProtoc());
            stm.setString(101, tipi.getPritens());
            stm.setString(102, tipi.getPritensproto());
            stm.setString(103, tipi.getPrprotocolo());
            stm.setInt(104, tipi.getChave());
            int executeUpdate = stm.executeUpdate();

            if(executeUpdate > 0)
                testa = true;
            else
                testa = false;
        }catch(Exception e){
            System.out.println("Erro ao alterar");
        }
        return testa;
    }

    public static boolean excluiUsuario (usuariosGS tipi){
        boolean testa = false;
        try {
            stm = Conexao.conectar().prepareStatement("delete from usuarios "
                    + "where idusuarios = ?");
            stm.setInt(1, tipi.getChave());
            int executeUpdate = stm.executeUpdate();

            if(executeUpdate > 0)
                testa = true;
            else
                testa = false;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return testa;
    }

    public void selUsuario(String Id) {
        try {
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("Select * From usuarios Where idusuarios ='"+Id+"'");

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static int getAutoInc(String Generator) {
        int Codigo = 0;
        try {
            PreparedStatement pstmt = Conexao.conectar().prepareStatement(
                    "Select max(idusuarios) From usuarios");
            ResultSet rss = pstmt.executeQuery();
            rss.next();
            Codigo = rss.getInt(1) + 1;
        }
        catch (Exception e) {
            e.printStackTrace();
        }
        return Codigo;
    }

    public void listaUsuario(){
        try{
            stmt = Conexao.conectar().createStatement();
            rs = stmt.executeQuery("select * from usuarios order by nome");
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public void selLogin(String n, String s) {
        usuariosGS logar = null;
        try {
          stmt = Conexao.conectar().createStatement();
          rs = stmt.executeQuery("select idusuarios, "
          + "nome, senha from usuarios "
          + "where nome = '"+n+"' and senha = '"+s+"'");
//          if (rs.next()) {
  //          logar = new usuariosGS();
    //        logar.setChave(rs.getInt("chave"));
      //      logar.setNome(rs.getString("nome"));
        //    logar.setSenha(rs.getString("senha"));
          //}
//          rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public ResultSet getResultado(){
        return rs;
    }

}