剛剛接觸了FreeMarker覺(jué)得不錯(cuò)
做了個(gè)小例子
剛剛接觸了FreeMarker覺(jué)得不錯(cuò)做了個(gè)小例子,沒(méi)有用到j(luò)sp和jsptag
首先建立個(gè)數(shù)據(jù)表里面有username,password兩個(gè)字段自己隨便加幾條數(shù)據(jù)
建立一個(gè)webwork action TestAction.java
在xwork.xml里加入如下內(nèi)容
----------------------------------------
/test.flt
----------------------------------------
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");//數(shù)據(jù)結(jié)果我是用List,HashMap封裝的,HashMap存的是單條記錄
return SUCCESS;
}
}
-------------------------------------------------------------------------------------------------------------------
ResultGather.java代碼如下
----------------------------------------------------------
package com;
import conn.DBConnManager;//數(shù)據(jù)庫(kù)連接池
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() //數(shù)據(jù)結(jié)果在這里裝入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 {
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}
</#list>
//freemarker用法網(wǎng)上有相關(guān)介紹
-------------------------------------------------------------------------------------
OK 完成了 沒(méi)有用到j(luò)sp<%.....%>和jsptag
用這個(gè)例子做一點(diǎn)修改就可以具有分頁(yè)用能了