DbUtils:Use Bean (ORM) : Apache Dbutils « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. Apache Dbutils

DbUtils:Use Bean (ORM)

import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import java.util.List;

public class DbUtilsUseBeanMySQL {
  public static void main(String[] args) {
    Connection conn = null;
    String jdbcURL = "jdbc:mysql://localhost/octopus";
    String jdbcDriver = "com.mysql.jdbc.Driver";
    String user = "root";
    String password = "root";

    try {
      DbUtils.loadDriver(jdbcDriver);
      conn = DriverManager.getConnection(jdbcURL, user, password);

      QueryRunner qRunner = new QueryRunner();
      List beans = (List) qRunner.query(conn, "select id, name from animals_table",
          new BeanListHandler(Employee.class));

      for (int i = 0; i < beans.size(); i++) {
        Employee bean = (Employee) beans.get(i);
        bean.print();
      }
    } catch (SQLException e) {
      // handle the exception
      e.printStackTrace();
    } finally {
      DbUtils.closeQuietly(conn);
    }
  }
}

class Employee {

  private int id;
  private String name;

  public Employee() {
  }

  public void setName(String name) {
      this.name = name;
  }

  public String getName() {
      return this.name;
  }

  public void setId(int id) {
      this.id = id;
  }

  public int getId() {
      return this.id;
  }

  public void print() {
      System.out.println("id="+id+" name="+name);
  }
}

           
       

Related examples in the same category