ResultSet rs = stmt.executeQuery("SELECT userid, username FROM USER");
while (rs.next()) {
int i = rs.getInt("userid");
String str = rs.getString("username");
User user = new User(i, str);
al.add(user);
}
Oracle Teknolojileri, Weblogic, SOA Suite, Java, Kurumsal Veri Sözlüğü, API Gateway, API Manager, Veri Sözlüğü, SOAGEN, Metanizer, Apinizer
ResultSet rs = stmt.executeQuery("SELECT userid, username FROM USER");
while (rs.next()) {
int i = rs.getInt("userid");
String str = rs.getString("username");
User user = new User(i, str);
al.add(user);
}
CREATE TABLE alumnos ( ID integer NOT NULL, NOMBRE varchar(100) NOT NULL, CLAVE varchar(100) NOT NULL, PRIMARY KEY (ID) )
CREATE TABLE materias ( ID integer NOT NULL, NOMBRE VARCHAR(100) NOT NULL, PRIMARY KEY (ID) )
CREATE TABLE alumnos_materias ( ALUMNO_ID integer NOT NULL, MATERIA_ID integer NOT NULL, PRIMARY KEY (ALUMNO_ID, MATERIA_ID), FOREIGN KEY (ALUMNO_ID) REFERENCES alumnos (ID), FOREIGN KEY (MATERIA_ID) REFERENCES materias (ID)
)INSERT INTO alumnos VALUES (1, 'Alumno 1', '00001'); INSERT INTO alumnos VALUES (2, 'Alumno 2', '00002'); INSERT INTO alumnos VALUES (3, 'Alumno 3', '00003'); INSERT INTO alumnos VALUES (4, 'Alumno 4', '00004'); INSERT INTO alumnos VALUES (5, 'Alumno 5', '00005'); INSERT INTO alumnos VALUES (6, 'Alumno 6', '00006'); INSERT INTO alumnos VALUES (7, 'Alumno 7', '00007'); INSERT INTO alumnos VALUES (8, 'Alumno 8', '00008'); INSERT INTO alumnos VALUES (9, 'Alumno 9', '00009'); INSERT INTO alumnos VALUES (10, 'Alumno 10', '000010'); INSERT INTO materias VALUES (1, 'Matematicas'); INSERT INTO materias VALUES (2, 'Fisica'); INSERT INTO materias VALUES (3, 'Quimica'); INSERT INTO materias VALUES (4, 'Biologia'); INSERT INTO materias VALUES (5, 'Historia'); INSERT INTO materias VALUES (6, 'Geografia'); INSERT INTO alumnos_materias VALUES (1, 1); INSERT INTO alumnos_materias VALUES (1, 3); INSERT INTO alumnos_materias VALUES (1, 5); INSERT INTO alumnos_materias VALUES (2, 1); INSERT INTO alumnos_materias VALUES (2, 2); INSERT INTO alumnos_materias VALUES (2, 3); INSERT INTO alumnos_materias VALUES (3, 2); INSERT INTO alumnos_materias VALUES (3, 4); INSERT INTO alumnos_materias VALUES (3, 6); INSERT INTO alumnos_materias VALUES (4, 4); INSERT INTO alumnos_materias VALUES (4, 5); INSERT INTO alumnos_materias VALUES (4, 6); INSERT INTO alumnos_materias VALUES (5, 1); INSERT INTO alumnos_materias VALUES (5, 4); INSERT INTO alumnos_materias VALUES (5, 5); INSERT INTO alumnos_materias VALUES (6, 2); INSERT INTO alumnos_materias VALUES (6, 5); INSERT INTO alumnos_materias VALUES (6, 6); INSERT INTO alumnos_materias VALUES (7, 1); INSERT INTO alumnos_materias VALUES (7, 3); INSERT INTO alumnos_materias VALUES (7, 5); INSERT INTO alumnos_materias VALUES (8, 1); INSERT INTO alumnos_materias VALUES (8, 2); INSERT INTO alumnos_materias VALUES (8, 3); INSERT INTO alumnos_materias VALUES (9, 2); INSERT INTO alumnos_materias VALUES (9, 4); INSERT INTO alumnos_materias VALUES (9, 6); INSERT INTO alumnos_materias VALUES (10, 4); INSERT INTO alumnos_materias VALUES (10, 5); INSERT INTO alumnos_materias VALUES (10, 6);
<?xml version="1.0" encoding="UTF-8"?>
<invoice due="2000-09-22">
<product>
<name>Apple</name>
<price>0.10</price>
</product>
<product>
<name>Orange</name>
<price>0.08</price>
</product>
<product>
<name>Strawberries</name>
<price>0.20</price>
</product>
<product>
<name>Banana</name>
<price>0.14</price>
</product>
<total currency="US$">0.52</total>
</invoice>
|
<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSPY v2004 rel. 4 U (http://www.xmlspy.com) by aa (ORiON) -->
<!--W3C Schema generated by XMLSPY v2004 rel. 4 U (http://www.xmlspy.com)-->
<xs:schema elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="invoice">
<xs:complexType>
<xs:sequence>
<xs:element ref="product" maxOccurs="unbounded"/>
<xs:element ref="total"/>
</xs:sequence>
<xs:attribute name="due" type="xs:date" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="name">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="Apple"/>
<xs:enumeration value="Banana"/>
<xs:enumeration value="Orange"/>
<xs:enumeration value="Strawberries"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="price">
<xs:simpleType>
<xs:restriction base="xs:decimal">
<xs:enumeration value="0.08"/>
<xs:enumeration value="0.10"/>
<xs:enumeration value="0.14"/>
<xs:enumeration value="0.20"/>
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="product">
<xs:complexType>
<xs:sequence>
<xs:element ref="name"/>
<xs:element ref="price"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="total">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:decimal">
<xs:attribute name="currency" type="xs:string" use="required"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:schema>
|
<?xml version="1.0" encoding="UTF-8"?>
<invoice due="2000-09-22" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="C:xmldeneme.xsd">
<product>
<name>Apple</name>
<price>0.10</price>
</product>
<product>
<name>Orange</name>
<price>0.08</price>
</product>
<product>
<name>Strawberries</name>
<price>0.20</price>
</product>
<product>
<name>Banana</name>
<price>0.14</price>
</product>
<total currency="US$">0.52</total>
</invoice>
|
Fatura Bilgileri
Fatura Ödeme Tarihi:
Toplam:
Fatura Kur:
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
Document : deneme.xsl
Created on : 26 Mart 2008 Çarşamba, 11:54
Author : byazar
Description:
Purpose of transformation follows.
-->
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="html"/>
<!-- TODO customize transformation rules
syntax recommendation http://www.w3.org/TR/xslt
-->
<xsl:template match="/">
<html>
<head>
<title>deneme.xsl</title>
</head>
<body>
<H1>Fatura Bilgileri</H1>
<br> Fatura Ödeme Tarihi:
<xsl:value-of select="invoice/@due" />
</br>
<table border="1">
<tr bgcolor="#9acd32">
<th>Ürün</th>
<th>Fiyat</th>
</tr>
<xsl:for-each select="invoice/product">
<tr>
<td><xsl:value-of select="name"/></td>
<td><xsl:value-of select="price"/></td>
</tr>
</xsl:for-each>
</table>
<br> Toplam:<xsl:value-of select="invoice/total"/> </br>
<br> Fatura Kur:<xsl:value-of select="invoice/total/@currency"/> </br>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
|
package com.ibm.dw.main;
import javax.xml.bind.JAXBContext;
import javax.xml.bind.JAXBElement;
import javax.xml.bind.Unmarshaller;
import javax.xml.bind.annotation.XmlRootElement;
import com.ibm.dw.*;
import java.io.FileInputStream;
public class JAXBDeneme {
/**
* @param args
*/
public static void main (String args[]) {
try {
String xmlfile = "c:/xmldeneme/deneme.xml";
;
Unmarshaller unmarshaller =null;
Invoice invoice= null;
try {
JAXBContext jaxbContext= JAXBContext.newInstance(new Class[] {com.ibm.dw.Invoice.class});
unmarshaller = jaxbContext.createUnmarshaller();
invoice =(Invoice)
unmarshaller.unmarshal(new FileInputStream(xmlfile));
} catch (Exception e) {
e.printStackTrace();
}
System.out.println("Fatura Bilgileri") ;
System.out.println("Fatura Tarihi: " + invoice.getDue().toXMLFormat()) ;
System.out.println("Fatura Kur: " + invoice.getTotal().getCurrency()) ;
System.out.println("Fatura Toplam: " + invoice.getTotal().getValue()) ;
System.out.println("Ürünler") ;
for (int i=0;i<invoice.getProduct().size();i++)
{
Product product=invoice.getProduct().get(i);
System.out.println("Ürün Adı: " + product.getName()) ;
System.out.println("Ürün Fiyat: " + product.getPrice().toString()) ;
}
}catch (Exception e ) {
e.printStackTrace();
}
}
}
|