分享

webwork Freemarker较完整的GRUD数据库操作例子(简单方便使用同一个页面...

 WindySky 2007-05-25

这个例子也是一直以来用webwork的足见形成的方式
虽然是简单例子,一些细节部分也做上去了

以下是简单说明,详细可以参看源码

VIEW
通常一个insert,update操作都可以通过一个页面来完成,
这里我设置form 的 action=""  这样他默认提交到的是当前URL。

ACTION
在中定义几个方法,以user!insert.ww的方式访问,
这样grud操作就可以在一个ACTION中完成。
    public String insert() throws Exception {
        ....
    }

    public String update() throws Exception {
        ....
    }

    public String delete() throws Exception {
        ....
    }

    public String list() throws Exception {
        ....
    }

DAO
下面是DAO接口
public interface BaseDao {
    public int insert(Object form);
    public int update(Object form);
    public int delete(Object form);
    public int delete(int[] id);//这里是为了支持批量删除
    public Map getInfo(Object form);
    public List getList();
    public void getList(Pagination page);//这里没有返回值,内详。。。。
}

EXTENDS
扩展部分
1 BaseAction
这里增加了一些公用方便的功能,便于其他ACTION继承,共用
2 DaoSupport
这里也是一些公用的功能,Dao中用的大部分SQL都是配置在外部配置文件中


3DaoFactory
public class DaoFactory {
    public static BaseDao getDao(String daoKey){
        if("user".equals(daoKey)) //这样的方式可以通过在XWORK.XML中配置ACTION使用哪个DAO(静态注入)
            return new UserDao();
        else
            return null;

    }
}


数据库是MYSQL5

CREATE TABLE `usertbl` (                                                                                                                                                                                                                                                                                                                
           `User_ID` int(11) NOT NULL auto_increment,                                                                                                                                                                                                                                                                                            
           `username` varchar(50) default NULL,                                                                                                                                                                                                                                                                                                  
           `password` varchar(50) default NULL,                                                                                                                                                                                                                                                                                                  
           `truename` varchar(50) default NULL,                                                                                                                                                                                                                                                                                                  
           `usersex` tinyint(4) default NULL,                                                                                                                                                                                                                                                                                                    
           `useremail` varchar(50) default NULL,                                                                                                                                                                                                                                                                                                 
           PRIMARY KEY  (`User_ID`)                                                                                                                                                                                                                                                                                                              
         )


源码下载地址
http://www./download.ww

    本站是提供个人知识管理的网络存储空间,所有内容均由用户发布,不代表本站观点。请注意甄别内容中的联系方式、诱导购买等信息,谨防诈骗。如发现有害或侵权内容,请点击一键举报。
    转藏 分享 献花(0

    0条评论

    发表

    请遵守用户 评论公约

    类似文章 更多