1. 先来缕一下项目的结构:项目有2个接口IPCBAFilterHandler和IPCBAProcessHandler,2个bean:PurchaseOrder和PurchaseOrderItem,1个Dao:PurchaseOrderDAO,和一个抓取网页PCBAParser,其他的为控制文件Program和PCBADataImport。
在PCBADataImport中,主要2个步骤:
一个是抓取网页,如果数据库中根据reqid查出的记录状态是已经是in progress或者不存在,则插入新的记录。
一个是更新In progress记录,如果遍历记录的状态是in progress,则删除,重新插入新的记录。(当然,这里有可能in progress状态不变,但是仍然删除后插入)
2. 配置文件采用XML,解析采用java自带的javax.xml.parser,采用实例化DocumentBuilderFactory的方法。
public void LoadConfig(String filePath) throws Exception {
try{
File configFile = new File(filePath);
DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder dBuilder = dbFactory.newDocumentBuilder();
Document doc = dBuilder.parse(configFile);
doc.getDocumentElement().normalize();
this.domain = doc.getElementsByTagName("Domain").item(0).getChildNodes().item(0).getNodeValue();
this.username = doc.getElementsByTagName("Username").item(0).getChildNodes().item(0).getNodeValue();
this.password = doc.getElementsByTagName("Password").item(0).getChildNodes().item(0).getNodeValue();
Element databaseElement = (Element)doc.getElementsByTagName("Database").item(0);
this.dbUrl = databaseElement.getElementsByTagName("Url").item(0).getChildNodes().item(0).getNodeValue();
this.dbUsername = databaseElement.getElementsByTagName("Username").item(0).getChildNodes().item(0).getNodeValue();
this.dbPassword = databaseElement.getElementsByTagName("Password").item(0).getChildNodes().item(0).getNodeValue();
}catch(Exception ex){
log.error("Load configuration file error.", ex);
throw ex;
}
}
如果对于没有XML需求的配置文件读取,常用的为利用java.util.Properties对文件进行关键字查找的方式
public void load(String filePath) throws FileNotFoundException, IOException{
java.io.File sysini = new java.io.File(filePath);
Properties sini = new Properties();
sini.load(new FileInputStream(sysini));
this.processedDir = sini.getProperty("ProcessedDir");
this.errorDir = sini.getProperty("ErrorDir");
this.fromDir = sini.getProperty("FromDir");
this.cm = sini.getProperty("CM");
this.deleteProcessedFile = Boolean.parseBoolean(sini.getProperty("DeleteProcessedFile"));
this.enableSyncSeq = Boolean.parseBoolean(sini.getProperty("EnableSyncSeq"));
this.dbConnString = sini.getProperty("DB_CONN_STRING");
this.dbUsername = sini.getProperty("DB_CONN_USERNAME");
this.dbPassword = sini.getProperty("DB_CONN_PASSWORD");
}
2. 初始化类的使用。
IPCBAFilterHandler filter = new IPCBAFilterHandler() {
private PurchaseOrderDAO dao;
private Connection conn;
public IPCBAFilterHandler initialize(PurchaseOrderDAO dao, Connection conn){
this.dao = dao;
this.conn = conn;
return this;
}
@Override
public boolean valid(String reqId, String status) throws Exception {
String dbStatus = dao.getPurchaseOrderStatus(conn, reqId);
if(dbStatus == null || dbStatus.toLowerCase().equals("in process")){
return true;
}
return false;
}
}.initialize(dao, conn);
IPCBAProcessHandler process = new IPCBAProcessHandler() {
private PurchaseOrderDAO dao;
private Connection conn;
public IPCBAProcessHandler initialize(PurchaseOrderDAO dao, Connection conn){
this.dao = dao;
this.conn = conn;
return this;
}
@Override
public void process(PurchaseOrder po) throws Exception {
log.info("Update purchase order req id: "+po.getReqId());
dao.updatePurchaseOrder(conn, po);
}
}.initialize(dao, conn);
它的好处体现在这里:
//parser.getPurchaseOrderListWithinOneWeek(filter, process);
parser.getPurchaseOrderList(filter, process);
PCBAImport项目学习总结
最新推荐文章于 2020-04-01 18:24:54 发布