package deng.myhibernatejpa;

import javax.persistence.*;

@Entity
@Table(name="category")
public class Category {
    @Id
    @GeneratedValue
    @Column(name="id")
    private Short id;
    
    @Column(name="name")
	private String name;

    public Short getId() {
        return id;
    }

    public void setId(Short id) {
        this.id = id;
    }
    
    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
    
}

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	version="2.5">
	<display-name>Archetype Created Web Application</display-name>
        <!--
	<servlet>
		<servlet-name>HelloWorldExample</servlet-name>
		<servlet-class>cnx.mywebapp.HelloWorldExample</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>HelloWorldExample</servlet-name>
		<url-pattern>/hello</url-pattern>
	</servlet-mapping>
        -->
</web-app>

#!/bin/bash
if wmctrl -m | grep -q '"showing the desktop" mode: ON'; then
	wmctrl -k off
else
	wmctrl -k on
fi

to_number(to_char(sysdate,'YYYYMMDD'),'99999999')-50000)
--subtracts 5 years from a date. 
--   20070924
--     -50000 
--  =20020924

<?xml version="1.0" encoding="UTF-8" ?>
<configuration>
	<appender name="STDOUT"
			class="ch.qos.logback.core.ConsoleAppender">
		<layout class="ch.qos.logback.classic.PatternLayout">
			<pattern>%-4relative [%thread] %-5level %class - %msg%n</pattern>
		</layout>
	</appender>

	<!--Basic file appender<appender name="FILE"
		class="ch.qos.logback.core.FileAppender">
		<layout class="ch.qos.logback.classic.PatternLayout">
			<pattern>%-4relative [%thread] %-5level %class - %msg%n</pattern>
		</layout>
		<File>sample-log.txt</File>
	</appender>-->

        <!--Daily rolling file appender -->
	<appender name="FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
		<File>logFile.log</File>
		<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
			<FileNamePattern>logFile.%d{yyyy-MM-dd}.log</FileNamePattern>
		</rollingPolicy>

		<layout class="ch.qos.logback.classic.PatternLayout">
			<Pattern>%-4relative [%thread] %-5level %logger{35} - %msg%n</Pattern>
		</layout>
	</appender>
	
	
	<logger name="deng.mysimpleapp">
		<level value="debug" />
	</logger>
	
	<root>
		<level value="error" />
		<appender-ref ref="STDOUT" />
		<appender-ref ref="FILE" />
	</root>
</configuration>

public interface PlayerDAO {
	
    public Player findByName(name);
    public List findAllByPosition(position);

    // ... other methods
}

public class Player {

    String name;
    String position;
    
    Date creationDate;

    // ... get/set
}

select * from User_Procedures; 

select * from DBA_Procedures;

select * from User_Source where name = 'stored_proc'; 

select * from DBA_Source where name = 'stored_proc';

import java.io.FileWriter;
import java.io.File;
import java.io.IOException;

import org.dom4j.io.*;
import org.dom4j.*;


public class MyClass {
	
    public static void main(String[] args) {

        File dir = new File("in/emissions");
        File[] files = dir.listFiles();
        for (int i=0; i<files.length; i++) {
            if (!files[i].getName().endsWith(".xml")) {
                continue;
            }

            XMLWriter output = null;
            try {
                Element emission = new SAXReader().read(files[i]).getRootElement();

                Element sondage = emission.addElement("pr:sondage");
                sondage.addAttribute("xsi:nil", "true");
                sondage.setText("n/a");

                FileWriter writer = new FileWriter("out/" + files[i].getName());
                output = new XMLWriter(writer, OutputFormat.createPrettyPrint());

                output.write(emission);		
            } catch (IOException e) {
                e.printStackTrace();
            } catch (DocumentException e)
                e.printStackTrace();
            } finally {
                try {
                    output.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}

import org.dom4j.io.*
import org.dom4j.*

new File('in/emissions').eachFile{ file ->
	
    if (!file.name.endsWith('.xml'))
	return

    def emission  = new SAXReader().read(file).rootElement

    def sondage = emission.addElement('pr:sondage')
    sondage.addAttribute('xsi:nil', 'true')
    sondage.setText('n/a')

    def writer = new FileWriter('out/' + file.name)
    XMLWriter output = new XMLWriter(writer, OutputFormat.createPrettyPrint())

    output.writeNode(emission)
    output.close()
}