计算机科学论坛--[原创]实现将本体文件存入数据库，再从数据库中读出，输出该本体中的所有类，所有属性及其对应属性的值

贴子主题： [原创]实现将本体文件存入数据库，再从数据库中读出，输出该本体中的所有类，所有属性及其对应属性的值

本主题类别: Ontology Language | RDF/RDFS

今天终于实现了将一个本体文件存储到数据库中，再从数据库中将文本文件读出来，输出该本体中的所有类，所有属性及其对应属性的值。

import java.util.Iterator;
import com.hp.hpl.jena.db.DBConnection;
import com.hp.hpl.jena.db.IDBConnection;
import com.hp.hpl.jena.ontology.Individual;
import com.hp.hpl.jena.ontology.OntClass;
import com.hp.hpl.jena.ontology.OntModel;
import com.hp.hpl.jena.ontology.OntModelSpec;
import com.hp.hpl.jena.ontology.OntProperty;
import com.hp.hpl.jena.rdf.model.Model;
import com.hp.hpl.jena.rdf.model.ModelFactory;
import com.hp.hpl.jena.rdf.model.ModelMaker;
import com.hp.hpl.jena.util.iterator.ExtendedIterator;

public class ReadOntologyFromMysql {
public static final String strDriver = "com.mysql.jdbc.Driver";
public static final String strURL = "jdbc:mysql://localhost:3306/jena";
public static final String strUser = "root";
public static final String strPassword = "root";
public static final String strDB = "MySQL";

// 连接数据库
public static IDBConnection connectDB(String DBURL, String DBUSER, String DBPASSWORD, String DBTYPE){
  try {
   Class.forName("com.mysql.jdbc.Driver");
   System.out.print("数据库连接成功, 已经连接到");
  }catch (ClassNotFoundException e){
   e.printStackTrace();
   System.out.println("数据库连接不成功");
  }
  return new DBConnection(DBURL, DBUSER,DBPASSWORD,DBTYPE);
}

    // 提取本体文件关于OWL架构等详细信息
public static OntModelSpec getModelSpec(ModelMaker maker) {
  OntModelSpec spec = new OntModelSpec(OntModelSpec.OWL_MEM);
  spec.setImportModelGetter(maker);
  return spec;
}

// 从文件读取本体并将其存入数据库
public static OntModel ceateDBModelFromFile(IDBConnection con, String name, String filePath){
  ModelMaker maker = ModelFactory.createModelRDBMaker(con);
  Model base = maker.createModel(name);
  OntModel newmodel = ModelFactory.createOntologyModel(getModelSpec(maker),base);
  newmodel.read(filePath);
  System.out.println("已将本体文件存入数据库。");
  System.out.println();
  return newmodel;
}

// 从数据库中得到已存入本体
public static OntModel getModelFromDB(IDBConnection con, String name){
  ModelMaker maker = ModelFactory.createModelRDBMaker(con);
  Model base = maker.getModel(name);
  OntModel newmodel = ModelFactory.createOntologyModel(getModelSpec(maker),base);
  System.out.println("已从数据库中读出本体文件。");
  System.out.println();
  return newmodel;
}

// 简单读取本体中的所有类
public static void SimpleReadOntology(OntModel model){
  System.out.println("该本体文件中包括以下类：");
  for (Iterator i = model.listClasses(); i.hasNext();){
   OntClass c = (OntClass) i.next();
   System.out.println("    " + c.getLocalName());
  }
  System.out.println();
}

public static void main(String args[]){
  IDBConnection con = connectDB(strURL, strUser, strPassword, strDB);
  System.out.println(con + ";");
  System.out.println();
  String filePath = "file:e:/ontologies/BeijingOpera/Costume.owl";
  String prefix = "http://Costume.owl#";

  OntModel defModel = ceateDBModelFromFile(con, "Costume", filePath);
  // 读取filePath目录下本体文件Costume的内容，将该本体文件的内容存储到数据库con中；
  OntModel model = getModelFromDB(con, "Costume");
  // 将数据库con中存储的本体文件Costume的内容读出到一个本体文件Model中；

  SimpleReadOntology(model);
  OntClass CostumeClass = model.getOntClass(prefix + "Costume");
  String name = CostumeClass.getLocalName();
//返回的是Costume本体中的类Costume的名字，是一个字符串；
  System.out.print("此处返回的是" + name + "类的名称");
  System.out.println(name);
  System.out.println();

  ExtendedIterator it = CostumeClass.listInstances();
  System.out.println("此处返回的是" + name + "类的所有实例：");
  while (it.hasNext()) {
   Individual oi = (Individual) it.next();
   System.out.println("    " + oi.getLocalName());

   for (Iterator ipp = CostumeClass.listDeclaredProperties(); ipp.hasNext();){
    OntProperty p = (OntProperty) ipp.next();
    System.out.println("    associated property:" + p.getLocalName() + ":" + oi.getPropertyValue(p));
   }
  }
}
}

以上代码执行后，控制台的输出如下：
数据库连接成功, 已经连接到com.hp.hpl.jena.db.DBConnection@157f0dc;

已将本体文件存入数据库。

已从数据库中读出本体文件。

该本体文件中包括以下类：
    Costume
    Document
    Image
    Master

此处返回的是Costume类的名称Costume

此处返回的是Costume类的所有实例：
    HongTuanLongMang
            associated property:kind:Mang^^http://www.w3.org/2000/01/rdf-schema#Literal
            associated property:image:null
            associated property:pattern:SanJianShui, Long^^http://www.w3.org/2000/01/rdf-schema#Literal
            associated property:daPei:null
            associated property:name:HuanTuanLongMang^^http://www.w3.org/2000/01/rdf-schema#Literal
            associated property:color:red^^http://www.w3.org/2000/01/rdf-schema#Literal
            associated property:hangDang:Sheng^^http://www.w3.org/2000/01/rdf-schema#Literal
            associated property:texture:DaDuan^^http://www.w3.org/2000/01/rdf-schema#Literal
            associated property:depiction:null
            associated property:style:DuiJin, YuanCollar^^http://www.w3.org/2000/01/rdf-schema#Literal

    HuangTuanLongMang
            associated property:kind:null
            associated property:image:null
            associated property:pattern:null
            associated property:daPei:null
            associated property:name:null
            associated property:color:null
            associated property:hangDang:null
            associated property:texture:null
            associated property:depiction:null
            associated property:style:null

    LvTuanLongMang
            associated property:kind:null
            associated property:image:null
            associated property:pattern:null
            associated property:daPei:null
            associated property:name:null
            associated property:color:null
            associated property:hangDang:null
            associated property:texture:null
            associated property:depiction:null
            associated property:style:null


	W 3 C h i n a ( since 2003 ) 旗下站点苏ICP备05006046号《全国人大常委会关于维护互联网安全的决定》《计算机信息网络国际联网安全保护管理办法》	171.875ms