Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package Persistencia;
- import java.sql.Connection;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import java.util.Vector;
- import Negocio.Distribuidora;
- public class AdmPersistenciaDistribuidora extends AdministradorPersistencia
- {
- private static AdmPersistenciaDistribuidora instancia;
- private AdmPersistenciaDistribuidora()
- {
- }
- public static AdmPersistenciaDistribuidora getInstancia()
- {
- if (instancia == null)
- instancia = new AdmPersistenciaDistribuidora();
- return instancia;
- }
- @Override
- public void delete(Object d) {
- // TODO Auto-generated method stub
- }
- @Override
- public void insert(Object o) {
- // TODO Auto-generated method stub
- }
- @Override
- public Vector<Object> select(Object o) {
- // TODO Auto-generated method stub
- return null;
- }
- @Override
- public void update(Object o) {
- // TODO Auto-generated method stub
- }
- public Vector<Distribuidora> selectAll()
- {
- try
- {
- Vector <Distribuidora>rta = new Vector<Distribuidora>();
- Connection c = PoolConnection.getPoolConnection().getConnection();
- Statement s = c.createStatement();
- ResultSet result = s.executeQuery("Select * from A_Interactivas_01.dbo.distribuidoras");
- while (result.next())
- {
- int codigo = result.getInt(1);
- String nom = result.getString(2);
- Distribuidora dis = new Distribuidora(codigo, nom);
- rta.add(dis);
- }
- PoolConnection.getPoolConnection().realeaseConnection(c);
- return rta;
- }
- catch(Exception e)
- {
- }
- return null;
- }
- public Distribuidora buscarDistribuidora(int codigo)
- {
- try
- {
- Distribuidora rta = null;
- Connection c = PoolConnection.getPoolConnection().getConnection();
- Statement s = c.createStatement();
- ResultSet result = s.executeQuery("Select * from A_Interactivas_01.dbo.distribuidoras where codigo =" + codigo);
- while (result.next())
- {
- int cod = result.getInt(1);
- String nom = result.getString(2);
- rta = new Distribuidora(cod, nom);
- }
- PoolConnection.getPoolConnection().realeaseConnection(c);
- return rta;
- }
- catch(Exception e)
- {
- }
- return null;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement