C:/sourceforge/roller/build/roller
jdbc/rollerdb
javax.sql.DataSource
rollerdb
SELECT passphrase FROM rolleruser u, website w WHERE username=? and u.id = w.userid and w.isenabled = 1
SELECT username FROM rolleruser WHERE cookie=?
UPDATE rolleruser u, website w SET cookie=? WHERE username=? and u.id = w.userid and w.isenabled = 1
SELECT rolename FROM userrole r, rolleruser u, website w
WHERE r.username=? and r.userid = u.id and u.id = w.userid and w.isenabled = 1
FORM
/login.jsp
/loginerror.jsp