Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- package sisteweb;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- import javax.swing.JOptionPane;
- public class ConexaoAccess {
- private Connection con;
- private Statement statement;
- private ResultSet rs;
- String banco = "C:\\Sisteweb\\banco.mdb";
- public String[][] procurarPessoa(String descricao) {
- rs = null;
- String[][] dados = null;
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con= DriverManager.getConnection("jdbc:odbc:Driver=" +
- "{Microsoft Access Driver (*.mdb)};" +
- "DBQ=" + banco ,"","");
- statement = con.createStatement();
- String s = null;
- if(descricao !=null && !descricao.equals("")){
- s= "select * from PESSOA where CODIGO=" + descricao + " "
- + "or NOMEPESSOA like '%" + descricao + "%'";
- }else
- s = "select * from PESSOA";
- JOptionPane.showMessageDialog(null, s);
- rs = statement.executeQuery(s);
- ResultSetTableModel rst = new ResultSetTableModel("sun.jdbc.odbc.JdbcOdbcDriver",
- "jdbc:odbc:Driver=" +
- "{Microsoft Access Driver (*.mdb)}; DBQ=" + banco, "", "",
- s);
- dados = new String[rst.getRowCount()][9];
- int aux = 0;
- while (rs.next()) {
- dados[aux][0] = rs.getString(1);
- dados[aux][1] = rs.getString(2);
- dados[aux][2] = rs.getString(5);
- aux++;
- }
- } catch (Exception ex) {
- Logger.getLogger(ConexaoAccess.class.getName()).log(Level.SEVERE, null, ex);
- }
- return dados;
- }
- void adicionarPessoa(String addsql){
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con= DriverManager.getConnection("jdbc:odbc:Driver=" +
- "{Microsoft Access Driver (*.mdb)};" +
- "DBQ=" + banco ,"","");
- String sql = "insert into PESSOA(NOMEPESSOA,ENDERECOPESSOA,SEXOPESSOA,CPFPESSOA,RGPESSOA,"
- + "CIDADEPESSOA,UFPESSOA,STATUS,CODIGOFUNCIONARIO) values " + addsql ;
- statement = con.createStatement();
- statement.executeQuery(sql);
- }
- catch(Exception e){
- e.printStackTrace();
- JOptionPane.showMessageDialog(null, "Houve um error ao inserir" + e);
- }
- }
- }
Add Comment
Please, Sign In to add comment