package org.tutorial;

import static java.lang.System.out;

import java.util.List;
import java.util.Map;

import org.dao.RevistaDao;
import org.modelos.ModeloRevista;
import org.skife.jdbi.v2.DBI;
import org.skife.jdbi.v2.Handle;
import org.skife.jdbi.v2.Query;
import org.skife.jdbi.v2.util.StringMapper;

public class TestJdbi3 {

	public static void main(String[] args) {
		 DBI dbi = new DBI("jdbc:oracle:thin:@148.215.1.174:1521:DBSRALYC",
	                "uredalyc",
	                "uredalyc174");


		Handle h = dbi.open();
		if(!dbi.open().isInTransaction()){
			out.println("No esta realizando alguna transaccion");
		}
		RevistaDao revista= null;
		try{
			revista=dbi.open(RevistaDao.class);
			if(revista.verTodo().size()>0){
				out.println("Lista Revista llena!!: "+revista.verTodo().size());
				for(ModeloRevista rev: revista.verTodo()){
					out.println("**Id revista:"+rev.getCveentrev());
					out.println("**Revista:"+rev.getNomentrev());
					out.println("**clave area:"+rev.getCveareprin());
					out.println("**clave pais:"+rev.getCveentpai());
					out.println("**img:"+rev.getImgentrev());
					out.println("**edo:"+rev.getEdoentrev());
					out.println("**clave inst:"+rev.getCveentint());
					out.println("**clave idioma:"+rev.getCveentidi());
				}
			}
		}
		catch(Exception ex){
			System.err.println(ex.getMessage());
		}

		finally{
			revista.close();
		}

		h.close();

	}

}



package org.modelos;

public class ModeloRevista implements java.io.Serializable {

	private static final long serialVersionUID = 1L;

	private String cveentrev;
	private String nomentrev;
	private String cveareprin;
	private String cveentpai;
	private String urlentrev;
	private String imgentrev;
	private String edoentrev;
	private String cveentint;
	private String cveentidi;

	public ModeloRevista(){}

	public ModeloRevista(String cveentrev, String nomentrev, String cveareprin,
			String cveentpai, String urlentrev, String imgentrev,
			String edoentrev, String cveentint, String cveentidi) {
		super();
		this.cveentrev = cveentrev;
		this.nomentrev = nomentrev;
		this.cveareprin = cveareprin;
		this.cveentpai = cveentpai;
		this.urlentrev = urlentrev;
		this.imgentrev = imgentrev;
		this.edoentrev = edoentrev;
		this.cveentint = cveentint;
		this.cveentidi = cveentidi;
	}

	public String getCveentrev() {
		return cveentrev;
	}

	public void setCveentrev(String cveentrev) {
		this.cveentrev = cveentrev;
	}

	public String getNomentrev() {
		return nomentrev;
	}

	public void setNomentrev(String nomentrev) {
		this.nomentrev = nomentrev;
	}

	public String getCveareprin() {
		return cveareprin;
	}

	public void setCveareprin(String cveareprin) {
		this.cveareprin = cveareprin;
	}

	public String getCveentpai() {
		return cveentpai;
	}

	public void setCveentpai(String cveentpai) {
		this.cveentpai = cveentpai;
	}

	public String getUrlentrev() {
		return urlentrev;
	}

	public void setUrlentrev(String urlentrev) {
		this.urlentrev = urlentrev;
	}

	public String getImgentrev() {
		return imgentrev;
	}

	public void setImgentrev(String imgentrev) {
		this.imgentrev = imgentrev;
	}

	public String getEdoentrev() {
		return edoentrev;
	}

	public void setEdoentrev(String edoentrev) {
		this.edoentrev = edoentrev;
	}

	public String getCveentint() {
		return cveentint;
	}

	public void setCveentint(String cveentint) {
		this.cveentint = cveentint;
	}

	public String getCveentidi() {
		return cveentidi;
	}

	public void setCveentidi(String cveentidi) {
		this.cveentidi = cveentidi;
	}

	public static long getSerialversionuid() {
		return serialVersionUID;
	}

	@Override
	public String toString() {
		return "ModeloRevista [cveentrev=" + cveentrev + ", nomentrev="
				+ nomentrev + ", cveareprin=" + cveareprin + ", cveentpai="
				+ cveentpai + ", urlentrev=" + urlentrev + ", imgentrev="
				+ imgentrev + ", edoentrev=" + edoentrev + ", cveentint="
				+ cveentint + ", cveentidi=" + cveentidi + "]";
	}

}


package org.dao;

import java.util.List;

import org.modelos.ModeloRevista;
import org.skife.jdbi.v2.sqlobject.Bind;
import org.skife.jdbi.v2.sqlobject.SqlQuery;
import org.skife.jdbi.v2.sqlobject.customizers.RegisterMapper;


@RegisterMapper(ModeloRevistaMapper.class)
public interface RevistaDao {
		@SqlQuery("SELECT CVEENTREV,NOMENTREV,CVEAREPRIN,CVEENTPAI,URLENTREV,IMGENTREV,EDOENTREV,CVEENTINT,CVEENTIDI FROM TBLENTREV WHERE CVEENTREV = :id")
		ModeloRevista findById(@Bind("id") long id);
		@SqlQuery("SELECT UREDALYC.TBLENTREV.CVEENTREV,UREDALYC.TBLENTREV.NOMENTREV,UREDALYC.TBLENTREV.CVEAREPRIN,UREDALYC.TBLENTREV.CVEENTPAI,UREDALYC.TBLENTREV.URLENTREV,UREDALYC.TBLENTREV.IMGENTREV,UREDALYC.TBLENTREV.EDOENTREV,UREDALYC.TBLENTREV.CVEENTINT,UREDALYC.TBLENTREV.CVEENTIDI FROM UREDALYC.TBLENTREV")
		List<ModeloRevista> verTodo();
		void close();
}




package org.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.modelos.ModeloRevista;
import org.skife.jdbi.v2.StatementContext;
import org.skife.jdbi.v2.tweak.ResultSetMapper;

public class ModeloRevistaMapper  implements ResultSetMapper<ModeloRevista>  {

	@Override
	public ModeloRevista map(int arg0, ResultSet r, StatementContext arg2)
			throws SQLException {
		ModeloRevista modeloRevista = new ModeloRevista();
        modeloRevista.setCveentrev(r.getString("CVEENTREV"));
        modeloRevista.setNomentrev(r.getString("NOMENTREV"));
        modeloRevista.setCveareprin(r.getString("CVEAREPRIN"));
        modeloRevista.setCveentpai(r.getString("CVEENTPAI"));
        modeloRevista.setUrlentrev(r.getString("URLENTREV"));
        modeloRevista.setImgentrev(r.getString("IMGENTREV"));
        modeloRevista.setEdoentrev(r.getString("EDOENTREV"));
        modeloRevista.setCveentint(r.getString("CVEENTINT"));
        modeloRevista.setCveentidi(r.getString("CVEENTIDI"));
	return modeloRevista;
	}

}