Export Table Data Into CSV file - Rest API | Spring Boot | JDBC Template | Java Inspires

0

#JavaInspires

Export Table Data Into CSV file - Rest API | Spring Boot | JDBC Template | Java Inspires

Hi , Welcome to #JavaInspires

In this post, we sill see how to download/export a table data into csv file using spring rest and spring data jdbc. Here, we are using  spring-boot-starter-jdbc, spring-boot-starter-web
starters.



 
Project Structure:



pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.7.5</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.javainspires</groupId>
	<artifactId>export-to-excel</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>export-to-excel</name>
	<description>Demo project for Spring Boot</description>
	<properties>
		<java.version>11</java.version>
	</properties>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>com.mysql</groupId>
			<artifactId>mysql-connector-j</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
				<configuration>
					<excludes>
						<exclude>
							<groupId>org.projectlombok</groupId>
							<artifactId>lombok</artifactId>
						</exclude>
					</excludes>
				</configuration>
			</plugin>
		</plugins>
	</build>

</project>


application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/sakila
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#spring.jpa.show-sql: true

ExportToExcelApplication.java

package com.javainspires.exporttoexcel;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class ExportToExcelApplication {

    public static void main(String[] args) {
        SpringApplication.run(ExportToExcelApplication.class, args);
    }

}




ExportController.java

package com.javainspires.exporttoexcel;

import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;

@RestController
@RequestMapping("/api/v1")
@Slf4j
public class ExportController {

    @Autowired
    ExportService exportService;

    @GetMapping("/export/table/{tableName}")
    public void exportTable(@PathVariable(name = "tableName") String tableName, HttpServletResponse httpServletResponse) {

        log.info("table name :{}", tableName);
        exportService.exportTable(tableName, httpServletResponse);
    }
}

ExportService.java

package com.javainspires.exporttoexcel;

import lombok.SneakyThrows;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.support.rowset.SqlRowSet;
import org.springframework.stereotype.Component;

import javax.servlet.http.HttpServletResponse;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

@Component
@Slf4j
public class ExportService {

    @Autowired
    JdbcTemplate jdbcTemplate;

    @SneakyThrows
    public void exportTable(String tableName, HttpServletResponse httpServletResponse) {

        try {
            httpServletResponse.setHeader(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=table-data.csv");
            httpServletResponse.setContentType("application/octet-stream");
            PrintWriter out = httpServletResponse.getWriter();
            String selectQuery = "SELECT * FROM " + tableName;

            SqlRowSet sqlRowSet = jdbcTemplate.queryForRowSet(selectQuery);

            List<String> columnList = Arrays.asList(sqlRowSet.getMetaData().getColumnNames());
            //writing headers
            out.write(String.join(",", columnList));
            out.write("\n");

            while (sqlRowSet.next()) {
                List<String> rowColumns = new ArrayList<>();
                for (String s : columnList) {
                    Object obj = sqlRowSet.getObject(s);
                    rowColumns.add(obj != null ? String.valueOf(obj) : "");
                }
                out.write(String.join(",", rowColumns));
                out.write("\n");
            }
            out.flush();

        } catch (Exception e) {
            throw new ExportTableException("Error occurred ...in exporting table " + tableName + "error :" + e.getMessage());
        }


    }
}

ExportTableException.java

package com.javainspires.exporttoexcel;

public class ExportTableException extends RuntimeException{
    public ExportTableException(String message) {
        super(message);
    }
}




Start Up Log:

C:\WWW\SW\openjdk-11.0.15\bin\java.exe -javaagent:C:\WWW\SW\ideaIC-2022.2.3.win\lib\idea_rt.jar=58192:C:\WWW\SW\ideaIC-2022.2.3.win\bin -Dfile.encoding=UTF-8 -classpath C:\Users\developer\Desktop\export-to-excel\target\classes;C:\Users\developer\.m2\repository\org\springframework\boot\spring-boot-starter-jdbc\2.7.5\spring-boot-starter-jdbc-2.7.5.jar;C:\Users\developer\.m2\repository\org\springframework\boot\spring-boot-starter\2.7.5\spring-boot-starter-2.7.5.jar;C:\Users\developer\.m2\repository\org\springframework\boot\spring-boot\2.7.5\spring-boot-2.7.5.jar;C:\Users\developer\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\2.7.5\spring-boot-autoconfigure-2.7.5.jar;C:\Users\developer\.m2\repository\org\springframework\boot\spring-boot-starter-logging\2.7.5\spring-boot-starter-logging-2.7.5.jar;C:\Users\developer\.m2\repository\ch\qos\logback\logback-classic\1.2.11\logback-classic-1.2.11.jar;C:\Users\developer\.m2\repository\ch\qos\logback\logback-core\1.2.11\logback-core-1.2.11.jar;C:\Users\developer\.m2\repository\org\apache\logging\log4j\log4j-to-slf4j\2.17.2\log4j-to-slf4j-2.17.2.jar;C:\Users\developer\.m2\repository\org\apache\logging\log4j\log4j-api\2.17.2\log4j-api-2.17.2.jar;C:\Users\developer\.m2\repository\org\slf4j\jul-to-slf4j\1.7.36\jul-to-slf4j-1.7.36.jar;C:\Users\developer\.m2\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\Users\developer\.m2\repository\org\yaml\snakeyaml\1.30\snakeyaml-1.30.jar;C:\Users\developer\.m2\repository\com\zaxxer\HikariCP\4.0.3\HikariCP-4.0.3.jar;C:\Users\developer\.m2\repository\org\slf4j\slf4j-api\1.7.36\slf4j-api-1.7.36.jar;C:\Users\developer\.m2\repository\org\springframework\spring-jdbc\5.3.23\spring-jdbc-5.3.23.jar;C:\Users\developer\.m2\repository\org\springframework\spring-beans\5.3.23\spring-beans-5.3.23.jar;C:\Users\developer\.m2\repository\org\springframework\spring-tx\5.3.23\spring-tx-5.3.23.jar;C:\Users\developer\.m2\repository\org\springframework\boot\spring-boot-starter-web\2.7.5\spring-boot-starter-web-2.7.5.jar;C:\Users\developer\.m2\repository\org\springframework\boot\spring-boot-starter-json\2.7.5\spring-boot-starter-json-2.7.5.jar;C:\Users\developer\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.13.4.2\jackson-databind-2.13.4.2.jar;C:\Users\developer\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.13.4\jackson-annotations-2.13.4.jar;C:\Users\developer\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.13.4\jackson-core-2.13.4.jar;C:\Users\developer\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.13.4\jackson-datatype-jdk8-2.13.4.jar;C:\Users\developer\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.13.4\jackson-datatype-jsr310-2.13.4.jar;C:\Users\developer\.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.13.4\jackson-module-parameter-names-2.13.4.jar;C:\Users\developer\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\2.7.5\spring-boot-starter-tomcat-2.7.5.jar;C:\Users\developer\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.68\tomcat-embed-core-9.0.68.jar;C:\Users\developer\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\9.0.68\tomcat-embed-el-9.0.68.jar;C:\Users\developer\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.68\tomcat-embed-websocket-9.0.68.jar;C:\Users\developer\.m2\repository\org\springframework\spring-web\5.3.23\spring-web-5.3.23.jar;C:\Users\developer\.m2\repository\org\springframework\spring-webmvc\5.3.23\spring-webmvc-5.3.23.jar;C:\Users\developer\.m2\repository\org\springframework\spring-aop\5.3.23\spring-aop-5.3.23.jar;C:\Users\developer\.m2\repository\org\springframework\spring-context\5.3.23\spring-context-5.3.23.jar;C:\Users\developer\.m2\repository\org\springframework\spring-expression\5.3.23\spring-expression-5.3.23.jar;C:\Users\developer\.m2\repository\com\mysql\mysql-connector-j\8.0.31\mysql-connector-j-8.0.31.jar;C:\Users\developer\.m2\repository\org\projectlombok\lombok\1.18.24\lombok-1.18.24.jar;C:\Users\developer\.m2\repository\org\springframework\spring-core\5.3.23\spring-core-5.3.23.jar;C:\Users\developer\.m2\repository\org\springframework\spring-jcl\5.3.23\spring-jcl-5.3.23.jar com.javainspires.exporttoexcel.ExportToExcelApplication

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::                (v2.7.5)

2022-10-31 21:18:50.377  INFO 3100 --- [           main] c.j.e.ExportToExcelApplication           : Starting ExportToExcelApplication using Java 11.0.15 on DESKTOP-IQA676G with PID 3100 (C:\Users\developer\Desktop\export-to-excel\target\classes started by developer in C:\Users\developer\Desktop\export-to-excel)
2022-10-31 21:18:50.382  INFO 3100 --- [           main] c.j.e.ExportToExcelApplication           : No active profile set, falling back to 1 default profile: "default"
2022-10-31 21:18:52.571  INFO 3100 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2022-10-31 21:18:52.592  INFO 3100 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2022-10-31 21:18:52.592  INFO 3100 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.68]
2022-10-31 21:18:52.758  INFO 3100 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2022-10-31 21:18:52.758  INFO 3100 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 2250 ms
2022-10-31 21:18:53.542  INFO 3100 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2022-10-31 21:18:53.561  INFO 3100 --- [           main] c.j.e.ExportToExcelApplication           : Started ExportToExcelApplication in 4.311 seconds (JVM running for 5.327)


Hit the following URL in your browser:

http://localhost:8080/api/v1/export/table/actor

This downloads a table-data.csv file. 

table-data.csv

actor_id,first_name,last_name,last_update
1,PENELOPE,GUINESS,2006-02-15 18:04:33.0
2,NICK,WAHLBERG,2006-02-15 18:04:33.0
3,ED,CHASE,2006-02-15 18:04:33.0
4,JENNIFER,DAVIS,2006-02-15 18:04:33.0
5,JOHNNY,LOLLOBRIGIDA,2006-02-15 18:04:33.0
6,BETTE,NICHOLSON,2006-02-15 18:04:33.0
7,GRACE,MOSTEL,2006-02-15 18:04:33.0
8,MATTHEW,JOHANSSON,2006-02-15 18:04:33.0
9,JOE,SWANK,2006-02-15 18:04:33.0
10,CHRISTIAN,GABLE,2006-02-15 18:04:33.0
11,ZERO,CAGE,2006-02-15 18:04:33.0
12,KARL,BERRY,2006-02-15 18:04:33.0
13,UMA,WOOD,2006-02-15 18:04:33.0
14,VIVIEN,BERGEN,2006-02-15 18:04:33.0
15,CUBA,OLIVIER,2006-02-15 18:04:33.0
16,FRED,COSTNER,2006-02-15 18:04:33.0
17,HELEN,VOIGHT,2006-02-15 18:04:33.0
18,DAN,TORN,2006-02-15 18:04:33.0
19,BOB,FAWCETT,2006-02-15 18:04:33.0
20,LUCILLE,TRACY,2006-02-15 18:04:33.0
21,KIRSTEN,PALTROW,2006-02-15 18:04:33.0
22,ELVIS,MARX,2006-02-15 18:04:33.0
23,SANDRA,KILMER,2006-02-15 18:04:33.0
24,CAMERON,STREEP,2006-02-15 18:04:33.0
25,KEVIN,BLOOM,2006-02-15 18:04:33.0
26,RIP,CRAWFORD,2006-02-15 18:04:33.0
27,JULIA,MCQUEEN,2006-02-15 18:04:33.0
28,WOODY,HOFFMAN,2006-02-15 18:04:33.0
29,ALEC,WAYNE,2006-02-15 18:04:33.0
30,SANDRA,PECK,2006-02-15 18:04:33.0
31,SISSY,SOBIESKI,2006-02-15 18:04:33.0
32,TIM,HACKMAN,2006-02-15 18:04:33.0
33,MILLA,PECK,2006-02-15 18:04:33.0
34,AUDREY,OLIVIER,2006-02-15 18:04:33.0
35,JUDY,DEAN,2006-02-15 18:04:33.0
36,BURT,DUKAKIS,2006-02-15 18:04:33.0
37,VAL,BOLGER,2006-02-15 18:04:33.0
38,TOM,MCKELLEN,2006-02-15 18:04:33.0
39,GOLDIE,BRODY,2006-02-15 18:04:33.0
40,JOHNNY,CAGE,2006-02-15 18:04:33.0
41,JODIE,DEGENERES,2006-02-15 18:04:33.0
42,TOM,MIRANDA,2006-02-15 18:04:33.0
43,KIRK,JOVOVICH,2006-02-15 18:04:33.0
44,NICK,STALLONE,2006-02-15 18:04:33.0
45,REESE,KILMER,2006-02-15 18:04:33.0
46,PARKER,GOLDBERG,2006-02-15 18:04:33.0
47,JULIA,BARRYMORE,2006-02-15 18:04:33.0
48,FRANCES,DAY-LEWIS,2006-02-15 18:04:33.0
49,ANNE,CRONYN,2006-02-15 18:04:33.0
50,NATALIE,HOPKINS,2006-02-15 18:04:33.0
51,GARY,PHOENIX,2006-02-15 18:04:33.0
52,CARMEN,HUNT,2006-02-15 18:04:33.0
53,MENA,TEMPLE,2006-02-15 18:04:33.0
54,PENELOPE,PINKETT,2006-02-15 18:04:33.0
55,FAY,KILMER,2006-02-15 18:04:33.0
56,DAN,HARRIS,2006-02-15 18:04:33.0
57,JUDE,CRUISE,2006-02-15 18:04:33.0
58,CHRISTIAN,AKROYD,2006-02-15 18:04:33.0
59,DUSTIN,TAUTOU,2006-02-15 18:04:33.0
60,HENRY,BERRY,2006-02-15 18:04:33.0
61,CHRISTIAN,NEESON,2006-02-15 18:04:33.0
62,JAYNE,NEESON,2006-02-15 18:04:33.0
63,CAMERON,WRAY,2006-02-15 18:04:33.0
64,RAY,JOHANSSON,2006-02-15 18:04:33.0
65,ANGELA,HUDSON,2006-02-15 18:04:33.0
66,MARY,TANDY,2006-02-15 18:04:33.0
67,JESSICA,BAILEY,2006-02-15 18:04:33.0
68,RIP,WINSLET,2006-02-15 18:04:33.0
69,KENNETH,PALTROW,2006-02-15 18:04:33.0
70,MICHELLE,MCCONAUGHEY,2006-02-15 18:04:33.0
71,ADAM,GRANT,2006-02-15 18:04:33.0
72,SEAN,WILLIAMS,2006-02-15 18:04:33.0
73,GARY,PENN,2006-02-15 18:04:33.0
74,MILLA,KEITEL,2006-02-15 18:04:33.0
75,BURT,POSEY,2006-02-15 18:04:33.0
76,ANGELINA,ASTAIRE,2006-02-15 18:04:33.0
77,CARY,MCCONAUGHEY,2006-02-15 18:04:33.0
78,GROUCHO,SINATRA,2006-02-15 18:04:33.0
79,MAE,HOFFMAN,2006-02-15 18:04:33.0
80,RALPH,CRUZ,2006-02-15 18:04:33.0
81,SCARLETT,DAMON,2006-02-15 18:04:33.0
82,WOODY,JOLIE,2006-02-15 18:04:33.0
83,BEN,WILLIS,2006-02-15 18:04:33.0
84,JAMES,PITT,2006-02-15 18:04:33.0
85,MINNIE,ZELLWEGER,2006-02-15 18:04:33.0
86,GREG,CHAPLIN,2006-02-15 18:04:33.0
87,SPENCER,PECK,2006-02-15 18:04:33.0
88,KENNETH,PESCI,2006-02-15 18:04:33.0
89,CHARLIZE,DENCH,2006-02-15 18:04:33.0
90,SEAN,GUINESS,2006-02-15 18:04:33.0
91,CHRISTOPHER,BERRY,2006-02-15 18:04:33.0
92,KIRSTEN,AKROYD,2006-02-15 18:04:33.0
93,ELLEN,PRESLEY,2006-02-15 18:04:33.0
94,KENNETH,TORN,2006-02-15 18:04:33.0
95,DARYL,WAHLBERG,2006-02-15 18:04:33.0
96,GENE,WILLIS,2006-02-15 18:04:33.0
97,MEG,HAWKE,2006-02-15 18:04:33.0
98,CHRIS,BRIDGES,2006-02-15 18:04:33.0
99,JIM,MOSTEL,2006-02-15 18:04:33.0
100,SPENCER,DEPP,2006-02-15 18:04:33.0
101,SUSAN,DAVIS,2006-02-15 18:04:33.0
102,WALTER,TORN,2006-02-15 18:04:33.0
103,MATTHEW,LEIGH,2006-02-15 18:04:33.0
104,PENELOPE,CRONYN,2006-02-15 18:04:33.0
105,SIDNEY,CROWE,2006-02-15 18:04:33.0
106,GROUCHO,DUNST,2006-02-15 18:04:33.0
107,GINA,DEGENERES,2006-02-15 18:04:33.0
108,WARREN,NOLTE,2006-02-15 18:04:33.0
109,SYLVESTER,DERN,2006-02-15 18:04:33.0
110,SUSAN,DAVIS,2006-02-15 18:04:33.0
111,CAMERON,ZELLWEGER,2006-02-15 18:04:33.0
112,RUSSELL,BACALL,2006-02-15 18:04:33.0
113,MORGAN,HOPKINS,2006-02-15 18:04:33.0
114,MORGAN,MCDORMAND,2006-02-15 18:04:33.0
115,HARRISON,BALE,2006-02-15 18:04:33.0
116,DAN,STREEP,2006-02-15 18:04:33.0
117,RENEE,TRACY,2006-02-15 18:04:33.0
118,CUBA,ALLEN,2006-02-15 18:04:33.0
119,WARREN,JACKMAN,2006-02-15 18:04:33.0
120,PENELOPE,MONROE,2006-02-15 18:04:33.0
121,LIZA,BERGMAN,2006-02-15 18:04:33.0
122,SALMA,NOLTE,2006-02-15 18:04:33.0
123,JULIANNE,DENCH,2006-02-15 18:04:33.0
124,SCARLETT,BENING,2006-02-15 18:04:33.0
125,ALBERT,NOLTE,2006-02-15 18:04:33.0
126,FRANCES,TOMEI,2006-02-15 18:04:33.0
127,KEVIN,GARLAND,2006-02-15 18:04:33.0
128,CATE,MCQUEEN,2006-02-15 18:04:33.0
129,DARYL,CRAWFORD,2006-02-15 18:04:33.0
130,GRETA,KEITEL,2006-02-15 18:04:33.0
131,JANE,JACKMAN,2006-02-15 18:04:33.0
132,ADAM,HOPPER,2006-02-15 18:04:33.0
133,RICHARD,PENN,2006-02-15 18:04:33.0
134,GENE,HOPKINS,2006-02-15 18:04:33.0
135,RITA,REYNOLDS,2006-02-15 18:04:33.0
136,ED,MANSFIELD,2006-02-15 18:04:33.0
137,MORGAN,WILLIAMS,2006-02-15 18:04:33.0
138,LUCILLE,DEE,2006-02-15 18:04:33.0
139,EWAN,GOODING,2006-02-15 18:04:33.0
140,WHOOPI,HURT,2006-02-15 18:04:33.0
141,CATE,HARRIS,2006-02-15 18:04:33.0
142,JADA,RYDER,2006-02-15 18:04:33.0
143,RIVER,DEAN,2006-02-15 18:04:33.0
144,ANGELA,WITHERSPOON,2006-02-15 18:04:33.0
145,KIM,ALLEN,2006-02-15 18:04:33.0
146,ALBERT,JOHANSSON,2006-02-15 18:04:33.0
147,FAY,WINSLET,2006-02-15 18:04:33.0
148,EMILY,DEE,2006-02-15 18:04:33.0
149,RUSSELL,TEMPLE,2006-02-15 18:04:33.0
150,JAYNE,NOLTE,2006-02-15 18:04:33.0
151,GEOFFREY,HESTON,2006-02-15 18:04:33.0
152,BEN,HARRIS,2006-02-15 18:04:33.0
153,MINNIE,KILMER,2006-02-15 18:04:33.0
154,MERYL,GIBSON,2006-02-15 18:04:33.0
155,IAN,TANDY,2006-02-15 18:04:33.0
156,FAY,WOOD,2006-02-15 18:04:33.0
157,GRETA,MALDEN,2006-02-15 18:04:33.0
158,VIVIEN,BASINGER,2006-02-15 18:04:33.0
159,LAURA,BRODY,2006-02-15 18:04:33.0
160,CHRIS,DEPP,2006-02-15 18:04:33.0
161,HARVEY,HOPE,2006-02-15 18:04:33.0
162,OPRAH,KILMER,2006-02-15 18:04:33.0
163,CHRISTOPHER,WEST,2006-02-15 18:04:33.0
164,HUMPHREY,WILLIS,2006-02-15 18:04:33.0
165,AL,GARLAND,2006-02-15 18:04:33.0
166,NICK,DEGENERES,2006-02-15 18:04:33.0
167,LAURENCE,BULLOCK,2006-02-15 18:04:33.0
168,WILL,WILSON,2006-02-15 18:04:33.0
169,KENNETH,HOFFMAN,2006-02-15 18:04:33.0
170,MENA,HOPPER,2006-02-15 18:04:33.0
171,OLYMPIA,PFEIFFER,2006-02-15 18:04:33.0
172,GROUCHO,WILLIAMS,2006-02-15 18:04:33.0
173,ALAN,DREYFUSS,2006-02-15 18:04:33.0
174,MICHAEL,BENING,2006-02-15 18:04:33.0
175,WILLIAM,HACKMAN,2006-02-15 18:04:33.0
176,JON,CHASE,2006-02-15 18:04:33.0
177,GENE,MCKELLEN,2006-02-15 18:04:33.0
178,LISA,MONROE,2006-02-15 18:04:33.0
179,ED,GUINESS,2006-02-15 18:04:33.0
180,JEFF,SILVERSTONE,2006-02-15 18:04:33.0
181,MATTHEW,CARREY,2006-02-15 18:04:33.0
182,DEBBIE,AKROYD,2006-02-15 18:04:33.0
183,RUSSELL,CLOSE,2006-02-15 18:04:33.0
184,HUMPHREY,GARLAND,2006-02-15 18:04:33.0
185,MICHAEL,BOLGER,2006-02-15 18:04:33.0
186,JULIA,ZELLWEGER,2006-02-15 18:04:33.0
187,RENEE,BALL,2006-02-15 18:04:33.0
188,ROCK,DUKAKIS,2006-02-15 18:04:33.0
189,CUBA,BIRCH,2006-02-15 18:04:33.0
190,AUDREY,BAILEY,2006-02-15 18:04:33.0
191,GREGORY,GOODING,2006-02-15 18:04:33.0
192,JOHN,SUVARI,2006-02-15 18:04:33.0
193,BURT,TEMPLE,2006-02-15 18:04:33.0
194,MERYL,ALLEN,2006-02-15 18:04:33.0
195,JAYNE,SILVERSTONE,2006-02-15 18:04:33.0
196,BELA,WALKEN,2006-02-15 18:04:33.0
197,REESE,WEST,2006-02-15 18:04:33.0
198,MARY,KEITEL,2006-02-15 18:04:33.0
199,JULIA,FAWCETT,2006-02-15 18:04:33.0
200,THORA,TEMPLE,2006-02-15 18:04:33.0




THANK YOU
Tags:

Post a Comment

Previous Post Next Post