cvs commit: jakarta-velocity/whiteboard/geir_context_20001228 DBContext.java DBContextTest.class DBContextTest.java velocity-0.71.jar

[geirm]

geirm       00/12/29 15:09:01

  Modified:    whiteboard/geir_context_20001228 velocity-0.71.jar
  Added:       whiteboard/geir_context_20001228 DBContext.java
                        DBContextTest.class DBContextTest.java
  Log:
  Silliness, but a fun example...
  
  "When good Contexts go bad!"
  
  Revision  Changes    Path
  1.2       +32 -21    
jakarta-velocity/whiteboard/geir_context_20001228/velocity-0.71.jar
  
        <<Binary file>>
  
  
  1.1                  jakarta-velocity/whiteboard/geir_context_20001228/DBContext.java
  
  Index: DBContext.java
  ===================================================================
  package org.apache.velocity;
  
  import java.sql.*;
  import java.io.Serializable;
  import java.io.*;
  
  /**
   *   Example context impl that uses a database to store stuff :)
   *
   *   yes, this is silly
   *
   *   expects a mysql db test with table 
   * 
   *  CREATE TABLE contextstore (
   *    k varchar(100),
   *    val blob
   *  );
   *
   *  very fragile, crappy code.... just a demo!
   *
   * @author <a href="mailto:[EMAIL PROTECTED]">Geir Magnusson Jr.</a>
   * @version $Id: DBContext.java,v 1.1 2000/12/29 23:09:00 geirm Exp $
   */
  
  public class DBContext extends AbstractContext
  {
      Connection conn = null;
  
      public DBContext()
      {
          super();
          setup();
      }
  
      public DBContext( Context inner )
      {
          super( inner );
          setup();
      }
  
      public Object internalGet( String key )
      {
          try 
          {
              String data = null;
  
              String sql = "SELECT k, val FROM contextstore WHERE k ='"+key+"'";
              
              Statement s = conn.createStatement();
  
              ResultSet rs = s.executeQuery( sql );
  
              if(rs.next())
                 data = rs.getString("val");
              
              rs.close();
              s.close();
              
              ObjectInputStream in = new ObjectInputStream(  new ByteArrayInputStream( 
data.getBytes() ));
  
              Object o =  in.readObject();
  
              in.close();
  
              return o;
          }        
          catch(Exception e)
          {
              System.out.println("internalGet() : " + e );
          }
  
          return null;
      }
  
      public Object internalPut( String key, Object value )
      {
  
          try 
          {    
              ByteArrayOutputStream baos = new ByteArrayOutputStream();
              ObjectOutputStream out = new ObjectOutputStream( baos );
              
              out.writeObject( value );
              String data = baos.toString();
  
              out.close();
              baos.close();
            
              Statement s = conn.createStatement();
  
              s.executeUpdate( "DELETE FROM contextstore WHERE k = '" + key + "'" );
              s.executeUpdate( "INSERT INTO contextstore (k,val) values ('"+key+"','" 
+ data + "')" );
  
              s.close();            
          }        
          catch(Exception e)
          {
              System.out.println("internalGet() : " + e );
          }
  
          return null;
      }
  
      public  boolean internalContainsKey(Object key)
      {
          return false;
      }
  
      public  Object[] internalGetKeys()
      {
          return null;
      }
  
      public  Object internalRemove(Object key)
      {
          return null;
      }
  
  
      private void setup()
      {
          try
          {
              Class.forName("org.gjt.mm.mysql.Driver").newInstance();
              conn = 
DriverManager.getConnection("jdbc:mysql://localhost/test?user=root");
          }
          catch (Exception e) 
          {
              System. out.println(e);
          }
        
          return;
      }
  }
  
  
  
  
  1.1                  
jakarta-velocity/whiteboard/geir_context_20001228/DBContextTest.class
  
        <<Binary file>>
  
  
  1.1                  
jakarta-velocity/whiteboard/geir_context_20001228/DBContextTest.java
  
  Index: DBContextTest.java
  ===================================================================
  
  import java.io.BufferedWriter;
  import java.io.OutputStreamWriter;
  import java.io.Writer;
  
  import java.util.Hashtable;
  import java.util.Vector;
  import java.util.Properties;
  
  import org.apache.velocity.DBContext;
  import org.apache.velocity.Template;
  
  import org.apache.velocity.runtime.Runtime;
  
  /**
   *  the ultimate in silliness...
   */
  
  public class DBContextTest
  {
      public DBContextTest(String templateFile)
      {
          try
          {
              Runtime.init( new Properties() );
   
              Template template = Runtime.getTemplate(templateFile);
  
              DBContext dbc = new DBContext();
  
              Hashtable h = new Hashtable();
              h.put("Bar", "this is from a hashtable!");
         
              dbc.put( "string", "Hello!");
              dbc.put( "hashtable", h );
              
              Writer writer = new BufferedWriter(new OutputStreamWriter(System.out));
         
              template.merge(dbc, writer);
  
              writer.flush();
              writer.close();
          }
          catch( Exception e )
          {
              Runtime.error(e);
          }
      }
  
      public static void main(String[] args)
      {
          DBContextTest t;
          t = new DBContextTest(args[0]);
      }
  }