test.java

创建中间企业对象层

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

import java.io.*;
import java.sql.*;

public class Test
{
	public Test(String name) throws Exception
	{
		objectName=name;
		String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};"
			+ "DBQ=D:\\work\\test\\mydb.mdb"; 
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		conn=DriverManager.getConnection(strurl) ;
		stmt=conn.createStatement();
	}



	public String getObjectName()
	{
		return objectName;
	}
	
	public void list() throws Exception
	{
		rs=stmt.executeQuery("select * from user");
		/*
		String s;
        while(rs.next())
        { 
            s=rs.getString("a");
            System.out.println(s);

        }
        */
	}
	
	public boolean read()
	{
		return false;
	}
	
	public String value(String field) throws Exception
	{
		return "";
	}
	
	
	
	
	public void listend() throws Exception
	{
		rs.close();
	}
	
	
	
	private String objectName="";
	private String where="";
	private String orderby="";
	private String fields="";
	
	private Connection conn;
	private Statement stmt; 
	private ResultSet rs;
	
	public static void main(String args[]) throws Exception
	{
		System.out.println("sss");
		Test t = new Test("user");
		t.list();
			
	}
}