Admin: 1 версия

2010-06-01T06:34:49Z

1 версия

в 18:01, 31 мая 2010

2010-05-31T18:01:44Z

Новая страница

== 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>

← Предыдущая	Версия 06:34, 1 июня 2010
(нет различий)

Java/Database SQL JDBC/Apache Dbutils - История изменений

Admin: 1 версия

в 18:01, 31 мая 2010