自己写的一个用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 onclick=\"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 onclick=\"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 onclick=\"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 onclick=\"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 onclick=\"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());
}
}
比较乱
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 onclick=\"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 onclick=\"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 onclick=\"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 onclick=\"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 onclick=\"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());
}
}
相关推荐
本项目专注于构建一个自定义的iPhone datagrid组件,它具备数据列表功能并支持行列锁定,这对于展示大量数据并需要用户交互的情况非常有用。下面将详细探讨这个iOS应用源码的关键知识点。 1. **自定义视图组件**: ...
本资源提供的是一个自制的iPhone DataGrid组件,特别之处在于它支持行列锁定功能,这在处理大量数据时尤其有用,可以固定重要的列或行,方便用户查看和比较。 首先,我们来理解一下DataGrid组件的基本概念。...
本压缩包“IOS应用源码之自制 iPhone DataGrid 数据列表组件,支持行列锁定Grid.zip”提供了一个自定义的数据网格解决方案,特别适合于需要展示表格形式信息的应用场景。下面我们将深入探讨这个源码中的关键知识点。...
本资源提供了一个自制的iPhone DataGrid组件,它专为iOS应用设计,支持行列锁定功能,能有效提升用户体验,尤其在处理表格数据时。 这个组件的亮点在于行列锁定功能,这在数据密集型应用中非常实用。行列锁定允许...
这个“自制 iPhone DataGrid 数据列表组件”是一个专门为iOS应用设计的自定义控件,它允许开发者创建类似电子表格的布局,支持行列锁定功能,极大地增强了数据展示的灵活性和用户体验。 在iOS开发中,标准的...
本教程将围绕“jQuery 自制分页,控制 EasyUI datagrid 分页”这一主题进行深入讲解。 首先,EasyUI 的 DataGrid 默认的分页功能已经相当强大,它可以自动处理数据请求、显示页码和每页条数等。然而,在某些情况下...
有项目用到简易的分布表(不需要排序,修改等复杂操作,只需要分页)网上找到的都不是我需要的,在此使用绑定自制一个简易分页,不修改DataGrid样式及其事件,最大限度给其它项目复用及定制 ...
在.NET开发环境中,C# WinForm应用经常需要处理大量数据,这时自定义分页控件显得尤为重要。"C# Winform+devexpress 自定义分页控件"是为了解决这个问题而设计的一种解决方案,它利用DevExpress组件库的强大功能,...
0204 如何在DataGrid中嵌入LookupComboBox 135 0205 在DBGrid中设置不滚动的列 136 0206 如何在DBGrid中实现复制、粘贴功能 137 0207 在DBGrid中将选中的多行删除 137 0208 在DataGrid中如何使标题文字居中...
0204 如何在DataGrid中嵌入LookupComboBox 135 0205 在DBGrid中设置不滚动的列 136 0206 如何在DBGrid中实现复制、粘贴功能 137 0207 在DBGrid中将选中的多行删除 137 0208 在DataGrid中如何使标题文字居中...