Help insert SQL query in jsp page

[bylum]

Kindly please anyone here helps me how to check in my program,

i want to insert this SQL query to jsp file:

SELECT COUNT(id) new
FROM annaudio
WHERE id NOT IN (
SELECT annaudio_id FROM annread WHERE annuser_id=1
)


and this is my jsp file's script:
<%
Class.forName ("org.gjt.mm.my sql.Driver");
Connection connection = DriverManager.g etConnection("j dbc:mysql://localhost:3306/ann?user=root") ;
Statement statement = connection.crea teStatement();

ResultSet rs = statement.execu teQuery("SELECT COUNT(id) FROM annaudio WHERE id NOT IN(SELECT annaudio_id FROM annread WHERE annuser_id=" + "iduser)");

out.println(rs) ;
%>

My problem is how to display my "ResultSet" ??

[Motoma]

I have moved this thread to the Java forum, hopefully they will have some knowledge on the subject.

[dmjpro]

Did u see the SUN API Documentation of ResultSet interface?
If u did then there would be no problem.
Best of luck.

Kind regards,
Dmjpro.

[r035198x]

Kindly please anyone here helps me how to check in my program,

i want to insert this SQL query to jsp file:

SELECT COUNT(id) new
FROM annaudio
WHERE id NOT IN (
SELECT annaudio_id FROM annread WHERE annuser_id=1
)


and this is my jsp file's script:
<%
Class.forName ("org.gjt.mm.my sql.Driver");
Connection connection = DriverManager.g etConnection("j dbc:mysql://localhost:3306/ann?user=root") ;
Statement statement = connection.crea teStatement();

ResultSet rs = statement.execu teQuery("SELECT COUNT(id) FROM annaudio WHERE id NOT IN(SELECT annaudio_id FROM annread WHERE annuser_id=" + "iduser)");

out.println(rs) ;
%>

My problem is how to display my "ResultSet" ??

Read sun's jdbc tutorial and see how to use resultsets. You probably won't take long to grasp it because it really is very simple.

[tmerkaj]

Read sun's jdbc tutorial and see how to use resultsets. You probably won't take long to grasp it because it really is very simple.

SELECT COUNT(id) new
FROM annaudio
WHERE id NOT IN (
SELECT annaudio_id FROM annread WHERE annuser_id=1
)


and this is my jsp file's script:
<%
Class.forName ("org.gjt.mm.my sql.Driver");
Connection connection = DriverManager.g etConnection("j dbc:mysql://localhost:3306/ann?user=root") ;
Statement statement = connection.crea teStatement();

ResultSet rs = statement.execu teQuery("SELECT COUNT(id) FROM annaudio WHERE id NOT IN(SELECT annaudio_id FROM annread WHERE annuser_id=" + "iduser)");

out.println(rs) ;
%>

My problem is how to display my "ResultSet" ??


Integer retval = getInteger(rs, 1);

out.println( retval);

[r035198x]

SELECT COUNT(id) new
FROM annaudio
WHERE id NOT IN (
SELECT annaudio_id FROM annread WHERE annuser_id=1
)


and this is my jsp file's script:
<%
Class.forName ("org.gjt.mm.my sql.Driver");
Connection connection = DriverManager.g etConnection("j dbc:mysql://localhost:3306/ann?user=root") ;
Statement statement = connection.crea teStatement();

ResultSet rs = statement.execu teQuery("SELECT COUNT(id) FROM annaudio WHERE id NOT IN(SELECT annaudio_id FROM annread WHERE annuser_id=" + "iduser)");

out.println(rs) ;
%>

My problem is how to display my "ResultSet" ??


Integer retval = getInteger(rs, 1);

out.println( retval);

If you wont go through the tutorial then at least take time to read the resultset specs.

[praveen2gupta]

Kindly please anyone here helps me how to check in my program,

i want to insert this SQL query to jsp file:

SELECT COUNT(id) new
FROM annaudio
WHERE id NOT IN (
SELECT annaudio_id FROM annread WHERE annuser_id=1
)


and this is my jsp file's script:
<%
Class.forName ("org.gjt.mm.my sql.Driver");
Connection connection = DriverManager.g etConnection("j dbc:mysql://localhost:3306/ann?user=root") ;
Statement statement = connection.crea teStatement();

ResultSet rs = statement.execu teQuery("SELECT COUNT(id) FROM annaudio WHERE id NOT IN(SELECT annaudio_id FROM annread WHERE annuser_id=" + "iduser)");

out.println(rs) ;
%>

My problem is how to display my "ResultSet" ??

execution of the above query will fetch only one record in the resultset. To print
the value of the resultset you should use request.getPara meter("count(id )") will be displaying the output on the page.