12) LNCPRTDOC : MySQL

In this example, the database has the following characteristics :

• Type DB : MySQL

• Database server address : 192.168.1.7

• Port number of the database server : 3306

• Database user : root

• Database user password : (none)

• Database name : test

• SQL query : select * from test.marci

The command LNCPRTDOC is used to generate the following Word document:

C:\temp\TEST2_MySQL.doc

The template used for mail merging is :
C:\temp\SP_CUST_MYSQL.DOC

String template = "C:\\temp\\SP_CUST_MYSQL.DOC";
String destination = "C:\\temp\\TEST2_MySQL.DOC";

     DataSource myDataSource = new DataSource();
     myDataSource.setType("mysql");
     myDataSource.setSrvAddr("192.168.1.7");
     myDataSource.setPort("3306");
     myDataSource.setUser("root");
     myDataSource.setPassword("");
     myDataSource.setDBName("test");
     myDataSource.setQuery("select * from test.marci");

     LNCPRTDOC myLNCPRTDOC = new LNCPRTDOC();
     myLNCPRTDOC.setDoc(template);
     myLNCPRTDOC.setSavFmt("*NORMAL");
     myLNCPRTDOC.setShowDoc("true");
     myLNCPRTDOC.setMrgType("*FILE");
     myLNCPRTDOC.setOutSave("true");
     myLNCPRTDOC.setSavDoc(destination);
     myLNCPRTDOC.setMrgSel("*LTR");
     myLNCPRTDOC.setExecMrg("true");
     myLNCPRTDOC.setHeaderSrc("*FILE");
     myLNCPRTDOC.setSourceData(myDataSource);
     myLNCPRTDOC.setDltLgn("true");
     myLNCPRTDOC.setSourceData(myDataSource);
     myLNCPRTDOC.setLNCSrvAddr("192.168.1.9");

myLNCPRTDOC.execute();