分享SimpleFramework开发新增,删除,修改,分页,导出

Simpleframework 修改与明细实现，从零开始体验simple,包括simple基础文件配置步骤。

说明

上一篇介绍了基于SimpleFramework 开发新增,删除,修改,查询，这篇贴出对修改于明细做了补充，经过最近对simple的学习，在代码实现中去掉了menu组件，力求从零基础介绍如何基于simple开发应用，如果没有说清楚的地方，希望大家指正。

经过实践，个人觉得基于simple开发应用，在展现层可以使用页面handleClass，不需要破坏html页面，后台业务处理可以调用组件的确可以加快开发速度，关于开发技巧还需要要继续探索，并愿意与志同道合者多多交流。

文件一,web.xml，拷贝到WEB-INF目录下(已经有simple工程跳过该步骤)。

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee"

xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

id="WebApp_ID" version="2.5">

<display-name>simpleframework</display-name>

<welcome-file-list>

<welcome-file>index.html</welcome-file>

<welcome-file>index.htm</welcome-file>

<welcome-file>index.jsp</welcome-file>

<welcome-file>default.html</welcome-file>

<welcome-file>default.htm</welcome-file>

<welcome-file>default.jsp</welcome-file>

</welcome-file-list>

<session-config>

<session-timeout>1</session-timeout>

</session-config>

<servlet-name>startup</servlet-name>

<servlet-class>net.simpleframework.web.SimpleWebApplication</servlet-class>

<load-on-startup>0</load-on-startup>

</servlet>

<filter-name>actionFilter</filter-name>

<filter-class>net.simpleframework.web.page.PageFilter</filter-class>

<init-param>

<param-name>initializerHandle</param-name>

<param-value>net.simpleframework.example.MyPageInitializer</param-value>

</init-param>

</filter>

<filter-mapping>

<filter-name>actionFilter</filter-name>

<url-pattern>*.jsp</url-pattern>

</filter-mapping>

<listener-class>net.simpleframework.web.page.PageEventAdapter</listener-class>

</listener>

<error-page>

<error-code>404</error-code>

<location>/template/404.jsp</location>

</error-page>

</web-app>

文件二，project.xml，拷贝到WEB-INF目录下 (已经有simple工程跳过该步骤)。

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

<bean id="defaultDatasource" class="org.apache.commons.dbcp.BasicDataSource"

destroy-method="close">

<property name="url"

value="jdbc:mysql://127.0.0.1:3306/simple3?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8" />

</bean>

</bean>

</bean>

</bean><bean id="idNotificationInitializer" class="net.simpleframework.notification.NotificationInitializer">

</bean>

</bean>

<list>

</list>

</property>

<value>net.simpleframework.ado.db.cache.MapTableEntityManager</value>

</property>

</bean>

</beans>

第三步，编写演示例子数据库脚本（这才是开发的第一步）。

CREATE TABLE `simple_framework_test` (

`id` int(32) default NULL,

`version` varchar(128) default NULL,

`name` varchar(128) default NULL,

`description` varchar(128) default NULL

) ;

第四步，编写TestHandle.java（该类实现了新增，修改，删除，该类继承了AbstractAjaxRequestHandle）。

package net.simpleframework.test;

import java.util.HashMap;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import javax.sql.DataSource;

import net.simpleframework.ado.DataObjectManagerFactory;

import net.simpleframework.ado.db.ITableEntityManager;

import net.simpleframework.ado.db.schema.ExpressionValue;

import net.simpleframework.ado.db.schema.Table;

import net.simpleframework.ado.id.ID;

import net.simpleframework.web.IWebApplication;

import net.simpleframework.web.page.IForward;

import net.simpleframework.web.page.UrlForward;

import net.simpleframework.web.page.component.ComponentParameter;

import net.simpleframework.web.page.component.base.ajaxrequest.AbstractAjaxRequestHandle;

public class TestHandle extends AbstractAjaxRequestHandle {

// 新增本例只是dmeo,并没有做到公用方法抽象与优化

public IForward doSave(final ComponentParameter compParameter)

throws Exception {

final DataSource dataSource = IWebApplication.Instance.getWebApplication().getDataSource();

Table table = new Table("simple_framework_test");

ITableEntityManager entityManager = DataObjectManagerFactory.getTableEntityManager(dataSource, table);

Map<String, Comparable> insertData = new HashMap<String, Comparable>();

final HttpServletRequest request = compParameter.request;

// request.getParameter

String id = (String) request.getParameter("id2");// 获得修改的id

if (id != null) {

insertData.put("id", id);

insertData.put("version",compParameter.getRequestParameter("version2"));

insertData.put("name", compParameter.getRequestParameter("name2"));

insertData.put("description",compParameter.getRequestParameter("description2"));

entityManager.update(insertData);

} else { // 新增

insertData.put("id", (Comparable) ID.Utils.newID(entityManager.nextIncValue("id")));

insertData.put("version",compParameter.getRequestParameter("version"));

insertData.put("name", compParameter.getRequestParameter("name"));

insertData.put("description",compParameter.getRequestParameter("description"));

entityManager.insert(insertData);

}

return jsonForward(new JsonCallback() {

@Override

public void doAction(Map<String, Object> json) throws Exception {

json.put("ok", true);

}

});

}

// 删除

public IForward doDeleteTest(final ComponentParameter compParameter)

throws Exception {

final DataSource dataSource = IWebApplication.Instance.getWebApplication().getDataSource();

Table table = new Table("simple_framework_test");

ITableEntityManager entityManager = DataObjectManagerFactory.getTableEntityManager(dataSource, table);

String id = compParameter.getRequestParameter("testId");

entityManager.delete(new ExpressionValue("id=?", new Object[] { id }));

return jsonForward(new JsonCallback() {

@Override

public void doAction(Map<String, Object> json) throws Exception {

json.put("ok", true);

}

});

}

第五步，编写TestPagerHandle.java （该类实现了表格列表，导出，分页功能）。

package net.simpleframework.test;

import java.util.HashMap;

import java.util.Map;

import javax.sql.DataSource;

import net.simpleframework.ado.DataObjectManagerFactory;

import net.simpleframework.ado.IDataObjectQuery;

import net.simpleframework.ado.db.IQueryEntityManager;

import net.simpleframework.ado.db.schema.SQLValue;

import net.simpleframework.web.IWebApplication;

import net.simpleframework.web.page.component.ComponentParameter;

import net.simpleframework.web.page.component.ui.pager.AbstractTablePagerData;

import net.simpleframework.web.page.component.ui.pager.AbstractTablePagerHandle;

import net.simpleframework.web.page.component.ui.pager.TablePagerBean;

import net.simpleframework.web.page.component.ui.pager.TablePagerColumn;

public class TestPagerHandle extends AbstractTablePagerHandle {

@Override

public Object getBeanProperty(final ComponentParameter compParameter,

final String beanProperty) throws Exception {

if ("title".equals(beanProperty)) {

final StringBuilder sb = new StringBuilder();

sb.append("<a style=\"margin-left: 10px;\" onclick=\"$Actions['")

.append(compParameter.componentBean.getName())

.append("'].exportFile(null, false);\">导出</a>");

return sb.toString();

}

return super.getBeanProperty(compParameter, beanProperty);

}

@Override

public IDataObjectQuery<?> createDataObjectQuery(

final ComponentParameter compParameter) throws Exception {

final DataSource dataSource = IWebApplication.Instance.getWebApplication().getDataSource();

final IQueryEntityManager queryManager = DataObjectManagerFactory.getQueryEntityManager(dataSource);

final IDataObjectQuery<Map<String, Object>> data = queryManager.query(new SQLValue("SELECT * FROM simple_framework_test s"));

return data;

}

// 这个方法对业务数据做相关处理相当的重要

@Override

public AbstractTablePagerData createTablePagerData(final ComponentParameter compParameter)

throws Exception {

return new AbstractTablePagerData(compParameter) {

@Override

protected Map<String, TablePagerColumn> getTablePagerColumns() {

return ((TablePagerBean) compParameter.componentBean).getColumns();

}

@SuppressWarnings("unchecked")

@Override

protected Map<Object, Object> getRowData(final Object dataObject) throws Exception {

final Map<Object, Object> dataObjectMap = new HashMap<Object, Object>();

final Map map = (Map) dataObject;

// 拼装查看url

final StringBuffer name = new StringBuffer(200);

name.append("<a ");

name.append("onclick=\"");

name.append("$Actions['viewTestWindow']('view=true&testId="+ map.get("id") + "')");

name.append("\"");

name.append(">");

name.append(map.get("name").toString());

name.append("</a>");

map.put("name",name);

dataObjectMap.putAll((Map<? extends Object, ? extends Object>) map);

dataObjectMap.put("action","<a onclick=\"$Actions['DeleteTest']('testId="+ map.get("id") + "');$Actions['TestListPager'].refresh();\">删除</a> <a onclick=\"$Actions['addOrUpdateTestWindow']('testId="+ map.get("id") + "');\">修改</a>");

//dataObjectMap.put("action","<a class=\"TestPagerRowStyle down_menu_image\"></a>"); // 这是数据菜单绑定相关操作按钮

return dataObjectMap;

}

@Override

protected Map<Object, Object> getRowAttributes(final Object dataObject) throws Exception {

final Map<Object, Object> attributes = super.getRowAttributes(dataObject);

attributes.put(ROW_ID,((Map) dataObject).get("id") ); // 如果不封装bean,需要特殊处理

//attributes.put("name",((Map) dataObject).get("name") );

final Map<Object, Object> attributes2 = getTableRowAttributes(dataObject);

if (attributes2 != null) {

attributes.putAll(attributes2);

}

return attributes;

}

};

}

第六步，编写TestModify.java （修改实现）。

package net.simpleframework.test;

import java.util.List;

import java.util.Map;

import javax.sql.DataSource;

import net.simpleframework.ado.DataObjectManagerFactory;

import net.simpleframework.ado.db.ITableEntityManager;

import net.simpleframework.ado.db.schema.Table;

import net.simpleframework.ado.db.schema.UniqueValue;

import net.simpleframework.web.IWebApplication;

import net.simpleframework.web.page.DefaultPageHandle;

import net.simpleframework.web.page.PageParameter;

public class TestModify extends DefaultPageHandle {

@Override

public void pageLoad(final PageParameter pageParameter, final Map<String, Object> dataBinding,

final List<String> visibleToggleSelector, final List<String> readonlySelector,

final List<String> disabledSelector) throws Exception {

String id = pageParameter.request.getParameter("testId"); // 获得需要修改

String view = pageParameter.request.getParameter("view"); // 页面是否只读

final DataSource dataSource = IWebApplication.Instance.getWebApplication().getDataSource();

Table table = new Table("simple_framework_test");

ITableEntityManager entityManager = DataObjectManagerFactory.getTableEntityManager(dataSource,table);

// 根据id 查询需要修改的对象

Map date = entityManager.queryForMap(new UniqueValue(id));

// simple 提供的数据绑定,在jsp页面自动填充字段

dataBinding.put("id2", id);

dataBinding.put("name2", date.get("name"));

dataBinding.put("description2", date.get("description"));

dataBinding.put("version2", date.get("version"));

if(view!=null) {

readonlySelector.add("#ajaxTestParams input"); // simple 控制 input 页面显示只读

}

第七步，编写test.jsp 与 test.xml （大家可以看下jsp 文件，都是标准的html元素，xml文件中定义组件元信息，页面通过CSS选择器和组件绑定，所有simple不需要标签库）。

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>

<tr>

<td> <h1 align="center">基于SimpleFramework 开发新增,删除,修改,查询</h1></td>

</tr>

</table>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</div>

------------------------------------------------下面是 test.xml--------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>

<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:noNamespaceSchemaLocation="/xsd/default/simple.xsd">

<scriptEval>first</scriptEval>

<ajaxRequest name="TestSave" handleClass="net.simpleframework.test.TestHandle"

handleMethod="doSave" formSelector="#ajaxTestParams">

if (json["ok"])

alert("ok");

$Actions['TestListPager'].refresh();

</jsCompleteCallback>

</ajaxRequest>

<ajaxRequest name="DeleteTest"

handleClass="net.simpleframework.test.TestHandle"

handleMethod="doDeleteTest">

<![CDATA[

if(json['ok'] == 'true'){

alert('删除成功');

}

]]>

</jsCompleteCallback>

</ajaxRequest>

<tablePager name="TestListPager" containerId="testTablePager"

handleClass="net.simpleframework.test.TestPagerHandle" showCheckbox="true">

<column columnName="name" columnText="产品名称" separator="true"

style="text-align: center;width: 120px;" headerStyle="width: 120px;" />

<column columnName="description" columnText="产品描述" separator="true"

style="text-align: center;width: 120px;" headerStyle="width: 120px;" />

<column columnName="version" columnText="产品版本" separator="true"

style="text-align: center;width: 120px;" headerStyle="width: 120px;" />

<column columnName="action" sort="false" separator="true"

style="text-align: center; width: 64px;" headerStyle="width: 64px;"

columnText='操作' />

</columns>

</tablePager>

<urlForward>/modify.jsp</urlForward>

</ajaxRequest>

<window name="addOrUpdateTestWindow"

contentRef="addOrUpdateTestAjaxRequest" title="测试修改" minWidth="550"

minHeight="380" resizable="true" destroyOnClose="true">

</window>

</ajaxRequest>

<window name="viewTestWindow"

contentRef="viewTestAjaxRequest" title="查看" minWidth="550"

minHeight="380" resizable="true" destroyOnClose="true">

</window>

</components>

</page>

第八步，编写modify.jsp 与 modify.xml

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<tr>

<td> <h1 align="center">基于SimpleFramework 开发修改</h1></td>

</tr>

</table>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

----------下面是 modify.xml--------------

<?xml version="1.0" encoding="UTF-8"?>

<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:noNamespaceSchemaLocation="/xsd/default/simple.xsd">

<scriptEval>first</scriptEval>

net.simpleframework.test.TestModify

</handleClass>

</page>

第九步，编写view.jsp 与 view.xml

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<tr>

<td> <h1 align="center">基于SimpleFramework 开发修改</h1></td>

</tr>

</table>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

----------------下面是 view.xml --------------------

<?xml version="1.0" encoding="UTF-8"?>

<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:noNamespaceSchemaLocation="/xsd/default/simple.xsd">

<scriptEval>first</scriptEval>

net.simpleframework.test.TestModify

</handleClass>

</page>

下图是工程的文件结构图：

运行效果如下：

附件： SimpleFramework Helloword 工程下载

本例代码下载

注：需要手工把本例代码拷贝到 simpleFramework Helloword 工程中，如果没有描述清楚的地方，请大家论坛讨论。

分享SimpleFramework开发新增,删除,修改,分页,导出

sim...的其他提问

类似问题

OSCHINA 社区

在线工具

微信公众号

OSCHINA APP

OSCHINA App —— 关注技术领域的头条文章

分享SimpleFramework开发新增,删除,修改,分页,导出

sim...的其他提问

类似问题

OSCHINA 社区

在线工具

微信公众号

OSCHINA APP

OSCHINA App ——
关注技术领域的头条文章