DbUtils:Use Map against MySQL : Apache Dbutils « Database SQL JDBC « Java

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

DbUtils:Use Map against MySQL

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

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

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

public class DbUtilsUseMapMySQL {
  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 mapList = (List) qRunner.query(conn, "select id, name from animals_table",
          new MapListHandler());

      for (int i = 0; i < mapList.size(); i++) {
        Map map = (Map) mapList.get(i);
        System.out.println("id=" + map.get("id"));
        System.out.println("name=" + map.get("name"));
        System.out.println("-----------------");
      }

      System.out.println("DbUtils_UseMap_MySQL: end.");

    } 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