Este ejemplo crea una actualizacion por lotes y ademas devuelve un resulset. El problema es que lanza una excepcion diciendo que la base de datos esta bloqueada.

BEAN:

package user;

import com.sun.faces.taglib.jsf_core.ConvertDateTimeTag;
import java.sql.*;

/*
* UserData.java
*
* Created on 24 de marzo de 2008, 4:43
*
* To change this template, choose Tools | Template Manager
* and open the template in the editor.
*/

/**
*
* @author user
*/
public class UserData {
public ResultSet rs;
String username;
String email;
int age;

public void setUsername( String value ) {
username = value;
}

public void setEmail( String value ) {
email = value;
}

public void setAge( int value ) {
age = value;
}

public String getUsername() { return username; }

public String getEmail() { return email; }

public int getAge() { return age; }

public String alta(){
String a="";
try {
Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
Statement stat = conn.createStatement();
stat.executeUpdate("drop table if exists people;");
stat.executeUpdate("create table people (name, occupation);");
PreparedStatement prep = conn.prepareStatement(
"insert into people values (?, ?);");

prep.setString(1, username);
prep.setString(2, email);
prep.addBatch();
prep.setString(1, "Turing");
prep.setString(2, "computers");
prep.addBatch();
prep.setString(1, "Wittgenstein");
prep.setString(2, "smartypants");
prep.addBatch();

conn.setAutoCommit(false);
prep.executeBatch();
conn.setAutoCommit(true);
//conn.close();

rs = stat.executeQuery("select * from people;");
/*while (rs.next()) {
System.out.println("name = " + rs.getString("name"));
System.out.println("job = " + rs.getString("occupation"));
}*/
//rs.close();
//conn.close();

}catch (Exception e){

a=e.toString();

}
return a;
}

}

JSP que recoge la informacion con su directiva page:

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<jsp:useBean id="user" class="user.UserData" scope="session"/>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
You entered<BR>
Name: <%= user.getUsername() %><BR>
Email: <%= user.getEmail() %><BR>
Age: <%= user.getAge() %><BR>
Insercion <%= user.alta() %><br>
1er registro <%= user.rs.getString(1) %>
</BODY>
</HTML>

La ruta de la generacion de la BD en SQLite es:

c:\Archivos de programa\netbeans-5.5\enterprise3\apache-tomcat-5.5.17\bin