自制DataGrid

自己写的一个用java在表单生成的GRID
比较乱


package com.znmt.j2ee.common.datagrid;

import java.util.*;
import javax.servlet.jsp.*;
import javax.servlet.http.*;

/**
* <warn></warn>
* <p>Title:datagrid </p>
* <p>Description: 按照指定SQL语句及相应的设置枸造表格，以html表示</p>
* <p>Copyright: Tidedge Computer. Co., Ltd.</p>
* <p>Company: 泰克艾奇 中南迈特 </p>
* @author xuejun
* @version 1.0
* @serialData 2004/12/7
* History:// 历史修改记录
* <author> <time> <version > <desc>
* xuejun 2004/12/7 1.01 增加静态列设置,包括文字静态列，图像态列设置
* xuejun 2004/12/8 1.02 将主键值从td里移到链接字符串中
* xuejun 2004/12/26 1.03 增加图片显示列
* xuejun 2004/12/27 1.04 增加图片变换列，在页面上增加排序功能
* xuejun 2004/12/28 1.05 增加简单分页功能
*/

public class grid
{

String strSQl; //SQL语句
String[] primaryKeys; //主键列数组
String[] columnsName; //中文列名数组
ArrayList dlinkeColums = new ArrayList(2); //动态键接列数组
ArrayList slinkeColums = new ArrayList(2); //静态键接列数组
ArrayList showImgColums = new ArrayList(2); //图片显示列数组
ArrayList imgTransitionColums = new ArrayList(2); //图片转换列
boolean isHiddenCheck;

/**
* 初始化设置表格查询语句
* @param str_sql SQL查询语句
*/
public grid(String str_sql)
{
this.strSQl = str_sql;
}

/**
* 设置是否隐藏checkbok
* @param isHidden
*/
public void setHiddenCheck(boolean isHidden)
{
this.isHiddenCheck = isHidden;
}

/**
* 增加图片转换列
* @param columnName 数据库列名
* @param showName 表头显示名
* @param Value 与Value相等时显示imgUrl1,否则显示imgUrl2
* @param linkUrl 链接地址
* @param imgUrl1 图片地址1
* @param imgUrl2 图片地址2
*/
public void addImgTransitionColum(String columnName,String showName,
String Value1,String Value2,
String linkUrl,
String imgUrl1,String imgUrl2)
{
String[] arrayImgTransitionColumn = new String[7];
arrayImgTransitionColumn[0] = columnName;
arrayImgTransitionColumn[1] = showName;
arrayImgTransitionColumn[2] = Value1;
arrayImgTransitionColumn[3] = Value2;
arrayImgTransitionColumn[4] = linkUrl;
arrayImgTransitionColumn[5] = imgUrl1;
arrayImgTransitionColumn[6] = imgUrl2;
//加入动态数组列表
this.imgTransitionColums.add(arrayImgTransitionColumn);
}

/**
* 获得是否隐藏checkbok
* @param isHidden
*/
public boolean isHiddenCheck()
{
return isHiddenCheck;
}

/**
*设置主键列数组
* @param priKeys 主键列数组
*/
public void setPriKey(String[] priKeys)
{
this.primaryKeys = priKeys;
}

/**
* 加入显示图片列
* @param columnName
* @param showName
* @param Value
* @param imgUrl
*/
public void addShowImgColumn(String columnName,String showName,
String Value,String imgUrl)
{

String[] arrayShowImgColumn = new String[4];

arrayShowImgColumn[0] = columnName;
arrayShowImgColumn[1] = showName;
arrayShowImgColumn[2] = Value;
arrayShowImgColumn[3] = imgUrl;
//加入动态数组列表
this.showImgColums.add(arrayShowImgColumn);
}

/**
*设置中文列名数组
* @param tableHeandName 中文列名数组
*/
public void setColumnName(String[] tableHeandName)
{
this.columnsName = tableHeandName;
}

/**
* 设置键接列 (动态链接列)
* @param columnName 链接列的列名(数据库字段名)
* @param linkUrl 链接列的URL地址
*/
public void addLinkColum(String columnName,String linkUrl)
{
String[] arrayLinkColum = new String[2];

arrayLinkColum[0] = columnName;
arrayLinkColum[1] = linkUrl;
//加入动态数组列表
this.dlinkeColums.add(arrayLinkColum);
}

/**
* 设置键接列 (静态链接列)
* @param linkName 链接列的列名(表头)
* @param linkUrl 链接列的URL地址
* @param JpgURL 图像文件的URL地址
*/
public void addLinkColum(String linkName,String linkUrl,
String JpgURL
)
{

String[] arrayLinkColum = new String[3];

arrayLinkColum[0] = linkName;
arrayLinkColum[1] = linkUrl;
arrayLinkColum[2] = JpgURL;
//加入静态数组列表
this.slinkeColums.add(arrayLinkColum);
}

/**
* 判断是否动态链接列
* @param columnN 列名(数据库字段名)
* @return boolean 布尔型
*/
public boolean isdLinkColum(String columnN)
{
String[] columnName;
// 判断是否动态链接列
for(int i = 0; i < this.dlinkeColums.size(); i++)
{
columnName = (String[])dlinkeColums.get(i);
if(columnName[0].equals(columnN))
{
return true;
}
}
return false;
}

/**
* 判断是否图片显示列链接列
* @param columnN
* @return
*/
public boolean isShowImgColum(String columnN)
{
String[] columnName;
// 判断是否图片显示列
for(int i = 0; i < this.showImgColums.size(); i++)
{
columnName = (String[])showImgColums.get(i);
if(columnName[0].equals(columnN))
{
return true;
}
}
return false;
}

/**
*
* @param columnN
* @return
*/
public boolean isImgTransitionColums(String columnN)
{
String[] columnName;
// 判断是否图片显示列
for(int i = 0; i < this.imgTransitionColums.size(); i++)
{
columnName = (String[])imgTransitionColums.get(i);
if(columnName[0].equals(columnN))
{
return true;
}
}
return false;
}

/**
* 根据设置返回grid的html字符串
* @return grid的html字符串
*/
public String getGridHtml(JspWriter out,HttpServletRequest req) throws
JspException
{
dbrs sqlgrid = new dbrs();
sqlgrid.connect();
//查询
sqlgrid.query(this.strSQl);
String jspName = req.getRequestURI(); //jsp文件名
jspName = jspName.substring(jspName.lastIndexOf("/") + 1);

boolean[] islink = new boolean[sqlgrid.columnCount]; //记录是否是链接列
boolean[] isShowImgColums = new boolean[sqlgrid.columnCount]; //记录是否是链接列
boolean[] isimgTransitionColum = new boolean[sqlgrid.columnCount]; //记录是否是图像变化列
boolean[] isprimary = new boolean[sqlgrid.columnCount]; //记录是否是主键列
String[] linkcolumnName; //链接列数组
String[] ShowImgColumName; //图片显示列数组
String[] ImgTransitionColumName; //图片转换列数组
int counter = 0; //计数器
int recordCount = 0; //记录总数
int pageSize = 10; //每页显示10条
int pageCount = 0; //总页数
int pageId = 1; //当前页
//获取记录总数
recordCount = sqlgrid.getrowcount();

System.out.println("recordCount:" + recordCount);
//计算总页数
pageCount = ((recordCount % pageSize) == 0 ? (recordCount / pageSize) :
(recordCount / pageSize) + 1);

int count = 1;
//获取要显示的页数
String strPage = req.getParameter("pageId");
//为null默认跳转到第一页
if(strPage == null)
{
pageId = 1;
}
//将显示的页数转为整型
else
{
pageId = java.lang.Integer.parseInt(strPage);
}

if(pageId > recordCount)
{
pageId = recordCount;
}
if(recordCount > 0)
{

sqlgrid.absolute((pageId - 1) * pageSize + 1);

}

//设置是否是链接列数据组
for(int i = 0; i < islink.length; i++)
{
islink[i] = this.isdLinkColum(sqlgrid.getColunmName(i));
}
/**
* 此处修改　2004－12－27
*/
//设置是否是图片链接列数据列
for(int i = 0; i < isShowImgColums.length; i++)
{
isShowImgColums[i] = this.isShowImgColum(sqlgrid.getColunmName(i));
}
//设置是否是图片转换列数据列
for(int i = 0; i < isimgTransitionColum.length; i++)
{
isimgTransitionColum[i] = this.isImgTransitionColums(sqlgrid.
getColunmName(i));
}

/**
* 注意：此处修改 2004-12-9
* 如果没指定主键列，默认第一列是主键列
*/
if(this.primaryKeys == null)
{
primaryKeys = new String[1];
primaryKeys[0] = sqlgrid.getColunmName(0);
}
//设置是否是主键列数据组
for(int j = 0; j < sqlgrid.columnCount; j++)
{
for(int p = 0; p < this.primaryKeys.length; p++)
{
isprimary[j] = sqlgrid.getColunmName(j).equals(primaryKeys[p]);
if(isprimary[j])
{
break;
}
}
}

String Html = "<center><table cellSpacing=\"0\" "
+ "cellPadding=\"0\" align=\"center\" border=\"0\">"
+ " <thead>";

//写表头

if(this.isHiddenCheck)
{
Html += "<tr><th><a οnclick=\"this.blur(); return sortTable('defTblBdy'," +
counter + " , false);\""
+ " href=\"薛钧\">选择</th>";
/**
* 注意：此处修改 2004-12-9
* 如果没指定列名,则列名默认为列1、列2、列3......
*/
counter++;
}
if(this.columnsName == null)
{
columnsName = new String[sqlgrid.getcolumncount() - 1];
for(int i = 1;
i <
sqlgrid.getcolumncount() - showImgColums.size() -
imgTransitionColums.size();
i++)
{
columnsName[i - 1] = "列" + i;
}
}
//图片显示列名
for(int i = 0; i < this.showImgColums.size(); i++)
{
String[] showImgColum = (String[])this.showImgColums.get(i);
Html += "<th><a οnclick=\"this.blur(); return sortTable('defTblBdy'," +
counter + " , false);\""
+ " href=\"薛钧\">";
Html += showImgColum[1];
Html += "</th>";
counter++;
}

for(int i = 0; i < this.columnsName.length; i++)
{
if(columnsName[i] != null)
{
Html += "<th><a οnclick=\"this.blur(); return sortTable('defTblBdy'," +
counter + " , false);\""
+ " href=\"薛钧\">";
Html += columnsName[i];
Html += "</th>";
counter++;
}

}
//图片转换列
for(int i = 0; i < this.imgTransitionColums.size(); i++)
{
String[] imgTransitionColum = (String[])this.imgTransitionColums.get(i);
Html += "<th><a οnclick=\"this.blur(); return sortTable('defTblBdy'," +
counter + " , false);\""
+ " href=\"薛钧\">";
Html += imgTransitionColum[1];
Html += "</th>";
counter++;
}

//静态链接列名
for(int i = 0; i < this.slinkeColums.size(); i++)
{
String[] slinkeColum = (String[])this.slinkeColums.get(i);
Html += "<th><a οnclick=\"this.blur(); return sortTable('defTblBdy'," +
counter + " , false);\""
+ " href=\"薛钧\">";
Html += slinkeColum[0];
Html += "</th>";
counter++;
}

Html += "</tr></thead> <tbody id=\"defTblBdy\">";

/* int recordCounter=0;
while(test.nextrecord()&&count<=pageSize){*/

/*表内容*/
int recordCounter = 0;
//if (pageId==1)
//sqlgrid.beforeFirst();
while(count <= pageSize)
{
if(sqlgrid.getrowcount() == 0)
{
break;
}
recordCounter++;
count++;
Html += "<tr> ";
for(int j = 0; j <= sqlgrid.columnCount; j++)
{

if(j == 0 && this.isHiddenCheck)
{
/**
* 第一列为复选框,name为CB,value为主键
* 设置复选框id,id值为设该行的主键列值
* id=sqlgrid.getstring(primaryKeys[k])
*/
Html += "<td><input type=\"checkbox\" name=\"CB\" value=\"";
for(int k = 0; k < this.primaryKeys.length; k++)
{
Html += sqlgrid.getstring(primaryKeys[k]);
/*System.out.println(primaryKeys[k] + ":" +
sqlgrid.getstring(primaryKeys[k]) +
sqlgrid.getstring(j + 1));*/
if(this.primaryKeys.length > 1)
{
Html += ",";
}
}
Html += "\"></td>";
}
else
{
if(j == 0)
{
j = 1;
}
//判断动态链接列
if(islink[j - 1])
{
//是，定位到链接详细内容数组
for(int k = 0; k < this.dlinkeColums.size(); k++)
{
linkcolumnName = (String[])dlinkeColums.get(k);
if(linkcolumnName[0].equals(sqlgrid.getColunmName(j - 1)))
{
//找到链接详细内容数组
// System.out.print(sqlgrid.getstring(j) + " ");

/*注意:此处修改
修改后将主键值放入链接字符串中*/
Html += "<td>" + "<a href=\"" + linkcolumnName[1] + "?";

for(int p = 0; p < this.primaryKeys.length; p++)
{
Html += primaryKeys[p] + "=" +
sqlgrid.getstring(primaryKeys[p]);
if(this.primaryKeys.length > 1)
{
Html += ",";
}
}
//linkcolumnName[1]为链接URL地址
Html += "\">" + "</a></td>";
break;
}
}
}
/**
* 此处为新增代码
*/
if(isShowImgColums[j - 1])
{

//是，定位到图片显示列详细内容数组
for(int k = 0; k < this.showImgColums.size(); k++)
{
ShowImgColumName = (String[])showImgColums.get(k);
// System.out.println("进来");
if(ShowImgColumName[0].equals(sqlgrid.getColunmName(j - 1)))
{

// System.out.println("ShowImgColumName:" + ShowImgColumName[2]);
// System.out.println("sqlgrid.getstring(ShowImgColumName[0])" +
// sqlgrid.getstring(ShowImgColumName[0]));
if(sqlgrid.getstring(ShowImgColumName[0]).trim().equals(
ShowImgColumName[2]))
{

Html += "<td>" + "<img src=\"" + ShowImgColumName[3] + "\">";
// System.out.println("进来");

}
else
{
Html += "<td>";
}

//linkcolumnName[1]为链接URL地址
Html += "</td>";
break;
}
}

}

if(isimgTransitionColum[j - 1])
{
//是，定位到图片显示列详细内容数组
for(int k = 0; k < this.imgTransitionColums.size(); k++)
{
ImgTransitionColumName = (String[])imgTransitionColums.get(k);
// System.out.println("进来");
if(ImgTransitionColumName[0].equals(sqlgrid.getColunmName(j - 1)))
{
if(sqlgrid.getstring(ImgTransitionColumName[0]).trim().equals(
ImgTransitionColumName[2]))
{
Html += "<td><a href=\"" + ImgTransitionColumName[4] + "?";

for(int p = 0; p < this.primaryKeys.length; p++)
{
Html += primaryKeys[p] + "=" +
sqlgrid.getstring(primaryKeys[p]);
if(this.primaryKeys.length > 1)
{
Html += ",";
}
}

Html += "&&UserStatus=0\"><img "
+ " border=\"0\" src=\"" + ImgTransitionColumName[5]
+ "\"></a>";

}
else if(sqlgrid.getstring(ImgTransitionColumName[0]).trim().
equals(
ImgTransitionColumName[3]))
{
Html += "<td><a href=\"" + ImgTransitionColumName[4] + "?";

for(int p = 0; p < this.primaryKeys.length; p++)
{
Html += primaryKeys[p] + "=" +
sqlgrid.getstring(primaryKeys[p]);
if(this.primaryKeys.length > 1)
{
Html += ",";
}
}

Html += "&&UserStatus=1\"><img "
+ " border=\"0\" src=\"" + ImgTransitionColumName[6]
+ "\"></a>";

}
else
{
Html += "<td>";
}

//linkcolumnName[1]为链接URL地址
Html += "</td>";
break;
}
}

}

//普通列内容
else
{

if(!isprimary[j - 1] && !(isShowImgColums[j - 1]) &&
!(isimgTransitionColum[j - 1]))
{
// System.out.print(sqlgrid.getstring(j) + " ");
Html += "<td>" + sqlgrid.getstring(j) + "</td>";
}
}

}

/* */

}
//静态列内容
for(int n = 0; n < this.slinkeColums.size(); n++)
{
String[] slinkeColum = (String[])this.slinkeColums.get(n);
if(slinkeColum[2].equals(""))
{
//文字静态列

/*注意:此处修改
修改后将主键值放入链接字符串中*/
Html += "<td>" + "<a href=\"" + slinkeColum[1] + "?";

for(int p = 0; p < this.primaryKeys.length; p++)
{
Html += primaryKeys[p] + "=" + sqlgrid.getstring(primaryKeys[p]);
if(this.primaryKeys.length > 1)
{
Html += ",";
}
}
//linkcolumnName[1]为链接URL地址
Html += "\">" + slinkeColum[0] + "</a></td>";

/** //设置静态列链接地址和显示内容
Html += "\"><a href=\"" + slinkeColum[1] + "\">" +
slinkeColum[0] + "</a></td>";**/
}
else
{

//设置图像静态列URL
Html += "<td><a href=\"" + slinkeColum[1] + "?";

/*注意:此处修改
修改后将主键值放入链接字符串中*/
for(int p = 0; p < this.primaryKeys.length; p++)
{
Html += primaryKeys[p] + "=" + sqlgrid.getstring(primaryKeys[p]);
if(this.primaryKeys.length > 1)
{
Html += ",";
}
}
Html +=
"\"><img border=\"0\" src=\"" +
slinkeColum[2] + "\"></a></td>";
}
}
Html += "</tr>";
// System.out.println();
if(sqlgrid.nextrecord() == false)
{
break;
}
}
//数据读入完毕
sqlgrid.close();
//收尾
Html += "</tbody></table></center>";

/*
if(pageCount>1){
if(pageId==1){ out.print("<font color=\"#999999\">首页 上一页</font>"); }else{ %>
<a href="pagetest.jsp?pageId=1">首页</a> <a href="pagetest.jsp?pageId=<%=pageId-1%>">上一页</a>
<%}%>
<%if(pageId>=pageCount){out.print("<font color=\"#999999\">下一页 尾页</font>");}else{ %>
<a href="pagetest.jsp?pageId=<%=pageId+1%>">下一页</a> <a
href="pagetest.jsp?pageId=<%=pageCount%>">尾页</a>
<%}}else{
out.print("<font color=\"#999999\">首页 上一页 下一页 尾页</font>");
}
%>
*/

try
{
out.print(Html);
out.print("<form><center>");
if(pageCount > 1)
{
if(pageId == 1)
{
out.print("<font color=\"#999999\">首页 上一页</font>");
}
else
{
out.print("<a href=\"" + jspName + "?pageId=1\">首页</a> <a href=\"" +
jspName + "?pageId=" + (pageId - 1) + "\">上一页</a>");

}

if(pageId >= pageCount)
{
out.print("<font color=\"#999999\">下一页 尾页</font>");
}
else
{
out.print("<a href=\"" + jspName + "?pageId=" + (pageId + 1) +
"\">下一页</a> <a "
+ "href=\"" + jspName + "?pageId=" + pageCount +
"\">尾页</a>");
}
}
else
{
out.print("<font color=\"#999999\">首页 上一页 下一页 尾页</font>");
}
out.print("</center></form>");
Html = null;

}
catch(java.io.IOException je)
{
throw new JspException(je);
}

return "";
}

public static void main(String[] args)
{
//实例化grid
grid test = new grid("select * from huida");
//加修改列
test.addLinkColum("修改","dd","");
//表头数组
String[] ColumnsName =
{
"外键","回答人","回答内容","日期"};
//主键数组
String[] PriKeys =
{
"h_id"};
//设置表头
test.setColumnName(ColumnsName);
//设置主键
test.setPriKey(PriKeys);
// System.out.println(test.getGridHtml());
}

}