Java/Database SQL JDBC/Apache Dbutils
Версия от 21:01, 31 мая 2010; (обсуждение)
DbUtils:Use Bean (ORM)
<source lang="java">
import org.apache.rumons.dbutils.DbUtils; import org.apache.rumons.dbutils.QueryRunner; import org.apache.rumons.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); }
}
</source>
DbUtils:Use Map against MySQL
<source lang="java">
import org.apache.rumons.dbutils.DbUtils; import org.apache.rumons.dbutils.QueryRunner; import org.apache.rumons.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); }
}
</source>