lists.java

本系统是一套基于WEB的软件平台。借助于现代信息技术手段

package JXC.web;

import java.sql.*;
import java.util.Vector;
import JXC.Com.DBConnect;
/**
 * Title:        物品列表
 * Description:
 * Copyright:    Copyright (c) 2003
 * Company:      torch
 * @author:		 wind
 * @version 1.0
 */

public class Lists extends Pages {
    private String[]           columnNames = {};
    private ResultSetMetaData  metaData;
	int                        FRow=0;
	int                       columnCount=0; 
	String                    StrSql="";  
	public Lists() throws Exception{
		super();
	}
	
    public String getColumnName(int column) {
    	if (column>=columnCount) 
    	  column=columnCount-1;
    	  
    	if (column<0) 
    	  column=0; 
    	     	  
        if (columnNames[column] != null) {
            return columnNames[column];
        } else 
            return "";
        
    }
    
    public int getColumnIndex(String name) {
      int ok=0; 
      if (name!=null) {
      	for (int i=0;i<columnCount;i++) {
      	   String temp=columnNames[i].toLowerCase();
      	   name=name.toLowerCase(); 	
      	  if (name.equals(temp))
      	  	{  	
      		  ok= i;
      		  break;
      		}

       }
   }
     return ok;	
   }
    
    public void setRow(int i) {
    	FRow=i;
    }
    public int getColumnCount() {
        return columnNames.length;
    }
    
     public Class getColumnClass(int column) {
        int type;
        try {
            type = metaData.getColumnType(column+1);
        }
        catch (SQLException e) {
            return null;
        }

        switch(type) {
        case Types.CHAR:
        case Types.VARCHAR:
        case Types.LONGVARCHAR:
            return String.class;

        case Types.BIT:
            return Boolean.class;

        case Types.TINYINT:
        case Types.SMALLINT:
        case Types.INTEGER:
            return Integer.class;

        case Types.BIGINT:
            return Long.class;

        case Types.FLOAT:
        case Types.DOUBLE:
            return Double.class;

        case Types.DATE:
            return java.sql.Date.class;

        default:
            return Object.class;
        }
    }
       
    public String getString(int aColumn) {
    	String[] row = (String[])list.elementAt(FRow);
    	return row[aColumn];
    //	Vector row = (Vector)list.elementAt(FRow);
    //	return row.elementAt(aColumn).toString();
    	}
    	
    public String getString(String aColumnName) {
    	String[] row = (String[])list.elementAt(FRow);
    	return row[getColumnIndex(aColumnName)];    	
    //	Vector row = (Vector)list.elementAt(FRow);
    //	return row.elementAt(getColumnIndex(aColumnName)).toString();
    	}
	public void setSql(String s) {
		String Str="";
		Str="select  * from "+s+" order by id desc";
		StrSql=Str;
	}

	public void setStrSql(String Str) {
		StrSql=Str;
	}
				
	public String getSql() {
		return StrSql;
	}

	public boolean excute() throws Exception {
		int id = 0;
		try {
		DBConnect dbc  = new DBConnect(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
		ResultSet rs = dbc.executeQuery(getSql());
        metaData = rs.getMetaData();
        columnCount =  metaData.getColumnCount();
         columnNames = new String[columnCount];
            // Get the column names and cache them.
            // Then we can close the connection.
        for(int column = 0; column < columnCount; column++) {
            columnNames[column] = metaData.getColumnLabel(column+1);
          }
	    rs.last();
        setShowPage(rs.getRow());
    	rs.absolute(getRecode());
	
		for (int i=0;i<getPageSize();i++){
		  String[]            rsRow = {};
		  rsRow = new String[columnCount];	
          for(int column = 0; column < columnCount; column++) {
            rsRow[column] = rs.getString(column+1);
          }
            list.addElement(rsRow);			
		//	list.addElement(rs.getObject(i));
            if (!rs.next())
                break;
			}
			rs.close();
			dbc.close();
			return true;
		}
		catch (SQLException sqle){
			return false;
		}
	}
};