EasyDBO简易教程-stef-天意.doc

Transcription

1 EasyJF EasyDBO 1.0! EasyJF,EasyDBO EasyJF

2 EasyJF 1

3 EasyJF EasyDBO 1.0 ( EasyDBO EasyDBO EasyDBO...5 EasyDBO EasyDBO SDK EasyDBO EasyDBO EasyDBO EasyDBO...8 EasyDBO ORM EasyJDB EasyJDB EasyJDB ( ) PO FO(Fan Object) Java EasyJDB DOM(PO) DOM(PO) FO(Fan Object)

4 EasyJF sql EasyDBO EasyDBO EasyJWeb EasyDBO Spring Struts EasyDBO...37 EasyDBO EasyJF Blog java ( 0.5, 10 1 ) java ( : ) EasyJF iula-0.1.0( : )

5 EasyJF EasyDBO hibernate JDO - EasyDBO EasyDBO EasyDBO EasyJF EasyDBO Java EasyJF ( ) stef_wu EasyJF! EasyDBO piginzoo william stef_wu qgz0910 clyyu 3

6 EasyJF EasyDBO Object/Relation Mapping ORM - (ORM) SQL Java JDBC JDBC JAVA Java SQL JDBC JDBC - 35% JDBC API ORM - ORM ORM Hibernate EasyDBO ibatis JDO EJB Entities 3 EJB Entity Beans 2.x TopLink 1.3 EasyDBO java JDBC jdbc API SQL 4

7 EasyJF sql ibatis hibernate ORM JDBC SQL ORM sql ORM 1.4 EasyDBO EasyDBO java Java - (ORM) EasyDBO JDBC ORM EasyDBO ORM ORM EasyDBO EasyJF EasyJWeb EasyDBO 2.1 EasyDBO SDK EasyDBO Java : SVN Check out EasyDBO SVN EasyDBO lib EasyDBO src EasyDBO bin EasyDBO 2.3 EasyDBO EasyDBO JDK bin build.bat jar build.bat jar EasyDBO 5

8 EasyJF jar release easyjf-dbo jar EasyDBO Java5 Java5(jdk1.5) 2.4 EasyDBO EasyDBO easyjf-dbo.jar cglib jar log4j jar classpath My SQL apache-dbcp EasyDBO jar 2.5 EasyDBO Message PO JavaBean 6

9 EasyJF Java Bean IObject Message.java package example; import java.util.date; import com.easyjf.dbo.iobject; public class Message implements IObject { private int cid; private String title; private String content; private String inputuser; private Date inputtime; private Boolean publish; private Integer status; public String gettablename() { return "message"; public String getkeyfield() { return "cid"; public String getkeygenerator() { return "com.easyjf.dbo.nullidgenerator"; public int getcid() { return cid; public void setcid(int cid) { this.cid = cid;... getter setter EasyDBO package example; import org.apache.commons.dbcp.basicdatasource; public class MessageTest { public static void main(string[] args) { // BasicDataSource datasource = new BasicDataSource(); datasource.setdriverclassname("org.gjt.mm.mysql.driver"); datasource.seturl("jdbc:mysql:// :3306/easyjf"); datasource.setusername("root"); datasource.setpassword("mysql"); // EasyDBO EasyJDB 7

10 EasyJF com.easyjf.dbo.easyjdb easyjdb=new com.easyjf.dbo.easyjdb(datasource); Message m=new Message(); m.settitle(" "); m.setcontent(" "); m.setinputtime(new java.util.date()); m.setinputuser("easyjf"); m.setpublish(boolean.true); m.setstatus(new Integer(0)); // EasyDBO boolean ret=easyjdb.add(m); if(ret)system.out.println(" "); // java.util.list list=easyjdb.query(message.class,"1=1"); Message m2=(message)list.get(0); System.out.println(m2.getTitle()); System.out.println(m2.getContent()); 2.6 EasyDBO 1 (DOM PO) Java Bean Java Bean IObject Java5 JavaBean easyjf-dbo.xml 2 EasyJDB ( ) EasyJDB Sql 3 EasyJDB 4 EasyJDB SQL EasyDBO 3.1 ORM EasyJDB EasyJDB EasyDBO EasyJDB 8

11 EasyJF EasyJDB 1 add update del saveorupdate execute easyjdb.add(m) m 2 ( ) query uniqueresult read easyjdb.read(mesage.class,"2") 2 Message 3 setshowsql setenablecache setautocommit setmaxsize setenablecache EasyDBO EasyJDB EasyJDB EasyJDB EasyDBO EasyJDB EasyJDB EasyJDB EasyJDB EasyJDB : EasyJDB(javax.sql.DataSource datasource) MySQL EasyJDB EasyJDB(javax.sql.DataSource datasource, java.lang.string cachename) EasyJDB EasyJDB(javax.sql.DataSource datasource, ISqlQuery sqlquery) EasyJDB EasyJDB(javax.sql.DataSource datasource, ISqlQuery sqlquery, java.lang.string cachename) EasyJDB EasyJDB(javax.sql.DataSource datasource, ISqlQuery sqlquery, java.lang.string cachename, boolean showsql) EasyDBO sql EasyJDB EasyJDB() EasyJDB EasyJDB BasicDataSource datasource = new BasicDataSource();... EasyJDB easyjdb=new com.easyjf.dbo.easyjdb(datasource,new com.easyjf.dbo.sql.mssqlserverquery()); Message m=(message)easyjdb.read(message.class,cid); EasyJDB easyjdb=new com.easyjf.dbo.easyjdb(datasource); 9

12 EasyJF easyjdb.setsqlquery(new MSSqlServerQuery()) Message m=(message)easyjdb.read(message.class,cid); EasyJDB easyjdb=new com.easyjf.dbo.easyjdb(datasource,new MSSqlServerQuery(),"EasyDBO",true); Message m=(message)easyjdb.read(message.class,cid); EasyJDB EasyJDB EasyJDB getinstance EasyJDB EasyJDB easyjf-dbo.xml EasyDBO getinstance EasyJDB EasyJDB easyjdb=easyjdb.getinstance(); Message m=(message)easyjdb.read(message.class,cid); EasyJDB setconffiles EasyDBO EasyDBO public void testconfigfile() { BasicDataSource datasource = new BasicDataSource(); datasource.setdriverclassname("org.gjt.mm.mysql.driver"); datasource.seturl("jdbc:mysql:// :3306/easyjf"); datasource.setusername("root"); datasource.setpassword("mysql"); EasyJDB easyjdb=new EasyJDB(datasource); java.util.list configfile=new java.util.arraylist(); configfile.add("/easyjf-dbo.xml"); configfile.add("/easyjf-dbo2.xml"); easyjdb.setconfigfiles(configfile); System.out.println(easyjdb.getMapping().getMap().size()); easyjdb.setconfigfiles /easyjf-dbo.xml /easyjf-dbo2.xml EasyJDB EasyJDB EasyJDB innercache enablecache true innercache DBOCache DBOCache ICache Cache public void testcustomcache() 10

13 EasyJF { EasyJDB easyjdb=new EasyJDB(datasource); com.easyjf.cache.icache cache=new com.easyjf.cache.easycache(); com.easyjf.dbo.dbocache dcache=new com.easyjf.dbo.dbocache(); dcache.setcache(cache); easyjdb.setinnercache(dcache); easyjdb.setenablecache(true); easyjdb.setshowsql(true); easyjdb.setconfigfiles(configfile); for(int i=0;i<5;i++) { easyjdb.query(message.class,"1=1"); 3.2 EasyJDB EasyJDB javax.sql.datasource EasyDBO Apache DBCP JNDI 1 Apache DBCP import org.apache.commons.dbcp.basicdatasource; BasicDataSource mssql = new BasicDataSource(); mssql.setdriverclassname("net.sourceforge.jtds.jdbc.driver"); mssql.seturl("jdbc:jtds:sqlserver:// :1433;databasenam e=easyjf;selectmethod=cursor"); mssql.setusername("easyjf"); mssql.setpassword("easyjf"); EasyJDB easyjdb=new EasyJDB(); easyjdb.setdatasource(mssql); easyjdb.setsqlquery(new MSSqlServerQuery()); 2 JNDI Context ctx=null; ctx=new InitialContext(); DataSource ds=(datasource)ctx.lookup("java:comp/env/jdbc/easyjf"); EasyJDB easyjdb=new EasyJDB(ds,new MSSqlServerQuery()); 3.3 SQL 11

14 EasyJF EasyDBO EasyJDB EasyJDB EasyJDB My SQL MySqlQuery EasyDBO com.easyjf.dbo.sql.isqlquery MSSqlServerQuery MySqlQuery OracleQuery MS SQL(ACCESS) MY SQL Oracle EasyJDB 1 EasyJDB easyjdb=new EasyJDB(datasource,new MSSqlServerQuery()); 2 EasyJDB setsqlquery EasyJDB easyjdb=new EasyJDB(dataSource); easyjdb.setsqlquery(new MSSqlServerQuery()); 3 easyjf-dbo.xml getinstance EasyJDB easyjf-dbo.xml <property name="easydbo.dialect">com.easyjf.dbo.sql.mssqlserverquery</prope rty> EasyJDB easyjdb=easyjdb.getinstance(); 3.4 ( ) PO FO(Fan Object) EasyDBO (DOM) PO User User Message Message User Message PO EasyDBO DBObject DBObject DBOject EasyDBO Map select a.cid as cid,b.title as title,c.username as username from IDS a,message b,user c inner join User - User - Hibernate hibernate hibernate.cfg.xml User User.hbm.xml EasyDBO EasyDBO com.easyjf.dbo.iobject - IObject 12

15 EasyJF package com.easyjf.dbo; public interface IObject { String gettablename(); String getkeyfield(); String getkeygenerator(); gettablename() getkeyfield() ID getkeygenerator() ID IObject User User.jav : package com.easyjw eb.business; import java.util.date; import com.easyjf.dbo.iobject; public class User implements IObject,Serializable { private String cid; private String username; private String password; private String ; private String tel; private Date birthday; private String intro; public String gettablename() { return "UserTable"; public String getkeyfield() { return "cid"; public String getkeygenerator() { return "com.easyjf.dbo.randomidgenerator"; public String getcid() { return cid; public void setcid(string cid) { this.cid = cid;.. getter setter User User cid com.easyjf.dbo.randomidgenerator 16 13

16 EasyJF N N M N EasyDBO EasyDBO easyjf-dbo.xml Message Serializable JavaBean IObject public class Message implements Serializable {... private String cid; private String title; private String content; private String inputuser; private Date inputtime; private Boolean publish; private Integer status; public String getcid() { return cid; public void setcid(string cid) { this.cid = cid; getter setter easyjf-dbo.xml <class name="com.easyjf.dbo.example.message" table="message" schema="dbo" catalog="easyjf" lazy = "false"> <id name="cid" type="string"> <column name="cid" length="16" not-null="true" /> <generator class="com.easyjf.dbo.idgenerator" /> </id> <property name="title" type="string"> <column name="title" length="50" not-null="true" /> </property> <property name="content" type="string"> <column name="content" /> 14

17 EasyJF </property> <property name="status" type="integer"> <column name="status" length="" /> </property> <property name="inputuser" type="string"> <column name="inputuser" length="23" /> </property> <property name="inputtime" type="date"> <column name="inputtime" length="8" /> </property> <property name="publish" type="bool"> <column name="publish" length="1" /> </property> </class> <class> <class> name PO table <id> <generator> <property> <column> 3.7 Java5 EasyDBO Java5 Java5 Message import java.io.serializable; import java.util.date; import public class Message implements private String private String private String private String private Date 15

18 EasyJF private Boolean private Integer status1; public String getcid() { return cid; public void setcid(string cid) { this.cid = cid; getter EasyDBO IObject String getkeyfield() keyfield EasyDBO IObject String getkeygenerator() keygenerator IIdGenerator IIdGenerator public interface IIdGenerator { Object generator(class classtype); Object generator(class classtype, String column); EasyDBO NullIdGenerator 16 IdGenerator RandomIdGenerator 3.9 EasyDBO EasyJDB innercache DBOCache enablecache true IOC DBOCache com.easyjf.cache.icache cache=new com.easyjf.cache.easycache(); 16

19 EasyJF com.easyjf.dbo.dbocache dcache=new com.easyjf.dbo.dbocache(); dcache.setcache(cache); easyjdb.setinnercache(dcache); easyjdb.setenablecache(true); EasyJDB EasyJDB cacehname null "" EasyJDB cachename easyjf-cache.xml cache easyjf-dbo.xml EasyJDB EasyJDB enablecache true EasyJDB Cache Cache easyjf-cache.xml EasyDBO easyjf-cache.xml <?xml version="1.0" encoding="utf-8"?> <easyjf-cache> <!-- storepolicy LRU LFU FIFO, LRU --> <cache name="easydbo" storepolicy="lfu" maxelements="50" expiredinterval="1000" type="com.easyjf.cache.easycache" /> </easyjf-cache> <cache> name storepolicy maxelements expiredinterval type EasyDBO EasyCache easyjf-dbo.xml <property name="easydbo.cache_name">easydbo</property> <property name="easydbo.enable_cache">true</property> EasyJDB EasyJDB easyjdb=new EasyJDB(dataSoruce,"EasyDBO"); 3.10 OO ORM EasyDBO <class name="com.easyjf.dbo.example.orderdetail" table="orderdetail" schema="dbo" catalog="easyjf" lazy = "false"> <id name="cid" type="string"> <column name="cid" length="16" not-null="true" /> 17

20 EasyJF <generator class="com.easyjf.dbo.randomidgenerator" /> </id> <one-to-one name="order" type="com.easyjf.dbo.example.order" column="orderid" key="cid" lazy="true"> </one-to-one> <one-to-one name="product" type="com.easyjf.dbo.example.product" column="productid" key="cid"> </one-to-one>... </class> <one-to-one> name order OrderDetail private Order order; type Class column column="orderid" order OrderDetail orderid order cid lazy OrderDetail Order Product <one-to-one> OrderDetail order OrderDetail bean public class OrderDetail { private String cid; private Order order; private Product product; private Integer num; private java.math.bigdecimal price; // OrderDetail detail=(orderdetail)db.get(orderdetail.class, id); String ordertitle=detail.getorder().gettitle(); 18

21 EasyJF order order orderdetail Order order=(order)db.get(order.class, id); OrderDetail detail=order.getorderdetail(); detail Order OrderDetail <one-to-one name="order " type="com.easyjf.dbo.example.order " column="order Id" key="cid" lazy="true"> order orderdetail Order OrderDetail public class OrderDetail private String private Order private Product private Integer private java.math.bigdecimal price; public String getcid() { return cid; public void setcid(string cid) {... this.cid = cid; 3.11 Order OrderDetail <many-to-one> Order OrderDetail <class name="com.easyjf.dbo.example.order" table="orderinfo" schema="dbo" catalog="easyjf" lazy = "false"> <id name="cid" type="string"> <column name="cid" length="16" not-null="true" /> <generator class="com.easyjf.dbo.randomidgenerator" /> 19

22 EasyJF </id> <property name="title" type="string"> <column name="title" length="50" not-null="true" /> </property> <many-to-one name="children" fieldtype="java.util.list" type="com.easyjf.dbo.example.orderdetail" column="orderid" key="cid"> </many-to-one> </class> <many-to-one> name fieldtype ArrayList List Set type Class column orderdetail orderid Order key orderdetail cid Order public class Order { private String cid; private String title; private java.math.bigdecimal money; private List children; Order order=(order)db.get(order.class, id); List allitem=order.getchildren(); for(...){ //... // OrderDetail public class Order private String private String private java.math.bigdecimal private List children=new java.util.arraylist(); 20

23 EasyJF public String getcid() { return cid; public void setcid(string cid) { this.cid = cid;... EasyJDB db=easyjdb.getinstance(); db.setautocommit(false); Order order=new Order(); order.settitle(" "); order.setcid("1111"); java.util.list details=new java.util.arraylist(); for(int i=0;i<10;i++){ OrderDetail detail=new OrderDetail(); detail.setorder(order); detail.setnum(15); detail.setprice(new java.math.bigdecimal(16)); details.add(detail); order.setchildren(details); db.add(order); db.commit(); EasyJDB add order children OrderDetail EasyDBO lazy false 3.12 EasyDBO EasyDBO <many-to-many> Product 21

24 EasyJF Provider ProvidrProduct Provider Product Product Provider EasyDBO <class name="com.easyjf.dbo.example.product" table="product" schema="dbo" catalog="easyjf" lazy = "false"> <id name="cid" type="string"> <column name="cid" length="16" not-null="true" /> <generator class="com.easyjf.dbo.idgenerator" /> </id> <many-to-many name="providers" fieldtype="java.util.list" type="com.easyjf.dbo.example.provider" tablename="providerproduct" column="productid" key="cid" tagcolumn="providername" tagkey="username"> </many-to-many>... </class> <class name="com.easyjf.dbo.example.provider" table="provider" schema="dbo" catalog="easyjf" lazy = "false"> <many-to-many name="prdoucts" fieldtype="java.util.list" type="com.easyjf.dbo.example.product" tablename="providerproduct" column="providername" key="username" tagcolumn="productid" tagkey="cid"> </many-to-many> 22

25 EasyJF... </class> name filedtype type tablename columan key tagcolumn tagkey filedtype Product.java import com.easyjf.dbo.annotation.manytomany; import com.easyjf.dbo.annotation.table; import public class Product private String private String private String private java.math.bigdecimal lumn="productid",tablename="providerproduct",key="cid",tagcolumn= "providername",tagkey="username") private java.util.list private Integer status; public String getcid() {... return cid; Provider.java package com.easyjf.dbo.example; import com.easyjf.dbo.annotation.manytomany; import com.easyjf.dbo.annotation.table; 23

26 EasyJF import public class Provider private String private String private java.util.date private Integer column="providername",tablename="providerproduct",key="username", tagcolumn="productid",tagkey="cid") private java.util.list products;... public java.util.list getproducts() { return products; public void setproducts(java.util.list products) { this.products = products; EasyJDB db=easyjdb.getinstance(); db.setautocommit(false); Provider p=new Provider(); p.setusername("easyjf"); java.util.list products=new java.util.arraylist(); for(int i=0;i<5;i++) { Product pro=new Product(); pro.settitle(" "+i); pro.setintro(" "+i); products.add(pro); p.setproducts(products); db.add(p); db.commit(); Provider Product ProviderProduct 24

27 EasyJF 3.13 ORM EasyDBO lazy true <class name="com.easyjf.dbo.example.orderdetail" table="orderdetail" schema="dbo" catalog="easyjf"> <id name="cid" type="string"> </id> <column name="cid" length="16" not-null="true" /> <generator class="com.easyjf.dbo.randomidgenerator" /> <property name="num" type="integer" > <column name="num" length="" /> </property> <property name="price" type="java.math.bigdecimal"> <column name="price" length="" /> </property> <one-to-one name="order" type="com.easyjf.dbo.example.order" column="orderid" key="cid" lazy="true"> </one-to-one> <one-to-one name="product" type="com.easyjf.dbo.example.product" column="productid" key="cid"> </one-to-one> </class> order EasyJDB get(class cls, Object id) OrderDetail oder public class OrderDetail private String e) 25

28 EasyJF private Order private Product private Integer private java.math.bigdecimal price;... order 3.14 EasyDBO ) EasyJDB false commit() close JDBC EasyJDB db=easyjdb.getinstance(); db.setautocommit(false);// Message m=new Message(); Message m2=new Message(); m.settitle(" "); m2.settitle(" 2"); m.setinputtime(new java.util.date()); db.add(m); db.add(m2); db.commit(); // db.close();// add(m),add(m2) 3.15 EasyDBO EasyDBO (FO) List EasyJDB java.util.list callquery(java.lang.string procedurename) DBObject java.util.list callquery(java.lang.string procedurename, java.lang.object[] parameter) DBObject void callupdate(java.lang.string procedurename) 26

29 EasyJF void callupdate(java.lang.string procedurename, java.lang.object[] parameter) EasyJDB easyjdb=new EasyJDB(dataSource); List list=easyjdb.callquery("getpm",new Object[]{" "); for(int i=0;i<list.size;i++) { DBObject obj=(dbobject)list.get(i); System.out.println(obj.get("title")); System.out.println(obj.get("num")); getpm EasyJDB 4.1 boolean add(java.lang.object obj) obj boolean update(java.lang.object obj) obj boolean saveorupdate(java.lang.object obj) obj boolean del(java.lang.object obj) obj DOM( PO) EasyDBO obj (FO) DBObject sql sql EasyDBO saveorupdate update add EasyJDB execute sql 4.2 DOM(PO) java.lang.object get(java.lang.class cls, java.lang.object id) cls null. id 27

30 EasyJF Message message=(message)db.get(message.class,"1111"); java.lang.object read(java.lang.class cls, java.lang.string scope) Message message=(message)db.get(message.class,"inputuser=' '"); sql sql java.lang.object read(java.lang.class cls, java.lang.string scope, java.util.collection params) scope "?" java.util.collection paras=new java.util.arraylist(); paras.add(" "); Message message=(message)db.get(message.class,"inputuser=?",paras); sql jdbc 4.3 DOM(PO) java.util.list query(java.lang.class cls, java.lang.string scope) cls! java.util.list list=db.query(message.class,"inputuser=' '"); inputuser Message sql jdbc java.util.list query(java.lang.class cls, java.lang.string scope, java.util.collection params) cls java.util.collection paras=new java.util.arraylist(); paras.add(" "); java.util.list list=db.query(message.class,"inputuser=?",paras); inputuser Message java.util.list query(java.lang.class cls, java.lang.string scope, java.util.collection params, int begin, int max) sql begin,max cls 28

31 EasyJF java.util.collection paras=new java.util.arraylist(); paras.add(" "); java.util.list list=db.query(message.class,"inputuser=?",paras,100,10); inputuser java.util.list query(java.lang.class cls, java.lang.string scope, java.util.collection params, int begin, int max, boolean cache) sql begin,max cls java.util.collection paras=new java.util.arraylist(); paras.add(" "); java.util.list list=db.query(message.class,"inputuser=?",paras,100,10,true); 4.4 FO(Fan Object) java.util.list query(java.lang.string sql) sql DBObject java.util.list query(java.lang.string sql, java.util.collection params) sql DBObject java.util.list query(java.lang.string sql, java.util.collection params, int begin, int max) sql begin,max DBObject java.util.list query(java.lang.string sql, java.util.collection params, int begin, int max, boolean cache) sql begin,max DBObject SQL select * from Message where inputuser=' ' DBObject java.util.collection paras=new java.util.arraylist(); paras.add(" "); java.util.list list=db.query("select * from Message where inputuser=?",paras,0,10,true); for(int i=0;i<list.size();i++) { DBObject obj=(dbobject)list.get(i); System.out.println(obj.get("title")); 29

32 EasyJF 4.5 java.lang.object uniqueresult(dbtable table, DBField field, java.io.serializable value) DBTable DBField java.lang.object uniqueresult(java.lang.string sql) sql java.lang.object uniqueresult(java.lang.string sql, boolean cache) sql cache java.lang.object uniqueresult(java.lang.string sql, java.util.collection params) sql java.lang.object uniqueresult(java.lang.string sql, java.util.collection params, boolean cache) sql cache uniqueresult sql Java Number String DOM(PO) FO uniqueresult sql sql Number num=(number)db.uniqueresult("select count(*) from Message"); Message java.util.collection paras=new java.util.arraylist(); paras.add("1"); String title=(string)db..uniqueresult("select title from Message where cid=?",paras); Message cid "1" title 4.6 sql int execute(java.lang.string sql) sql int execute(java.lang.string sql, java.util.collection params) params sql sql sql EasyJDB execute sql Statement JDBC db.execute("update Message set status=2 where status<1"); 4.7 java.util.list callquery(java.lang.string procedurename) java.util.list callquery(java.lang.string procedurename, java.lang.object[] parameter) 30

33 EasyJF void callupdate(java.lang.string procedurename) void callupdate(java.lang.string procedurename, java.lang.object[] parameter EasyDBO 15 EasyDBO 5.1 EasyDBO EasyJWeb EasyDBO EasyJWeb EasyJWeb EasyDBO EasyJWeb EasyDBO EasyJWeb EasyDBO EasyDBO EasyJWeb EasyJWeb ORM EasyJWeb CRUDAction Action DAO IDAO IDAO public interface IDAO { boolean save(object obj); boolean update(object obj); boolean del(object obj); Object get(class clz, Serializable id); Object getby(class clz, String fieldname, Serializable value); List query(class clz, String scope); List query(class clz, String scope, Collection paras); List query(class clz, String scope, Collection paras, int begin, int max); Object uniqueresult(string sql); Object uniqueresult(string sql,collection paras); int execute(string sql); int execute(string sql,collection paras); // SQL EasyJWeb EasyDBO IDAO EasyDBODAO, public class EasyDBODAO implements IDAO { private static final EasyDBODAO singleton = new EasyDBODAO(); private EasyJDB db; public EasyDBODAO() { public EasyDBODAO(EasyJDB db) { this.db = db; public EasyJDB getdb() { return db; public void setdb(easyjdb db) { this.db = db; 31

34 EasyJF... public boolean save(object obj) { return db.add(obj); public Object get(class clz, Serializable id) { return db.get(clz, (Object) id); AbstractCrudAction IDAO autoloaddao EasyDBO protected IDAO autoloaddao(module module) { return EasyDBODAO.getInstance(); EasyJWeb Tools EasyJWeb EasyJWeb Tools Action /** * action easyjwebtools * */ public class MessageAction extends CrudAction { /** * AbstractCrudAction */ public IPageList doquery(webform form, int currentpage, int pagesize) { String scope = "1=1"; Collection paras = new ArrayList(); String ordertype = CommUtil.null2String(form.get("orderType")); String orderfield = CommUtil.null2String(form.get("orderField")); paras); if (!"".equals(orderfield)) { scope += " order by " + orderfield; if (!"".equals(ordertype)) scope += " " + ordertype; DbPageList plist = new DbPageList(Message.class, scope, plist.dolist(currentpage, pagesize); 32

35 EasyJF return plist; /** * Form java * */ public Object form2obj(webform form) { String cid = (String) form.get("cid"); Message obj = null; if (cid!= null && (!cid.equals(""))) obj =(Message)this.getDao().get(Message.class,cid); if (obj == null) obj = new Message(); return form.topo(obj); 5.2 EasyDBO Spring EasyDBO EasyDBO Setter spring spring EasyDBO EasyDBO bean DataSource <bean id="datasource" class="org.apache.commons.dbcp.basicdatasource" destroy-method="close"> <property name="driverclassname"> <value> </value> </property> <property name="url"> <value> </value> </property> <property name="username"> <value>root</value> </property> <property name="password"> <value>stef</value> </property> </bean> EasyDBO EasyJDB bean EasyJDB <bean id="easydbo" class="com.easyjf.dbo.easyjdb" singleton= true > </bean> <property name="datasource" ref="datasource"></property> 33

36 EasyJF EasyJDB singleton EasyDBO Message Message public interface IMessageService { boolean add(message message); boolean del(message message); boolean update(message message); List getallmessages(); public class MessageService implements IMessageService { private EasyJDB db; public EasyJDB getdb() { return db; public void setdb(easyjdb db) { this.db = db; public boolean add(message message){ return this.getdb().add(message); public boolean del(message message){ return this.getdb().del(message); public boolean update(message message){ return this.getdb().update(message); public List getallmessages(){ return this.getdb().query(message.class, "1=1"); public class MessageTest { private IMessageService messageservice; /** the messageservice */ public IMessageService getmessageservice() { return messageservice; 34

37 EasyJF /** messageservice the messageservice to set */ public void setmessageservice(imessageservice messageservice) { this.messageservice = messageservice; public void test(){ Message m=new Message(); m.settitle(" "); m.setcontent(" "); m.setinputtime(new java.util.date()); m.setinputuser("easyjf"); m.setstatus(new Integer(0)); if(this.getmessageservice().add(m)){ System.out.println("??"); java.util.list list=this.getmessageservice().getallmessages(); Message m2=(message)list.get(0); System.out.println(m2.getTitle()); System.out.println(m2.getContent()); m2.settitle(" "); if(this.getmessageservice().update(m2)){ System.out.println(" "); public static void main(string[] args){ ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml"); MessageTest test=(messagetest)context.getbean("messagetest"); test.test(); applicationcontext.xml <bean name="messageservice" class="impl.messageservice"> </bean> <property name="db" ref="easydbo"></property> <bean name="messagetest" class="test.messagetest"> <property name="messageservice" ref="messageservice"></property> 35

38 EasyJF </bean> spring debug EasyDBO spring hibernate ibaits cache <bean id="easydbo" class="com.easyjf.dbo.easyjdb" </bean> singleton="true"> <property name="datasource" ref="datasource"></property> <property name="configfiles"> <list> </list> </property> <value>/mappings.xml</value> <property name="showsql" value="true"></property> <property name="enablecache" value="true"></property> <property name="innercache" ref="dcache"></property> <bean name="dcache" class="com.easyjf.dbo.dbocache"> </bean> <property name="cache" ref="easycache"></property> <bean name="easycache" class="com.easyjf.cache.easycache" /> Message mapping /mappings.xml Message javabean setter cache showsql=true for(int i=0;i<5;i++){ java.util.list list=this.getmessageservice().getallmessages(); Message m2=(message)list.get(0); System.out.println(m2.getTitle()); System.out.println(m2.getContent()); debug [main] INFO com.easyjf.cache.store.memorystore - defaultcache: defaultmemorystore OBJECT:domain.Message: [main] INFO com.easyjf.cache.store.memorystore - defaultcache: defaultmemorystore OBJECT:domain.Message:2 Cache 36

39 EasyJF 5.3 Struts EasyDBO struts spring EasyDBO EasyDBO action hibernate struts plugin plugin EasyDBO applicationcontext session action EasyDBO action message BaseDaoAction public class BaseDaoAction extends Action { private EasyJDB easyjdb; protected EasyJDB geteasyjdb() { if(easyjdb==null){ easyjdb=initjdb(); return easyjdb; private EasyJDB initjdb(){ BasicDataSource datasource = new BasicDataSource(); datasource.setdriverclassname("org.gjt.mm.mysql.driver"); datasource.seturl("jdbc:mysql:// :3306/easydbotest"); datasource.setusername("root"); datasource.setpassword("mysql"); com.easyjf.dbo.easyjdb db=new com.easyjf.dbo.easyjdb(datasource); return db; ActionForm: MessageForm: public class MessageForm extends ActionForm { private String title; private String content; public String getcontent() { //... return content; MessageAction: public class MessageAction extends BaseDaoAction { public ActionForward execute( ActionMapping mapping, ActionForm form, HttpServletRequest request, 37

40 EasyJF HttpServletResponse response) throws Exception { MessageForm messageform=(messageform)form; Date date=new Date(); String title=messageform.gettitle(); String content=messageform.getcontent(); Message message=new Message(); message.settitle(title); message.setcontent(content); if(this.geteasyjdb.add(message)){ return mapping.findforward("successed"); return mapping.findforward("faild"); Message EasyDBO 6.1 EasyJF Blog EasyJF Blog EasyJF Java Blog RSS html OO B/S EasyDBO Web EasyJWeb java Java SVN java ( 0.5, 10 1 ) java UBB OO B/S EasyDBO Web EasyJWeb java Java SVN java ( : ) Java, Web MVC EasyJWeb Java Web., Web 38

41 EasyJF My SQL MS SQL Server AJAX WEB :test :test EasyJF iula-0.1.0( : ) EasyJF iula AJAX+EasyJWeb+EasyDBO EasyJF iula AJAX svn EasyDBO : EasyDBO 7 EasyDBO EasyJF EasyDBO ( ) QQ , , , EasyJF EasyJF easyjf at 163.com easyjf at 126.com 39

42 EasyJF 40