Freemarker---IsMy

刚刚接触了FreeMarker觉得不错

做了个小例子

首先建立个数据表里面有username,password两个字段自己随便加几条数据

建立一个Webwork action TestAction.Java

在struts.xml里加入如下内容

----------------------------------------

<action name="test" class="com.action.TestAction">

<result name="success" type="freemarker">/test.flt</result>

</action>

----------------------------------------

TestAction.java代码如下

----------------------------------------

package com.action;

import com.opensymphony.xwork.ActionSupport;

import java.util.*;

import com.ResultGather;

public class TestAction extends ActionSupport

{

private List lis;

private ResultGather rs;

public List getLis()

{

return this.lis;

}

public String execute() throws Exception

{

rs = new ResultGather();

lis = rs.selectRS("select * from userbasedatum");//数据结果我是用List,HashMap封装的,HashMap存的是单条记录

return SUCCESS;

}

}

---------------------------------------------------

ResultGather.java代码如下

---------------------------------------------------

package com;

import conn.DBConnManager;//数据库连接池

import java.sql.*;

import java.util.*;

public class ResultGather

{

private String sql;

public ResultGather()

{

}

public ResultGather(String sqlcom)

{

this.sql=sqlcom;

}

public List selectRS(String sqlStr)

{

this.sql = sqlStr;

return selectRS();

}

public List selectRS() //数据结果在这里装入List和Map

{

List rsall = new ArrayList();

DBConnManager conn = null;

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

Map rsTree;

try{

conn = DBConnManager.getInstance();

con = conn.getConnection("MSSQL");

stmt = con.createStatement();

rs = stmt.executeQuery(sql);

ResultSetMetaData rsmd = rs.getMetaData();

int numberOfColumns = rsmd.getColumnCount();

while(rs.next())

{

rsTree = new HashMap(numberOfColumns);

for(int r=1;r<numberOfColumns 1;r )

{

rsTree.put(rsmd.getColumnName(r),rs.getObject(r));

­

}

rsall.add(rsTree);

}

­

}catch(java.lang.Exception ex){

ex.printStackTrace();

}finally{

try{

if(rs!=null)

rs.close();

if(stmt!=null)

stmt.close();

if(conn!=null)

conn.releaseConnection("mssql",con);

}catch(Exception e){

System.out.println(e);

}

}

return rsall;

}

}

-------------------------------------------------------------

test.flt代码如下

-------------------------------------------------------------

<#list lis as x>

${x.username},

${x.password}<br>

</#list> //freemarker用法网上有相关介绍

-------------------------------------------------------------

OK 完成了 没有用到JSP<%.....%>和jsptag

用这个例子做一点修改就可以具有分页用能了