Pointbase JDBC 简介

今天研究了一下PointBase，感觉是还是很好的，对平台的依赖性很小，而且特别的小，我是仅仅的用了3个jar 包 和一个bat 文件就完美的搞定了一个数据库，搭建仅仅需要3分钟。

搭建过程：

在任何地方找到pbclient44.jar，pbserver44.jar，pbtools44.jar

大家也看到了，为什么我不选用其他版本的jar 包。仅仅选用了4.4版本

那是因为IBM太坏了，5.0以上版本就加了限制，也就是说多了licence，这个不是免费的，也就用不了了。

4.4 版本的就很好，没有这样的限制而且很稳定，下面就开始吧。

 

@rem *************************************************************************
@rem This script is used to start PointBase
@rem *************************************************************************
@echo off
set POINTBASE_HOME=..
set POINTBASE_CLASSPATH=%POINTBASE_HOME%\lib\pbserver44.jar;%POINTBASE_HOME%\lib\pbclient44.jar

@rem Add PointBase classes to the classpath
set CLASSPATH=%POINTBASE_CLASSPATH%

@rem Start PointBase
"%JAVA_HOME%\bin\java" com.pointbase.net.netServer /port:9092 /d:3 /pointbase.ini=".\pointbase.ini"

 

database.home=../databases
documentation.home=../
transaction.isolationlevel=TRANSACTION_READ_COMMITTED
database.pagesize=4096
cache.size=2063
sort.size=1024

 

好了基本想研究的，我想bat还是能看懂的。

下面这来说明一下JDBC的书写：

package com.pointbase;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 * 
 * @author cnchenhl Apr 12, 2011
 */
public class JDBC {

    public static void main(String[] args) {
        try {
            String str = executeSelectSQL("select count(*) from people");
            System.out.println(str);
        } catch (Exception e) {
            e.printStackTrace();
package com.pointbase;

/**
 * @author cnchenhl Apr 13, 2011
 */
public final class CommonConstants {

    public static String USERNAME = null;
    public static String PASSWORD = null;
    public static String DBURL = null;
    public static String FILENAME = "database.properties";

}

 
        }
    }

    public static Connection getConnection() throws InstantiationException, IllegalAccessException,
            ClassNotFoundException, FileNotFoundException, IOException, SQLException {
        Class.forName("com.pointbase.jdbc.jdbcUniversalDriver").newInstance();
        Properties properties = Configuration.getProperties(CommonConstants.FILENAME);
        CommonConstants.USERNAME = properties.getProperty("userName");
        CommonConstants.PASSWORD = properties.getProperty("password");
        CommonConstants.DBURL = properties.getProperty("url");
        Connection conn = DriverManager.getConnection(CommonConstants.DBURL, CommonConstants.USERNAME,
                CommonConstants.PASSWORD);
        return conn;
    }

    public static Statement getStatement() throws FileNotFoundException, InstantiationException,
            IllegalAccessException, ClassNotFoundException, IOException, SQLException {
        Connection conn = getConnection();
        Statement stat = conn.createStatement();
        return stat;
    }

    public static String executeSelectSQL(String sql) throws FileNotFoundException, InstantiationException,
            IllegalAccessException, ClassNotFoundException, IOException, SQLException {
        Statement stat = getStatement();
        ResultSet rs = stat.executeQuery(sql);
        String str = "";
        while(rs.next()){
            str = rs.getString(1);
        }
        return str;
    }
}

 

package com.pointbase;

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Properties;

/**
 * 
 * @author cnchenhl
 * Apr 13, 2011
 */
public class Configuration {

    public static Properties getProperties(String fileName) throws FileNotFoundException, IOException{
        Properties pro = new Properties();
        File propertyFile = new File(fileName);
        pro.load(new BufferedInputStream(new FileInputStream(propertyFile)));
        return pro;
    }
}

 

#User Name
userName = ×××××
#Password
password = ×××××
#URL of Database 
url = jdbc:pointbase:server://localhost/sample

 

好了 大功告成，Pointbase 搭建成功了

只要书写JDBC 就能改变PointBase数据库了

很简单，很强大哦