testdb.java

用来为垂直搜索引擎抓取数据的采集系统

/*
 * *****************************************************
 * Copyright (c) 2005 IIM Lab. All  Rights Reserved.
 * Created by xuehao at Nov 30, 2005
 * Contact: [e-mail]
 * *****************************************************
 */
package org.indigo.db;


import java.util.Date;
import java.sql.ResultSet;
import java.sql.SQLException;


public class TestDB
{
    public TestDB()
    {
        
    }
    public void testMe()
    {
        /*
SimpleDateFormat format = new SimpleDateFormat(ApplicationConstants.DATE_FORMAT);
Date dateTime = format.parse("10/1/2003"); 
           long lDate = dateTime.getTime();

           Java.sql.Date sqlDate = new java.sql.Date(lDate);
dtEndTime = java.sql.Date.valueOf(dateString);
         */
        String strdate="2005-11-30";
        double price = 0;
        Date thedate = new Date();
        java.sql.Date date2 = new java.sql.Date(2005-1900, 10, 30);
        System.out.println( date2 );
        String sql;
        sql  = "insert into test(price, thedate) ";
        sql += "values( " + price + ", '" + date2 + "' )";
        System.out.println( sql );
        
        DBConnection.getInstance().executeInsert( sql );
        
        
        sql = "select price, thedate from test where id=1";
        ResultSet rs = DBConnection.getInstance().executeQuery( sql );
        try
        {
            rs.next();
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
        try
        {
            price = Double.parseDouble( rs.getString("price") );
            date2 = rs.getDate( "thedate" );
        } catch (NumberFormatException e1)
        {
            e1.printStackTrace();
        } catch (SQLException e1)
        {
            e1.printStackTrace();
        }
        System.out.println( price );
        System.out.println( date2 );
        
    }
    public static void main(String[] args)
    {
        TestDB tdb = new TestDB();
        tdb.testMe();
    }
}