SV: Java / MySQL Question

Google

Mailing List

Home

Forum Home

JBoss - Java Application Server

Struts - A MVC web framework

Tomcat - JSP/Servlet container

iText - An open source PDF Java Library

JDOM - JDOM XML Parser

J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition

J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog

Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology

JSP - A mailing list about Java Server Pages specification and reference

Struts & Hibernate

Subjects

•	JSP editor plugin for eclipse ?
•	org apache jasper JasperException: Unable to compile class for JSP
•	Tomcat: Connection reset by peer: socket write error
•	Cannot retrieve definition for form bean null
•	Struts Tiles Tutorial (free Struts training)
•	Where do I download Tomcat 4 0 6?
•	Data Access Object (DAO) pattern, example DAO 's
•	Where to download Tomcat v 4 1 24 from?
•	Tomcat 5 0 16 Requested resource not available
•	Oracle Connection Pooling in 3 2 2
•	Servlet : Session invalidate
•	Servlet action is currently unavailable
•	Tomcat/Struts Unicode Encoding/Decoding problems
•	Tomcat and webapplication specific java library path
•	Running a Simple JMS Example
•	Mapping in workers2 properties
•	org apache jasper JasperException
•	Cannot find message resources under key org apache struts action MESSAGE
•	problem with html:text bean throwing exception
•	Cannot find message resources under key org apache struts action MESSAGE
•	invalid direct reference problem with solution
•	Tool for jsp debug Try Sysdeo Eclipse Plugin
•	Tomcat 5 Cannot load JDBC driver class 'null ' SQL state: null
•	weblogic ejbc
•	java properties file
•	Jboss 3 2 3 Coyote Can 't re
•	Tomcat 5, Apache2 and mod jk2 integration problem
•	JBoss example problem new to J2EE
•	url string for connecting jboss to oracle
•	Value attribute of <html:checkbox
•	javax servlet ServletException: BeanUtils populate
•	HTTP Status 404 The requested resource is not available
•	5 0 18: Windows XP Pro vs Windows 2000

SV: Java / MySQL Question

SV: Java / MySQL Question

2004-02-11 - By Mathias H�ggren

Back

Reply: 1 2

Hi,

Since you're using MySQL you could always use this non-standard solution:

SELECT * FROM myTable ORDER BY rand() LIMIT 1

Brgds
Mathias

-- --Ursprungligt meddelande-- --
Fr�n: A mailing list about Java Server Pages specification and reference
[mailto:JSP-INTEREST@(protected)]F�r Brian Sperryn
Skickat: den 11 februari 2004 13:22
Till: JSP-INTEREST@(protected)
�mne: Re: Java / MySQL Question

rs.last();
int randomRow = (int)(Math.random()*rs.getRow());
rs.absolute(randomRow);
***********
the usual get column stuff...
***********

-- -- Original Message -- --
From: "Jack Lauman" <jlauman@(protected)>
To: <JSP-INTEREST@(protected)>
Sent: Wednesday, February 11, 2004 1:49 PM
Subject: Java / MySQL Question

> I have a table containing information about different businesses. I
> want to randomly select a single row from the table using a prepared
> statement in a java bean. (Using MySQL 4.0.17 and JBoss 3.2.2)
>
> What is the most eficient way to do this?
>
> TIA
>
> Jack
>
>
==========================================================================> To
unsubscribe: mailto listserv@(protected) with body: "signoff
JSP-INTEREST".
> For digest: mailto listserv@(protected) with body: "set JSP-INTEREST
DIGEST".
>
> Some relevant archives, FAQs and Forums on JSPs can be found at:
>
> http://java.sun.com/products/jsp
> http://archives.java.sun.com/jsp-interest.html
> http://forums.java.sun.com
> http://www.jspinsider.com
>

==========================================================================To
unsubscribe: mailto listserv@(protected) with body: "signoff
JSP-INTEREST".
For digest: mailto listserv@(protected) with body: "set JSP-INTEREST
DIGEST".

Some relevant archives, FAQs and Forums on JSPs can be found at:

http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com

==========================================================================To
unsubscribe: mailto listserv@(protected) with body: "signoff JSP-INTEREST".
For digest: mailto listserv@(protected) with body: "set JSP-INTEREST DIGEST".

Some relevant archives, FAQs and Forums on JSPs can be found at:

http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com