用JAVA读取Domain的数据库

　　去年，由于做一个项目是针对DOMINO的系统，所以抽出时间研究了一个这个当初是莲花公司的传。
　其实，DOMINO有自己的LOTUSSRIPT，但是大家都用JAVA习惯了，当然它也提供了JAVA的接口，所以我们参考一下它的开发文档，写了一下JAVA操作DOMNIO的数据库的例子。


public class LotusReadDB {

private static String user = "test";
private static String passwd = "123456789";
private static String dominoHost = "192.168.8.17";

private static String TESTDB1="mail.box";//用户的邮箱数据库
private static String TESTDB1VIEW="mail";//用户的邮箱视图

private static String TESTDB2="mtdata/mtstore.nsf";//MTC邮件跟踪的数据库
private static String TESTDB2VIEW="alluser";

Vector rowDataParent=new Vector();

Vector columnNames=new Vector();

Database db=null;

/**

* 取得数据库

* @param accessDB

* @return

* @throws NotesException

*/

Database getDB(String accessDB) throws NotesException{
// String accessDB = "mail.box";
/**数据库的路径是相对于Data目录下的
*mtdata/mtstore.nsf
*mail/songlb.nsf
* **/

lotus.domino.Session s = lotus.domino.NotesFactory.createSession(
dominoHost, user, passwd);

// System.out.println(s.getServerName() + " :" + s.getNotesVersion() +
// ":user " + s.getUserName());

lotus.domino.Database db = s.getDatabase(null, accessDB);
if (!db.isOpen())
{
db.open();
}

//打出数据库的标题和大小

//System.out.println("title:" + db.getTitle() + " size:" + db.getSize());
return db;
}

/**
* 取某个数据库的某张表
* @param accessDB String 数据库名称
* @param accessView String 表名称
*/
public void getDBDatas(String accessDB,String accessView)
{
Vector rowDataSon=new Vector();
try
{


db=this.getDB(accessDB);//得到数据库

View view = (View) db.getView(accessView);//取得自己想要的MAIL视图

System.out.print(view.getName() + "(");

columnNames = view.getColumns(); //得到所有列名

Document doc=view.getFirstDocument();
StringBuffer strBuf=new StringBuffer();

while(doc!=null){

Vector values = doc.getColumnValues();

for (int j = 0; j < columnNames.size(); j++) {
String columnName = ((String) columnNames.elementAt(j) .toString()).trim();

if (columnName.length() != 0) {
System.out.println("cloumn class:"+values.get(j).getClass());
ViewColumn column = (ViewColumn) columnNames.elementAt(j);
// strBuf=strBuf.append("/t[" + columnName + "]:");
// //strBuf=strBuf.append(column.getItemName());
// strBuf=strBuf.append(values.get(j).toString());
System.out.println("/t[" + columnName + "]:" + values.get(j));

}

}
System.out.println(")");

System.out
.println("----------------------------------------------------------------");


// for(int p=0;p<doc.getItems().size();p++){
// Item item=(Item)doc.getItems().get(p);
// System.out.println("*"+p+""+item.getName()+"------"+item.getValues());
// }



doc = view.getNextDocument(doc);
}








// Document docF = view.getFirstDocument();
//
// Vector allItems = docF.getItems();
// for (int t = 0; t < allItems.size(); t++)
// {
// System.out.println("********* " + t + " Start ***********");
// Item item = (Item) allItems.get(t);
// System.out.println("--item.getName():" + item.getName());
// System.out.println("--item.getText():" + item.getText());
// //System.out.println("--item.getValueString():" + item.getValueString());
// System.out.println("********* " + t + " end ***********");
// System.out.println("");
// System.out.println("");
// }
System.out.println("");
System.out.println("");

}
catch (lotus.domino.NotesException e)
{
e.printStackTrace();
// System.out.println("Domino Server 可能没有启动!");
}
catch (Exception ex)
{ex.printStackTrace();
//System.out.println("Domino Server 可能没有启动!");
}

}

/**
* 取得所有行数据
* @return
*/
public Object[][] getRowData(){
int row=rowDataParent.size();
int col=columnNames.size();
Object[][] temp=new Object[row][col];
for(int i=0;i<row;i++){
temp[i]=((Vector)rowDataParent.get(i)).toArray();
}
return temp;
}

public Object[] getColumnName(){
return this.columnNames.toArray();
}

public LotusReadDB()
{
}


/**
* Example 得全部 document
* @param db
* @throws NotesException
* @throws ClassNotFoundException
* @throws IOException
*/
public void getAllDocument(View view) throws NotesException, IOException, ClassNotFoundException{
Document doc=view.getFirstDocument();
int t=0;
Item item=null;
while(doc!=null){
Vector vt=doc.getItems();
// for(int i=0;i<vt.size();i++){

//PostedDate

item = doc.getFirstItem("PostedDate");
if (item != null)
System.out.println("PostedDate: "+"[ " + item.getText() + " ]");



System.out.println(doc.getColumnValues().toString());


// RichTextItem body =
// (RichTextItem)doc.getFirstItem("Body");
// if (body == null)
// System.out.println("No body");
// else
// System.out.println( body.getFormattedText(true, 0, 0));


// }

doc=view.getNextDocument(doc);
}
}

/**
* Example 得全部 document
* @param db
* @throws NotesException
*/
public void getAllDocument(Database db) throws NotesException{
DocumentCollection dc = db.getAllDocuments();
Document doc = dc.getFirstDocument();
while (doc != null) {
System.out.println("******");
System.out.println(
doc.getItemValueString("Subject"));
Enumeration e = doc.getAuthors().elements();
while (e.hasMoreElements())
System.out.println("Author: " + e.nextElement());
System.out.println("Created: " + doc.getCreated());
if (doc.isNewNote())
System.out.println("Is new note");
if (doc.isResponse())
System.out.println("Parent UNID: " + doc.getParentDocumentUNID());
if (doc.isSigned()) {
System.out.println("Signed by: " + doc.getSigner());
System.out.println("Verified by: " + doc.getVerifier()); }
System.out.println("Last accessed: " + doc.getLastAccessed());
System.out.println("Verified by: " + doc.getLastModified());
System.out.println("Note ID: " + doc.getNoteID());
System.out.println("Universal ID: " + doc.getUniversalID());
doc = dc.getNextDocument(); }
}

/**
* Example 得到指定View 的全部entry
* @param view
* @throws NotesException
*/
public void getEntryByView(View view) throws NotesException{
ViewNavigator nav = (ViewNavigator) view.createViewNav();
String typeCol = null;
ViewEntry entry = nav.getFirst();
while (entry != null) {
if (entry.isCategory()) typeCol = "category";
else if (entry.isDocument()) typeCol = "document";
else if (entry.isTotal()) typeCol = "total";
System.out.println("Entry at position" +
entry.getPosition('.') + " is a " + typeCol);
System.out.println("/tIndent level: " +
entry.getIndentLevel());
System.out.println
("/tColumn indent level: " +
entry.getColumnIndentLevel());
System.out.println("/tNote ID: " + entry.getNoteID());
if (entry.isDocument()) {
System.out.println
("/tUniversal ID: " + entry.getUniversalID());
System.out.println
("/tFT search score: " + entry.getFTSearchScore());
if (entry.isConflict())
System.out.println("/tConflict document");
System.out.println("/tSubject: /"" +
entry.getDocument().getItemValueString("Subject") +
"/""); }
if (entry.getParent() instanceof ViewNavigator)
System.out.println("/tParent is ViewNavigator");
else if (entry.getParent() instanceof
ViewEntryCollection)
System.out.println("/tParent is ViewEntryCollection");
else System.out.println("/tParent is View");
System.out.println("/tSibling count: " +
entry.getSiblingCount());
System.out.println("/tChild count: " +
entry.getChildCount());
System.out.println
("/tDescendant count: " + entry.getDescendantCount());
if (entry.isValid()) System.out.println("/tEntry is Valid");
else System.out.println("/tEntry is deletion stub");
entry = nav.getNext(); }
}

/**
* Example 得到指定数据的所有view
* @param db
* @throws NotesException
*/
public void getAllView(Database db) throws NotesException{
String title = db.getTitle();
Vector views = db.getViews();
int size = views.size();
System.out.println("Database /"" + title +
"/" has " + size + " views");
for (int i = 0; i<size; i++) {
String name =
((View)views.elementAt(i)).getName();
System.out.println
("View #" + (i+1) + ": " + name); }
}


/**
* Example 得到指定数据的所有FORM
* @throws NotesException
*
*
*/
public void getAllForm(Database db) throws NotesException {

Vector forms = db.getForms();
System.out.println("Forms in /"" + db.getTitle() + "/":");
for (int i = 0; i < forms.size(); i++) {

Form form = (Form) forms.elementAt(i);

System.out.println("/nForm name : " + form.getName());

Vector alias = form.getAliases();

if (alias.size() != 0) {
System.out.println("/tAlias/t: " + alias.elementAt(0));
for (int j = 1; j < alias.size(); j++)
System.out.println("/t /" /"/t: " + alias.elementAt(j));
}

System.out.println("/tProtect Readers/t: "
+ form.isProtectReaders());
System.out.println("/tProtect Users/t: " + form.isProtectUsers());
System.out.println("/tSub Form /t: " + form.isSubForm());
Vector users = form.getFormUsers();
if (users.size() != 0) {
System.out.println("/tForm users/t: " + users.elementAt(0));
for (int j = 1; j < users.size(); j++)
System.out.println("/t /" /" /t: "
+ users.elementAt(j));
}
Vector readers = form.getReaders();
if (readers.size() != 0) {
System.out.println("/tForm Readers/t: " + readers.elementAt(0));
for (int j = 1; j < readers.size(); j++)
System.out.println("/t /" /" /t: "
+ readers.elementAt(j));
}
Vector fields = form.getFields();
if (fields.size() != 0) {
System.out.println("/tFields /t: " + fields.elementAt(0));
for (int j = 1; j < fields.size(); j++)
System.out.println("/t /"/" /t: "
+ fields.elementAt(j));
}
}
}

/**
* 得到ITEM的所有属性.
* @param db
* @throws NotesException
*/
public void getAllItemP(Database db) throws NotesException{
DocumentCollection dc = db.getAllDocuments();
Document doc = dc.getFirstDocument();
Enumeration items = doc.getItems().elements();
while (items.hasMoreElements()) {
System.out.println("******");
Item item = (Item)items.nextElement();
System.out.println("Name: " + item.getName());
String type = "Undefined";
switch (item.getType()) {
case Item.ATTACHMENT :
type = "Attachment"; break;
case Item.EMBEDDEDOBJECT :
type = "Embedded object"; break;
case Item.ERRORITEM :
type = "Error item"; break;
case Item.NAMES :
type = "Names"; break;
case Item.AUTHORS :
type = "Authors"; break;
case Item.READERS :
type = "Readers"; break;
case Item.NOTELINKS :
type = "Note links"; break;
case Item.NOTEREFS :
type = "Note references"; break;
case Item.NUMBERS :
type = "Numbers"; break;
case Item.RICHTEXT :
type = "Rich text"; break;
case Item.TEXT :
type = "Text"; break;
case Item.SIGNATURE :
type = "Signature"; break;
case Item.DATETIMES :
type = "Date-times"; break;
case Item.UNAVAILABLE :
type = "Unavailable"; break;
case Item.UNKNOWN :
type = "Unknown"; break;
case Item.USERDATA :
type = "User data"; break;
case Item.USERID :
type = "User ID"; break;
}
System.out.println("Type: " + type);
if (item.isEncrypted())
System.out.println("Is encrypted");
if (item.isSigned())
System.out.println("Is signed");
if (item.isSummary())
System.out.println("Is summary");
if (item.isProtected())
System.out.println("Is protected");
System.out.println("Text:/n" + item.getText());
}
}

public static void main(String[] arg) throws NotesException, IOException, ClassNotFoundException{
LotusReadDB readDB=new LotusReadDB();

Database db=readDB.getDB(TESTDB2);
//-------------example get all form
//readDB.getAllForm(db);

//get "(Tracking Request)" 的form
//Form form=db.getForm("(ReturnNonReceipt)");
//System.out.println(form.getFields().toString()+" "+form.getName());

System.out.println();

//-------------example get all form
//readDB.getAllView(db);

View mailV=db.getView(TESTDB2VIEW);


//readDB.getEntryByView(mailV);

//---------------得到全部document
//readDB.getAllDocument(db);

//readDB.getAllDocument(mailV);

readDB.getDBDatas(TESTDB2,TESTDB2VIEW);

//readDB.getAllItemP(db);
}
}