DbUtilsUseBeanMySQL.java Source code

Introduction

Here is the source code for DbUtilsUseBeanMySQL.java

Source

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);
    }
}