當前位置:編程學習大全網 - 源碼下載 - java查詢數據庫的數據並顯示出來

java查詢數據庫的數據並顯示出來

本人使用的是 Jena-2.5.7 MySQL 5.0 mysql-connector-java-3.1.10 jdk1.6.0_07

源代碼:

import java.io.*;

import java.sql.SQLException;

import com.hp.hpl.jena.db.*;

import com.hp.hpl.jena.rdf.model.*;

public class MysqlTest{

public static final String strDriver = "com.mysql.jdbc.Driver"; // path of driver class

public static final String strURL = "jdbc:mysql://localhost/ontodb"; // URL of database

public static final String strUser = "root"; // database user id

public static final String strPassWord = "4408"; // database password

public static final String strDB = "MySQL"; // database type

public static void main(String[] args){

try{

// 創建壹個數據庫連接

IDBConnection conn = new DBConnection ( strURL, strUser, strPassWord, strDB );

// 加載數據庫驅動類,需要處理異常

try

{

Class.forName(strDriver);

}catch(ClassNotFoundException e){

System.out.println("ClassNotFoundException, Driver is not available...");

}

// 使用數據庫連接參數創建壹個模型制造器

ModelMaker maker = ModelFactory.createModelRDBMaker(conn);

// 創建壹個默認模型,命名為 MyOntology

Model defModel = maker.createDefaultModel();

// 準備需要存入數據庫的本體文件,建立輸入文件流

FileInputStream inputSreamfile = null;

try

{

File file = new File("D:/Person.owl");

inputSreamfile = new FileInputStream(file);

} catch (FileNotFoundException e) {

e.printStackTrace();

System.out.println("Ontology File is not available...");

}

InputStreamReader in = null;

try

{

in = new InputStreamReader(inputSreamfile, "UTF-8");

} catch (UnsupportedEncodingException e) {

System.out.println("Exceptions occur33...");

e.printStackTrace();

}

// 讀取文件

defModel.read(in,null);

// 關閉輸入流讀取器

try

{

in.close();

} catch (IOException e) {

System.out.println("Exceptions occurclose1...");

e.printStackTrace();

}

// 執行數據轉換,將本體數據存入數據庫

defModel.commit();

// 關閉數據庫連接

try

{

conn.close();

} catch (SQLException e) {

System.out.println("Exceptions occur22...");

e.printStackTrace();

}

}catch(RDFRDBException e){

System.out.println("Exceptions occur...");

}

}

}

輸出結果

Tue Dec 30 17:07:06 CST 2008 TRACE:

Tue Dec 30 17:07:06 CST 2008 TRACE:

.....

Tue Dec 30 17:07:06 CST 2008 TRACE:

Tue Dec 30 17:07:06 CST 2008 TRACE:

Exceptions occur...

幫忙解決壹下。。。

  • 上一篇:在不重裝系統的前提下怎樣才能令電腦運行快些!
  • 下一篇:wordpress如何移除或修改父主題函數
  • copyright 2024編程學習大全網