Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import org.dao.AutorDao;
- import org.dao.MyDAO;
- import org.skife.jdbi.v2.DBI;
- //import org.skife.jdbi.v2.Handle;
- //import org.skife.jdbi.v2.sqlobject.Bind;
- public class TestJdbi2 {
- public static void main(String[] args) {
- DBI dbi = new DBI("jdbc:oracle:thin:@148.215.1.155:1521:DBSRALYC",
- "uautores",
- "uautores155");
- MyDAO dao = dbi.open(MyDAO.class);
- System.out.println(dao.findNameById(194));
- try{
- AutorDao autor= dbi.open(AutorDao.class);
- System.out.println(autor.findById(194).getNombreAutor()+" "+autor.findById(194).getApellidoAutor());
- }
- catch(Exception ex){
- ex.printStackTrace();
- }
- dao.close();
- }
- }
- package org.dao;
- //import org.dao.ModeloAutorDAO;
- //import org.dao.ModeloAutorMapper;
- //import org.modelos.ModeloAutor;
- //import org.skife.jdbi.v2.BeanMapper;
- //import org.skife.jdbi.v2.DBI;
- //import org.skife.jdbi.v2.Handle;
- import org.skife.jdbi.v2.sqlobject.Bind;
- import org.skife.jdbi.v2.sqlobject.SqlQuery;
- import org.skife.jdbi.v2.sqlobject.SqlUpdate;
- //import org.skife.jdbi.v2.tweak.HandleCallback;
- //import org.skife.jdbi.v2.util.IntegerMapper;
- //import org.skife.jdbi.v2.sqlobject.Bind;
- //import org.skife.jdbi.v2.sqlobject.SqlQuery;
- //import org.skife.jdbi.v2.sqlobject.SqlUpdate;
- //import org.skife.jdbi.v2.sqlobject.customizers.Mapper;
- //import org.skife.jdbi.v2.sqlobject.mixins.Transactional;
- //import org.skife.jdbi.v2.util.StringMapper;
- public interface MyDAO {
- // @SqlUpdate("create table something (id int primary key, name varchar(100))")
- // void createSomethingTable();
- // @SqlUpdate("insert into something (id, name) values (:id, :name)")
- // void insert(@Bind("id") int id, @Bind("name") String name);
- @SqlQuery("SELECT NOMAUTNOR FROM TBLAUTNOR WHERE CVEAUTNOR= :id")
- String findNameById(@Bind("id") int id);
- /**
- * close with no args is used to close the connection
- */
- void close();
- }
- package org.tutorial;
- import java.io.Serializable;
- import javax.persistence.*;
- @Entity
- public class Autor implements Serializable {
- private static final long serialVersionUID = 1L;
- @Id @GeneratedValue
- private long id;
- private String nombreAutor;
- private String apellidoAutor;
- private String correoAutor;
- private String cveInstitucion;
- private String cveOrcid;
- public Autor(){}
- public Autor(long id, String nombreAutor, String apellidoAutor,
- String correoAutor, String cveInstitucion, String cveOrcid) {
- super();
- this.id = id;
- this.nombreAutor = nombreAutor;
- this.apellidoAutor = apellidoAutor;
- this.correoAutor = correoAutor;
- this.cveInstitucion = cveInstitucion;
- this.cveOrcid = cveOrcid;
- }
- public String getCveOrcid() {
- return cveOrcid;
- }
- public void setCveOrcid(String cveOrcid) {
- this.cveOrcid = cveOrcid;
- }
- public String getCveInstitucion() {
- return cveInstitucion;
- }
- public void setCveInstitucion(String cveInstitucion) {
- this.cveInstitucion = cveInstitucion;
- }
- public String getApellidoAutor() {
- return apellidoAutor;
- }
- public void setApellidoAutor(String apellidoAutor) {
- this.apellidoAutor = apellidoAutor;
- }
- public long getId() {
- return id;
- }
- public void setId(long id) {
- this.id = id;
- }
- public String getNombreAutor() {
- return nombreAutor;
- }
- public void setNombreAutor(String nombreAutor) {
- this.nombreAutor = nombreAutor;
- }
- public String getCorreoAutor() {
- return correoAutor;
- }
- public void setCorreoAutor(String correoAutor) {
- this.correoAutor = correoAutor;
- }
- public static long getSerialversionuid() {
- return serialVersionUID;
- }
- @Override
- public String toString() {
- return String.format("Autor(%d%n, %s , %s, %s , %s,%s)", this.id, this.nombreAutor,this.apellidoAutor,this.correoAutor,this.cveInstitucion,this.cveOrcid);
- }
- }
- package org.modelos;
- public class ModeloAutor implements java.io.Serializable {
- /**
- *
- */
- private static final long serialVersionUID = 1L;
- private long id;
- private String nombreAutor;
- private String apellidoAutor;
- private String correoAutor;
- private String cveInstitucion;
- private String cveOrcid;
- public ModeloAutor(){}
- public ModeloAutor(long id, String nombreAutor, String apellidoAutor,
- String correoAutor, String cveInstitucion, String cveOrcid) {
- super();
- this.id = id;
- this.nombreAutor = nombreAutor;
- this.apellidoAutor = apellidoAutor;
- this.correoAutor = correoAutor;
- this.cveInstitucion = cveInstitucion;
- this.cveOrcid = cveOrcid;
- }
- public long getId() {
- return id;
- }
- public void setId(long id) {
- this.id = id;
- }
- public String getNombreAutor() {
- return nombreAutor;
- }
- public void setNombreAutor(String nombreAutor) {
- this.nombreAutor = nombreAutor;
- }
- public String getApellidoAutor() {
- return apellidoAutor;
- }
- public void setApellidoAutor(String apellidoAutor) {
- this.apellidoAutor = apellidoAutor;
- }
- public String getCorreoAutor() {
- return correoAutor;
- }
- public void setCorreoAutor(String correoAutor) {
- this.correoAutor = correoAutor;
- }
- public String getCveInstitucion() {
- return cveInstitucion;
- }
- public void setCveInstitucion(String cveInstitucion) {
- this.cveInstitucion = cveInstitucion;
- }
- public String getCveOrcid() {
- return cveOrcid;
- }
- public void setCveOrcid(String cveOrcid) {
- this.cveOrcid = cveOrcid;
- }
- }
- package org.dao;
- import org.modelos.ModeloAutor;
- //import org.skife.jdbi.v2.StatementContext;
- import org.skife.jdbi.v2.sqlobject.Bind;
- import org.skife.jdbi.v2.sqlobject.SqlQuery;
- import org.skife.jdbi.v2.sqlobject.customizers.RegisterMapper;
- //import org.skife.jdbi.v2.tweak.ResultSetMapper;
- //import org.skife.jdbi.v2.sqlobject.customizers.*;
- @RegisterMapper(ModeloAutorMapper.class)
- public interface AutorDao {
- @SqlQuery("SELECT CVEAUTNOR, NOMAUTNOR,APEAUTNOR,MAILAUTNOR1,CVEENTINT,CVEORCID FROM TBLAUTNOR WHERE CVEAUTNOR = :id")
- ModeloAutor findById(@Bind("id") long id);
- }
- package org.modelos;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import org.skife.jdbi.v2.StatementContext;
- import org.skife.jdbi.v2.tweak.ResultSetMapper;
- public abstract class ModeloAutorMapper implements ResultSetMapper<ModeloAutor> {
- public ModeloAutor map(int index, ResultSet r, StatementContext ctx) throws SQLException
- {
- return new ModeloAutor(
- r.getLong("CVEAUTNOR"),
- r.getString("NOMAUTNOR")
- ,r.getString("APEAUTNOR")
- ,r.getString("MAILAUTNOR1")
- ,r.getString("CVEENTINT")
- ,r.getString("CVEORCID")
- );
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement