Delete From in Not In in Postgresql

command ini digunakan saat ingin delete table dengan kondisi yang disebut yang tidak didelete DELETE FROM otp.msection WHERE ssect NOT IN (‘4210’) and ssect NOT IN (‘4220’) and ssect NOT IN (‘4310’) and ssect NOT IN (‘4320’) and ssect NOT IN (‘4110’) and ssect NOT IN (‘4120’) and ssect NOT IN (‘4130’) and ssect NOT… Continue reading Delete From in Not In in Postgresql

XML parse file from HTTP

sumber : http://stackoverflow.com/questions/3058434/xml-parse-file-from-http ini adalahcara untuk ambil data xml dari url di internet kemudian dibuka file xml tersebut dan diurai diambil datanya. caranya seperti ini : private void start() throws Exception { URL url = new URL(“http://localhost:8080/AutoLogin/resource/web.xml&#8221;); URLConnection connection = url.openConnection(); Document doc = parseXML(connection.getInputStream()); NodeList descNodes = doc.getElementsByTagName(“description”); for(int i=0; i<descNodes.getLength();i++) { System.out.println(descNodes.item(i).getTextContent()); }… Continue reading XML parse file from HTTP