数据库访问简单实现---edainfo-model（三）——简单例子

下面就正式来讲一下开发步骤：

首先，在Tomcat5.X下建一个jdbc/edainfo的数据源，数据库可以是oracle、sql server、mysql。表的结构如下：

CREATE TABLE example (

id varchar(13) NOT NULL ,

name varchar(50) NULL ,

address varchar(50) NULL

) ON [PRIMARY]

其中，id为主键。

datasource.xml内容如下：

<?xml version="1.0" encoding="gb2312"?>

<database>

<model name="exampleModel">

<tablename>example</tablename>

<columns>

<column type="0" name="id" tabColumn="id"/>

<column type="0" name="name" tabColumn="name"/>

<column type="0" name="address" tabColumn="address"/>

<column type="2" name="pageNum" tabColumn="pageNum"/>

<column type="2" name="operation" tabColumn="operation"/>

</columns>

<relations>

</relations>

<pk tabColumn="id" />

<pages>

<page name="fore" size="20" viewPage="5"/>

</pages>

</model>

</database>

init-config.xml前面已经介绍过，这里就不详细介绍了。

将以上两个文件都放置到WEB-INF目录下。

在web.xml中，建立一个net.edainfo.filter.SetCharacterEncodingFilter的过滤器。

建立一个ExampleModel.java，如下所示：

package net.edainfo.example;

import java.util.Map;

import net.edainfo.db.DBModel;

import net.edainfo.db.ModelException;

import net.edainfo.util.format.Encode;

import net.edainfo.util.format.StringProcessor;

public class ExampleModel extends DBModel {

public ExampleModel(Map dataBase) throws ModelException {

super("exampleModel" ,dataBase);

}

public void setId(String id) throws ModelException {

set("id" ,id);

}

public String getId() throws ModelException {

return getString("id");

}

public void setName(String name) throws ModelException {

set("name" ,name);

}

public String getName() throws ModelException {

return getString("name");

}

public void setAddress(String address) throws ModelException {

set("address" ,address);

}

public String getAddress() throws ModelException {

return getString("address");

}

}

建立一个异常类ExampleException.java：

package net.edainfo.example;

import net.edainfo.exception.BaseException;

public class ExampleException extends BaseException {

static public String createFailed = "exception.createFailed";

static public String retrieveFailed = "exception.retrieveFailed";

static public String updateFailed = "exception.updateFailed";

static public String deleteFailed = "exception.deleteFailed";

static public String[] exampleArgs = {"edainfo.example"};

}

再建立一个action，ExampleAction.java：

package net.edainfo.example;

import java.util.ArrayList;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import net.edainfo.db.DAO;

import net.edainfo.util.ActionBase;

import net.edainfo.util.EdaGlobals;

import net.edainfo.util.FormParameter;

import net.edainfo.util.page.PageList;

import org.apache.struts.action.ActionForm;

import org.apache.struts.action.ActionForward;

import org.apache.struts.action.ActionMapping;

import org.apache.struts.validator.DynaValidatorForm;

/**

* @author slf

*

* TODO To change the template for this generated type comment go to Window -

* Preferences - Java - Code Style - Code Templates

*/

public class ExampleAction extends ActionBase {

public ActionForward executeAction(ActionMapping mapping, ActionForm form,

HttpServletRequest request, HttpServletResponse response, Map params)

throws Exception {

DynaValidatorForm theForm = (DynaValidatorForm) form;

String next = "";

conn = this.getConnection();

String operation = (String) theForm.get("operation");

DAO dao = new DAO(conn, params.get(EdaGlobals.DATABASE_TYPE_KEY)

+ "");

if (operation == null || operation.equals(""))

operation = "list";

if (operation.equals("list")) {

ExampleModel model = new ExampleModel((Map) params

.get(EdaGlobals.DATA_BASE_KEY));

String pageNum = (String) theForm.get("pageNum");

if (pageNum == null || pageNum.equals("")) {

pageNum = "1";

}

theForm.set("pageNum" ,pageNum);

int pageSize = model.getPageSize("fore");

int viewPage = model.getViewPage("fore");

PageList lists = dao.select(model, "", new ArrayList(), "", Integer

.parseInt(pageNum), pageSize, viewPage, dao.DISTINCT_OFF);

Map parms = FormParameter.setListPage (theForm ,lists ,"example" ,

request);

request.setAttribute ("parms" ,parms);

next = "list";

} else if(operation.equals("add")) {

ExampleModel model = new ExampleModel((Map) params

.get(EdaGlobals.DATA_BASE_KEY));

model = (ExampleModel)FormParameter.getParameter (model ,theForm);

model.setId(dao.generateId());

dao.create(model);

next = "add";

} else if(operation.equals("addform")) {

next = "addform";

theForm.set("operation" ,"add");

}

return mapping.findForward(next);

}

}

然后是建立jsp页面，这里有两个页面，一个是浏览页，一个是表单页；

浏览页，listExample.jsp：

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

<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>

<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>

<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%>

<%

String linkPage = (String)request.getAttribute("linkPage");

%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<title><bean:message key="edainfo.example"/></title>

</head>

<body>

<table width="75%" border="0" align="center" cellpadding="3" cellspacing="1">

<tr>

<td colspan="2"><html:link action="example?operation=addform"><bean:message key="example.add"/></html:link></td>

</tr>

<tr>

<td width="47%"><bean:message key="example.name"/></td>

<td width="53%"><bean:message key="example.address"/></td>

</tr>

<logic:iterate name="lists" id="list">

<tr>

<td><bean:write name="list" property="name"/></td>

<td><bean:write name="list" property="address"/></td>

</tr>

</logic:iterate>

<tr align="center">

<td colspan="2">

<%@ include file="/turnPage.jsp" %>

</td>

</tr>

</table>

</body>

</html>

表单页，exampleForm.jsp：

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

<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%>

<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<title><bean:message key="edainfo.example"/></title>

</head>

<body>

<logic:messagesPresent>

<ul>

<html:messages id="error">

<li><bean:write name="error"/></li>

</html:messages>

</ul>

</logic:messagesPresent>

<html:form action="example">

<table width="75%" border="0" align="center" cellpadding="3" cellspacing="1">

<tr>

<td width="26%"><bean:message key="example.name"/></td>

<td width="74%"><html:text property="name" size="20"/></td>

</tr>

<tr>

<td><bean:message key="example.address"/></td>

<td><html:text property="address" size="20"/></td>

</tr>

<tr align="center">

<td colspan="2"><html:submit property="submit" styleClass="buttonface">

<bean:message key="button.save"/>

</html:submit></td>

</tr>

</table>

<html:hidden property="operation"/>

</html:form>

</body>

</html>

以上两个页面放到页面根目录下，请记得将请记得将turnPage.jsp也拷贝过来。

然后，我们在struts-config.xml中配置我们的action：

<?xml version="1.0" encoding="ISO-8859-1" ?>

<!DOCTYPE struts-config PUBLIC

"-//Apache Software Foundation//DTD Struts Configuration 1.1//EN"

"http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd">

<struts-config>

<!-- ========== Form Bean Definitions =================================== -->

<form-beans>

<form-bean name="exampleForm"

type="org.apache.struts.validator.DynaValidatorForm">

<form-property name="name" type="java.lang.String"/>

<form-property name="address" type="java.lang.String"/>

<form-property name="operation" type="java.lang.String"/>

<form-property name="pageNum" type="java.lang.String"/>

</form-bean>

</form-beans>

<!-- global exception definitions -->

<global-exceptions>

<exception handler="net.edainfo.exception.BaseExceptionHandler"

key="exception.unawareError"

path="/error.jsp"

scope="request"

type="java.lang.Exception"/>

</global-exceptions>

<!-- ========== Global Forward Definitions ============================== -->

<global-forwards type="org.apache.struts.action.ActionForward">

</global-forwards>

<!-- ========== Action Mapping Definitions ============================== -->

<action-mappings>

<action path="/example"

type="net.edainfo.example.ExampleAction"

name="exampleForm"

validate="false"

scope="request">

<forward name="list" path="/listExample.jsp"/>

<forward name="add" path="/example.do" redirect="true"/>

<forward name="addform" path="/exampleForm.jsp"/>

</action>

</action-mappings>

<!-- ========== Message Resources Definitions =========================== -->

<message-resources

null="false"

parameter="ApplicationResources"/>

<!-- ========== Plug Ins Configuration ================================== -->

<!--

Add multiple validator resource files by setting the pathnames property

with a comma delimitted list of resource files to load.

-->

<plug-in className="org.apache.struts.validator.ValidatorPlugIn">

<set-property property="pathnames" value="/WEB-INF/validator-rules.xml,

/WEB-INF/validation.xml"/>

</plug-in>

</struts-config>

在WEB-INF/lib下记得要放如下包：struts1.1及它的相关包、jfreechart及其相关包、edabase-model.jar、log4j-1.2.8.jar、jdom.jar、xercesImpl.jar、xmlParserAPIs.jar。

现在已经完成，启动tomcat，在浏览器中敲如http://xxxxx/example.do，就可以看到效果了。

在这里，主要演示了edainfo-model的数据库操作、分页及actionform中批量的获取数据，如果你已经对它发生兴趣了，请继续关注本站的相关文章，还有更多精彩的内容等着你。

下面是这个例子的完整源码下载：

edainfo-model简单例子下载

• ·php页面访问时，统一进行权限验证的设计
• ·oracle系统紧急故障处理方法
• ·Applying Abstract Facto
• ·MetaProgramming 求π源代码
• ·成熟度与成长
• ·一个不错的社会性软件研究 Blog
• ·设计模式读书笔记(读后感)
• ·设计模式读书笔记(9)
• ·Sun 公开开发中的J2SE下一个版本源代码
• ·Abstract Factory模式示例（使用