📄 cadcreator.java
字号:
/*
* Copyright (c) 2006, University of Kent
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* 1. Neither the name of the University of Kent nor the names of its
* contributors may be used to endorse or promote products derived from this
* software without specific prior written permission.
*
* 2. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
* IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
* THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED.
*
* 3. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
* LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
*
* 4. YOU AGREE THAT THE EXCLUSIONS IN PARAGRAPHS 2 AND 3 ABOVE ARE REASONABLE
* IN THE CIRCUMSTANCES. IN PARTICULAR, YOU ACKNOWLEDGE (1) THAT THIS
* SOFTWARE HAS BEEN MADE AVAILABLE TO YOU FREE OF CHARGE, (2) THAT THIS
* SOFTWARE IS NOT "PRODUCT" QUALITY, BUT HAS BEEN PRODUCED BY A RESEARCH
* GROUP WHO DESIRE TO MAKE THIS SOFTWARE FREELY AVAILABLE TO PEOPLE WHO WISH
* TO USE IT, AND (3) THAT BECAUSE THIS SOFTWARE IS NOT OF "PRODUCT" QUALITY
* IT IS INEVITABLE THAT THERE WILL BE BUGS AND ERRORS, AND POSSIBLY MORE
* SERIOUS FAULTS, IN THIS SOFTWARE.
*
* 5. This license is governed, except to the extent that local laws
* necessarily apply, by the laws of England and Wales.
*/
/*
* CADCreator.java
*
* Created on 18 November 2006, 15:25
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/
package uk.ac.kent.dpa.mysql.init;
import org.w3c.dom.*;
import javax.xml.parsers.*;
import uk.ac.kent.dpa.coord.database.*;
import ke.files.*;
import java.util.Properties;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import ke.defaultimpl.utils.*;
import ke.defaultimpl.utils.Utils;
import issrg.web.service.EncodeXML;
/**
*
* @author ls97
*/
public class CADCreator {
/** Creates a new instance of CADCreator */
public CADCreator() {
}
private static void createCADTable(Element desc, Statement st, Connection con, DbConnectionPool dp) throws DatabaseException {
DbUtils dbUtils = new DbUtils();
dbUtils.createDbTables(st,con,dp,"CADTable");
NodeList list = desc.getElementsByTagName("AttributeDefinition");
for (int i=0; i<list.getLength(); i++) {
Node node = list.item(i);
if (Text.class.isAssignableFrom(node.getClass())) continue;
Element ele = (Element)node;
String coordAttrName = ele.getAttribute("CoordinationAttributeName");
String definition = new EncodeXML().encode(node,0);
NodeList list1 = node.getChildNodes();
for (int j=0; j<list1.getLength(); j++) {
Node node1 = list1.item(j);
if (Text.class.isAssignableFrom(node1.getClass())) continue;
if (node1.getNodeName().equals("InitialValue")) {
NodeList list2 = node1.getChildNodes();
if (list2.getLength()!=1) throw new DatabaseException("invalid CAD specifications");
Node node2 = list2.item(0);
String value = node2.getNodeValue();
value = value.trim();
dbUtils.insertRecord(coordAttrName,definition,new String(),value,st,con,dp);
}
}
}
}
public static void main(String[] args) {
String descFile, configFile;
configFile ="C:\\home\\DbProperties";
descFile ="/xacml/context.xml";
if (args.length==1) {
descFile = args[0];
} else if (args.length==2) {
descFile = args[0];
configFile = args[1];
}
Element msg = null;
BasicDom dom = new BasicDom(descFile);
Document doc = dom.getXMLDocument();
msg = doc.getDocumentElement();
try {
DbInitial bdInitial = new DbInitial(configFile);
Statement stmt = bdInitial.getConnection();
Connection connec = bdInitial.getDB();
DbConnectionPool pool = bdInitial.getPool();
CADCreator.createCADTable(msg,stmt,connec,pool);
CoordinationInitialiser cIni = new CoordinationInitialiser(configFile);
cIni.createCoordinationAttributeTable("CADTable");
System.out.println("CADTable and empty coordination tables are created");
} catch (Exception e) {
System.out.println("error:"+e);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -