Retrieve list of Lotus Notes forms

Retrieve list of Lotus Notes forms

This task retrieve list of Lotus Notes forms including name and xml data.

Retrieve list of Lotus Notes forms using java, DxlExporter and jsoup

1. Create getFormList as following
2. Call getFormList method as following

Call method

---

try {
    String idfile = "";
    String password = "";
    String server = "";
    String filepath = "";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    Database d = s.getDatabase(server, filepath);
    Map<String, String> forms = getFormList(d);
    for (String key : forms.keySet()) {
        logger.info("Form: " + key);
        logger.info(forms.get(key));
    }
} catch (Exception e) {
    logger.error("", e);
}
    

formattedraw

1	try {
2	String idfile = "";
3	String password = "";
4	String server = "";
5	String filepath = "";
6	NotesThread.sinitThread();
7	Session s = NotesFactory.createSessionWithFullAccess();
8	s.createRegistration().switchToID(idfile, password);
9	Database d = s.getDatabase(server, filepath);
10	Map<String, String> forms = getFormList(d);
11	for (String key : forms.keySet()) {
12	logger.info("Form: " + key);
13	logger.info(forms.get(key));
14	}
15	} catch (Exception e) {
16	logger.error("", e);
17	}

try {
    String idfile = "";
    String password = "";
    String server = "";
    String filepath = "";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    Database d = s.getDatabase(server, filepath);
    Map<String, String> forms = getFormList(d);
    for (String key : forms.keySet()) {
        logger.info("Form: " + key);
        logger.info(forms.get(key));
    }
} catch (Exception e) {
    logger.error("", e);
}

getFormList method

---

public Map<String, String> getFormList(Database db) {
    Map<String, String> tag = new HashMap<String, String>();
    try {
        NoteCollection nc = db.createNoteCollection(false);
        nc.setSelectForms(true);
        nc.buildCollection();
        String noteId = nc.getFirstNoteID();
        int fileNo = 0;
        while (noteId != null) {
            try {
                lotus.domino.Document doc = db.getDocumentByID(noteId);
                DxlExporter dxl = db.getParent().createDxlExporter();
                dxl.setConvertNotesBitmapsToGIF(true);
                String xml = dxl.exportDxl(doc);
                dxl.recycle();
                doc.recycle();

                xml = xml.substring(xml.indexOf("<form "));
                org.jsoup.nodes.Document jdoc = Jsoup.parse(xml);
                Element element = jdoc.select("form").first();
                tag.put(element.attr("name"), xml);
            } catch (Exception e) {
                logger.error("", e);
            }
       
            fileNo++;
            if (fileNo == nc.getCount()) {
                noteId = null;
            } else {
                noteId = nc.getNextNoteID(noteId);
            }
        }
        nc.recycle();
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}
    

formattedraw

1	public Map<String, String> getFormList(Database db) {
2	Map<String, String> tag = new HashMap<String, String>();
3	try {
4	NoteCollection nc = db.createNoteCollection(false);
5	nc.setSelectForms(true);
6	nc.buildCollection();
7	String noteId = nc.getFirstNoteID();
8	int fileNo = 0;
9	while (noteId != null) {
10	try {
11	lotus.domino.Document doc = db.getDocumentByID(noteId);
12	DxlExporter dxl = db.getParent().createDxlExporter();
13	dxl.setConvertNotesBitmapsToGIF(true);
14	String xml = dxl.exportDxl(doc);
15	dxl.recycle();
16	doc.recycle();
17
18	xml = xml.substring(xml.indexOf("<form "));
19	org.jsoup.nodes.Document jdoc = Jsoup.parse(xml);
20	Element element = jdoc.select("form").first();
21	tag.put(element.attr("name"), xml);
22	} catch (Exception e) {
23	logger.error("", e);
24	}
25
26	fileNo++;
27	if (fileNo == nc.getCount()) {
28	noteId = null;
29	} else {
30	noteId = nc.getNextNoteID(noteId);
31	}
32	}
33	nc.recycle();
34	} catch (Exception e) {
35	logger.error("", e);
36	}
37	return tag;
38	}

public Map<String, String> getFormList(Database db) {
    Map<String, String> tag = new HashMap<String, String>();
    try {
        NoteCollection nc = db.createNoteCollection(false);
        nc.setSelectForms(true);
        nc.buildCollection();
        String noteId = nc.getFirstNoteID();
        int fileNo = 0;
        while (noteId != null) {
            try {
                lotus.domino.Document doc = db.getDocumentByID(noteId);
                DxlExporter dxl = db.getParent().createDxlExporter();
                dxl.setConvertNotesBitmapsToGIF(true);
                String xml = dxl.exportDxl(doc);
                dxl.recycle();
                doc.recycle();

                xml = xml.substring(xml.indexOf("<form "));
                org.jsoup.nodes.Document jdoc = Jsoup.parse(xml);
                Element element = jdoc.select("form").first();
                tag.put(element.attr("name"), xml);
            } catch (Exception e) {
                logger.error("", e);
            }
       
            fileNo++;
            if (fileNo == nc.getCount()) {
                noteId = null;
            } else {
                noteId = nc.getNextNoteID(noteId);
            }
        }
        nc.recycle();
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}

Lotus Notes Java

 

Initialize logger by java

Initialize logger by java

This task use java to initialize logger.

Initialize logger

1. Create /cfg/log-conf.xml as following
2. Create initLog method as following
3. At beginning of program, call initLog method

/cfg/log-conf.xml

---

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration>
    <appender name="fileAppender" class="org.apache.log4j.RollingFileAppender">
        <param name="File"   value="log/bruchia.log" />
        <param name="Append" value="true" />
        <param name="MaxFileSize" value="1024KB" />
        <param name="MaxBackupIndex" value="10240" />
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" 
                   value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
        </layout>     
    </appender>
    <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern"
                   value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
        </layout>     
    </appender>
    
    <category name="org.apache.log4j.xml">
        <priority value="warn" />
        <appender-ref ref="fileAppender" />
        <appender-ref ref="STDOUT" />
    </category>
    
    <logger name="org.apache" >
            <level value ="warn" />
    </logger>
    
    <root>
        <priority value ="info" />
        <appender-ref ref="fileAppender" />
        <appender-ref ref="STDOUT" />
    </root>
</log4j:configuration>
    

formattedraw

1	<?xml version="1.0" encoding="UTF-8"?>
2	<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
3	<log4j:configuration>
4	<appender name="fileAppender" class="org.apache.log4j.RollingFileAppender">
5	<param name="File" value="log/bruchia.log" />
6	<param name="Append" value="true" />
7	<param name="MaxFileSize" value="1024KB" />
8	<param name="MaxBackupIndex" value="10240" />
9	<layout class="org.apache.log4j.PatternLayout">
10	<param name="ConversionPattern"
11	value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
12	</layout>
13	</appender>
14	<appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
15	<layout class="org.apache.log4j.PatternLayout">
16	<param name="ConversionPattern"
17	value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
18	</layout>
19	</appender>
20
21	<category name="org.apache.log4j.xml">
22	<priority value="warn" />
23	<appender-ref ref="fileAppender" />
24	<appender-ref ref="STDOUT" />
25	</category>
26
27	<logger name="org.apache" >
28	<level value ="warn" />
29	</logger>
30
31	<root>
32	<priority value ="info" />
33	<appender-ref ref="fileAppender" />
34	<appender-ref ref="STDOUT" />
35	</root>
36	</log4j:configuration>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration>
    <appender name="fileAppender" class="org.apache.log4j.RollingFileAppender">
        <param name="File"   value="log/bruchia.log" />
        <param name="Append" value="true" />
        <param name="MaxFileSize" value="1024KB" />
        <param name="MaxBackupIndex" value="10240" />
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" 
                   value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
        </layout>     
    </appender>
    <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern"
                   value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
        </layout>     
    </appender>
    
    <category name="org.apache.log4j.xml">
        <priority value="warn" />
        <appender-ref ref="fileAppender" />
        <appender-ref ref="STDOUT" />
    </category>
    
    <logger name="org.apache" >
            <level value ="warn" />
    </logger>
    
    <root>
        <priority value ="info" />
        <appender-ref ref="fileAppender" />
        <appender-ref ref="STDOUT" />
    </root>
</log4j:configuration>

initLog method

---

private static void initLog() {
    try {
        String configDir = new File(System.getProperty("user.dir"), "cfg").getAbsolutePath();
        String logConfigFile = new File(configDir, "log-conf.xml").getAbsolutePath();
        String logDir = new File(System.getProperty("user.dir"), "log").getAbsolutePath();
        String stdoutLogFile = new File(logDir, "stdout.log").getAbsolutePath();
   
        DOMConfigurator.configure(logConfigFile);
        System.setErr(new PrintStream(new BufferedOutputStream(new FileOutputStream(stdoutLogFile)), true));
        System.setOut(new PrintStream(new BufferedOutputStream(new FileOutputStream(stdoutLogFile)), true));
    } catch (Exception e) {
        e.printStackTrace();
    }
}
    

formattedraw

1	private static void initLog() {
2	try {
3	String configDir = new File(System.getProperty("user.dir"), "cfg").getAbsolutePath();
4	String logConfigFile = new File(configDir, "log-conf.xml").getAbsolutePath();
5	String logDir = new File(System.getProperty("user.dir"), "log").getAbsolutePath();
6	String stdoutLogFile = new File(logDir, "stdout.log").getAbsolutePath();
7
8	DOMConfigurator.configure(logConfigFile);
9	System.setErr(new PrintStream(new BufferedOutputStream(new FileOutputStream(stdoutLogFile)), true));
10	System.setOut(new PrintStream(new BufferedOutputStream(new FileOutputStream(stdoutLogFile)), true));
11	} catch (Exception e) {
12	e.printStackTrace();
13	}
14	}

private static void initLog() {
    try {
        String configDir = new File(System.getProperty("user.dir"), "cfg").getAbsolutePath();
        String logConfigFile = new File(configDir, "log-conf.xml").getAbsolutePath();
        String logDir = new File(System.getProperty("user.dir"), "log").getAbsolutePath();
        String stdoutLogFile = new File(logDir, "stdout.log").getAbsolutePath();
   
        DOMConfigurator.configure(logConfigFile);
        System.setErr(new PrintStream(new BufferedOutputStream(new FileOutputStream(stdoutLogFile)), true));
        System.setOut(new PrintStream(new BufferedOutputStream(new FileOutputStream(stdoutLogFile)), true));
    } catch (Exception e) {
        e.printStackTrace();
    }
}

Java

 

Format code with line number

Format code with line number.

This task use javascript to format code in <pre> tag with line number.

Format code with line number using jQuery

1. Put code in <pre class='code'></pre> tags.
2. Add following code at the end of page.

<style>
.code-viewer { border: solid 1px silver; font-family: monospace; font-size: 12px; padding: 5px; background-color: white; margin-bottom: 10px; }
.code-viewer-inner { width: 100%; border-top: solid 1px #E3E3E3; }
.code-viewer .line .number { width: 40px; background-color: teal; color: white; border-bottom: solid 1px #E3E3E3; padding: 0px 5px 0px 5px; }
.code-viewer .line .data { border-bottom: solid 1px #E3E3E3; white-space: pre-wrap; padding-left: 5px; }
.code-viewer .action { padding: 0px 0px 5px 0px; }
.code-viewer .action a { text-decoration: none; color: teal; font-family: Arial, sans-serif; font-size: 12px; font-weight: bold; margin: 0px 5px 0px 5px; }
.code-viewer .action a:hover { text-decoration: underline; }
.code-viewer .raw-code { display: none; }
</style>
<script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
<script>
var cv_ids = new Array();
function cv_getId() {
  var id = 'E' + Math.floor(Math.random() * 100000); 
  while (cv_ids.indexOf(id) >= 0) {
    id = 'E' + Math.floor(Math.random() * 100000); 
  }
  cv_ids.push(id);
  return id;
}
function cv_process(esrc) {
  esrc = $(esrc);
  var src = esrc.html();
  esrc.hide();
  var id = cv_getId();
  var id2 = cv_getId();
  var id3 = cv_getId();
  esrc.after("<div id='" + id + "' class='code-viewer'><div id='" + id2 + "' class='action'></div><table cellspacing='0' cellpadding='0' class='code-viewer-inner'></table><div id='" + id3 + "' class='raw-code'></div></div>");
  var etag = $('#' + id + ' .code-viewer-inner');
  var eaction = $('#' + id2);
  eaction.append("<a href='javascript:return false;' onclick=\"var e1 = $('#" + id + " .code-viewer-inner'); var e2 = $('#" + id3 + "'); e1.show(); e2.hide();\">formatted</a>");
  eaction.append("<a href='javascript:return false;' onclick=\"var e1 = $('#" + id + " .code-viewer-inner'); var e2 = $('#" + id3 + "'); e2.show(); e1.hide();\">raw</a>");
  var eraw = $('#' + id3);
  var lines = src.split('\n');
  var src2 = '';
  for (var i = 0; i < lines.length - 1; i++) {
    var line = lines[i];
    line = line.replace(/\</g, '<');
    line = line.replace(/\>/g, '>');
    id = cv_getId();
    etag.append("<tr id='" + id + "' class='line'></tr>");
    var eline = $('#' + id);
    id = cv_getId();
    id2 = cv_getId();
    eline.append("<td id='" + id + "' class='number'></td><td id='" + id2 + "' class='data'></td>");
    var enumber = $('#' + id);
    enumber.text(i + 1);
    var edata = $('#' + id2);
    edata.html(line);
    edata.css('white-space', 'pre-wrap');
    edata.css('font-family', 'monospace');
    src2 += line + '\n';
  }
  eraw.append("<pre>" + src2 + "</pre>");
}
var items = $('pre.code');
for (var i = 0; i < items.length; i++) {
  cv_process(items[i]);
}
</script>
    

formattedraw

1	<style>
2	.code-viewer { border: solid 1px silver; font-family: monospace; font-size: 12px; padding: 5px; background-color: white; margin-bottom: 10px; }
3	.code-viewer-inner { width: 100%; border-top: solid 1px #E3E3E3; }
4	.code-viewer .line .number { width: 40px; background-color: teal; color: white; border-bottom: solid 1px #E3E3E3; padding: 0px 5px 0px 5px; }
5	.code-viewer .line .data { border-bottom: solid 1px #E3E3E3; white-space: pre-wrap; padding-left: 5px; }
6	.code-viewer .action { padding: 0px 0px 5px 0px; }
7	.code-viewer .action a { text-decoration: none; color: teal; font-family: Arial, sans-serif; font-size: 12px; font-weight: bold; margin: 0px 5px 0px 5px; }
8	.code-viewer .action a:hover { text-decoration: underline; }
9	.code-viewer .raw-code { display: none; }
10	</style>
11	<script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
12	<script>
13	var cv_ids = new Array();
14	function cv_getId() {
15	var id = 'E' + Math.floor(Math.random() * 100000);
16	while (cv_ids.indexOf(id) >= 0) {
17	id = 'E' + Math.floor(Math.random() * 100000);
18	}
19	cv_ids.push(id);
20	return id;
21	}
22	function cv_process(esrc) {
23	esrc = $(esrc);
24	var src = esrc.html();
25	esrc.hide();
26	var id = cv_getId();
27	var id2 = cv_getId();
28	var id3 = cv_getId();
29	esrc.after("<div id='" + id + "' class='code-viewer'><div id='" + id2 + "' class='action'></div><table cellspacing='0' cellpadding='0' class='code-viewer-inner'></table><div id='" + id3 + "' class='raw-code'></div></div>");
30	var etag = $('#' + id + ' .code-viewer-inner');
31	var eaction = $('#' + id2);
32	eaction.append("<a href='javascript:return false;' onclick=\"var e1 = $('#" + id + " .code-viewer-inner'); var e2 = $('#" + id3 + "'); e1.show(); e2.hide();\">formatted</a>");
33	eaction.append("<a href='javascript:return false;' onclick=\"var e1 = $('#" + id + " .code-viewer-inner'); var e2 = $('#" + id3 + "'); e2.show(); e1.hide();\">raw</a>");
34	var eraw = $('#' + id3);
35	var lines = src.split('\n');
36	var src2 = '';
37	for (var i = 0; i < lines.length - 1; i++) {
38	var line = lines[i];
39	line = line.replace(/\</g, '<');
40	line = line.replace(/\>/g, '>');
41	id = cv_getId();
42	etag.append("<tr id='" + id + "' class='line'></tr>");
43	var eline = $('#' + id);
44	id = cv_getId();
45	id2 = cv_getId();
46	eline.append("<td id='" + id + "' class='number'></td><td id='" + id2 + "' class='data'></td>");
47	var enumber = $('#' + id);
48	enumber.text(i + 1);
49	var edata = $('#' + id2);
50	edata.html(line);
51	edata.css('white-space', 'pre-wrap');
52	edata.css('font-family', 'monospace');
53	src2 += line + '\n';
54	}
55	eraw.append("<pre>" + src2 + "</pre>");
56	}
57	var items = $('pre.code');
58	for (var i = 0; i < items.length; i++) {
59	cv_process(items[i]);
60	}
61	</script>

<style>
.code-viewer { border: solid 1px silver; font-family: monospace; font-size: 12px; padding: 5px; background-color: white; margin-bottom: 10px; }
.code-viewer-inner { width: 100%; border-top: solid 1px #E3E3E3; }
.code-viewer .line .number { width: 40px; background-color: teal; color: white; border-bottom: solid 1px #E3E3E3; padding: 0px 5px 0px 5px; }
.code-viewer .line .data { border-bottom: solid 1px #E3E3E3; white-space: pre-wrap; padding-left: 5px; }
.code-viewer .action { padding: 0px 0px 5px 0px; }
.code-viewer .action a { text-decoration: none; color: teal; font-family: Arial, sans-serif; font-size: 12px; font-weight: bold; margin: 0px 5px 0px 5px; }
.code-viewer .action a:hover { text-decoration: underline; }
.code-viewer .raw-code { display: none; }
</style>
<script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
<script>
var cv_ids = new Array();
function cv_getId() {
  var id = 'E' + Math.floor(Math.random() * 100000); 
  while (cv_ids.indexOf(id) >= 0) {
    id = 'E' + Math.floor(Math.random() * 100000); 
  }
  cv_ids.push(id);
  return id;
}
function cv_process(esrc) {
  esrc = $(esrc);
  var src = esrc.html();
  esrc.hide();
  var id = cv_getId();
  var id2 = cv_getId();
  var id3 = cv_getId();
  esrc.after("<div id='" + id + "' class='code-viewer'><div id='" + id2 + "' class='action'></div><table cellspacing='0' cellpadding='0' class='code-viewer-inner'></table><div id='" + id3 + "' class='raw-code'></div></div>");
  var etag = $('#' + id + ' .code-viewer-inner');
  var eaction = $('#' + id2);
  eaction.append("<a href='javascript:return false;' onclick=\"var e1 = $('#" + id + " .code-viewer-inner'); var e2 = $('#" + id3 + "'); e1.show(); e2.hide();\">formatted</a>");
  eaction.append("<a href='javascript:return false;' onclick=\"var e1 = $('#" + id + " .code-viewer-inner'); var e2 = $('#" + id3 + "'); e2.show(); e1.hide();\">raw</a>");
  var eraw = $('#' + id3);
  var lines = src.split('\n');
  var src2 = '';
  for (var i = 0; i < lines.length - 1; i++) {
    var line = lines[i];
    line = line.replace(/\</g, '<');
    line = line.replace(/\>/g, '>');
    id = cv_getId();
    etag.append("<tr id='" + id + "' class='line'></tr>");
    var eline = $('#' + id);
    id = cv_getId();
    id2 = cv_getId();
    eline.append("<td id='" + id + "' class='number'></td><td id='" + id2 + "' class='data'></td>");
    var enumber = $('#' + id);
    enumber.text(i + 1);
    var edata = $('#' + id2);
    edata.html(line);
    edata.css('white-space', 'pre-wrap');
    edata.css('font-family', 'monospace');
    src2 += line + '\n';
  }
  eraw.append("<pre>" + src2 + "</pre>");
}
var items = $('pre.code');
for (var i = 0; i < items.length; i++) {
  cv_process(items[i]);
}
</script>

JavaScript

 

Retrieve unique id by javascript

Retrieve unique id by javascript

This task use javascript to generate id which is unique in page.

Retrieve unique id using Math.random

var uniqid_list = new Array();
function uniqid() {
    var id = 'E' + Math.floor(Math.random() * 100000);
    while (uniqid_list.indexOf(id) >= 0) {
        id = 'E' + Math.floor(Math.random() * 100000);
    }
    uniqid_list.push(id);
    return id;
}
    

formattedraw

1	var uniqid_list = new Array();
2	function uniqid() {
3	var id = 'E' + Math.floor(Math.random() * 100000);
4	while (uniqid_list.indexOf(id) >= 0) {
5	id = 'E' + Math.floor(Math.random() * 100000);
6	}
7	uniqid_list.push(id);
8	return id;
9	}

var uniqid_list = new Array();
function uniqid() {
    var id = 'E' + Math.floor(Math.random() * 100000);
    while (uniqid_list.indexOf(id) >= 0) {
        id = 'E' + Math.floor(Math.random() * 100000);
    }
    uniqid_list.push(id);
    return id;
}

JavaScript

 

Verify table structure

Verify table structure

This task use java to check table structure and create new table if table structure is not valid.

Verify table structure

1. Create checkTable as following
2. Call checkTable as following

Call method

---

try {
    String dbfile = "C:\\Temp\\test.db";
    Class.forName("org.sqlite.JDBC");
    Connection conn = DriverManager.getConnection("jdbc:sqlite:" + dbfile);
    boolean valid = checkTable(conn, "element", new String[] { "id", "db_id", "eleType", "eleName", "eleFormula", "eleFlags", "eleParentObject", "eleModifiedBy", "eleModified", "score" });
    if (!valid) {
        Statement stat = conn.createStatement();
        stat.executeUpdate("drop table if exists element;");
        stat.executeUpdate("create table element (id char(36) not null primary key, db_id char(36) not null, eleType varchar(255) default null, eleName varchar(255) default null, eleFormula text default null, eleFlags varchar(8000) default null, eleParentObject varchar(255) default null, eleModifiedBy varchar(255) default null, eleModified varchar(50) default null, score int default 0);");
        stat.close();
    }
} catch (Exception e) {
    logger.error("", e);
}
    

formattedraw

1	try {
2	String dbfile = "C:\\Temp\\test.db";
3	Class.forName("org.sqlite.JDBC");
4	Connection conn = DriverManager.getConnection("jdbc:sqlite:" + dbfile);
5	boolean valid = checkTable(conn, "element", new String[] { "id", "db_id", "eleType", "eleName", "eleFormula", "eleFlags", "eleParentObject", "eleModifiedBy", "eleModified", "score" });
6	if (!valid) {
7	Statement stat = conn.createStatement();
8	stat.executeUpdate("drop table if exists element;");
9	stat.executeUpdate("create table element (id char(36) not null primary key, db_id char(36) not null, eleType varchar(255) default null, eleName varchar(255) default null, eleFormula text default null, eleFlags varchar(8000) default null, eleParentObject varchar(255) default null, eleModifiedBy varchar(255) default null, eleModified varchar(50) default null, score int default 0);");
10	stat.close();
11	}
12	} catch (Exception e) {
13	logger.error("", e);
14	}

try {
    String dbfile = "C:\\Temp\\test.db";
    Class.forName("org.sqlite.JDBC");
    Connection conn = DriverManager.getConnection("jdbc:sqlite:" + dbfile);
    boolean valid = checkTable(conn, "element", new String[] { "id", "db_id", "eleType", "eleName", "eleFormula", "eleFlags", "eleParentObject", "eleModifiedBy", "eleModified", "score" });
    if (!valid) {
        Statement stat = conn.createStatement();
        stat.executeUpdate("drop table if exists element;");
        stat.executeUpdate("create table element (id char(36) not null primary key, db_id char(36) not null, eleType varchar(255) default null, eleName varchar(255) default null, eleFormula text default null, eleFlags varchar(8000) default null, eleParentObject varchar(255) default null, eleModifiedBy varchar(255) default null, eleModified varchar(50) default null, score int default 0);");
        stat.close();
    }
} catch (Exception e) {
    logger.error("", e);
}

checkTable method

---

private boolean checkTable(Connection conn, String table, String[] fields) {
    try {
        PreparedStatement prep = conn.prepareStatement("select * from " + table + " where (1=0);");
        ResultSet rs = prep.executeQuery();
        ResultSetMetaData md = rs.getMetaData();
        List<String> cols = new ArrayList<String>();
        for (int i = 1; i <= md.getColumnCount(); i++) {
            cols.add(md.getColumnName(i).toLowerCase());
        }
        rs.close();
        prep.close();

        if (fields.length > cols.size()) return false;
        for (int i = 0; i < fields.length; i++) {
            if (cols.indexOf(fields[i].toLowerCase()) < 0) {
                return false;
            }
        }
        return true;
    } catch (Exception e) {
        logger.error("", e);
        return false;
    }
}
    

formattedraw

1	private boolean checkTable(Connection conn, String table, String[] fields) {
2	try {
3	PreparedStatement prep = conn.prepareStatement("select * from " + table + " where (1=0);");
4	ResultSet rs = prep.executeQuery();
5	ResultSetMetaData md = rs.getMetaData();
6	List<String> cols = new ArrayList<String>();
7	for (int i = 1; i <= md.getColumnCount(); i++) {
8	cols.add(md.getColumnName(i).toLowerCase());
9	}
10	rs.close();
11	prep.close();
12
13	if (fields.length > cols.size()) return false;
14	for (int i = 0; i < fields.length; i++) {
15	if (cols.indexOf(fields[i].toLowerCase()) < 0) {
16	return false;
17	}
18	}
19	return true;
20	} catch (Exception e) {
21	logger.error("", e);
22	return false;
23	}
24	}

private boolean checkTable(Connection conn, String table, String[] fields) {
    try {
        PreparedStatement prep = conn.prepareStatement("select * from " + table + " where (1=0);");
        ResultSet rs = prep.executeQuery();
        ResultSetMetaData md = rs.getMetaData();
        List<String> cols = new ArrayList<String>();
        for (int i = 1; i <= md.getColumnCount(); i++) {
            cols.add(md.getColumnName(i).toLowerCase());
        }
        rs.close();
        prep.close();

        if (fields.length > cols.size()) return false;
        for (int i = 0; i < fields.length; i++) {
            if (cols.indexOf(fields[i].toLowerCase()) < 0) {
                return false;
            }
        }
        return true;
    } catch (Exception e) {
        logger.error("", e);
        return false;
    }
}

Java

 

Redirect blog post to another web page

Redirect blog post to another web page

This task use javascript to redirect blog post to another web page.

Redirect blog post to another web page

<script>
var srcUrl = 'URL of blog post';
var tagUrl = 'URL of new web page';
var curUrl = window.location + '';
if (srcUrl != '' && tagUrl != '' && srcUrl.toLowerCase() == curUrl.toLowerCase()) {
  window.location.replace(tagUrl);
}
</script>
    

formattedraw

1	<script>
2	var srcUrl = 'URL of blog post';
3	var tagUrl = 'URL of new web page';
4	var curUrl = window.location + '';
5	if (srcUrl != '' && tagUrl != '' && srcUrl.toLowerCase() == curUrl.toLowerCase()) {
6	window.location.replace(tagUrl);
7	}
8	</script>

<script>
var srcUrl = 'URL of blog post';
var tagUrl = 'URL of new web page';
var curUrl = window.location + '';
if (srcUrl != '' && tagUrl != '' && srcUrl.toLowerCase() == curUrl.toLowerCase()) {
  window.location.replace(tagUrl);
}
</script>

JavaScript

 

Retrieve list of documents in Lotus Notes database

Retrieve list of documents in Lotus Notes database

This task use java to retrieve list of documents in Lotus Notes database.

Filter documents with aliases

1. Create getDocuments method as following
2. Call getDocuments method as following

Call method

---

try {
    String idfile = "path to your id file";
    String password = "your password";
    // <server>!!<filepath> | <filepath>
    String filename = "path to database file";
    String form = "your form";
    String filter = "your document filter";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    Database d = openDatabase(s, filename);
    DocumentCollection dc = getDocuments(d, form, filter);
    logger.info(dc.getCount());
    d.recycle();
    s.recycle();
} catch (Exception e) {
    logger.info("", e);
}
    

formattedraw

1	try {
2	String idfile = "path to your id file";
3	String password = "your password";
4	// <server>!!<filepath> | <filepath>
5	String filename = "path to database file";
6	String form = "your form";
7	String filter = "your document filter";
8	NotesThread.sinitThread();
9	Session s = NotesFactory.createSessionWithFullAccess();
10	s.createRegistration().switchToID(idfile, password);
11	Database d = openDatabase(s, filename);
12	DocumentCollection dc = getDocuments(d, form, filter);
13	logger.info(dc.getCount());
14	d.recycle();
15	s.recycle();
16	} catch (Exception e) {
17	logger.info("", e);
18	}

try {
    String idfile = "path to your id file";
    String password = "your password";
    // <server>!!<filepath> | <filepath>
    String filename = "path to database file";
    String form = "your form";
    String filter = "your document filter";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    Database d = openDatabase(s, filename);
    DocumentCollection dc = getDocuments(d, form, filter);
    logger.info(dc.getCount());
    d.recycle();
    s.recycle();
} catch (Exception e) {
    logger.info("", e);
}

getDocuments method

---

public DocumentCollection getDocuments(Database database, String form, String filter) throws Exception {
    if (filter.trim().length() == 0) {
        return database.search(grabFormCond(database, form));
    } else {
        return database.search(grabFormCond(database, form) + " & (" + filter + ")");
    }  
}  
  
private String grabFormCond(Database database, String form) throws Exception {
    String target = "((Form='" + form + "')";
    try {
        Vector aliases = database.getForm(form).getAliases();
        for (int i = 0; i < aliases.size(); i++) {
            target += "|(Form='" + aliases.get(i) + "')";
        }
    } catch (Exception e) {
        logger.error("", e);
    }
    return target + ")";
}
    

formattedraw

1	public DocumentCollection getDocuments(Database database, String form, String filter) throws Exception {
2	if (filter.trim().length() == 0) {
3	return database.search(grabFormCond(database, form));
4	} else {
5	return database.search(grabFormCond(database, form) + " & (" + filter + ")");
6	}
7	}
8
9	private String grabFormCond(Database database, String form) throws Exception {
10	String target = "((Form='" + form + "')";
11	try {
12	Vector aliases = database.getForm(form).getAliases();
13	for (int i = 0; i < aliases.size(); i++) {
14	target += "|(Form='" + aliases.get(i) + "')";
15	}
16	} catch (Exception e) {
17	logger.error("", e);
18	}
19	return target + ")";
20	}

public DocumentCollection getDocuments(Database database, String form, String filter) throws Exception {
    if (filter.trim().length() == 0) {
        return database.search(grabFormCond(database, form));
    } else {
        return database.search(grabFormCond(database, form) + " & (" + filter + ")");
    }  
}  
  
private String grabFormCond(Database database, String form) throws Exception {
    String target = "((Form='" + form + "')";
    try {
        Vector aliases = database.getForm(form).getAliases();
        for (int i = 0; i < aliases.size(); i++) {
            target += "|(Form='" + aliases.get(i) + "')";
        }
    } catch (Exception e) {
        logger.error("", e);
    }
    return target + ")";
}

Lotus Notes Java

 

Open Lotus Notes database

Open Lotus Notes database

This task use java to open Lotus Notes database.

Open Lotus Notes database using DbDirectory

1. Create openDatabase method as following
2. Call openDatabase method as following

Call method

---

try {
    String idfile = "path to your id file";
    String password = "your password";
    // <server>!!<filepath> | <filepath>
    String filename = "path to database file";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    Database d = openDatabase(s, filename);
    logger.info(d.getTitle() + " | " + d.getFilePath());
    d.recycle();
    s.recycle();
} catch (Exception e) {
    logger.info("", e);
}
    

formattedraw

1	try {
2	String idfile = "path to your id file";
3	String password = "your password";
4	// <server>!!<filepath> | <filepath>
5	String filename = "path to database file";
6	NotesThread.sinitThread();
7	Session s = NotesFactory.createSessionWithFullAccess();
8	s.createRegistration().switchToID(idfile, password);
9	Database d = openDatabase(s, filename);
10	logger.info(d.getTitle() + " | " + d.getFilePath());
11	d.recycle();
12	s.recycle();
13	} catch (Exception e) {
14	logger.info("", e);
15	}

try {
    String idfile = "path to your id file";
    String password = "your password";
    // <server>!!<filepath> | <filepath>
    String filename = "path to database file";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    Database d = openDatabase(s, filename);
    logger.info(d.getTitle() + " | " + d.getFilePath());
    d.recycle();
    s.recycle();
} catch (Exception e) {
    logger.info("", e);
}

openDatabase method

---

private Database openDatabase(Session session, String filename) throws Exception {
    int pos = filename.indexOf("!!");
    Database tag = null;
    if (pos < 0) {
        DbDirectory dir = session.getDbDirectory("");
        tag = dir.openDatabase(filename);
    } else {  
        String server = filename.substring(0, pos);
        String path = filename.substring(pos + 2, filename.length());
        DbDirectory dir = session.getDbDirectory(server);
        tag = dir.openDatabase(path);
    }
    return tag;
}
    

formattedraw

1	private Database openDatabase(Session session, String filename) throws Exception {
2	int pos = filename.indexOf("!!");
3	Database tag = null;
4	if (pos < 0) {
5	DbDirectory dir = session.getDbDirectory("");
6	tag = dir.openDatabase(filename);
7	} else {
8	String server = filename.substring(0, pos);
9	String path = filename.substring(pos + 2, filename.length());
10	DbDirectory dir = session.getDbDirectory(server);
11	tag = dir.openDatabase(path);
12	}
13	return tag;
14	}

private Database openDatabase(Session session, String filename) throws Exception {
    int pos = filename.indexOf("!!");
    Database tag = null;
    if (pos < 0) {
        DbDirectory dir = session.getDbDirectory("");
        tag = dir.openDatabase(filename);
    } else {  
        String server = filename.substring(0, pos);
        String path = filename.substring(pos + 2, filename.length());
        DbDirectory dir = session.getDbDirectory(server);
        tag = dir.openDatabase(path);
    }
    return tag;
}

Lotus Notes Java

 

Retrieve list of databases on Lotus Notes server

Retrieve list of databases on Lotus Notes server

This task use java to retrieve list of databases on Lotus Notes server.

Retrieve list of databases using DbDirectory

1. Create listDatabase method as following
2. Call listDatabase method as following

Call method

---

try {
    String idfile = "path to your id file";
    String password = "your password";
    String server = "your server, empty if local";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    List<Database> dblist = listDatabase(s, server);
    for (int i = 0; i < dblist.size(); i++) {
        Database db = dblist.get(i);
        logger.info(db.getTitle() + " | " + db.getFilePath());
        db.recycle();
    }
    s.recycle();
} catch (Exception e) {
    logger.info("", e);
}
    

formattedraw

1	try {
2	String idfile = "path to your id file";
3	String password = "your password";
4	String server = "your server, empty if local";
5	NotesThread.sinitThread();
6	Session s = NotesFactory.createSessionWithFullAccess();
7	s.createRegistration().switchToID(idfile, password);
8	List<Database> dblist = listDatabase(s, server);
9	for (int i = 0; i < dblist.size(); i++) {
10	Database db = dblist.get(i);
11	logger.info(db.getTitle() + " | " + db.getFilePath());
12	db.recycle();
13	}
14	s.recycle();
15	} catch (Exception e) {
16	logger.info("", e);
17	}

try {
    String idfile = "path to your id file";
    String password = "your password";
    String server = "your server, empty if local";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    List<Database> dblist = listDatabase(s, server);
    for (int i = 0; i < dblist.size(); i++) {
        Database db = dblist.get(i);
        logger.info(db.getTitle() + " | " + db.getFilePath());
        db.recycle();
    }
    s.recycle();
} catch (Exception e) {
    logger.info("", e);
}

listDatabase method

---

private List<Database> listDatabase(Session session, String server) throws Exception {
    List<Database> tag = new ArrayList<Database>();
    DbDirectory dir = session.getDbDirectory(server);
    Database db = dir.getFirstDatabase(DbDirectory.DATABASE);
    while (db != null) {
        tag.add(db);
        db = dir.getNextDatabase();
    }
    db = dir.getFirstDatabase(DbDirectory.TEMPLATE);
    while (db != null) {
        tag.add(db);
        db = dir.getNextDatabase();
    }
    return tag;
}
    

formattedraw

1	private List<Database> listDatabase(Session session, String server) throws Exception {
2	List<Database> tag = new ArrayList<Database>();
3	DbDirectory dir = session.getDbDirectory(server);
4	Database db = dir.getFirstDatabase(DbDirectory.DATABASE);
5	while (db != null) {
6	tag.add(db);
7	db = dir.getNextDatabase();
8	}
9	db = dir.getFirstDatabase(DbDirectory.TEMPLATE);
10	while (db != null) {
11	tag.add(db);
12	db = dir.getNextDatabase();
13	}
14	return tag;
15	}

private List<Database> listDatabase(Session session, String server) throws Exception {
    List<Database> tag = new ArrayList<Database>();
    DbDirectory dir = session.getDbDirectory(server);
    Database db = dir.getFirstDatabase(DbDirectory.DATABASE);
    while (db != null) {
        tag.add(db);
        db = dir.getNextDatabase();
    }
    db = dir.getFirstDatabase(DbDirectory.TEMPLATE);
    while (db != null) {
        tag.add(db);
        db = dir.getNextDatabase();
    }
    return tag;
}

Lotus Notes Java

 

Retrieve name of current user of Lotus Notes by java

Retrieve name of current user of Lotus Notes by java

This task use java to retrieve name of current user of Lotus Notes.

Extract name of current user of Lotus Notes

1. Create getUsername method as following
2. Call getUsername method as following

Call method

---

try {
    String idfile = "path to your id file";
    String password = "your password";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    String username = getUsername(s);
    logger.info(username);
} catch (Exception e) {
    logger.info("", e);
}
    

formattedraw

1	try {
2	String idfile = "path to your id file";
3	String password = "your password";
4	NotesThread.sinitThread();
5	Session s = NotesFactory.createSessionWithFullAccess();
6	s.createRegistration().switchToID(idfile, password);
7	String username = getUsername(s);
8	logger.info(username);
9	} catch (Exception e) {
10	logger.info("", e);
11	}

try {
    String idfile = "path to your id file";
    String password = "your password";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    String username = getUsername(s);
    logger.info(username);
} catch (Exception e) {
    logger.info("", e);
}

getUsername method

---

private String getUsername(Session session) throws Exception {
    String noteUser = session.getUserName();
    String[] fields = noteUser.split("/");
    for (int i = 0; i < fields.length; i++) {
        int pos = fields[i].indexOf("=");
        if (i == 0) {
            noteUser = fields[i].substring(pos + 1);
        } else {
            noteUser += "/" + fields[i].substring(pos + 1);
        }
    }
    return noteUser;
}
    

formattedraw

1	private String getUsername(Session session) throws Exception {
2	String noteUser = session.getUserName();
3	String[] fields = noteUser.split("/");
4	for (int i = 0; i < fields.length; i++) {
5	int pos = fields[i].indexOf("=");
6	if (i == 0) {
7	noteUser = fields[i].substring(pos + 1);
8	} else {
9	noteUser += "/" + fields[i].substring(pos + 1);
10	}
11	}
12	return noteUser;
13	}

private String getUsername(Session session) throws Exception {
    String noteUser = session.getUserName();
    String[] fields = noteUser.split("/");
    for (int i = 0; i < fields.length; i++) {
        int pos = fields[i].indexOf("=");
        if (i == 0) {
            noteUser = fields[i].substring(pos + 1);
        } else {
            noteUser += "/" + fields[i].substring(pos + 1);
        }
    }
    return noteUser;
}

Lotus Notes Java

 

Retrieve version of Lotus Notes by java

Retrieve version of Lotus Notes by java

This task use java to retrieve version of Lotus Notes.

Extract version of Lotus Notes

1. Create getNotesVersion method as following
2. Call getNotesVersion method as following

Call method

---

try {
    String idfile = "path to your id file";
    String password = "your password";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    String version = getNotesVersion(s);
    logger.info(version);
} catch (Exception e) {
    logger.info("", e);
}
    

formattedraw

1	try {
2	String idfile = "path to your id file";
3	String password = "your password";
4	NotesThread.sinitThread();
5	Session s = NotesFactory.createSessionWithFullAccess();
6	s.createRegistration().switchToID(idfile, password);
7	String version = getNotesVersion(s);
8	logger.info(version);
9	} catch (Exception e) {
10	logger.info("", e);
11	}

try {
    String idfile = "path to your id file";
    String password = "your password";
    NotesThread.sinitThread();
    Session s = NotesFactory.createSessionWithFullAccess();
    s.createRegistration().switchToID(idfile, password);
    String version = getNotesVersion(s);
    logger.info(version);
} catch (Exception e) {
    logger.info("", e);
}

getNotesVersion method

---

private String getNotesVersion(Session session) throws Exception {
    String version = session.getNotesVersion();
    int pos = version.indexOf("|");
    if (pos >= 0) {
        version = version.substring(0, pos);
    }
    pos = version.indexOf("Release ");
    if (pos >= 0) {
        version = version.substring(pos + 8);
    }
    return version;
}
    

formattedraw

1	private String getNotesVersion(Session session) throws Exception {
2	String version = session.getNotesVersion();
3	int pos = version.indexOf("|");
4	if (pos >= 0) {
5	version = version.substring(0, pos);
6	}
7	pos = version.indexOf("Release ");
8	if (pos >= 0) {
9	version = version.substring(pos + 8);
10	}
11	return version;
12	}

private String getNotesVersion(Session session) throws Exception {
    String version = session.getNotesVersion();
    int pos = version.indexOf("|");
    if (pos >= 0) {
        version = version.substring(0, pos);
    }
    pos = version.indexOf("Release ");
    if (pos >= 0) {
        version = version.substring(pos + 8);
    }
    return version;
}

Lotus Notes Java

 

Encrypt and decrypt string by java

Encrypt and decrypt string by java

This task use java to encrypt and decrypt string.

Encrypt and decrypt string using AES

1. Create Crypto.java as following
2. Call encrypt and decrypt methods as following

Call methods

---

try {
    String key = UUID.randomUUID().toString().replaceAll("-", "");
    String src = "Hello world!";
    String tag1 = Crypto.encrypt(src, key);
    String tag2 = Crypto.decrypt(tag1, key);
    logger.info(src);
    logger.info(tag1);
    logger.info(tag2);
} catch (Exception e) {
    logger.error("", e);
}
    

formattedraw

1	try {
2	String key = UUID.randomUUID().toString().replaceAll("-", "");
3	String src = "Hello world!";
4	String tag1 = Crypto.encrypt(src, key);
5	String tag2 = Crypto.decrypt(tag1, key);
6	logger.info(src);
7	logger.info(tag1);
8	logger.info(tag2);
9	} catch (Exception e) {
10	logger.error("", e);
11	}

try {
    String key = UUID.randomUUID().toString().replaceAll("-", "");
    String src = "Hello world!";
    String tag1 = Crypto.encrypt(src, key);
    String tag2 = Crypto.decrypt(tag1, key);
    logger.info(src);
    logger.info(tag1);
    logger.info(tag2);
} catch (Exception e) {
    logger.error("", e);
}

Crypto.java

---

public class Crypto {

    public static String encrypt(String value, String key) throws GeneralSecurityException {
        SecretKeySpec sks = new SecretKeySpec(hexStringToByteArray(key), "AES");
        Cipher cipher = Cipher.getInstance("AES");
        cipher.init(Cipher.ENCRYPT_MODE, sks, cipher.getParameters());
        byte[] encrypted = cipher.doFinal(value.getBytes());
        return byteArrayToHexString(encrypted);
    }

    public static String decrypt(String message, String key) throws GeneralSecurityException {
        SecretKeySpec sks = new SecretKeySpec(hexStringToByteArray(key), "AES");
        Cipher cipher = Cipher.getInstance("AES");
        cipher.init(Cipher.DECRYPT_MODE, sks);
        byte[] decrypted = cipher.doFinal(hexStringToByteArray(message));
        return new String(decrypted);
    }   
    
    private static String byteArrayToHexString(byte[] b){
        StringBuffer sb = new StringBuffer(b.length * 2);
        for (int i = 0; i < b.length; i++){
            int v = b[i] & 0xff;
            if (v < 16) {
                sb.append('0');
            }
            sb.append(Integer.toHexString(v));
        }
        return sb.toString().toUpperCase();
    }
   
    private static byte[] hexStringToByteArray(String s) {
        byte[] b = new byte[s.length() / 2];
        for (int i = 0; i < b.length; i++){
            int index = i * 2;
            int v = Integer.parseInt(s.substring(index, index + 2), 16);
            b[i] = (byte)v;
        }
        return b;
    }
     
}
    

formattedraw

1	public class Crypto {
2
3	public static String encrypt(String value, String key) throws GeneralSecurityException {
4	SecretKeySpec sks = new SecretKeySpec(hexStringToByteArray(key), "AES");
5	Cipher cipher = Cipher.getInstance("AES");
6	cipher.init(Cipher.ENCRYPT_MODE, sks, cipher.getParameters());
7	byte[] encrypted = cipher.doFinal(value.getBytes());
8	return byteArrayToHexString(encrypted);
9	}
10
11	public static String decrypt(String message, String key) throws GeneralSecurityException {
12	SecretKeySpec sks = new SecretKeySpec(hexStringToByteArray(key), "AES");
13	Cipher cipher = Cipher.getInstance("AES");
14	cipher.init(Cipher.DECRYPT_MODE, sks);
15	byte[] decrypted = cipher.doFinal(hexStringToByteArray(message));
16	return new String(decrypted);
17	}
18
19	private static String byteArrayToHexString(byte[] b){
20	StringBuffer sb = new StringBuffer(b.length * 2);
21	for (int i = 0; i < b.length; i++){
22	int v = b[i] & 0xff;
23	if (v < 16) {
24	sb.append('0');
25	}
26	sb.append(Integer.toHexString(v));
27	}
28	return sb.toString().toUpperCase();
29	}
30
31	private static byte[] hexStringToByteArray(String s) {
32	byte[] b = new byte[s.length() / 2];
33	for (int i = 0; i < b.length; i++){
34	int index = i * 2;
35	int v = Integer.parseInt(s.substring(index, index + 2), 16);
36	b[i] = (byte)v;
37	}
38	return b;
39	}
40
41	}

public class Crypto {

    public static String encrypt(String value, String key) throws GeneralSecurityException {
        SecretKeySpec sks = new SecretKeySpec(hexStringToByteArray(key), "AES");
        Cipher cipher = Cipher.getInstance("AES");
        cipher.init(Cipher.ENCRYPT_MODE, sks, cipher.getParameters());
        byte[] encrypted = cipher.doFinal(value.getBytes());
        return byteArrayToHexString(encrypted);
    }

    public static String decrypt(String message, String key) throws GeneralSecurityException {
        SecretKeySpec sks = new SecretKeySpec(hexStringToByteArray(key), "AES");
        Cipher cipher = Cipher.getInstance("AES");
        cipher.init(Cipher.DECRYPT_MODE, sks);
        byte[] decrypted = cipher.doFinal(hexStringToByteArray(message));
        return new String(decrypted);
    }   
    
    private static String byteArrayToHexString(byte[] b){
        StringBuffer sb = new StringBuffer(b.length * 2);
        for (int i = 0; i < b.length; i++){
            int v = b[i] & 0xff;
            if (v < 16) {
                sb.append('0');
            }
            sb.append(Integer.toHexString(v));
        }
        return sb.toString().toUpperCase();
    }
   
    private static byte[] hexStringToByteArray(String s) {
        byte[] b = new byte[s.length() / 2];
        for (int i = 0; i < b.length; i++){
            int index = i * 2;
            int v = Integer.parseInt(s.substring(index, index + 2), 16);
            b[i] = (byte)v;
        }
        return b;
    }
     
}

Java

 

Save hash table to string

Save hash table to string

This task use java to save hash table to string.

Save hash table to string using ByteArrayOutputStream

public String writeHash(Properties properties) {
    String tag = "";
    try {
        ByteArrayOutputStream baos = new ByteArrayOutputStream();
        properties.store(baos, "");
        tag = baos.toString();
        baos.close();
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}
    

formattedraw

1	public String writeHash(Properties properties) {
2	String tag = "";
3	try {
4	ByteArrayOutputStream baos = new ByteArrayOutputStream();
5	properties.store(baos, "");
6	tag = baos.toString();
7	baos.close();
8	} catch (Exception e) {
9	logger.error("", e);
10	}
11	return tag;
12	}

public String writeHash(Properties properties) {
    String tag = "";
    try {
        ByteArrayOutputStream baos = new ByteArrayOutputStream();
        properties.store(baos, "");
        tag = baos.toString();
        baos.close();
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}

Java

 

Load hash table from string

Load hash table from string

This task use java to load hash table from string.

Load hash table from string using ByteArrayInputStream

public void readHash(Properties properties, String src) {
    try {
        ByteArrayInputStream bais = new ByteArrayInputStream(src.getBytes()); 
        properties.load(bais);
        bais.close();
    } catch (Exception e) {
        logger.error("", e);
    }
}
    

formattedraw

1	public void readHash(Properties properties, String src) {
2	try {
3	ByteArrayInputStream bais = new ByteArrayInputStream(src.getBytes());
4	properties.load(bais);
5	bais.close();
6	} catch (Exception e) {
7	logger.error("", e);
8	}
9	}

public void readHash(Properties properties, String src) {
    try {
        ByteArrayInputStream bais = new ByteArrayInputStream(src.getBytes()); 
        properties.load(bais);
        bais.close();
    } catch (Exception e) {
        logger.error("", e);
    }
}

Java

 

Load hash table from file

Load hash table from file

This task use java to load hash table from file.

Load hash table from file using FileInputStream

public void loadHash(Properties properties, String filename) {
    try {
        FileInputStream fis = new FileInputStream(filename); 
        properties.load(fis);
        fis.close();
    } catch (Exception e) {
        logger.error("", e);
    }
}
    

formattedraw

1	public void loadHash(Properties properties, String filename) {
2	try {
3	FileInputStream fis = new FileInputStream(filename);
4	properties.load(fis);
5	fis.close();
6	} catch (Exception e) {
7	logger.error("", e);
8	}
9	}

public void loadHash(Properties properties, String filename) {
    try {
        FileInputStream fis = new FileInputStream(filename); 
        properties.load(fis);
        fis.close();
    } catch (Exception e) {
        logger.error("", e);
    }
}

Java

 

Save hash table to file

Save hash table to file

This task use java to save hash table to file.

Save hash table to file using FileOutputStream

public void saveHash(Properties properties, String filename) {
    try {
        FileOutputStream fos = new FileOutputStream(filename); 
        properties.store(fos, "");
        fos.close();
    } catch (Exception e) {
        logger.error("", e);
    }
}
    

formattedraw

1	public void saveHash(Properties properties, String filename) {
2	try {
3	FileOutputStream fos = new FileOutputStream(filename);
4	properties.store(fos, "");
5	fos.close();
6	} catch (Exception e) {
7	logger.error("", e);
8	}
9	}

public void saveHash(Properties properties, String filename) {
    try {
        FileOutputStream fos = new FileOutputStream(filename); 
        properties.store(fos, "");
        fos.close();
    } catch (Exception e) {
        logger.error("", e);
    }
}

Java

 

Encrypt and decrypt string

Encrypt and decrypt string

This task use php to encrypt and decrypt string.

Encrypt and decrypt string using RIJNDAEL_256

1. Create crypto.php as following
2. Call encrypt and decrypt method as following

call methods

---

$key = uniqid();
$src = "Hello world!";

require_once('crypto.php');
$cp = new crypto();
$tag1 = $cp->encrypt($src, $key);
$tag2 = $cp->decrypt($tag1, $key);
print($src . "<br />" . $tag1 . "<br />" . $tag2);
    

formattedraw

1	$key = uniqid();
2	$src = "Hello world!";
3
4	require_once('crypto.php');
5	$cp = new crypto();
6	$tag1 = $cp->encrypt($src, $key);
7	$tag2 = $cp->decrypt($tag1, $key);
8	print($src . "<br />" . $tag1 . "<br />" . $tag2);

$key = uniqid();
$src = "Hello world!";

require_once('crypto.php');
$cp = new crypto();
$tag1 = $cp->encrypt($src, $key);
$tag2 = $cp->decrypt($tag1, $key);
print($src . "<br />" . $tag1 . "<br />" . $tag2);

crypto.php

---

<?php

class crypto {

    public function encrypt($text, $key) { 
        $src = uniqid() . $text;
        $tag = trim(base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_256, $key, $src, MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND)))); 
        return $tag;
    } 

    public function decrypt($text, $key) { 
        $src = $text;
        $tag = trim(mcrypt_decrypt(MCRYPT_RIJNDAEL_256, $key, base64_decode($src), MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND))); 
        $tag = substr($tag, 13);
        return $tag;
    } 

}

?>
    

formattedraw

1	<?php
2
3	class crypto {
4
5	public function encrypt($text, $key) {
6	$src = uniqid() . $text;
7	$tag = trim(base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_256, $key, $src, MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND))));
8	return $tag;
9	}
10
11	public function decrypt($text, $key) {
12	$src = $text;
13	$tag = trim(mcrypt_decrypt(MCRYPT_RIJNDAEL_256, $key, base64_decode($src), MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND)));
14	$tag = substr($tag, 13);
15	return $tag;
16	}
17
18	}
19
20	?>

<?php

class crypto {

    public function encrypt($text, $key) { 
        $src = uniqid() . $text;
        $tag = trim(base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_256, $key, $src, MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND)))); 
        return $tag;
    } 

    public function decrypt($text, $key) { 
        $src = $text;
        $tag = trim(mcrypt_decrypt(MCRYPT_RIJNDAEL_256, $key, base64_decode($src), MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND))); 
        $tag = substr($tag, 13);
        return $tag;
    } 

}

?>

PHP

 

Access mysql database

Access mysql database

This task use php to execute query on mysql database. If error occurs, error message is sent to specified email.

Access mysql database using utility class

1. Create database.php as following
2. Call query or execute method as following

call methods

---

$CONFIG['db']['server'] = 'localhost';
$CONFIG['db']['database'] = 'database';
$CONFIG['db']['username'] = 'username';
$CONFIG['db']['password'] = 'password';
$CONFIG['db']['prefix'] = 'prefix_';

$CONFIG['mail']['report'] = 'webmaster@host.com';
$CONFIG['mail']['sender'] = 'webmaster@host.com';

require_once('database.php');

$db = new database();
$id = 'abcdef';
$data = $db->query(sprintf("select * from %s where id = %s", $db->table('task'), $db->quote($id) ));
print_r($data);
$db->execute(sprintf("delete from %s where id = %s", $db->table('task'), $db->quote($id) ));
$db->clean();
    

formattedraw

1	$CONFIG['db']['server'] = 'localhost';
2	$CONFIG['db']['database'] = 'database';
3	$CONFIG['db']['username'] = 'username';
4	$CONFIG['db']['password'] = 'password';
5	$CONFIG['db']['prefix'] = 'prefix_';
6
7	$CONFIG['mail']['report'] = 'webmaster@host.com';
8	$CONFIG['mail']['sender'] = 'webmaster@host.com';
9
10	require_once('database.php');
11
12	$db = new database();
13	$id = 'abcdef';
14	$data = $db->query(sprintf("select * from %s where id = %s", $db->table('task'), $db->quote($id) ));
15	print_r($data);
16	$db->execute(sprintf("delete from %s where id = %s", $db->table('task'), $db->quote($id) ));
17	$db->clean();

$CONFIG['db']['server'] = 'localhost';
$CONFIG['db']['database'] = 'database';
$CONFIG['db']['username'] = 'username';
$CONFIG['db']['password'] = 'password';
$CONFIG['db']['prefix'] = 'prefix_';

$CONFIG['mail']['report'] = 'webmaster@host.com';
$CONFIG['mail']['sender'] = 'webmaster@host.com';

require_once('database.php');

$db = new database();
$id = 'abcdef';
$data = $db->query(sprintf("select * from %s where id = %s", $db->table('task'), $db->quote($id) ));
print_r($data);
$db->execute(sprintf("delete from %s where id = %s", $db->table('task'), $db->quote($id) ));
$db->clean();

database.php

---

<?php

class database {

    private $cfg;
    private $link;

    public function __construct() {
        global $CONFIG;
        $this->cfg = $CONFIG['db'];
        $this->link = mysql_connect($this->cfg['server'], $this->cfg['username'], $this->cfg['password']);
        if (!$this->link) {
            $this->sendError(mysql_error());
        }
        if ($this->link) {
            if (!mysql_select_db($this->cfg['database'], $this->link)) {
                $this->sendError(mysql_error());
                $this->clean();
            }
        }
    }

    public function clean() {
        mysql_close($this->link);
        $this->link = null;
    }

    public function quote($src) {
        return "'" . mysql_real_escape_string($src) . "'";
    }

    public function table($src) {
        return $this->cfg['prefix'] . $src;
    }

    public function query($sql) {
        $data = array();
        if (!$this->link) return $data;
        $result = mysql_query($sql, $this->link);
        if ($result) {
            while ($row = mysql_fetch_assoc($result)) {
                $data[] = $row;
            }
        } else {
            $this->sendError(mysql_error());
        }
        return $data;
    }

    public function execute($sql) {
        if (!$this->link) return false;
        $result = mysql_query($sql, $this->link);
        if (!$result) {
            $msg = mysql_error();
            $this->sendError($msg);
            return $msg;
        } else {
            return true;
        }
    }

    public function sendError($message) {
        global $CONFIG;
        $from = $CONFIG['mail']['sender'];
        $to = $CONFIG['mail']['report'];
        $header = "From: $from\r\nReply-To: $from\r\n";
        $subject = "Database error!";
        mail($to, $subject, $message, $header);
    }

}

?>
    

formattedraw

1	<?php
2
3	class database {
4
5	private $cfg;
6	private $link;
7
8	public function __construct() {
9	global $CONFIG;
10	$this->cfg = $CONFIG['db'];
11	$this->link = mysql_connect($this->cfg['server'], $this->cfg['username'], $this->cfg['password']);
12	if (!$this->link) {
13	$this->sendError(mysql_error());
14	}
15	if ($this->link) {
16	if (!mysql_select_db($this->cfg['database'], $this->link)) {
17	$this->sendError(mysql_error());
18	$this->clean();
19	}
20	}
21	}
22
23	public function clean() {
24	mysql_close($this->link);
25	$this->link = null;
26	}
27
28	public function quote($src) {
29	return "'" . mysql_real_escape_string($src) . "'";
30	}
31
32	public function table($src) {
33	return $this->cfg['prefix'] . $src;
34	}
35
36	public function query($sql) {
37	$data = array();
38	if (!$this->link) return $data;
39	$result = mysql_query($sql, $this->link);
40	if ($result) {
41	while ($row = mysql_fetch_assoc($result)) {
42	$data[] = $row;
43	}
44	} else {
45	$this->sendError(mysql_error());
46	}
47	return $data;
48	}
49
50	public function execute($sql) {
51	if (!$this->link) return false;
52	$result = mysql_query($sql, $this->link);
53	if (!$result) {
54	$msg = mysql_error();
55	$this->sendError($msg);
56	return $msg;
57	} else {
58	return true;
59	}
60	}
61
62	public function sendError($message) {
63	global $CONFIG;
64	$from = $CONFIG['mail']['sender'];
65	$to = $CONFIG['mail']['report'];
66	$header = "From: $from\r\nReply-To: $from\r\n";
67	$subject = "Database error!";
68	mail($to, $subject, $message, $header);
69	}
70
71	}
72
73	?>

<?php

class database {

    private $cfg;
    private $link;

    public function __construct() {
        global $CONFIG;
        $this->cfg = $CONFIG['db'];
        $this->link = mysql_connect($this->cfg['server'], $this->cfg['username'], $this->cfg['password']);
        if (!$this->link) {
            $this->sendError(mysql_error());
        }
        if ($this->link) {
            if (!mysql_select_db($this->cfg['database'], $this->link)) {
                $this->sendError(mysql_error());
                $this->clean();
            }
        }
    }

    public function clean() {
        mysql_close($this->link);
        $this->link = null;
    }

    public function quote($src) {
        return "'" . mysql_real_escape_string($src) . "'";
    }

    public function table($src) {
        return $this->cfg['prefix'] . $src;
    }

    public function query($sql) {
        $data = array();
        if (!$this->link) return $data;
        $result = mysql_query($sql, $this->link);
        if ($result) {
            while ($row = mysql_fetch_assoc($result)) {
                $data[] = $row;
            }
        } else {
            $this->sendError(mysql_error());
        }
        return $data;
    }

    public function execute($sql) {
        if (!$this->link) return false;
        $result = mysql_query($sql, $this->link);
        if (!$result) {
            $msg = mysql_error();
            $this->sendError($msg);
            return $msg;
        } else {
            return true;
        }
    }

    public function sendError($message) {
        global $CONFIG;
        $from = $CONFIG['mail']['sender'];
        $to = $CONFIG['mail']['report'];
        $header = "From: $from\r\nReply-To: $from\r\n";
        $subject = "Database error!";
        mail($to, $subject, $message, $header);
    }

}

?>

PHP

 

Task tagged by [PHP]

1. Use one host for multiple domain
2. Access mysql database
3. Encrypt and decrypt string

Use one host for multiple domain

Use one host for multiple domain

This task use php to run multiple domain on one host

Run multiple domain by parking domain

1. Park domain
2. Create .htaccess as following
3. Create index.php file as following

.htaccess

---

RewriteEngine On
RewriteRule ^([a-z/A-Z/0-9/\-/\//+/\&/\=]*)$ /index.php?$1
    

formattedraw

1	RewriteEngine On
2	RewriteRule ^([a-z/A-Z/0-9/\-/\//+/\&/\=]*)$ /index.php?$1

RewriteEngine On
RewriteRule ^([a-z/A-Z/0-9/\-/\//+/\&/\=]*)$ /index.php?$1

index.php

---

<?php

$host = $_SERVER['HTTP_HOST'];

if ($host == 'host1.com') {
    require_once("host1.com/index.php");
} else if ($host == 'host2.com') {
    require_once("host2.com/index.php");
} else {
    header("Location: http://host3.com");
}

?>
    

formattedraw

1	<?php
2
3	$host = $_SERVER['HTTP_HOST'];
4
5	if ($host == 'host1.com') {
6	require_once("host1.com/index.php");
7	} else if ($host == 'host2.com') {
8	require_once("host2.com/index.php");
9	} else {
10	header("Location: http://host3.com");
11	}
12
13	?>

<?php

$host = $_SERVER['HTTP_HOST'];

if ($host == 'host1.com') {
    require_once("host1.com/index.php");
} else if ($host == 'host2.com') {
    require_once("host2.com/index.php");
} else {
    header("Location: http://host3.com");
}

?>

PHP

 

Retrieve list of libraries on SharePoint site

Retrieve list of libraries on SharePoint site

This task use Java WSDL for SharePoint to retrieve list of libraries on SharePoint site.

Retrieve list of libraries on SharePoint site using Lists webservice

private List<String> getLibraries(String site, String username, String password) {
    List<String> tag = new ArrayList<String>();
    try {
        ListsSoapStub stub = SharePointWSDL.newLists(new URL(site + "/_vti_bin/Lists.asmx"), new ListsLocator());
        stub.setUsername(username);
        stub.setPassword(password);
        com.microsoft.schemas.sharepoint.soap.GetListCollectionResponseGetListCollectionResult lcr = stub.getListCollection();
        if (lcr.get_any().length > 0) {
            NodeList children = lcr.get_any()[0].getChildNodes();
            for (int i = 0; i < children.getLength(); i++) {
                Node node = children.item(i);
                String baseType = node.getAttributes().getNamedItem("BaseType").getNodeValue();
                if (!"1".equals(baseType)) continue;
                String template = node.getAttributes().getNamedItem("ServerTemplate").getNodeValue();
                String title = node.getAttributes().getNamedItem("Title").getNodeValue();
                if ("|101|115|109|".indexOf("|" + template + "|") < 0) continue;
                tag.add(title);
            }
        }
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}
    

formattedraw

1	private List<String> getLibraries(String site, String username, String password) {
2	List<String> tag = new ArrayList<String>();
3	try {
4	ListsSoapStub stub = SharePointWSDL.newLists(new URL(site + "/_vti_bin/Lists.asmx"), new ListsLocator());
5	stub.setUsername(username);
6	stub.setPassword(password);
7	com.microsoft.schemas.sharepoint.soap.GetListCollectionResponseGetListCollectionResult lcr = stub.getListCollection();
8	if (lcr.get_any().length > 0) {
9	NodeList children = lcr.get_any()[0].getChildNodes();
10	for (int i = 0; i < children.getLength(); i++) {
11	Node node = children.item(i);
12	String baseType = node.getAttributes().getNamedItem("BaseType").getNodeValue();
13	if (!"1".equals(baseType)) continue;
14	String template = node.getAttributes().getNamedItem("ServerTemplate").getNodeValue();
15	String title = node.getAttributes().getNamedItem("Title").getNodeValue();
16	if ("|101|115|109|".indexOf("|" + template + "|") < 0) continue;
17	tag.add(title);
18	}
19	}
20	} catch (Exception e) {
21	logger.error("", e);
22	}
23	return tag;
24	}

private List<String> getLibraries(String site, String username, String password) {
    List<String> tag = new ArrayList<String>();
    try {
        ListsSoapStub stub = SharePointWSDL.newLists(new URL(site + "/_vti_bin/Lists.asmx"), new ListsLocator());
        stub.setUsername(username);
        stub.setPassword(password);
        com.microsoft.schemas.sharepoint.soap.GetListCollectionResponseGetListCollectionResult lcr = stub.getListCollection();
        if (lcr.get_any().length > 0) {
            NodeList children = lcr.get_any()[0].getChildNodes();
            for (int i = 0; i < children.getLength(); i++) {
                Node node = children.item(i);
                String baseType = node.getAttributes().getNamedItem("BaseType").getNodeValue();
                if (!"1".equals(baseType)) continue;
                String template = node.getAttributes().getNamedItem("ServerTemplate").getNodeValue();
                String title = node.getAttributes().getNamedItem("Title").getNodeValue();
                if ("|101|115|109|".indexOf("|" + template + "|") < 0) continue;
                tag.add(title);
            }
        }
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}

Java SharePoint

 

Task tagged by [SharePoint]

1. Upload file to SharePoint site
2. Retrieve list of libraries on SharePoint site

Upload file to SharePoint site

Upload file to SharePoint site

This task use Java WSDL for SharePoint to upload file to SharePoint site.

Upload file to SharePoint site using Copy webservice

Call uploadFile. site argument contains domain name instead of IP.

private String uploadFile(String site, String username, String password, String library, String filename) {
    String tag = "";
    try {
        CopySoapStub stub = SharePointWSDL.newCopy(new URL(site + "/_vti_bin/Copy.asmx"), new CopyLocator());
        stub.setUsername(username);
        stub.setPassword(password);

        String name = (new File(filename)).getName();
        String tagPath = site + "/" + library + "/" + name; 
        FieldInformation[] fis = new FieldInformation[1];
        UnsignedIntHolder uih = new UnsignedIntHolder(new UnsignedInt());
        CopyResultCollectionHolder crch = new CopyResultCollectionHolder(new CopyResult[] { new CopyResult() });

        fis[0] = new FieldInformation();
        fis[0].setInternalName("Title");
        fis[0].setDisplayName(name);
        fis[0].setType(FieldType.Text);
        fis[0].setValue(name);
       
        stub.copyIntoItems(tagPath, new String[] { tagPath }, fis, readFile(filename), uih, crch);
        boolean success = true;
        for (int i = 0; i < crch.value.length; i++) {
            if (CopyErrorCode._Success.equals(crch.value[i].getErrorCode().getValue())) continue;
            logger.error(crch.value[i].getErrorCode().getValue() + " : " + crch.value[i].getErrorMessage());
            logger.info(crch.value[i].getDestinationUrl());
            success = false;
        }
        if (success) {
            tag = tagPath;
        }
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}
    
private byte[] readFile(String filename) {
    File file = new File(filename);
    byte[] tag = new byte[0];
    try {
        tag = new byte[(int)file.length()];
        InputStream is = new FileInputStream(file);     
        int offset = 0;
        int numRead = 0;
        while (offset < tag.length && (numRead = is.read(tag, offset, tag.length - offset)) >= 0) {
            offset += numRead;
        }     
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}
    

formattedraw

1	private String uploadFile(String site, String username, String password, String library, String filename) {
2	String tag = "";
3	try {
4	CopySoapStub stub = SharePointWSDL.newCopy(new URL(site + "/_vti_bin/Copy.asmx"), new CopyLocator());
5	stub.setUsername(username);
6	stub.setPassword(password);
7
8	String name = (new File(filename)).getName();
9	String tagPath = site + "/" + library + "/" + name;
10	FieldInformation[] fis = new FieldInformation[1];
11	UnsignedIntHolder uih = new UnsignedIntHolder(new UnsignedInt());
12	CopyResultCollectionHolder crch = new CopyResultCollectionHolder(new CopyResult[] { new CopyResult() });
13
14	fis[0] = new FieldInformation();
15	fis[0].setInternalName("Title");
16	fis[0].setDisplayName(name);
17	fis[0].setType(FieldType.Text);
18	fis[0].setValue(name);
19
20	stub.copyIntoItems(tagPath, new String[] { tagPath }, fis, readFile(filename), uih, crch);
21	boolean success = true;
22	for (int i = 0; i < crch.value.length; i++) {
23	if (CopyErrorCode._Success.equals(crch.value[i].getErrorCode().getValue())) continue;
24	logger.error(crch.value[i].getErrorCode().getValue() + " : " + crch.value[i].getErrorMessage());
25	logger.info(crch.value[i].getDestinationUrl());
26	success = false;
27	}
28	if (success) {
29	tag = tagPath;
30	}
31	} catch (Exception e) {
32	logger.error("", e);
33	}
34	return tag;
35	}
36
37	private byte[] readFile(String filename) {
38	File file = new File(filename);
39	byte[] tag = new byte[0];
40	try {
41	tag = new byte[(int)file.length()];
42	InputStream is = new FileInputStream(file);
43	int offset = 0;
44	int numRead = 0;
45	while (offset < tag.length && (numRead = is.read(tag, offset, tag.length - offset)) >= 0) {
46	offset += numRead;
47	}
48	} catch (Exception e) {
49	logger.error("", e);
50	}
51	return tag;
52	}

private String uploadFile(String site, String username, String password, String library, String filename) {
    String tag = "";
    try {
        CopySoapStub stub = SharePointWSDL.newCopy(new URL(site + "/_vti_bin/Copy.asmx"), new CopyLocator());
        stub.setUsername(username);
        stub.setPassword(password);

        String name = (new File(filename)).getName();
        String tagPath = site + "/" + library + "/" + name; 
        FieldInformation[] fis = new FieldInformation[1];
        UnsignedIntHolder uih = new UnsignedIntHolder(new UnsignedInt());
        CopyResultCollectionHolder crch = new CopyResultCollectionHolder(new CopyResult[] { new CopyResult() });

        fis[0] = new FieldInformation();
        fis[0].setInternalName("Title");
        fis[0].setDisplayName(name);
        fis[0].setType(FieldType.Text);
        fis[0].setValue(name);
       
        stub.copyIntoItems(tagPath, new String[] { tagPath }, fis, readFile(filename), uih, crch);
        boolean success = true;
        for (int i = 0; i < crch.value.length; i++) {
            if (CopyErrorCode._Success.equals(crch.value[i].getErrorCode().getValue())) continue;
            logger.error(crch.value[i].getErrorCode().getValue() + " : " + crch.value[i].getErrorMessage());
            logger.info(crch.value[i].getDestinationUrl());
            success = false;
        }
        if (success) {
            tag = tagPath;
        }
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}
    
private byte[] readFile(String filename) {
    File file = new File(filename);
    byte[] tag = new byte[0];
    try {
        tag = new byte[(int)file.length()];
        InputStream is = new FileInputStream(file);     
        int offset = 0;
        int numRead = 0;
        while (offset < tag.length && (numRead = is.read(tag, offset, tag.length - offset)) >= 0) {
            offset += numRead;
        }     
    } catch (Exception e) {
        logger.error("", e);
    }
    return tag;
}

Java SharePoint

 

All tasks

1. Check Lotus Notes connection by java
2. Check Salesforce connection by java
3. Execute command line process from java with timeout
4. Execute thread from java with timeout
5. Retrieve CPU brand by C and Win32 API
6. Call JSONP with jQuery
7. Upload file to SharePoint site
8. Retrieve list of libraries on SharePoint site
9. Use one host for multiple domain
10. Access mysql database
11. Encrypt and decrypt string
12. Save hash table to file
13. Load hash table from file
14. Load hash table from string
15. Save hash table to string
16. Encrypt and decrypt string by java
17. Retrieve version of Lotus Notes by java
18. Retrieve name of current user of Lotus Notes by java
19. Retrieve list of databases on Lotus Notes server
20. Open Lotus Notes database
21. Retrieve list of documents in Lotus Notes database
22. Redirect blog post to another web page
23. Verify table structure
24. Retrieve unique id by javascript
25. Format code with line number
26. Initialize logger by java
27. Retrieve list of Lotus Notes forms
28. Install and run Jetty 8.0.4
29. Configure log4j for Jetty 8.0.4
30. Parse simple math expression
31. Extract summary of web page
32. Grab jobs from vWorker
33. Grab jobs from Freelancer
34. Retrieve Salesforce server instance
35. Add post and comment to Chatter
36. Grab jobs from oDesk
37. Grab jobs from Stack Overflow Careers
38. Extract Lotus Notes database icon
39. Run javascript in sandbox
40. Create javascript sandbox with jsoup support
41. Grab vBulletin pages in logged-in mode
42. Add JSON support to javascript sandbox
43. Grab google search results
44. Grab categories from Amazon aStores
45. Grab products from Amazon aStores
46. Grab categories from BestBuy
47. Grab products from BestBuy
48. Grab categories from Walmart
49. Grab products from Walmart
50. Grab categories from Newegg
51. Grab products from Newegg
52. Add Lucene support to javascript sandbox
53. Add MySQL support to javascript sandbox
54. Grab categories from HP Shopping
55. Grab products from HP Shopping
56. Grab video from YouTube
57. Grab video from DailyMotion
58. Grab book/journal from ScienceDirect
59. Grab article from ScienceDirect
60. Grab search results from Google
61. Grab search results from Bing
62. Grab search results from Yahoo

Task tagged by [JSONP]

1. Call JSONP with jQuery

Task tagged by [jQuery]

1. Call JSONP with jQuery

Task tagged by [JavaScript]

1. Call JSONP with jQuery
2. Redirect blog post to another web page
3. Retrieve unique id by javascript
4. Format code with line number
5. Run javascript in sandbox
6. Create javascript sandbox with jsoup support
7. Grab vBulletin pages in logged-in mode
8. Add JSON support to javascript sandbox
9. Grab google search results
10. Grab categories from Amazon aStores
11. Grab products from Amazon aStores
12. Grab categories from BestBuy
13. Grab products from BestBuy
14. Grab categories from Walmart
15. Grab products from Walmart
16. Grab categories from Newegg
17. Grab products from Newegg
18. Add Lucene support to javascript sandbox
19. Add MySQL support to javascript sandbox
20. Grab categories from HP Shopping
21. Grab products from HP Shopping
22. Grab video from YouTube
23. Grab video from DailyMotion
24. Grab book/journal from ScienceDirect
25. Grab article from ScienceDirect
26. Grab search results from Google
27. Grab search results from Bing
28. Grab search results from Yahoo

Call JSONP with jQuery

Call JSONP with jQuery

This task use jQuery to JSONP page.

Call JSONP using append method

Fill code in response method. Call request method with following arguments:

callbackVar: name of GET variable containing JSONP callback, eg. api.php?jsonp=response
bufferID: id of empty div tag which is used for temporarily adding script tag
args: arguments is passed to callback function
    

---

function jsonp() {

    this.request = function(url, args, callbackVar, bufferID) {
        var super = this;
        var callback = 'jsonp_response_' + Math.floor(Math.random() * 100000);
        window[callback] = function(data) {
            super.response(args, data);
            delete window[callback];
        }
        var params = { callbackVar : callback };
        var buffer = $('#' + bufferID);
        buffer.append("<script src='" + url + '&' + jQuery.param(params) + "'></script>");
    }

    this.response = function(args, data) {
        // Tasks go here
    }

}
    

formattedraw

1	function jsonp() {
2
3	this.request = function(url, args, callbackVar, bufferID) {
4	var super = this;
5	var callback = 'jsonp_response_' + Math.floor(Math.random() * 100000);
6	window[callback] = function(data) {
7	super.response(args, data);
8	delete window[callback];
9	}
10	var params = { callbackVar : callback };
11	var buffer = $('#' + bufferID);
12	buffer.append("<script src='" + url + '&' + jQuery.param(params) + "'></script>");
13	}
14
15	this.response = function(args, data) {
16	// Tasks go here
17	}
18
19	}

function jsonp() {

    this.request = function(url, args, callbackVar, bufferID) {
        var super = this;
        var callback = 'jsonp_response_' + Math.floor(Math.random() * 100000);
        window[callback] = function(data) {
            super.response(args, data);
            delete window[callback];
        }
        var params = { callbackVar : callback };
        var buffer = $('#' + bufferID);
        buffer.append("<script src='" + url + '&' + jQuery.param(params) + "'></script>");
    }

    this.response = function(args, data) {
        // Tasks go here
    }

}

JavaScript jQuery JSONP

 

All tags

Java	C/C++	Lotus Notes	Salesforce
JavaScript	jQuery	JSONP	SharePoint
PHP	Jetty	log4j	jsoup
Chatter	SWT	Lucene	MySQL

Task tagged by [Lotus Notes]

1. Check Lotus Notes connection by java
2. Retrieve version of Lotus Notes by java
3. Retrieve name of current user of Lotus Notes by java
4. Retrieve list of databases on Lotus Notes server
5. Open Lotus Notes database
6. Retrieve list of documents in Lotus Notes database
7. Retrieve list of Lotus Notes forms
8. Extract Lotus Notes database icon

Task tagged by [Salesforce]

1. Check Salesforce connection by java
2. Retrieve Salesforce server instance
3. Add post and comment to Chatter

Task tagged by [C/C++]

1. Retrieve CPU brand by C and Win32 API

Task tagged by [java]

1. Check Lotus Notes connection by java
2. Check Salesforce connection by java
3. Execute command line process from java with timeout
4. Execute thread from java with timeout
5. Upload file to SharePoint site
6. Retrieve list of libraries on SharePoint site
7. Save hash table to file
8. Load hash table from file
9. Load hash table from string
10. Save hash table to string
11. Encrypt and decrypt string by java
12. Retrieve version of Lotus Notes by java
13. Retrieve name of current user of Lotus Notes by java
14. Retrieve list of databases on Lotus Notes server
15. Open Lotus Notes database
16. Retrieve list of documents in Lotus Notes database
17. Verify table structure
18. Initialize logger by java
19. Retrieve list of Lotus Notes forms
20. Parse simple math expression
21. Extract summary of web page
22. Grab jobs from vWorker
23. Grab jobs from Freelancer
24. Retrieve Salesforce server instance
25. Add post and comment to Chatter
26. Grab jobs from oDesk
27. Grab jobs from Stack Overflow Careers
28. Extract Lotus Notes database icon
29. Run javascript in sandbox
30. Create javascript sandbox with jsoup support
31. Grab vBulletin pages in logged-in mode
32. Add JSON support to javascript sandbox
33. Grab google search results
34. Grab categories from Amazon aStores
35. Grab products from Amazon aStores
36. Grab categories from BestBuy
37. Grab products from BestBuy
38. Grab categories from Walmart
39. Grab products from Walmart
40. Grab categories from Newegg
41. Grab products from Newegg
42. Add Lucene support to javascript sandbox
43. Add MySQL support to javascript sandbox
44. Grab categories from HP Shopping
45. Grab products from HP Shopping
46. Grab video from YouTube
47. Grab video from DailyMotion
48. Grab book/journal from ScienceDirect
49. Grab article from ScienceDirect
50. Grab search results from Google
51. Grab search results from Bing
52. Grab search results from Yahoo