3243l1.orig100664 1061 330 2071 6761620177 11122 0ustar mlrljedit# Ensure that these two tags are present. LoadModule jserv_module libexec/apache/mod_jserv.so ... AddModule mod_jserv.c ... # Servlet configuration files # These go in global scope. ServletBinary<\\> /usr/bin/jdk-1.1.6/i586/green_threads/java ServletBinaryArgument<\\> -Dbase.dir=/home/httpd/servlet-properties/ ServletClassPath /usr/lib/jdk-1.1.6/lib/classes.zip ServletClassPath /usr/local/lib/jserv/servclasses.zip:/usr/local/lib/jserv/jserv.zip ServletClassPath /usr/share/postgresql/postgresql.jar ServletEnvironment LD_LIBRARY_PATH /usr/lib/jdk-1.1.6/lib/i586/green_threads/ ServletEnvironment JAVA_COMPILER tya ServletErrorLog /var/log/httpd/jserv_log ServletProperties /usr/local/lib/jserv/servlet.properties NameVirtualHost roger.dodger.org ServerName roger.dodger.org ServerAdmin bruce@roger.dodger.org DocumentRoot /export/home/roger/html ScriptAlias /cgi-bin/ /export/roger/bin/ ServletAlias /servlet /home/roger/servlet/ ErrorLog /var/log/httpd/error_log TransferLog /var/log/httpd/access_log 3243l2.orig100664 1061 330 1227 6761620327 11122 0ustar mlrljeditimport java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class ServletOne extends HttpServlet { int hits; public void init(ServletConfig conf) throws ServletException { super.init(conf); hits = 0; } public void service(HttpServletRequest req, HttpServletResponse res) res.setContentType("text/html"); ServletOutputStream os = res.getOutputStream(); os.print( "TestServlet - Apache/JServ"); os.print( "

Apache/JServ Servlet Test number one

"); os.print("Number of hits: "); os.println(Integer.toString( ++hits )); os.close(); } } 3243l3.orig100664 1061 330 2114 6761620564 11122 0ustar mlrljeditimport java.sql.*; public class PostgresJdbc { final static String loginUser = "peter"; final static String loginPasswd = ""; final static String loginUrl = "jdbc:postgresql:pecker"; final static String loginJdbc = "postgresql.Driver"; public static void main( String [] args ) { if( args.length > 0 ) { try { Class.forName( loginJdbc ); Connection con = DriverManager.getConnection( loginUrl, loginUser, loginPasswd ); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery( args[0] ); ResultSetMetaData rsmd = rs.getMetaData(); int colCount = rsmd.getColumnCount(); for( int j = 1; j < colCount; j++ ) System.out.print( rsmd.getColumnName( j )+"," ); System.out.println( rsmd.getColumnName( colCount )); while( rs.next()) { for( int k = 1; k < colCount; ++k ) System.out.print( rs.getString( k ) + ","); System.out.println( rs.getString( colCount )); } } catch( Exception e ) { e.printStackTrace(); } } else System.out.println( "Usage: java PostgresJdbc \"...SQL...\"" ); } } 3243l4.orig100664 1061 330 1554 6761620662 11131 0ustar mlrljeditlogin.user=roger login.passwd=dodger login.url=jdbc:postgresql:roger login.jdbc=postgresql.Driver table.name.bgcolor=wheat html.title=Guestbook html.header.list=

Guest Book

Welcome to the Guest Book. Here are the comments other people have added. Add your personal details to the list.
html.header.form=

Guest Book

Please enter your details in the form below. The only mandatory field is "Name". Click the "Submit" button to confirm and commit your details.
html.footer=
This is a Java Servlet / JDBC / PostgreSQL-based application. It was developed by Bruce McDonald.
All rights reserved. Copyright 1998 3243guestbook100664 1007 330 13345 6761044102 12173 0ustar darcyljeditimport java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.util.Date; import java.util.*; // Servlet - implements a guest book. public class GuestBook extends HttpServlet { Connection con; Statement stmt; Properties props; // Init gets called once and thats it. // Loads the properties (using the base.dir redirection) and // connects to the DB. public void init(ServletConfig conf) throws ServletException { super.init(conf); try { loadProperties(); Class.forName( props.getProperty( "login.jdbc" )); con = DriverManager.getConnection( props.getProperty( "login.url"), props.getProperty( "login.user" ), props.getProperty( "login.passwd" )); stmt = con.createStatement(); } catch( Exception e ) { throw new ServletException( e.toString()); } } // Get a new key value // Perform work in a transaction - commit at the end. private int getKey( int id ) throws Exception { con.setAutoCommit(false ); ResultSet rs = stmt.executeQuery( "select val from key_table where id = "+id ); int val = 0; if( rs.next()) { val = rs.getInt( "val" ) + 1; stmt.executeUpdate( "update key_table set val = "+val+" where id = "+id ); } else { stmt.executeUpdate( "insert into key_table values( "+id+", 0)" ); } con.commit(); con.setAutoCommit( true ); return val; } // Handle individual requests public void service(HttpServletRequest req, HttpServletResponse res) throws IOException{ //Get a channel to the Web browser, so we can send output ServletOutputStream out = res.getOutputStream(); res.setContentType("text/html"); // Required for HTTP try { out.print( props.getProperty( "html.title" )); if( req.getParameter( "enter" ) != null ) { out.print( props.getProperty( "html.header.form" )); showForm( req, out ); } else if( req.getParameter( "name" ) != null ) { addEntries( req ); out.print( props.getProperty( "html.header.list" )); listEntries( req, out ); } else { out.print( props.getProperty( "html.header.list" )); listEntries( req, out ); } } catch( Exception e ) { throw new IOException( e.toString()); } finally { out.print( props.getProperty( "html.footer" )); out.close(); } } // Load the properties - use the "base.dir" property to locate property file. // The 'base.dir' directory is a public readable/writable directory wherein // servlet developers may place their property files. private void loadProperties( ) throws IOException { props = new Properties(); props.load( new FileInputStream( System.getProperty( "base.dir" )+ "GuestBook.properties" )); } // Contruct a URL to this Servlet - for " ); while( rs.next()) { String email = rs.getString( "email" ); String comment = rs.getString( "comment" ); String name = rs.getString( "name" ); String addr = rs.getString( "addr" ); String tnbgColor = props.getProperty( "table.name.bgcolor" )!=null? (" BGCOLOR="+props.getProperty( "table.name.bgcolor" )) : ""; out.print( "" ); if( email != null && email.length() > 1 ) out.print( ""+name+"" ); else out.print( name ); out.print( ""+rs.getString( "time" )+"" ); out.print( "" ); if( addr != null ) out.print( ""+addr+"" ); if( comment != null ) out.print( ""+comment+"" ); out.print( "
" ); } out.print( "" ); } // Display the form private void showForm( HttpServletRequest req, ServletOutputStream out ) throws Exception { out.print( "
"); out.print( "" ); out.print( "" ); out.print( "" ); out.print( "" ); out.print( "
" ); out.print( "
Name
Address
Email
Comment
" ); out.print( "
" ); } // Replace 'from's in the comment text with 'to's private String replace( String s, String from, String to ) { StringBuffer sb = new StringBuffer(); int idx = 0; int ldx = 0; // copy the fragments between 'from's while(( idx = s.indexOf( from, ldx )) != -1 ) { sb.append( s.substring( ldx, idx )); sb.append( to ); ldx = idx+1; } // No more 'from's - make sure to copy the rest if( ldx < s.length()) { sb.append( s.substring( ldx )); } return new String( sb ); } // Add the new comment to the guestbook table. Only proceed if the length of the name supplied // is longer than 0 chars. private void addEntries( HttpServletRequest req ) throws Exception { String name = req.getParameter( "name" ); if( name.length() > 0 ) { String comment = (req.getParameter( "comment")!=null)?req.getParameter( "comment"):""; String email = (req.getParameter( "email" )!=null)?req.getParameter( "email" ):""; String addr = (req.getParameter( "addr" )!=null)?req.getParameter( "addr" ):""; stmt.executeUpdate( "insert into guest_book values( "+getKey( 1 )+",'','"+ name+"','"+addr+"','"+email+"','now','"+ replace( replace( comment, "\n", "
" ), "'", "''" )+"')"); } } }