基于BaseSqlGeneratorJdbcDao的增删改查类编写示例

目的

可以简华增删改查的Dao开发，继承一个基类并配合JPA annotation即可完成一张表的增删改查

 

 

 

依赖

 

<!-- 自行检查是否有最新版本 -->
<dependency>
        <groupId>com.duowan.common</groupId>
        <artifactId>duowan-common-jdbc</artifactId>
        <version>1.0.2</version>
</dependency>   

 

Java Model类(支持JPA标注)

(支持@Table @Column @GeneratedValue @Id)

public class RssInfo {
        
        private int rssId;
        private String rssTitle;
        private String rssContent;
        
        @Id
        @GeneratedValue
        public int getRssId() {
                return rssId;
        }
        public void setRssId(int rssId) {
                this.rssId = rssId;
        }
        
        public String getRssTitle() {
                return rssTitle;
        }
        public void setRssTitle(String rssTitle) {
                this.rssTitle = rssTitle;
        }
        
        public String getRssContent() {
                return rssContent;
        }
        public void setRssContent(String rssContent) {
                this.rssContent = rssContent;
        }

        
}

 

Dao

 

import com.duowan.common.jdbc.sqlgenerator.support.BaseSqlGeneratorJdbcDao;
public class RssInfoDao extends BaseSqlGeneratorJdbcDao<RssInfo,Integer>{
}

 

增删改查测试代码

 

 

        @Test
        public void test() throws SQLException {
                RssInfo info = new RssInfo();
                info.setRssTitle("title1");
                info.setRssContent("content1");

                dao.insert(info);
                dao.update(info);
                assertNotNull(dao.getById(info.getRssId()));
                dao.deleteById(info.getRssId());
                assertNull(dao.getById(info.getRssId()));
        }

评论

1 楼 liuxihope 2015-10-10  

楼主啊，rapid-framework这么好的项目，怎么没有继续维护呢