Java Related Knowledge: 2010

Sunday, December 26, 2010

Spring JDBC Template Sample

<?xml version="1.0" encoding="UTF-8"?>







<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

</beans>

JDBC Example

Class.forName("org.postgresql.Driver");         // load database interface
        // connect to the database
        conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/ProductReviews", "postgres", "abcd");
        stmt = conn.createStatement();
        //st=conn.createStatement();

Date dat = new Date(System.currentTimeMillis());
        ResultSet res = stmt.executeQuery(              // send the query
                "select obj_id from object where obj_status_cd='C' and obj_modify_dt >=  '18-DEC-10' and obj_modify_dt < '19-DEC-10' order by obj_id");

PreparedStatement pstmt = conn.prepareStatement("insert into event values(?,'C',?)");

if (res != null)
            while (res.next()) {
                String id = res.getString(1);
                //st.executeUpdate("insert into event values("+id+",'C','19-DEC-10')");

//Double d = new Double("2.9");

System.out.println("ID is: "+id);
                BigDecimal d = new BigDecimal(id);
                System.out.println("ID in double is: "+d);
                pstmt.setBigDecimal(1, d);
                java.sql.Date sqlDate = new java.sql.Date(new java.util.Date(System.currentTimeMillis()).getTime());
                pstmt.setDate(2, sqlDate);

pstmt.executeUpdate();

System.out.println(id);
            }

res.close();
        stmt.close();
        pstmt.close();
        conn.close();

Wednesday, March 24, 2010

Spring method invocation

Foo.java

package com.kohls;

public class Foo {
@Override
public String toString() {
    // TODO Auto-generated method stub
    return "Inside Foo";
}
}

FooFactory.java

package com.kohls;

public class FooFactory {
    private static Foo foo;
    public static Foo getInstance() {
        if (foo == null) foo = new Foo();
        return foo;
    }
}

foo.xml

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">


   getInstance

LegacyA.java

package com.kohls;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class LegacyA {
    public static void main(String args[]) {
        ApplicationContext context = new ClassPathXmlApplicationContext("foo.xml");
        FooFactory foofac =     (FooFactory) context.getBean("foofactory");
        Foo foo = foofac.getInstance();
        System.out.println(foo);

    }
}