Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package pl.softiq;
- import org.w3c.dom.Document;
- import javax.xml.parsers.*;
- import javax.xml.transform.Transformer;
- import javax.xml.transform.TransformerException;
- import javax.xml.transform.TransformerFactory;
- import javax.xml.transform.dom.DOMSource;
- import javax.xml.transform.stream.StreamResult;
- import java.io.StringWriter;
- import java.math.BigInteger;
- import java.sql.*;
- public class insterterMain {
- static final String dbDriver = "org.postgresql.Driver";
- static final String dbURL = "jdbc:postgresql://192.168.177.190:5432/portalzus";
- static final String dbUsername = "portalzus";
- static final String dbPassword = "q1w2e3r4";
- static final String przeznaczenie_wizualizacji = "'KUB0020'";
- static final String identyfikator_wizualizacji = "'2016'";
- static final String rodzaj_szablonu = "'fo'";
- public static void main(String[] args){
- String xsltString = "";
- try
- {
- DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
- DocumentBuilder docBuilder = dbFactory.newDocumentBuilder();
- Document xsltDoc = docBuilder.parse("src/stanKontaGenerycznyPo2016.xslt");
- xsltString = getStringFromDocument(xsltDoc);
- } catch (Exception ex) {
- ex.printStackTrace();
- }
- System.out.println("tresc: " + toHex(xsltString));
- Connection connection = null;
- Statement statement = null;
- try{
- DriverManager.registerDriver(new org.postgresql.Driver());
- connection = DriverManager.getConnection(dbURL, dbUsername, dbPassword);
- statement = connection.createStatement();
- String query = "UPDATE SZABLONY_WIZUALIZACJI " +
- "SET SZABLON = decode('" + toHex(xsltString) + "', 'hex'), " +
- "DATA_MODYFIKACJI = current_timestamp " +
- "WHERE PRZEZNACZENIE_WIZUALIZACJI = " + przeznaczenie_wizualizacji + " " +
- "AND IDENTYFIKATOR_WIZUALIZACJI = " + identyfikator_wizualizacji + " " +
- "AND RODZAJ_SZABLONU = " + rodzaj_szablonu + " ";
- System.out.println("Wykonano update rekordu!");
- statement.executeUpdate(query);
- statement.close();
- connection.close();
- }catch(SQLException e){
- e.printStackTrace();
- }
- }
- public static String getStringFromDocument(Document doc) throws TransformerException {
- DOMSource domSource = new DOMSource(doc);
- StringWriter writer = new StringWriter();
- StreamResult result = new StreamResult(writer);
- TransformerFactory tf = TransformerFactory.newInstance();
- Transformer transformer = tf.newTransformer();
- transformer.transform(domSource, result);
- return writer.toString();
- }
- public static String toHex(String arg) {
- return String.format("%040x", new BigInteger(1, arg.getBytes(/*YOUR_CHARSET?*/)));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement