分享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 社区

在线工具

QQ交流群

微信公众号

OSCHINA APP