sessiontest.java

用JAVA实现了,将DB装入内存,内存由DBMS控制,实现简单数据库的创建、数据表的创建、记录插入、查询以及表的删除。

package org.kdb.execute;

import org.kdb.Session;
import org.kdb.impl.SessionImpl;

import java.util.List;

/**

 * Date: 2007-11-24
 * Time: 8:41:45
 */
public class SessionTest {
    public static void main(String[] args) {
        SessionImpl session = new SessionImpl();
        session.execute("create database mydb");
        session.execute("use mydb");
        String sql = "create table user(\n" +
                "id int,\n" +
                "name      string 32,\n" +
                "password string 32,\n" +
                ")";
        session.execute(sql);
        for(int i =0;i<5;i++){
        String sql1 = "insert into user values("+i+",'user','pwd')";
        session.execute(sql1);
        }
        String selectStatement = "select * from user";
        List<Object[]> ls =session.executeQuery(selectStatement);
        System.out.println(ls.size());
        for(Object[] obj:ls){
            for(Object o:obj){
                System.out.print(o);
                System.out.print("        ");
            }
            System.out.println();
        }
    }
}