Giter Site home page Giter Site logo

crud's Introduction

CRUD

安装使用图文说明

CRUD is Really Urgly coDed -- 快速原型系统与通用后台

默认账号admin 密码admin

支持导入xls文件,直接生成表格,若表格已存在则导入数据。

支持查看界面,双击修改数据。

支持超文本编辑、文件上传。

新增权限管理,guest用户,显示内容单页含二维码。

数据库配置文件在WEB-INF/db.prop

image

约定如下:

1、每个表必须有id,自增类型

2、每个表id后的第一个字符型字段被当做外键关联的显示值

3、外键一律以表名_id进行命名。

datadic表用于翻译英文表名列名到中文,建表语句在db.sql。

除config/datadic/privilege/user四张系统表以外,样例表可以删除。 符合上述原则设计表,自动实现菜单、各表增删改,用于快速建立小型系统原型。

新增用户没有权限,权限表里增加记录,rightstr格式为[表名/类]权限/方法。

如: [config]read为读取config表权限,[]admin为管理员权限。

[com.newsclan.crud.Tools]update 表示允许调用com.newsclan.crud.Tools.update方法。

正常连接数据库后,新建符合上述要求的数据表,刷新页面会自动出现新的菜单,点击可以展开数据进行增删改。权限可以为insert/read/update/delete/upload等

需要中文含义,在数据字典表中进行添加即可,刷新页面立刻生效。

date/timestamp类型的自动会激活日期时间控件。

text类型自动以CKEditor进行编辑,支持上传图片与附件。

以_file结尾的varchar字段可以上传文件,并记录路径。

_id结尾的外键,自动显示为下拉选择。

在config/配置中增加记录 type=report记录将出现在报表菜单中。 value里可以自定义sql,START_DATE END_DATE用于日期筛选,USER_ID用于用户筛选,FILTER用于关键词查询。

type=menu的记录直接出现在主菜单里, 相当于没有起止日期和过滤词的报表的快捷方式。

image image image image

crud's People

Contributors

zhblue avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

crud's Issues

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.