users.java

创建中间企业对象层

/**
 ************************************************************
 * The VML Report
 *
 *
 *
 ************************************************************
 * @author duke
 * @version 1.2
 * @date 2004-8-10 14:37
 */
 
package com.kyle.eobject;

import java.io.*;
import java.util.Date;
import java.sql.*;


public class Users extends KyleList
{
	
	public Users() throws Exception
	{
		
	}
	
	public void initializeFields() 
	{
		setTableName("Users");
		/*
		addField("id","integer",8);
		addField("a","string",50);
		addField("b","string",50);
		addField("c","string",50);
		addField("Orgid","integer",8,"Org","id");
		*/
		
		
	}

	
	public static void main(String args[]) throws Exception
	{
		System.out.println("id	orgid	orgsym		locid	loccode	b");
		System.out.println("---------------------------------------------------------------");
		
		
		long d1,d2;
		d1 =new Date().getTime();
		
		Users user;
		user = new Users();
		user.setWhere("id>1 and b like '%a%' ");
		user.setField("id,a,b,orgid");
		user.setPage(true);
		user.setPageNo(1);
		user.list();  //time 100
		d2 =new Date().getTime();
		System.out.println("Milliseconds<1> is: " + (d2-d1));
		
		d1 =new Date().getTime();
		while (user.next())
		{
			System.out.println(user.value("id") +
					"	"+user.value("orgid")+
					"	"+user.value("orgid.sym")+
					"	"+user.value("orgid.loc")+
					"	"+user.value("orgid.loc.code")+
					"	"+user.value("b"));
		}
		
		d2 =new Date().getTime();
		System.out.println("Milliseconds<2> is: " + (d2-d1));

	}
}