| Предыдущая тема :: Следующая тема |
| Автор |
Сообщение |
Splash Site Admin
Зарегистрирован: 09.11.2007 Сообщения: 228
|
Добавлено: Ср Мар 18, 2009 10:36 am Заголовок сообщения: Day3 |
|
|
burakbolek@gmail.com - our trainer
plugin (!) http://maximodeveloper.sourceforge.net/
Javadoc: file:/C:/IBM/SMP/maximo/Javadocs7112/Maximo/Maximo7112/applications/maximo/doc/
Java Build Path - Libraries - External class library: c:\ibm\SMP\maximo\applications\maximo\maximo\businessobjects
Project - Preferenced Libraries - Import from Filesystem - From Directory "C:\IBM\SMP\maximo\applications\maximo\lib" - Into Folder "helloMaximo".
---
// import javax.activation.*;
// import javax.mail.*;
// import psdi.server.*;
// import java.sql.ResultSet; // import java.sql.*;
import psdi.app.asset.AssetSetRemote;
import psdi.app.asset.*;
import psdi.security.*;
import psdi.util.MXSession;
public class helloMaximo {
/**
* @param args
*/
public static void main(String[] args) {
try {
MXSession session=MXSession.getSession();
session.setHost("trmaximo2:13400/MXServer");
session.setUserName("maxadmin");
session.setPassword("maxadmin");
session.connect();
System.out.println("User:"+session.getUserName()+
" Insertsite:"+session.getUserInfo().getInsertSite());
UserInfo ui=session.getUserInfo();
/* Ooops it doesn't work =)
ConnectionKey ck=ui.getConnectionKey();
java.sql.Connection conn=MXServer.getMXServer().getDBManager().getConnection(ck);
java.sql.Statement statement=conn.createStatement();
String sqlString="select * from asset";
ResultSet rs=statement.executeQuery(sqlString);
while(rs.next()){
String assetnum=rs.getString("assetnum");
String location=rs.getString("LOCATION");
System.out.println("Assetnum:"+assetnum+" ; Location:"+location);
}
*/
AssetSetRemote assetSet=(AssetSetRemote)session.getMboSet("ASSET");
int count=assetSet.count();
// assetSet.getApp();
int size=assetSet.getSize();
for(int i=0;i<count;i++){
AssetRemote asset=(AssetRemote) assetSet.getMbo(i);
System.out.println("Assetnum:"+asset.getString("assetnum"));
System.out.println("Location:"+asset.getString("LOCATION"));
}
}
catch (Throwable e) {
System.out.println("User:"+e.toString());
}
}
}
--- |
|
| Вернуться к началу |
|
 |
Splash Site Admin
Зарегистрирован: 09.11.2007 Сообщения: 228
|
Добавлено: Ср Мар 18, 2009 1:21 pm Заголовок сообщения: |
|
|
http://www.burakbolek.com/blog/
jxl.jar
asset.class -> my class assetExt.class in the same folder
How to decompile a maximo class? What software is good?
jd-gui.exe - new decompiler(!)
---
| Код: |
// import javax.activation.*;
// import javax.mail.*;
// import psdi.server.*;
// import java.sql.ResultSet; // import java.sql.*;
import psdi.app.asset.AssetSetRemote;
import psdi.app.asset.*;
import psdi.app.item.*;
import psdi.security.*;
import psdi.util.MXSession;
import jxl.*;
public class helloMaximo {
/**
* @param args
*/
public static void main(String[] args) {
try {
MXSession session=MXSession.getSession();
session.setHost("trmaximo2:13400/MXServer");
session.setUserName("maxadmin");
session.setPassword("maxadmin");
session.connect();
System.out.println("User:"+session.getUserName()+
" Insertsite:"+session.getUserInfo().getInsertSite());
UserInfo ui=session.getUserInfo();
/* Ooops it doesn't work =)
ConnectionKey ck=ui.getConnectionKey();
java.sql.Connection conn=MXServer.getMXServer().getDBManager().getConnection(ck);
java.sql.Statement statement=conn.createStatement();
String sqlString="select * from asset";
ResultSet rs=statement.executeQuery(sqlString);
while(rs.next()){
String assetnum=rs.getString("assetnum");
String location=rs.getString("LOCATION");
System.out.println("Assetnum:"+assetnum+" ; Location:"+location);
}
*/
AssetSetRemote assetSet=(AssetSetRemote)session.getMboSet("ASSET");
int count=assetSet.count();
// assetSet.getApp();
int size=assetSet.getSize();
for(int i=0;i<count;i++){
AssetRemote asset=(AssetRemote) assetSet.getMbo(i);
System.out.println("Assetnum:"+asset.getString("assetnum"));
System.out.println("Location:"+asset.getString("LOCATION"));
System.out.println("Size:"+size);
}
// xls
Workbook wb=Workbook.getWorkbook(new java.io.File("c:\\example.xls"));
System.out.println("sheets "+wb.getNumberOfSheets());
Sheet sheet=wb.getSheet(0);
int cols=sheet.getColumns();
int rows=sheet.getRows();
System.out.println("cols:"+cols+"; rows:"+rows);
ItemSetRemote itemSet=(ItemSetRemote) session.getMboSet("ITEM");
ItemRemote item=null;
for (int i=1;i<rows;i++) {
String itemNum=sheet.getCell(0,i).getContents(); // "e"+
String description=sheet.getCell(1,i).getContents();
System.out.println("Assetnum:"+itemNum+"; descr:"+description);
itemSet.setWhere("ITEMNUM='"+itemNum+"'");
itemSet.reset();
if (itemSet.count()==0) {
item=(ItemRemote) itemSet.addAtEnd();
item.setValue("ITEMNUM", itemNum);
item.setValue("description", description);
if (i%100==0) itemSet.save();
}
else System.out.println("Already exists");
};
itemSet.save();
}
catch (Throwable e) {
System.out.println("Error: "+e.toString());
}
System.out.println("Bye-bye!");
}
}
|
--- |
|
| Вернуться к началу |
|
 |
Splash Site Admin
Зарегистрирован: 09.11.2007 Сообщения: 228
|
Добавлено: Ср Мар 18, 2009 4:52 pm Заголовок сообщения: |
|
|
http://www.maximokb.com/
(!) maximodeveloper could not read encrypted maximo.properties in C:\IBM\SMP\maximo\applications\maximo\properties
Q.: Does anybody have a 64 (sixty four) bit java in Maximo?
A.: Yes. |
|
| Вернуться к началу |
|
 |
|